公开(公告)号：US07512599B2

公开(公告)日：2009-03-31

申请号：US10767501

申请日：2004-01-29

申请人： Qin Yu ,  Adiel M. Yoaz ,  Subramanian Muralidhar ,  Visar Nimani ,  Susan Kotsovolos

发明人： Qin Yu ,  Adiel M. Yoaz ,  Subramanian Muralidhar ,  Visar Nimani ,  Susan Kotsovolos

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

CPC分类号： G06F17/30979 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99943

摘要： A request to execute a query is received in a database system. In response, the database system determines that a collection of data elements to be returned by the query corresponds to a first data structure not defined within a type dictionary of the database system. The database system obtains attribute values that describe respective data fields within the first data structure, and records, within the type dictionary, a first data type definition that specifies the data fields described by the attribute values.

摘要翻译： 在数据库系统中接收到执行查询的请求。 作为响应，数据库系统确定要由查询返回的数据元素的集合对应于在数据库系统的类型字典内未定义的第一数据结构。 数据库系统获得描述第一数据结构内的相应数据字段的属性值，并在类型字典内记录指定由属性值描述的数据字段的第一数据类型定义。

公开(公告)号：US20050154714A1

公开(公告)日：2005-07-14

申请号：US10767501

申请日：2004-01-29

申请人： Qin Yu ,  Adiel Yoaz ,  Subramanian Muralidhar ,  Visar Nimani ,  Susan Kotsovolos

发明人： Qin Yu ,  Adiel Yoaz ,  Subramanian Muralidhar ,  Visar Nimani ,  Susan Kotsovolos

IPC分类号： G06F17/30

CPC分类号： G06F17/30979 ,  Y10S707/99933 ,  Y10S707/99934 ,  Y10S707/99943

摘要： A request to execute a query is received in a database system. In response, the database system determines that a collection of data elements to be returned by the query corresponds to a first data structure not defined within a type dictionary of the database system. The database system obtains attribute values that describe respective data fields within the first data structure, and records, within the type dictionary, a first data type definition that specifies the data fields described by the attribute values.

摘要翻译： 在数据库系统中接收到执行查询的请求。 作为响应，数据库系统确定要由查询返回的数据元素的集合对应于在数据库系统的类型字典内未定义的第一数据结构。 数据库系统获得描述第一数据结构内的相应数据字段的属性值，并在类型字典内记录指定由属性值描述的数据字段的第一数据类型定义。

公开(公告)号：US07853619B2

公开(公告)日：2010-12-14

申请号：US10949895

申请日：2004-09-23

申请人： Qin Yu ,  Muralidhar Krishnaprasad ,  Subramanian Muralidhar ,  Thomas Chang ,  Susan Kotsovolos

发明人： Qin Yu ,  Muralidhar Krishnaprasad ,  Subramanian Muralidhar ,  Thomas Chang ,  Susan Kotsovolos

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

CPC分类号： G06F17/30318 ,  G06F17/30607

摘要： Methods and apparatus for enabling a plurality of table columns arranged to be associated with large objects (LOBs) to share a single LOB data segment within a database are disclosed. According to one aspect of the present invention, a method for allocating space associated with at least a first column arranged to accommodate LOB data and a second column arranged to accommodate LOB data includes allocating a first LOB data segment. The method also includes associating both the first column and the second column with the first LOB data segment.

摘要翻译： 公开了一种用于启用被布置为与大对象（LOB）相关联的多个表列以在数据库内共享单个LOB数据段的方法和装置。 根据本发明的一个方面，一种用于分配空间的方法，所述方法用于分配与至少布置成容纳LOB数据的第一列相关联的空间，以及用于容纳LOB数据的第二列，包括分配第一LOB数据段。 该方法还包括将第一列和第二列与第一LOB数据段相关联。

公开(公告)号：US20060075006A1

公开(公告)日：2006-04-06

申请号：US10949895

申请日：2004-09-23

申请人： Qin Yu ,  Muralidhar Krishnaprasad ,  Subramanian Muralidhar ,  Thomas Chang ,  Susan Kotsovolos

发明人： Qin Yu ,  Muralidhar Krishnaprasad ,  Subramanian Muralidhar ,  Thomas Chang ,  Susan Kotsovolos

IPC分类号： G06F17/30

CPC分类号： G06F17/30318 ,  G06F17/30607

摘要： Methods and apparatus for enabling a plurality of table columns arranged to be associated with large objects (LOBs) to share a single LOB data segment within a database are disclosed. According to one aspect of the present invention, a method for allocating space associated with at least a first column arranged to accommodate LOB data and a second column arranged to accommodate LOB data includes allocating a first LOB data segment. The method also includes associating both the first column and the second column with the first LOB data segment.

摘要翻译： 公开了一种用于启用被布置为与大对象（LOB）相关联的多个表列以共享数据库内的单个LOB数据段的方法和装置。 根据本发明的一个方面，一种用于分配空间的方法，所述方法用于分配与至少布置成容纳LOB数据的第一列相关联的空间，以及用于容纳LOB数据的第二列，包括分配第一LOB数据段。 该方法还包括将第一列和第二列与第一LOB数据段相关联。

