公开(公告)号：US20060161517A1

公开(公告)日：2006-07-20

申请号：US11038513

申请日：2005-01-18

申请人： Bishwaranjan Bhattacharjee ,  Sam Lightstone ,  Timothy Malkemus ,  Sriram Padmanabhan ,  Adam Storm ,  Daniele Zilio

发明人： Bishwaranjan Bhattacharjee ,  Sam Lightstone ,  Timothy Malkemus ,  Sriram Padmanabhan ,  Adam Storm ,  Daniele Zilio

IPC分类号： G06F17/30

CPC分类号： G06F17/30592 ,  G06F17/30306 ,  Y10S707/99932 ,  Y10S707/99942 ,  Y10S707/99943

摘要： Disclosed is a data processing system implemented method, a data processing system and an article of manufacture for improving execution efficiency of a database workload to be executed against a database. The database includes database tables, and the database workload identifies at least one of the database tables. The data processing system includes an identification module for identifying candidate database tables being identifiable in the database workload, the identified candidate database tables being eligible for organization under a clustering schema, a selection module for selecting the identified candidate tables according to whether execution of the database workload is improved if the selected identified candidate table is organized according to the clustering scheme, and an organization module for organizing the clustering schema of the selected organized identified candidate tables prior to the database workload being execution against the database.

公开(公告)号：US20070245079A1

公开(公告)日：2007-10-18

申请号：US11404966

申请日：2006-04-14

申请人： Bishwaranjan Bhattacharjee ,  Christian Lang ,  Timothy Malkemus

发明人： Bishwaranjan Bhattacharjee ,  Christian Lang ,  Timothy Malkemus

IPC分类号： G06F13/00

CPC分类号： G06F13/385 ,  G06F12/0842

摘要： An embodiment of the present invention provides a computer system comprising a first memory and a second memory, where the first memory is substantially faster than second and that performs a method includes steps of: receiving requests for blocks from scan processes; serializing requests for blocks with a request queue; inspecting requests, with a request handler process, R, for blocks and determining whether the requests can be fulfilled from the first memory, if possible; and using an interface for: getting a next data item not yet processed by a calling process, starting a new one-time table access operation, and ending one-time table access operation.

摘要翻译： 本发明的实施例提供一种包括第一存储器和第二存储器的计算机系统，其中第一存储器比第二存储器快得多，并且执行方法包括以下步骤：从扫描过程接收对块的请求; 使用请求队列串行化请求块; 如果可能的话，用块的请求处理程序R检查请求并确定是否可以从第一个存储器中完成请求; 并使用接口：获取尚未被调用进程处理的下一个数据项，启动新的一次表访问操作，并结束一次表访问操作。

公开(公告)号：US20070255772A1

公开(公告)日：2007-11-01

申请号：US11412554

申请日：2006-04-27

申请人： Bishwaranjan Bhattacharjee ,  Leslie Buback ,  Timothy Malkemus ,  Michael Winer

发明人： Bishwaranjan Bhattacharjee ,  Leslie Buback ,  Timothy Malkemus ,  Michael Winer

IPC分类号： G06F17/30

CPC分类号： G06F17/30492 ,  G06F17/30368 ,  G06F17/30377 ,  Y10S707/953 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99945 ,  Y10S707/99948

摘要： A computer implemented method, apparatus, and computer usable program code for deleting rows in a multidimensional clustering database. A multidimensional clustering processor receives a request to delete a set of multidimensionally clustered data. The multidimensional clustering processor determines whether all multidimensionally clustered data is located in a block. Responsive to all multidimensionally clustered data qualifying for deletion, the multidimensional clustering processor deletes all data in the block to delete the set of multidimensionally clustered data.

摘要翻译： 用于删除多维聚类数据库中的行的计算机实现的方法，装置和计算机可用程序代码。 多维聚类处理器接收删除一组多维聚类数据的请求。 多维聚类处理器确定所有多维聚类数据是否位于块中。 响应于符合要删除的所有多维聚类数据，多维聚类处理器将删除块中的所有数据以删除多维集群数据集。