公开(公告)号：CA2283050A1

公开(公告)日：2001-03-23

申请号：CA2283050

申请日：1999-09-23

Applicant: IBM CANADA

Inventor： LAU LEO TAT MAN

IPC: G06F17/30

Abstract: A computer system for transferring data from an object relational database t o another such database. The data in the source database having a table type hierarchy of data tables. The system transforming data from the source database to a flat file format data transf er file using a defined tree traversal order. The columns and subcolumns of the data transfer file corresponding to types and attributes from the source database type hierarchy; The data transfer file having a type identifier column corresponding to a type in the table type hierarchy. The system permitting the inputting of the data from the data transfer file to a target database having a table typ e hierarchy corresponding to the table type hierarchy of the source database.

公开(公告)号：CA2415018C

公开(公告)日：2006-09-19

申请号：CA2415018

申请日：2002-12-23

Applicant: IBM CANADA

Inventor： LEITCH MARK D ,  LIGHTSTONE SAM S ,  LAU LEO TAT MAN ,  BERKS ROBERT T ,  FLASZA MIROSLAW A ,  TREMAINE DAVID

IPC: G06F16/22 ,  G06F3/06 ,  G06F12/06 ,  G06F12/0882

Abstract: Loading input data into a multi-dimensional clustering (MDC) table or other structure containing data clustered along one or more dimensions entails assembling blocks of data in a partial block cache in which each partial block is associated with a distinc t logical cell. A minimum threshold number of partial blocks may be maintained. Partial blocks may be spilled from the partial block cache to make room for new logical cells. Last partia l pages of spilled partial blocks may be stored in a partial page cache to limit I/O if the cel l associated with a spilled block is encountered later in the input data stream. Buffers may be reassign ed from the partial block cache to the partial page cache if the latter is filled. Parallelism m ay be employed for efficiency during sorting of input data subsets and during storage of blocks to secondary storage.

公开(公告)号：CA2283050C

公开(公告)日：2003-03-18

申请号：CA2283050

申请日：1999-09-23

Applicant: IBM CANADA

Inventor： LAU LEO TAT MAN

IPC: G06F17/30

Abstract: A computer system for transferring data from an object relational database t o another such database. The data in the source database having a table type hierarchy of data tables. The system transforming data from the source database to a flat file format data transf er file using a defined tree traversal order. The columns and subcolumns of the data transfer file corresponding to types and attributes from the source database type hierarchy; The data transfer file having a type identifier column corresponding to a type in the table type hierarchy. The system permitting the inputting of the data from the data transfer file to a target database having a table typ e hierarchy corresponding to the table type hierarchy of the source database.

公开(公告)号：CA2422161C

公开(公告)日：2009-10-06

申请号：CA2422161

申请日：2003-03-14

Applicant: IBM CANADA

Inventor： WINER MICHAEL J ,  LAU LEO TAT MAN ,  BERKS ROBERT T ,  ROMANUFA KERILEY K ,  FLASZA MIROSLAW A ,  HURAS MATTHEW A ,  SACHEDINA AAMER

IPC: G06F17/30 ,  G06F7/00

Abstract: The use of a centralized version table allows for efficient object switching . Rather than synchronizing all database agents to recognize a newly created file as containing the most recent version of a given object, database agents requiring access to t he given object need only consult the centralized version table to learn file identity information. That is, the database agents consult the centralized version table to determine which of the files associated with a given object contain the most recent version of the given object. Mechanisms associated with the use of the centralized version table also provide for efficient recovery from a failure that has occurred during an object switchi ng transaction.

公开(公告)号：CA2422161A1

公开(公告)日：2004-09-14

申请号：CA2422161

申请日：2003-03-14

Applicant: IBM CANADA

Inventor： ROMANUFA KERILEY K ,  HURAS MATTHEW A ,  WINER MICHAEL J ,  FLASZA MIROSLAW A ,  BERKS ROBERT T ,  LAU LEO TAT MAN ,  SACHEDINA AAMER

IPC: G06F7/00 ,  G06F17/30

Abstract: The use of a centralized version table allows for efficient object switching. Rather than synchronizing all database agents to recognize a newly created file as containing the most recent version of a given object, database agents requiring access to the given object need only consult the centralized version table to learn file identity information. That is, the database agents consult the centralized version table to determine which of the files associated with a given object contain the most recent version of the given object. Mechanisms associated with the use of the centralized version table also provide for efficient recovery from a failure that has occurred during an object switching transaction.

公开(公告)号：CA2415018A1

公开(公告)日：2004-06-23

申请号：CA2415018

申请日：2002-12-23

Applicant: IBM CANADA

Inventor： LAU LEO TAT MAN ,  LEITCH MARK D ,  FLASZA MIROSLAW A ,  TREMAINE DAVID ,  LIGHTSTONE SAM S ,  BERKS ROBERT T

IPC: G06F16/22 ,  G06F3/06 ,  G06F12/06 ,  G06F12/0882 ,  G06F17/30

Abstract: Loading input data into a multi-dimensional clustering (MDC) table or other structure containing data clustered along one or more dimensions entails assembling blocks of data in a partial block cache in which each partial block is associated with a distinc t logical cell. A minimum threshold number of partial blocks may be maintained. Partial blocks may be spilled from the partial block cache to make room for new logical cells. Last partia l pages of spilled partial blocks may be stored in a partial page cache to limit I/O if the cel l associated with a spilled block is encountered later in the input data stream. Buffers may be reassign ed from the partial block cache to the partial page cache if the latter is filled. Parallelism m ay be employed for efficiency during sorting of input data subsets and during storage of blocks to secondary storage.