公开(公告)号：US08156084B2

公开(公告)日：2012-04-10

申请号：US12016039

申请日：2008-01-17

Applicant: Jing-Song Jang ,  James Michael McArdle ,  Michael John Elvery Spicer

Inventor： Jing-Song Jang ,  James Michael McArdle ,  Michael John Elvery Spicer

IPC: G06F7/00 ,  G06F17/00

CPC classification number: G06F17/30371 ,  G06F11/1443

Abstract: Method, computer program product, and system for transferring data from positional data sources to partitioned databases are provided. A record is read from a positional data source. The record is to be written to one of a plurality of partitions of a database. A position of the record in the positional data source is obtained. A transaction is initiated to write the record to the one partition and to store the position of the record in the database. The transaction is committed after the record is successfully written to the one partition and the position of the record is successfully stored in the database.

Abstract translation: 提供了方法，计算机程序产品和用于将数据从位置数据源传送到分区数据库的系统。 从位置数据源读取记录。 记录将写入数据库的多个分区中的一个。 得到位置数据源中记录的位置。 启动事务以将记录写入一个分区，并将记录的位置存储在数据库中。 记录成功写入一个分区后，事务被提交，记录的位置成功存储在数据库中。

公开(公告)号：US06405198B1

公开(公告)日：2002-06-11

申请号：US09148460

申请日：1998-09-04

Applicant: Roger Georges Bitar ,  Jean Chen Ho ,  Jing-Song Jang ,  Erik Allan Kane ,  James Louis Keesey ,  Angela Go Reyda ,  Gerald Johann Wilmot

Inventor： Roger Georges Bitar ,  Jean Chen Ho ,  Jing-Song Jang ,  Erik Allan Kane ,  James Louis Keesey ,  Angela Go Reyda ,  Gerald Johann Wilmot

IPC: G06F1730

CPC classification number: G06F17/30339 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99936

Abstract: In a database processing system with a partitioned database that provides relational extenders to support storage of and access to complex data types, metadata table rows are collocated with corresponding relational table partitions. Image indexes are generated and stored at system nodes with their corresponding relational table partitions. Image query processing is conditioned to account for the partitioned structure of the database.

Abstract translation: 在具有分区数据库的数据库处理系统中，提供关系扩展器以支持对复杂数据类型的存储和访问，元数据表行与相应的关系表分区并置。 图像索引生成并存储在系统节点及其相应的关系表分区。 图像查询处理的条件是考虑数据库的分区结构。

公开(公告)号：US06047291A

公开(公告)日：2000-04-04

申请号：US114587

申请日：1998-07-13

Applicant: Matthew Paul Anderson ,  Siyi Terry Donn ,  David Couttie Fallside ,  Tri Quac Ha ,  Douglas Michael Hembry ,  Jean C. Ho ,  Jing-Song Jang ,  Nelson Mattos ,  Carlton Wayne Niblack ,  Dragutin Petkovic ,  Frank Chin Tung ,  Peter Paval Uhrowczik ,  Mimi Phuong-Thao Thi Vo ,  Gerald Johann Wilmot ,  Peter C. Yanker ,  Josephine Min-Kung Cheng

Inventor： Matthew Paul Anderson ,  Siyi Terry Donn ,  David Couttie Fallside ,  Tri Quac Ha ,  Douglas Michael Hembry ,  Jean C. Ho ,  Jing-Song Jang ,  Nelson Mattos ,  Carlton Wayne Niblack ,  Dragutin Petkovic ,  Frank Chin Tung ,  Peter Paval Uhrowczik ,  Mimi Phuong-Thao Thi Vo ,  Gerald Johann Wilmot ,  Peter C. Yanker ,  Josephine Min-Kung Cheng

IPC: G06F17/30

CPC classification number: G06F17/30595 ,  Y10S707/954 ,  Y10S707/961 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99943 ,  Y10S707/99944

Abstract: This invention is directed to relational extenders for a computer-based relational database. Each relational extender includes at least one column, in a first, business table containing a user defined application database, dedicated to object handles for defining the complex data type of an object; a second, attribute, table containing at least one column defining a unique characteristic associated with the one object and one column dedicated to containing the object handle; and a third, metadata, table containing at least one column defining a common characteristic associated with all objects defined within the business table and one column dedicated to containing the object handles and at least one column dedicated to containing a reference to object data associated with the object. The relational extender further includes a fourth table containing a reference to each object handle column defined in the first table, and a fifth table containing the names of the second and third tables for each object defined in the first table.

