公开(公告)号：US6112207A

公开(公告)日：2000-08-29

申请号：US962409

申请日：1997-10-31

申请人： Anil Nori ,  John Weisz ,  Vikas Arora ,  Subramanian Muralidhar

发明人： Anil Nori ,  John Weisz ,  Vikas Arora ,  Subramanian Muralidhar

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30607 ,  Y10S707/99942

摘要： An apparatus and process for storing information objects in a database are disclosed. An information object, instantiated according to an abstract data type having a plurality of attributes, is pickled into an image that contains all values stored in the object in a linearized representation. In one embodiment, the entire image is stored in a single column of a table of the database. In another embodiment, each portion of the image associated with one of the attributes is stored in a separate column of the database table.

摘要翻译： 公开了一种用于在数据库中存储信息对象的装置和过程。 根据具有多个属性的抽象数据类型实例化的信息对象被以包含存储在对象中的所有值的图像以线性化表示形式进行筛选。 在一个实施例中，整个图像被存储在数据库的表的单个列中。 在另一个实施例中，与属性之一相关联的图像的每个部分存储在数据库表的单独列中。

公开(公告)号：US6112210A

公开(公告)日：2000-08-29

申请号：US962416

申请日：1997-10-31

申请人： Anil Nori ,  John Weisz ,  Subramanian Muralidhar

发明人： Anil Nori ,  John Weisz ,  Subramanian Muralidhar

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  Y10S707/99944

摘要： An apparatus and process for storing representations of information objects having null values in a database are disclosed. A null object is established in memory associated with an information-bearing object. The null object has an attribute null value corresponding to each data-bearing attribute of the information-bearing object. Each attribute null value is set to a value indicating whether the corresponding attribute of the information-bearing object is null, not null, or not capable of having a null value. The null object also has an atomic null value that indicates whether the entire information-bearing object is null. When the information-bearing object is to be accessed, the null object is first accessed to determine whether the entire information-bearing object or any attributes thereof are null. Accordingly, unnecessary retrieval and manipulation of the information-bearing object is avoided.

摘要翻译： 公开了一种在数据库中存储具有空值的信息对象的表示的装置和过程。 在与信息承载对象相关联的存储器中建立空对象。 空对象具有对应于信息承载对象的每个数据承载属性的属性空值。 每个属性空值被设置为一个值，该值指示信息承载对象的相应属性是否为空，不为空，或不能具有空值。 空对象还具有一个原子空值，指示整个信息承载对象是否为空。 当要访问信息承载对象时，首先访问空对象以确定整个信息承载对象或其任何属性是否为空。 因此，避免了对信息承载对象的不必要的检索和操作。

公开(公告)号：US20090313436A1

公开(公告)日：2009-12-17

申请号：US12465667

申请日：2009-05-14

申请人： Muralidhar Krishnaprasad ,  Anil Nori ,  Subramanian Muralidhar ,  Sudhir Mohan Jorwekar ,  Lakshmi Suresh Goduguluru

发明人： Muralidhar Krishnaprasad ,  Anil Nori ,  Subramanian Muralidhar ,  Sudhir Mohan Jorwekar ,  Lakshmi Suresh Goduguluru

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

CPC分类号： G06F12/0802 ,  G06F12/0813

摘要： A cache region can be created in a cache in response to receiving a cache region creation request from an application. A storage request from the application can identify the cache region and one or more objects to be stored in the cache region. Those objects can be stored in the cache region in response to receiving the storage request.

摘要翻译： 响应于从应用程序接收高速缓存区域创建请求，可以在高速缓存中创建高速缓存区域。 来自应用的存储请求可以识别高速缓存区域和要存储在高速缓存区域中的一个或多个对象。 响应于接收到存储请求，可以将这些对象存储在高速缓存区域中。

公开(公告)号：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.

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

公开(公告)号：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数据段相关联。

公开(公告)号：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.

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

公开(公告)号：US07158994B1

公开(公告)日：2007-01-02

申请号：US10006605

申请日：2001-12-05

申请人： Wayne Smith ,  Mahesh Subramaniam ,  Subramanian Muralidhar

发明人： Wayne Smith ,  Mahesh Subramaniam ,  Subramanian Muralidhar

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

CPC分类号： G06F17/30418 ,  G06F17/30383 ,  G06F17/30457 ,  Y10S707/954 ,  Y10S707/99932 ,  Y10S707/99943 ,  Y10S707/99944

摘要： Techniques are provided for creating object-oriented materialized views. The object-oriented materialized views may be object materialized views or object-relational materialized views. The base tables may be object tables, object relational tables, or relational tables. The object-oriented materialized views may be refreshed, fully or incrementally. When an object-oriented materialized view is created, refresh code is generated for it. Through the use of object-oriented materialized views, users gain both the efficiency of materialized views and the power of the object-oriented paradigm.

摘要翻译： 提供了用于创建面向对象的物化视图的技术。 面向对象的物化视图可以是对象物化视图或物体关系物化视图。 基表可以是对象表，对象关系表或关系表。 面向对象的物化视图可以被刷新，完全或递增。 当创建面向对象的物化视图时，会为其生成刷新代码。 通过使用面向对象的物化视图，用户可以获得物化视图的效率和面向对象范式的力量。

公开(公告)号：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数据段相关联。