公开(公告)号：US20060047670A1

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

申请号：US10912426

申请日：2004-08-05

申请人： Qin Yu ,  Subramanian Muralidhar

发明人： Qin Yu ,  Subramanian Muralidhar

IPC分类号： G06F7/00

CPC分类号： G06F17/30318

摘要： Methods and apparatus for efficiently storing data in a variable array (VARRAY) of a database system are disclosed. A method for storing data in a VARRAY having an associated large object segment in a system having a memory and a kernel includes determining a size of data to be inserted into the VARRAY. The method also includes determining when the size of the data is less than a threshold value, and storing the data as inline raw data in a column of the VARRAY that is present in the memory when the size of the data is less than the threshold value. When the size of the data is not less than the threshold value, the data is stored in a large object that is associated with the VARRAY. Further, when a VARRAY type is evolved to have a larger maximum size, existing data is not migrated or transformed.

摘要翻译： 公开了将数据有效地存储在数据库系统的可变数组（VARRAY）中的方法和装置。 在具有存储器和内核的系统中具有相关联的大对象段的VARRAY中存储数据的方法包括确定要插入到VARRAY中的数据的大小。 该方法还包括当数据的大小小于阈值时确定数据的大小是否小于阈值，并且当数据的大小小于阈值时，将数据作为内联原始数据存储在存在于存储器中的VARRAY的列中 。 当数据的大小不小于阈值时，数据存储在与VARRAY相关联的大对象中。 此外，当VARRAY类型演变为具有较大的最大大小时，现有数据不会迁移或转换。

公开(公告)号：US07320061B2

公开(公告)日：2008-01-15

申请号：US10912426

申请日：2004-08-05

申请人： Qin Yu ,  Subramanian Muralidhar

发明人： Qin Yu ,  Subramanian Muralidhar

IPC分类号： G06F12/00

CPC分类号： G06F17/30318

摘要： Methods and apparatus for efficiently storing data in a variable array (VARRAY) of a database system are disclosed. A method for storing data in a VARRAY having an associated large object segment in a system having a memory and a kernel includes determining a size of data to be inserted into the VARRAY. The method also includes determining when the size of the data is less than a threshold value, and storing the data as inline raw data in a column of the VARRAY that is present in the memory when the size of the data is less than the threshold value. When the size of the data is not less than the threshold value, the data is stored in a large object that is associated with the VARRAY. Further, when a VARRAY type is evolved to have a larger maximum size, existing data is not migrated or transformed.

摘要翻译： 公开了将数据有效地存储在数据库系统的可变数组（VARRAY）中的方法和装置。 在具有存储器和内核的系统中具有相关联的大对象段的VARRAY中存储数据的方法包括确定要插入到VARRAY中的数据的大小。 该方法还包括当数据的大小小于阈值时确定数据的大小是否小于阈值，并且当数据的大小小于阈值时，将数据作为内联原始数据存储在存在于存储器中的VARRAY的列中 。 当数据的大小不小于阈值时，数据存储在与VARRAY相关联的大对象中。 此外，当VARRAY类型演变为具有较大的最大大小时，现有数据不会迁移或转换。

公开(公告)号：US08261020B2

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

申请号：US12469688

申请日：2009-05-21

申请人： Muralidhar Krishnaprasad ,  Sudhir Mohan Jorwekar ,  Sharique Muhammed ,  Subramanian Muralidhar ,  Anil K. Nori

发明人： Muralidhar Krishnaprasad ,  Sudhir Mohan Jorwekar ,  Sharique Muhammed ,  Subramanian Muralidhar ,  Anil K. Nori

IPC分类号： G06F12/00

CPC分类号： G06F12/0813 ,  G06F12/0866 ,  G06F17/30949

摘要： In response to a request including a state object, which can indicate a state of an enumeration of a cache, the enumeration can be continued by using the state object to identify and send cache data. Also, an enumeration of cache units can be performed by traversing a data structure that includes object nodes, which correspond to cache units, and internal nodes. An enumeration state stack can indicate a current state of the enumeration, and can include state nodes that correspond to internal nodes in the data structure. Additionally, a cache index data structure can include a higher level table and a lower level table. The higher level table can have a leaf node pointing to the lower level table, and the lower level table can have a leaf node pointing to one of the cache units. Moreover, the lower level table can be associated with a tag.

摘要翻译： 响应于包括可指示高速缓存的枚举状态的状态对象的请求，可以通过使用状态对象来识别和发送高速缓存数据来继续枚举。 此外，可以通过遍历包括对应于高速缓存单元的对象节点和内部节点的数据结构来执行缓存单元的枚举。 枚举状态堆栈可以指示枚举的当前状态，并且可以包括对应于数据结构中的内部节点的状态节点。 此外，缓存索引数据结构可以包括更高级别的表和较低级别的表。 较高级别的表可以具有指向低级表的叶节点，并且下级表可以具有指向其中一个高速缓存单元的叶节点。 此外，较低级别的表可以与标签相关联。