Abstract translation: 本发明涉及用于基于计算机的关系数据库的关系扩展器。 每个关系扩展器包括至少一列，在包含用户定义的应用程序数据库的第一个业务表中，专用于定义对象的复杂数据类型的对象句柄; 第二属性表包含至少一列，定义与一个对象相关联的唯一特征，以及一列专用于包含对象句柄; 以及第三个元数据表，其包含至少一列，其定义与业务表中定义的所有对象相关联的共同特征，以及专用于包含对象句柄的专栏和至少一列专用于包含与该对象句柄相关联的对象数据的引用 目的。 关系扩展器还包括第四表，其包含对在第一表中定义的每个对象句柄列的引用，以及包含第一表中定义的每个对象的第二和第三表的名称的第五表。

公开(公告)号：US07933873B2

公开(公告)日：2011-04-26

申请号：US12015836

申请日：2008-01-17

Applicant: Jing-Song Jang ,  Wing Yun Mak ,  James Michael McArdle ,  Michael John Elvery Spicer

Inventor： Jing-Song Jang ,  Wing Yun Mak ,  James Michael McArdle ,  Michael John Elvery Spicer

IPC: G06F17/30

CPC classification number: G06F17/30377

Abstract: Method, computer program product, and system for transferring data to database partitions are provided. A transaction is initiated to insert one or more records into a partition of a database. At least one of the one or more records is then saved in binary form to a dump table in the database as a part of the transaction in response to the insertion of the at least one record into the partition having failed as a result of the at least one record not satisfying a predetermined condition. In response to the saving of the at least one record in binary form to the dump table having failed, the transaction is rolled back.

Abstract translation: 提供了将数据传输到数据库分区的方法，计算机程序产品和系统。 启动事务以将一个或多个记录插入数据库的分区。 一个或多个记录中的至少一个然后以二进制形式保存到数据库中的转储表中作为事务的一部分，以响应于将至少一个记录插入到由于在 至少一个记录不满足预定条件。 响应于将二进制形式的至少一个记录保存到转储表已经失败，事务被回滚。

公开(公告)号：US20090187608A1

公开(公告)日：2009-07-23

申请号：US12015836

申请日：2008-01-17

Applicant: Jing-Song Jang ,  Wing Yun Mak ,  James Michael Mcardle ,  Michael John Elvery Spicer

Inventor： Jing-Song Jang ,  Wing Yun Mak ,  James Michael Mcardle ,  Michael John Elvery Spicer

IPC: G06F12/00 ,  G06F17/30

CPC classification number: G06F17/30377

Abstract: Method, computer program product, and system for transferring data to database partitions are provided. A transaction is initiated to insert one or more records into a partition of a database. At least one of the one or more records is then saved in binary form to a dump table in the database as a part of the transaction in response to the insertion of the at least one record into the partition having failed as a result of the at least one record not satisfying a predetermined condition. In response to the saving of the at least one record in binary form to the dump table having failed, the transaction is rolled back.

Abstract translation: 提供了将数据传输到数据库分区的方法，计算机程序产品和系统。 启动事务以将一个或多个记录插入数据库的分区。 一个或多个记录中的至少一个然后以二进制形式保存到数据库中的转储表中作为事务的一部分，以响应于将至少一个记录插入到由于在 至少一个记录不满足预定条件。 响应于将二进制形式的至少一个记录保存到转储表已经失败，事务被回滚。

公开(公告)号：US08521682B2

公开(公告)日：2013-08-27

申请号：US12016092

申请日：2008-01-17

Applicant: Jing-Song Jang ,  James Michael Mcardle ,  Michael John Elvery Spicer

Inventor： Jing-Song Jang ,  James Michael Mcardle ,  Michael John Elvery Spicer

IPC: G06F17/00

CPC classification number: G06F17/30371 ,  G06F11/1474 ,  G06F17/30345

Abstract: Method, system, and computer program product for transferring data from transactional data sources to partitioned databases are provided. One or more messages from a transactional data source are read. Each message includes one or more records to be inserted into a database comprising a plurality of partitions. One of the partitions of the database in which the one or more records of each message are to be inserted is then identified. A transaction is initiated to insert the one or more records of each message into the one partition and to delete the one or more messages from the transactional data source. The transaction is committed only when insertion of the one or more records of each message into the one partition and deletion of the one or more messages from the transactional data source succeed.

Abstract translation: 提供了用于将数据从事务数据源传输到分区数据库的方法，系统和计算机程序产品。 读取来自事务数据源的一个或多个消息。 每个消息包括要插入到包括多个分区的数据库中的一个或多个记录。 然后识别要在其中插入每个消息的一个或多个记录的数据库的其中一个分区。 启动事务以将每个消息的一个或多个记录插入到一​​个分区中，并从事务数据源中删除一个或多个消息。 仅当将每个消息的一个或多个记录插入到一​​个分区中并且从事务数据源中删除一个或多个消息成功时才提交事务。

