公开(公告)号：US07792875B2

公开(公告)日：2010-09-07

申请号：US11393422

申请日：2006-03-30

申请人： Sean W. McKeough ,  David Sciaraffa

发明人： Sean W. McKeough ,  David Sciaraffa

IPC分类号： G06F17/30

CPC分类号： G06F17/30958 ,  G06F17/30312

摘要： A method for recreating a plurality of database dependencies of objects from one database to another is disclosed. The method comprises categorizing the dependencies based upon at least one base object and formalizing the relationships of the dependencies based upon the categorization. The method includes determining the order of recreating the objects based upon the formalizing of the relationships of the dependencies. In a preferred embodiment, the method builds a Dependency Management Table (DMT) that describes the relationship of each object to a base-table. The DMT includes an entry for every object-to-object relationship, including the category of the relationship, and the nesting-level of the dependency from the base-table. Using this information, objects can be recreated in an order which ensures correct management of dependencies.

摘要翻译： 公开了一种用于从一个数据库到另一个数据库重新创建对象的多个数据库依赖性的方法。 该方法包括基于至少一个基础对象对依赖性进行分类，并基于分类形式化依赖关系。 该方法包括基于依赖关系的形式化来确定重新创建对象的顺序。 在优选实施例中，该方法构建了描述每个对象与基表的关系的依赖关系管理表（DMT）。 DMT包括每个对象到对象关系的条目，包括关系的类别以及从基表的依赖关系的嵌套级别。 使用此信息，可以按照确保正确管理依赖关系的顺序重新创建对象。

公开(公告)号：US20080208802A1

公开(公告)日：2008-08-28

申请号：US11679076

申请日：2007-02-26

申请人： Bishwaranjan Bhattacharjee ,  Timothy Ray Malkemus ,  Sean W. McKeough ,  Jo-anne Mona Louise Kirton ,  Sherman Lau

发明人： Bishwaranjan Bhattacharjee ,  Timothy Ray Malkemus ,  Sean W. McKeough ,  Jo-anne Mona Louise Kirton ,  Sherman Lau

IPC分类号： G06F17/30

CPC分类号： G06F17/30327

摘要： A method and system utilizes a hierarchical bitmap structure to represent deleted data sets. Each level in the hierarchical bitmap structure may have progressively larger size and represent finer granularity of number of data blocks than its parent level. A method in one aspect may comprise allocating a first level bitmap having size equal to a register on a processor, each bit in the first level bitmap representing a plurality of blocks of data in a database, and allocating one or more pointers corresponding to said plurality of bits in the first level bitmap, said one or more pointers being allocated to point to a sub bitmap generated after a data block is deleted but before the index corresponding to the data block is cleaned.

摘要翻译： 一种方法和系统利用分层位图结构来表示删除的数据集。 分级位图结构中的每个级别可以具有逐渐更大的大小并且表示比其父级别更多的数据块的粒度。 一方面的方法可以包括：分配具有等于处理器上的寄存器的大小的第一级位图，第一级位图中的每一位表示数据库中的多个数据块，并且分配与所述多个对应的一个或多个指针 所述一个或多个指针被分配以指向在数据块被删除之后但在与数据块相对应的索引被清除之前生成的子位图。

公开(公告)号：US06807540B2

公开(公告)日：2004-10-19

申请号：US09872831

申请日：2001-05-31

申请人： Matthew A. Huras ,  Sean W. McKeough ,  Timothy J. Vincent ,  Xun Xue ,  Roger L. Zheng

发明人： Matthew A. Huras ,  Sean W. McKeough ,  Timothy J. Vincent ,  Xun Xue ,  Roger L. Zheng

IPC分类号： G06F1730

CPC分类号： G06F9/526 ,  G06F17/30362 ,  Y10S707/99938 ,  Y10S707/99945

摘要： A system and method for managing deadlocks in a database management system (DBMS) for a demultiplexed database system. The DBMS supports applications that are capable of holding and retaining locks on database resources while disassociated from worker agents. The system and method includes an application scheduler for managing requests for access to the database, and a deadlock detector for identifying a deadlock. The application scheduler assigns one worker agent to an application requesting access to a database resource, assigns a flag to an application holding a lock on the database resource while disassociated from a worker agent, and in cooperation with the deadlock detector, resolves the deadlock between the application requesting access and the flagged application holding the lock.

摘要翻译： 一种用于管理解复用数据库系统的数据库管理系统（DBMS）中的死锁的系统和方法。 DBMS支持能够保留和保留数据库资源上的锁定的应用程序，同时与工作代理程序解除关联。 该系统和方法包括用于管理对数据库的访问请求的应用调度器，以及用于识别死锁的死锁检测器。 应用程序调度器向请求访问数据库资源的应用程序分配一个工作代理，在与工作代理解除关联的同时向持有数据库资源的锁定的应用程序分配标志，并且与死锁检测器协作解决了 请求访问的应用程序和持有锁定的标记应用程序。

公开(公告)号：US07685181B2

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

申请号：US11679076

申请日：2007-02-26

申请人： Bishwaranjan Bhattacharjee ,  Timothy Ray Malkemus ,  Sean W. McKeough ,  Jo-anne Mona Louise Kirton ,  Sherman Lau