公开(公告)号：US07877397B2

公开(公告)日：2011-01-25

申请号：US11830281

申请日：2007-07-30

申请人： Ramesh Nagarajan ,  Subramanian Muralidhar ,  Stephen Frederick Starck ,  Sean B. House ,  Simon Cavanagh ,  Fabio Meireles Fernandez Valbuena ,  Katica Iceva

发明人： Ramesh Nagarajan ,  Subramanian Muralidhar ,  Stephen Frederick Starck ,  Sean B. House ,  Simon Cavanagh ,  Fabio Meireles Fernandez Valbuena ,  Katica Iceva

IPC分类号： G06F7/00

CPC分类号： G06F17/30427

摘要： Systems and methods that translate queries defined by an entity model, to a dialect recognizable by storage provider (e.g., relational store). A bridge component facilitates translation of a rich object structure into flat relational constructs, which can then be executed by a relational store. Accordingly, queries defined by applications in terms of entity concepts can readily be employed in conjunction with relational data stores. Similarly, results obtained from executing the query can be converted back to a form understandable by the application.

摘要翻译： 将由实体模型定义的查询转换为存储提供商可识别的方言（例如，关系存储）的系统和方法。 桥接组件有助于将富对象结构转换为平面关系结构，然后可以由关系存储执行。 因此，应用程序根据实体概念定义的查询可以很容易地与关系数据存储一起使用。 类似地，从执行查询获得的结果可以转换回应用程序可以理解的表单。

公开(公告)号：US20100293332A1

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

申请号：US12469688

申请日：2009-05-21

申请人： Muralidhar Krishnaprasad ,  Sudhir Mohan Jorwekar ,  Sharique Muhammed ,  Subramanian Muralidhar ,  Anil K. Nori

发明人： Muralidhar Krishnaprasad ,  Sudhir Mohan Jorwekar ,  Sharique Muhammed ,  Subramanian Muralidhar ,  Anil K. Nori

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

CPC分类号： G06F12/0813 ,  G06F12/0866 ,  G06F17/30949

摘要： In response to a request including a state object, which can indicate a state of an enumeration of a cache, the enumeration can be continued by using the state object to identify and send cache data. Also, an enumeration of cache units can be performed by traversing a data structure that includes object nodes, which correspond to cache units, and internal nodes. An enumeration state stack can indicate a current state of the enumeration, and can include state nodes that correspond to internal nodes in the data structure. Additionally, a cache index data structure can include a higher level table and a lower level table. The higher level table can have a leaf node pointing to the lower level table, and the lower level table can have a leaf node pointing to one of the cache units. Moreover, the lower level table can be associated with a tag.

摘要翻译： 响应于包括可指示高速缓存的枚举状态的状态对象的请求，可以通过使用状态对象来识别和发送高速缓存数据来继续枚举。 此外，可以通过遍历包括对应于高速缓存单元的对象节点和内部节点的数据结构来执行缓存单元的枚举。 枚举状态堆栈可以指示枚举的当前状态，并且可以包括对应于数据结构中的内部节点的状态节点。 此外，缓存索引数据结构可以包括更高级别的表和较低级别的表。 较高级别的表可以具有指向低级表的叶节点，并且下级表可以具有指向其中一个高速缓存单元的叶节点。 此外，较低级别的表可以与标签相关联。

公开(公告)号：US20090037394A1

公开(公告)日：2009-02-05

申请号：US11830281

申请日：2007-07-30

申请人： Ramesh Nagarajan ,  Subramanian Muralidhar ,  Stephen Frederick Starck ,  Sean B. House ,  Simon Cavanagh ,  Fabio Meireles Fernandez Valbuena ,  Katica Iceva

发明人： Ramesh Nagarajan ,  Subramanian Muralidhar ,  Stephen Frederick Starck ,  Sean B. House ,  Simon Cavanagh ,  Fabio Meireles Fernandez Valbuena ,  Katica Iceva

IPC分类号： G06F17/30

CPC分类号： G06F17/30427

摘要： Systems and methods that translate queries defined by an entity model, to a dialect recognizable by storage provider (e.g., relational store). A bridge component facilitates translation of a rich object structure into flat relational constructs, which can then be executed by a relational store. Accordingly, queries defined by applications in terms of entity concepts can readily be employed in conjunction with relational data stores. Similarly, results obtained from executing the query can be converted back to a form understandable by the application.

摘要翻译： 将由实体模型定义的查询转换为存储提供商可识别的方言（例如，关系存储）的系统和方法。 桥接组件有助于将富对象结构转换为平面关系结构，然后可以由关系存储执行。 因此，应用程序根据实体概念定义的查询可以很容易地与关系数据存储一起使用。 类似地，从执行查询获得的结果可以转换回应用程序可以理解的表单。