公开(公告)号：US20090187787A1

公开(公告)日：2009-07-23

申请号：US12016039

申请日：2008-01-17

Applicant: Jing-Song JANG ,  James Michael Mcardle ,  Michael John Elvery Spicer

Inventor： Jing-Song JANG ,  James Michael Mcardle ,  Michael John Elvery Spicer

IPC: G06F11/07 ,  G06F7/06 ,  G06F17/30

CPC classification number: G06F17/30371 ,  G06F11/1443

Abstract: Method, computer program product, and system for transferring data from positional data sources to partitioned databases are provided. A record is read from a positional data source. The record is to be written to one of a plurality of partitions of a database. A position of the record in the positional data source is obtained. A transaction is initiated to write the record to the one partition and to store the position of the record in the database. The transaction is committed after the record is successfully written to the one partition and the position of the record is successfully stored in the database.

Abstract translation: 提供了方法，计算机程序产品和用于将数据从位置数据源传送到分区数据库的系统。 从位置数据源读取记录。 记录将写入数据库的多个分区中的一个。 得到位置数据源中记录的位置。 启动事务以将记录写入一个分区，并将记录的位置存储在数据库中。 记录成功写入一个分区后，事务被提交，记录的位置成功存储在数据库中。

公开(公告)号：US6078925A

公开(公告)日：2000-06-20

申请号：US487988

申请日：1995-06-07

Applicant: Matthew Paul Anderson ,  Siyi Terry Donn ,  David Couttie Fallside ,  Tri Quac Ha ,  Douglas Michael Hembry ,  Jean C. Ho ,  Jing-Song Jang ,  Nelson Mattos ,  Carlton Wayne Niblack ,  Dragutin Petkovic ,  Frank Chin Tung ,  Peter Paval Uhrowczik ,  Mimi Phuong-Thao Thi Vo ,  Gerald Johann Wilmot ,  Peter C. Yanker ,  Josephine Min-Kung Cheng

Inventor： Matthew Paul Anderson ,  Siyi Terry Donn ,  David Couttie Fallside ,  Tri Quac Ha ,  Douglas Michael Hembry ,  Jean C. Ho ,  Jing-Song Jang ,  Nelson Mattos ,  Carlton Wayne Niblack ,  Dragutin Petkovic ,  Frank Chin Tung ,  Peter Paval Uhrowczik ,  Mimi Phuong-Thao Thi Vo ,  Gerald Johann Wilmot ,  Peter C. Yanker ,  Josephine Min-Kung Cheng

IPC: G06F17/30

CPC classification number: G06F17/30595 ,  Y10S707/954 ,  Y10S707/961 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99943 ,  Y10S707/99944

Abstract: This invention is directed to relational extenders for a computer-based relational database. Each relational extender includes at least one column, in a first, business, table containing a user defined application database, dedicated to object handles for defining the complex data type of an object; a second, attribute, table containing at least one column defining a unique characteristic associated with the one object and one column dedicated to containing the object handle; and a third, metadata, table containing at least one column defining a common characteristic associated with all objects defined within the business table and one column dedicated to containing the object handle and at least one column dedicated to containing a reference to object data associated with the object. The relational extender further includes a fourth table containing a reference to each object handle column defined in the first table, a fifth table containing the names of the second and third tables for each object defined in the first table, a sixth table containing a reference to each object handle removed from the first table and including one column dedicated to containing a reference to the location of the object data associated with the removed object handle, and a seventh table having at least one column which describes a property of the data type of each object defined in the first table. The relational extender further includes an eighth table as a temporary holding table for the second table, and a ninth table as a temporary holding table for the third table. Both the eighth and ninth tables are used in conjunction with the extender triggers to ensure data integrity.

Abstract translation: 本发明涉及用于基于计算机的关系数据库的关系扩展器。 每个关系扩展器包括至少一列，在包含用户定义的应用数据库的第一业务表中，专用于定义对象的复杂数据类型的对象句柄的至少一列; 第二属性表包含至少一列，定义与一个对象相关联的唯一特征，以及一列专用于包含对象句柄; 以及第三个元数据表，其包含至少一列，其定义与业务表中定义的所有对象相关联的共同特征，以及专用于包含对象句柄的专栏和至少一列专用于包含与该对象句柄相关联的对象数据的引用 目的。 关系扩展器还包括第四表，其包含对在第一表中定义的每个对象句柄列的引用，第五表包含在第一表中定义的每个对象的第二和第三表的名称，第六表包含引用 每个对象句柄从第一表中移除并且包括专用于包含与被移除的对象句柄相关联的对象数据的位置的引用的一列，以及具有描述每个对象句柄的数据类型的属性的至少一列的第七表 对象在第一个表中定义。 关系扩展器还包括作为第二表的临时保持表的第八表和作为第三表的临时保持表的第九表。 第八和第九表与扩展器触发器一起使用以确保数据完整性。

