公开(公告)号：US06519613B1

公开(公告)日：2003-02-11

申请号：US09527501

申请日：2000-03-16

申请人： Craig Alan Friske ,  Gary Howard Sockut ,  James Zu-Chia Teng ,  Stephen Walter Turnbaugh

发明人： Craig Alan Friske ,  Gary Howard Sockut ,  James Zu-Chia Teng ,  Stephen Walter Turnbaugh

IPC分类号： G06F1700

CPC分类号： G06F17/30339 ,  Y10S707/99952 ,  Y10S707/99953

摘要： A method and apparatus for online reorganization of a database which does not prevent a process from accessing the database during the data reorganization. The invention uses a non-blocking drain to lock on a database, unloads a copy of the data contained in the database, reorganizes the copied data, loads the reorganized data into a shadow location, applies log records to the shadow location data so that the reorganized data may be adjusted for any changes to the database after the data was copied and reorganized, and then replaces the data in the database with the reorganized data. The non-blocking drain does not prevent other requests on the database from being processed while the reorganization lock is in place, except briefly when the reorganized data replaces the data in the database.

摘要翻译： 一种在线重组数据库的方法和装置，在数据重组期间不阻止进程访问数据库。 本发明使用非阻塞漏洞来锁定数据库，卸载数据库中包含的数据的副本，重新组织复制的数据，将重组的数据加载到阴影位置，将日志记录应用于阴影位置数据，以便 重新组织的数据可能会在数据复制和重组后对数据库的任何更改进行调整，然后用重组数据替换数据库中的数据。 无阻塞的漏洞不会阻止在重组锁定到位时对数据库的其他请求进行处理，除非重组的数据替换数据库中的数据。

公开(公告)号：US6070170A

公开(公告)日：2000-05-30

申请号：US942453

申请日：1997-10-01

申请人： Craig Alan Friske ,  Gary Howard Sockut ,  James Zu-Chia Teng ,  Stephen Walter Turnbaugh

发明人： Craig Alan Friske ,  Gary Howard Sockut ,  James Zu-Chia Teng ,  Stephen Walter Turnbaugh

IPC分类号： G06F17/30 ,  G06F12/00

CPC分类号： G06F17/30339 ,  Y10S707/99952 ,  Y10S707/99953

摘要： A method and apparatus for online reorganization of a database which does not prevent a process from accessing the database during the data reorganization. The invention uses a non-blocking drain to lock on a database, unloads a copy of the data contained in the database, reorganizes the copied data, loads the reorganized data into a shadow location, applies log records to the shadow location data so that the reorganized data may be adjusted for any changes to the database after the data was copied and reorganized, and then replaces the data in the database with the reorganized data. The non-blocking drain does not prevent other requests on the database from being processed while the reorganization lock is in place, except briefly when the reorganized data replaces the data in the database.

摘要翻译： 一种在线重组数据库的方法和装置，在数据重组期间不阻止进程访问数据库。 本发明使用非阻塞漏洞来锁定数据库，卸载数据库中包含的数据的副本，重新组织复制的数据，将重组的数据加载到阴影位置，将日志记录应用于阴影位置数据，以便 重新组织的数据可能会在数据复制和重组后对数据库的任何更改进行调整，然后用重组数据替换数据库中的数据。 无阻塞的漏洞不会阻止在重组锁定到位时对数据库的其他请求进行处理，除非重组的数据替换数据库中的数据。

公开(公告)号：US06823326B2

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

申请号：US09823062

申请日：2001-03-30

申请人： James Zu-Chia Teng ,  Namik Hrle ,  Akira Shibamiya ,  Stephen Walter Turnbaugh

发明人： James Zu-Chia Teng ,  Namik Hrle ,  Akira Shibamiya ,  Stephen Walter Turnbaugh

IPC分类号： G06F1730

CPC分类号： G06F17/30286 ,  Y10S707/99931

摘要： A method and system for formatting space in a storage device for a database system is disclosed. The method and system include formatting a first increment for creating a database file and asynchronously formatting at least one subsequent increment for the database file in a background of the database system.

摘要翻译： 公开了一种用于格式化用于数据库系统的存储设备中的空间的方法和系统。 该方法和系统包括格式化用于创建数据库文件的第一增量，并且在数据库系统的后台异步格式化数据库文件的至少一个后续增量。

公开(公告)号：US06604097B2

公开(公告)日：2003-08-05

申请号：US09915867

申请日：2001-07-26

申请人： San Yu Phoenix ,  Kalpana Shyam ,  James Zu-Chia Teng ,  Stephen Walter Turnbaugh ,  Julie Ann Watts

发明人： San Yu Phoenix ,  Kalpana Shyam ,  James Zu-Chia Teng ,  Stephen Walter Turnbaugh ,  Julie Ann Watts

IPC分类号： G06F1730

CPC分类号： G06F17/30595 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99938 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99953

摘要： Provided is a method, system, program, and data structures for making data available to an application program. A result table is generated including rows corresponding to a subset of rows in a base table having data in one or more columns that satisfy a query predicate clause. The result table includes, for each row, a location identifier of the corresponding row in the base table and a column for each column in a query select list. The result table is accessed to return requested data from the base table to the application program.

公开(公告)号：US07840774B2

公开(公告)日：2010-11-23

申请号：US11233956

申请日：2005-09-09

申请人： Jeffrey Allen Berger ,  You-Chin Fuh ,  Sauraj Goswami ,  Balakrishna Raghavendra Iyer ,  Michael R. Shadduck ,  James Zu-Chia Teng ,  Stephen Walter Turnbaugh

发明人： Jeffrey Allen Berger ,  You-Chin Fuh ,  Sauraj Goswami ,  Balakrishna Raghavendra Iyer ,  Michael R. Shadduck ,  James Zu-Chia Teng ,  Stephen Walter Turnbaugh

IPC分类号： G06F12/00 ,  G06F13/00 ,  G06F13/28 ,  G06F13/12 ,  G06F13/38

CPC分类号： H03M7/30 ,  G06F17/30336

摘要： Various embodiments of a computer-implemented method, system and computer program product maintain a logical page having a predetermined size. Data is added to an uncompressed area of the logical page. The uncompressed area of the logical page is associated with an uncompressed area of a physical page. The logical page also has a compressed area associated with a compressed area of a physical page. In response to exhausting the uncompressed area, data in the uncompressed area is included in the compressed area. The uncompressed area is adjusted.

摘要翻译： 计算机实现的方法，系统和计算机程序产品的各种实施例维护具有预定大小的逻辑页面。 数据被添加到逻辑页面的未压缩区域。 逻辑页面的未压缩区域与物理页面的未压缩区域相关联。 逻辑页面还具有与物理页面的压缩区域相关联的压缩区域。 响应于未压缩区域的耗尽，未压缩区域中的数据被包括在压缩区域中。 未压缩区域被调整。