公开(公告)号：US20180225215A1

公开(公告)日：2018-08-09

申请号：US15425808

申请日：2017-02-06

申请人： International Business Machines Corporation

发明人： Avrilia Floratou ,  Fatma Ozcan ,  Mir H. Pirahesh ,  Navneet S. Potti

IPC分类号： G06F12/0846

CPC分类号： G06F12/0848 ,  G06F2212/1041 ,  G06F2212/282

摘要： A computer-implemented method according to one embodiment includes receiving a request for data, locating the data at one or more partitions of a heterogeneously partitioned table, determining an access method associated with each of the one or more partitions, and requesting the data from the one or more partitions, utilizing the access method associated with each of the one or more partitions.

公开(公告)号：US09774682B2

公开(公告)日：2017-09-26

申请号：US14591951

申请日：2015-01-08

申请人： International Business Machines Corporation

发明人： Sangeeta T. Doraiswamy ,  Marc Hörsken ,  Fatma Ozcan ,  Mir H. Pirahesh

IPC分类号： H04L29/08 ,  H04L12/879 ,  H04W12/06

CPC分类号： H04L67/1097 ,  H04L49/901 ,  H04L63/08 ,  H04L67/10 ,  H04L67/141 ,  H04W12/06

摘要： Embodiments relate to parallel data streaming between a first computer system and a second computer system. Aspects include transmitting a request to establish an authenticated connection between a processing job on the first computer system and a process on the second computer system and transmitting a query to the process on the second computer system over the authenticated connection. Aspects further include creating one or more tasks on the first computer system configured to receive data from the second computer system in parallel and reading data received by the one or more tasks by the processing job on the first computer system.

公开(公告)号：US20160205188A1

公开(公告)日：2016-07-14

申请号：US14591951

申请日：2015-01-08

申请人： International Business Machines Corporation

发明人： Sangeeta T. Doraiswamy ,  Marc Hörsken ,  Fatma Ozcan ,  Mir H. Pirahesh

IPC分类号： H04L29/08 ,  H04L12/879

CPC分类号： H04L67/1097 ,  H04L49/901 ,  H04L63/08 ,  H04L67/10 ,  H04L67/141 ,  H04W12/06

摘要： Embodiments relate to parallel data streaming between a first computer system and a second computer system. Aspects include transmitting a request to establish an authenticated connection between a processing job on the first computer system and a process on the second computer system and transmitting a query to the process on the second computer system over the authenticated connection. Aspects further include creating one or more tasks on the first computer system configured to receive data from the second computer system in parallel and reading data received by the one or more tasks by the processing job on the first computer system.

摘要翻译： 实施例涉及第一计算机系统和第二计算机系统之间的并行数据流。 方面包括传送在第一计算机系统上的处理作业和第二计算机系统上的处理之间建立认证连接的请求，并通过认证连接向第二计算机系统上的处理发送查询。 方面还包括在第一计算机系统上创建一个或多个任务，其被配置为并行地从第二计算机系统接收数据，并且通过第一计算机系统上的处理作业读取由一个或多个任务接收的数据。

公开(公告)号：US20180101569A1

公开(公告)日：2018-04-12

申请号：US15290065

申请日：2016-10-11

申请人： International Business Machines Corporation

发明人： Ronald J. Barber ,  Ioana M. Delaney ,  Mir H. Pirahesh ,  Vijayshankar Raman

IPC分类号： G06F17/30

CPC分类号： G06F16/2452

摘要： Embodiments relate to aggregation operations. More specifically, embodiments relate to translating a query involving a distinct aggregate(s) into a query that does not involve a distinct aggregate. The translation involves a transformation effectively rewriting the original query containing the distinct aggregate including removal of the distinct aggregate from the query. The translated query enables the query to perform a non-distinct aggregation that effectively provides the results of the removed distinct aggregate(s).