专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明申请

US20050131890A1 Communicating external expressions using a parallel single cursor model 有权
标题翻译：使用并行单光标模型来传达外部表达式
公开(公告)号：US20050131890A1
公开(公告)日：2005-06-16
申请号：US10865178
申请日：2004-06-09
申请人： Thierry Cruanes , Bhaskar Ghosh , Subramanian Muralidhar , William Waddington
发明人： Thierry Cruanes , Bhaskar Ghosh , Subramanian Muralidhar , William Waddington
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30445 , Y10S707/99932 , Y10S707/99938
摘要： Techniques are provided for processing, within a database server, a database statement, where at least one subtask required by the database statement is to be executed in parallel by a slave set. The database server determines whether the database statement includes an external expression, relative to the subtask, that (a) produces information that is required by slave processes in the slave set in order to perform the subtask, and (b) is not to be evaluated by each slave process in the slave set. During execution of the statement, if the database statement includes an external expression, then one or more external values are generated by causing the external expression to be evaluated, and the one or more external values are communicated to slaves of the slave set to allow the slave processes to perform respective portions of the subtask in parallel, without requiring each slave of the slave set to evaluate the external expression.
摘要翻译：提供技术来在数据库服务器内处理数据库语句，数据库语句所要求的至少一个子任务将由从属集并行执行。数据库服务器确定数据库语句是否包含相对于子任务的外部表达式，（a）产生从属集中的从属进程所需的信息以执行子任务，并且（b）不被评估由从设备中的每个从属进程。在执行语句期间，如果数据库语句包含外部表达式，则通过使外部表达式进行求值来生成一个或多个外部值，并将一个或多个外部值传送到从设备的从站，以允许从属进程并行执行子任务的各个部分，而不需要从属集的每个从属点来评估外部表达式。

2. 发明授权

US07203672B2 Communicating external expressions using a parallel single cursor model 有权
标题翻译：使用并行单光标模型来传达外部表达式
公开(公告)号：US07203672B2
公开(公告)日：2007-04-10
申请号：US10865178
申请日：2004-06-09
申请人： Thierry Cruanes , Bhaskar Ghosh , Subramanian Muralidhar , William H. Waddington
发明人： Thierry Cruanes , Bhaskar Ghosh , Subramanian Muralidhar , William H. Waddington
IPC分类号： G06F17/30
CPC分类号： G06F17/30445 , Y10S707/99932 , Y10S707/99938
摘要： Techniques are provided for processing, within a database server, a database statement, where at least one subtask required by the database statement is to be executed in parallel by a slave set. The database server determines whether the database statement includes an external expression, relative to the subtask, that (a) produces information that is required by slave processes in the slave set in order to perform the subtask, and (b) is not to be evaluated by each slave process in the slave set. During execution of the statement, if the database statement includes an external expression, then one or more external values are generated by causing the external expression to be evaluated, and the one or more external values are communicated to slaves of the slave set to allow the slave processes to perform respective portions of the subtask in parallel, without requiring each slave of the slave set to evaluate the external expression.
摘要翻译：提供技术来在数据库服务器内处理数据库语句，数据库语句所要求的至少一个子任务将由从属集并行执行。数据库服务器确定数据库语句是否包含相对于子任务的外部表达式，（a）产生从属集中的从属进程所需的信息以执行子任务，并且（b）不被评估由从设备中的每个从属进程。在执行语句期间，如果数据库语句包含外部表达式，则通过使外部表达式进行求值来生成一个或多个外部值，并将一个或多个外部值传送到从设备的从站，以允许从属进程并行执行子任务的各个部分，而不需要从属集的每个从属点来评估外部表达式。

3. 发明授权

US07451133B2 Executing nested subqueries of parallel table functions in the parallel single cursor model 有权
标题翻译：在并行单光标模型中执行并行表函数的嵌套子查询
公开(公告)号：US07451133B2
公开(公告)日：2008-11-11
申请号：US10930433
申请日：2004-08-30
申请人： Adiel Yoaz , Thierry Cruanes , Bhaskar Ghosh , Subramanian Muralidhar
发明人： Adiel Yoaz , Thierry Cruanes , Bhaskar Ghosh , Subramanian Muralidhar
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F7/00 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936
摘要： Techniques are provided for processing a database statement that includes a table function capable of parallel execution, where the input of the table function is specified in a subquery. During compilation of the database statement, a global cursor is generated for the database statement. The global cursor includes a first plan component for executing the table function and a second plan component for generating input for the table function. A “dummy” cursor is then generated. When slaves execute the table function, they call the dummy cursor for input. When a slave calls the dummy cursor for input, the dummy cursor causes a context switch back to the global cursor, so that the second plan component within the first cursor generates the input for the slave.
摘要翻译：提供了用于处理数据库语句的技术，该数据库语句包括能够并行执行的表函数，其中在子查询中指定了表函数的输入。在编译数据库语句时，会为数据库语句生成一个全局游标。全局光标包括用于执行表功能的第一计划组件和用于生成表功能的输入的第二计划组件。然后生成“虚拟”光标。当从站执行表功能时，它们调用虚拟光标进行输入。当从机调用虚拟光标进行输入时，虚拟光标会使上下文切换回全局光标，以便第一个光标中的第二个计划组件生成从属设备的输入。