发明人： Bishwaranjan Bhattacharjee ,  Timothy Ray Malkemus ,  Sean W. McKeough ,  Jo-anne Mona Louise Kirton ,  Sherman Lau

IPC分类号： G06F17/30 ,  G06F17/00 ,  G06F13/28 ,  G06F13/00

CPC分类号： G06F17/30327

摘要： A method and system utilizes a hierarchical bitmap structure to represent deleted data sets. Each level in the hierarchical bitmap structure may have progressively larger size and represent finer granularity of number of data blocks than its parent level. A method in one aspect may comprise allocating a first level bitmap having size equal to a register on a processor, each bit in the first level bitmap representing a plurality of blocks of data in a database, and allocating one or more pointers corresponding to said plurality of bits in the first level bitmap, said one or more pointers being allocated to point to a sub bitmap generated after a data block is deleted but before the index corresponding to the data block is cleaned.

摘要翻译： 一种方法和系统利用分层位图结构来表示删除的数据集。 分级位图结构中的每个级别可以具有逐渐更大的大小并且表示比其父级别更多的数据块的粒度。 一方面的方法可以包括：分配具有等于处理器上的寄存器的大小的第一级位图，第一级位图中的每一位表示数据库中的多个数据块，并且分配与所述多个对应的一个或多个指针 所述一个或多个指针被分配以指向在数据块被删除之后但在与数据块相对应的索引被清除之前生成的子位图。

公开(公告)号：US20090164511A1

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

申请号：US12145038

申请日：2008-06-24

申请人： Sean W. MCKEOUGH ,  David Sciaraffa

发明人： Sean W. MCKEOUGH ,  David Sciaraffa

IPC分类号： G06F17/30

CPC分类号： G06F16/22 ,  G06F16/9024

摘要： A system for recreating a plurality of database dependencies of objects from one database to another is disclosed. The system comprises categorizing the dependencies based upon at least one base object and formalizing the relationships of the dependencies based upon the categorization. The system includes determining the order of recreating the objects based upon the formalizing of the relationships of the dependencies. In a preferred embodiment, the system and method builds a Dependency Management Table (DMT) that describes the relationship of each object to a base-table. The DMT includes an entry for every object-to-object relationship, including the category of the relationship, and the nesting-level of the dependency from the base-table. Using this information, objects can be recreated in an order which ensures correct management of dependencies.

摘要翻译： 公开了一种用于从一个数据库到另一个数据库重新创建对象的多个数据库依赖性的系统。 该系统包括基于至少一个基础对象对依赖性进行分类，并且基于分类对依赖性的关系进行形式化。 系统包括基于依赖关系的形式化来确定重新创建对象的顺序。 在优选实施例中，系统和方法构建了描述每个对象与基表的关系的依赖关系管理表（DMT）。 DMT包括每个对象到对象关系的条目，包括关系的类别以及从基表的依赖关系的嵌套级别。 使用此信息，可以按照确保正确管理依赖关系的顺序重新创建对象。

公开(公告)号：US07016911B2

公开(公告)日：2006-03-21

申请号：US10317276

申请日：2002-12-10

申请人： Melissa N. Bousfield ,  Douglas J. Doole ,  Sean W. McKeough ,  Timothy J. Vincent ,  George M. Wilson

发明人： Melissa N. Bousfield ,  Douglas J. Doole ,  Sean W. McKeough ,  Timothy J. Vincent ,  George M. Wilson

IPC分类号： G06F17/30

CPC分类号： G06F9/44594 ,  Y10S707/99942 ,  Y10S707/99945

摘要： Library management for libraries of user-defined routines in a database system. Libraries are stored in a long-term storage device and loaded into working memory in the database system when routines in the libraries are to be executed. An unload thread is defined to carry out the process of unloading libraries from the working memory when such libraries are inactive. The unload thread becomes active on a defined timing interval. The unload thread accesses a hash table and a most recently used list to determine which of the loaded libraries is inactive and which of the libraries ought to be unloaded. The hash table maintains information as to which libraries have been accessed in the most recent past defined timing interval. The size of the most recently used list can be defined such that all libraries associated with the list are retained in working memory.

公开(公告)号：US06985911B2

公开(公告)日：2006-01-10

申请号：US10211392

申请日：2002-08-01

申请人： Douglas J. Doole ,  Sean W. McKeough ,  Timothy J. Vincent ,  George M. Wilson

发明人： Douglas J. Doole ,  Sean W. McKeough ,  Timothy J. Vincent ,  George M. Wilson

IPC分类号： G06F17/30

CPC分类号： G06F9/4843 ,  G06F17/3056 ,  Y10S707/99944

摘要： A database management system provides for the execution of invokable user-defined routines. Applications specify user-defined routines as being threadsafe or not threadsafe and specify the language of user-defined routines. Execution of routines will be carried out dependent on the threadsafe characteristic of the routines and on the language of the routines. Routines are assigned to processes based on their language to have any given process execute routines of the same language. Routines that are specified to be threadsafe are executed in threads in a potentially multi-threaded process. Each routine that is specified to be not threadsafe is executed in a fenced-mode processes in which no other routine is being executed.