公开(公告)号：US5799310A

公开(公告)日：1998-08-25

申请号：US548301

申请日：1995-11-01

Applicant: Matthew Paul Anderson ,  Siyi Terry Donn ,  David Couttie Fallside ,  Tri Q. Ha ,  Douglas Michael Hembry ,  Jean C. Ho ,  Jing-Song Jang ,  Nelson Mattos ,  Carlton Wayne Niblack ,  Dragutin Petkovic ,  Frank Chin Tung ,  Peter Paval Uhrowczik ,  Mimi Phuong-Thao Thi Vo ,  Gerald Johann Wilmot ,  Peter C. Yanker ,  Josephine Min-Kung Cheng

Inventor： Matthew Paul Anderson ,  Siyi Terry Donn ,  David Couttie Fallside ,  Tri Q. Ha ,  Douglas Michael Hembry ,  Jean C. Ho ,  Jing-Song Jang ,  Nelson Mattos ,  Carlton Wayne Niblack ,  Dragutin Petkovic ,  Frank Chin Tung ,  Peter Paval Uhrowczik ,  Mimi Phuong-Thao Thi Vo ,  Gerald Johann Wilmot ,  Peter C. Yanker ,  Josephine Min-Kung Cheng

IPC: G06F17/30

CPC classification number: G06F17/30595 ,  Y10S707/954 ,  Y10S707/961 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99943 ,  Y10S707/99944

Abstract: This invention is directed to relational extenders for a computer-based relational database. Each relational extender includes at least one column, in a first, business, table containing a user defined application database, dedicated to object handles for defining the complex data type of an object; a second, attribute, table containing at least one column defining a unique characteristic associated with the one object and one column dedicated to containing the object handle; and a third, metadata, table containing at least one column defining a common characteristic associated with all objects defined within the business table and one column dedicated to containing the object handle and at least one column dedicated to containing a reference to object data associated with the object. The relational extender further includes a fourth table containing a reference to each object handle column defined in the first table, and a fifth table containing the names of the second and third tables for each object defined in the first table.

Abstract translation: 本发明涉及用于基于计算机的关系数据库的关系扩展器。 每个关系扩展器包括至少一列，在包含用户定义的应用数据库的第一业务表中，专用于定义对象的复杂数据类型的对象句柄的至少一列; 第二属性表包含至少一列，定义与一个对象相关联的唯一特征，以及一列专用于包含对象句柄; 以及第三个元数据表，其包含至少一列，其定义与业务表中定义的所有对象相关联的共同特征，以及专用于包含对象句柄的专栏和至少一列专用于包含与该对象句柄相关联的对象数据的引用 目的。 关系扩展器还包括第四表，其包含对在第一表中定义的每个对象句柄列的引用，以及包含第一表中定义的每个对象的第二和第三表的名称的第五表。

公开(公告)号：US20090187917A1

公开(公告)日：2009-07-23

申请号：US12016092

申请日：2008-01-17

Applicant: Jing-Song JANG ,  James Michael Mcardle ,  Michael John Elvery Spicer

Inventor： Jing-Song JANG ,  James Michael Mcardle ,  Michael John Elvery Spicer

IPC: G06F3/00 ,  G06F17/30

CPC classification number: G06F17/30371 ,  G06F11/1474 ,  G06F17/30345

Abstract: Method, system, and computer program product for transferring data from transactional data sources to partitioned databases are provided. One or more messages from a transactional data source are read. Each message includes one or more records to be inserted into a database comprising a plurality of partitions. One of the partitions of the database in which the one or more records of each message are to be inserted is then identified. A transaction is initiated to insert the one or more records of each message into the one partition and to delete the one or more messages from the transactional data source. The transaction is committed only when insertion of the one or more records of each message into the one partition and deletion of the one or more messages from the transactional data source succeed.

Abstract translation: 提供了用于将数据从事务数据源传输到分区数据库的方法，系统和计算机程序产品。 读取来自事务数据源的一个或多个消息。 每个消息包括要插入到包括多个分区的数据库中的一个或多个记录。 然后识别要在其中插入每个消息的一个或多个记录的数据库的其中一个分区。 启动事务以将每个消息的一个或多个记录插入到一​​个分区中，并从事务数据源中删除一个或多个消息。 仅当将每个消息的一个或多个记录插入到一​​个分区中并且从事务数据源中删除一个或多个消息成功时才提交事务。