4. 发明申请

US20050131880A1 Executing nested subqueries of parallel table functions in the parallel single cursor model 有权
标题翻译：在并行单光标模型中执行并行表函数的嵌套子查询
公开(公告)号：US20050131880A1
公开(公告)日：2005-06-16
申请号：US10930433
申请日：2004-08-30
申请人： Adiel Yoaz , Thierry Cruanes , Bhaskar Ghosh , Subramanian Muralidhar
发明人： Adiel Yoaz , Thierry Cruanes , Bhaskar Ghosh , Subramanian Muralidhar
IPC分类号： G06F7/00
CPC分类号： G06F7/00 , Y10S707/99931 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99935 , Y10S707/99936
摘要： Techniques are provided for processing a database statement that includes a table function capable of parallel execution, where the input of the table function is specified in a subquery. During compilation of the database statement, a global cursor is generated for the database statement. The global cursor includes a first plan component for executing the table function and a second plan component for generating input for the table function. A “dummy” cursor is then generated. When slaves execute the table function, they call the dummy cursor for input. When a slave calls the dummy cursor for input, the dummy cursor causes a context switch back to the global cursor, so that the second plan component within the first cursor generates the input for the slave.
摘要翻译：提供了用于处理数据库语句的技术，该数据库语句包括能够并行执行的表函数，其中在子查询中指定了表函数的输入。在编译数据库语句时，会为数据库语句生成一个全局游标。全局光标包括用于执行表功能的第一计划组件和用于生成表功能的输入的第二计划组件。然后生成“虚拟”光标。当从站执行表功能时，它们调用虚拟光标进行输入。当从机调用虚拟光标进行输入时，虚拟光标会使上下文切换回全局光标，以便第一个光标中的第二个计划组件生成从属设备的输入。

5. 发明授权

US08261020B2 Cache enumeration and indexing 有权
标题翻译：缓存枚举和索引
公开(公告)号：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.
摘要翻译：响应于包括可指示高速缓存的枚举状态的状态对象的请求，可以通过使用状态对象来识别和发送高速缓存数据来继续枚举。此外，可以通过遍历包括对应于高速缓存单元的对象节点和内部节点的数据结构来执行缓存单元的枚举。枚举状态堆栈可以指示枚举的当前状态，并且可以包括对应于数据结构中的内部节点的状态节点。此外，缓存索引数据结构可以包括更高级别的表和较低级别的表。较高级别的表可以具有指向低级表的叶节点，并且下级表可以具有指向其中一个高速缓存单元的叶节点。此外，较低级别的表可以与标签相关联。

6. 发明授权

US07877397B2 Extensible command execution for entity data model platform 有权
标题翻译：实体数据模型平台的可扩展命令执行
公开(公告)号：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.
摘要翻译：将由实体模型定义的查询转换为存储提供商可识别的方言（例如，关系存储）的系统和方法。桥接组件有助于将富对象结构转换为平面关系结构，然后可以由关系存储执行。因此，应用程序根据实体概念定义的查询可以很容易地与关系数据存储一起使用。类似地，从执行查询获得的结果可以转换回应用程序可以理解的表单。

7. 发明授权

US07853619B2 Storage model for large object columns 有权
标题翻译：大对象列的存储模型
公开(公告)号：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数据段相关联。

8. 发明申请

US20100293332A1 CACHE ENUMERATION AND INDEXING 有权
标题翻译：缓存创建和索引
公开(公告)号：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.
摘要翻译：响应于包括可指示高速缓存的枚举状态的状态对象的请求，可以通过使用状态对象来识别和发送高速缓存数据来继续枚举。此外，可以通过遍历包括对应于高速缓存单元的对象节点和内部节点的数据结构来执行缓存单元的枚举。枚举状态堆栈可以指示枚举的当前状态，并且可以包括对应于数据结构中的内部节点的状态节点。此外，缓存索引数据结构可以包括更高级别的表和较低级别的表。较高级别的表可以具有指向低级表的叶节点，并且下级表可以具有指向其中一个高速缓存单元的叶节点。此外，较低级别的表可以与标签相关联。

9. 发明申请

US20090037394A1 EXTENSIBLE COMMAND EXECUTION FOR ENTITY DATA MODEL PLATFORM 有权
标题翻译：实体数据模型平台的可扩展命令执行
公开(公告)号：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.
摘要翻译：将由实体模型定义的查询转换为存储提供商可识别的方言（例如，关系存储）的系统和方法。桥接组件有助于将富对象结构转换为平面关系结构，然后可以由关系存储执行。因此，应用程序根据实体概念定义的查询可以很容易地与关系数据存储一起使用。类似地，从执行查询获得的结果可以转换回应用程序可以理解的表单。

10. 发明授权

US07158994B1 Object-oriented materialized views 有权
标题翻译：面向对象的物化视图
公开(公告)号：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.
摘要翻译：提供了用于创建面向对象的物化视图的技术。面向对象的物化视图可以是对象物化视图或物体关系物化视图。基表可以是对象表，对象关系表或关系表。面向对象的物化视图可以被刷新，完全或递增。当创建面向对象的物化视图时，会为其生成刷新代码。通过使用面向对象的物化视图，用户可以获得物化视图的效率和面向对象范式的力量。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式