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

81. 发明授权

US08745031B2 Cache-based predicate handling for queries on XML data using uncorrelated path-based row sources 有权
标题翻译：基于缓存的谓词处理，使用不相关的基于路径的行源查询XML数据
公开(公告)号：US08745031B2
公开(公告)日：2014-06-03
申请号：US12474124
申请日：2009-05-28
申请人： Balasubramanyam Sthanikam , Sivasankaran Chandrasekar , Sam Idicula , Nipun Agarwal
发明人： Balasubramanyam Sthanikam , Sivasankaran Chandrasekar , Sam Idicula , Nipun Agarwal
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30935
摘要： The approaches described herein provide an efficient way to process certain kinds of queries that retrieve XML data stored in an object-relational database. An XML query may include a predicate condition that joins two row sources. One or both of the row sources required for predicate evaluation may be path-based; that is, consume and produce rows of XMLType data. Such a path-based row source may be modified to use the predicate condition to filter the rows it generates so that only rows satisfying the predicate condition need to be further processed. A small cache structure introduced into the path-based row source may be used to optimize the evaluation of the predicate row. Once populated with row data, the cache structure may be reorganized to optimize the performance of predicate evaluation.
摘要翻译：本文描述的方法提供了处理检索存储在对象关系数据库中的XML数据的某些类型的查询的有效方式。 XML查询可能包括连接两个行源的谓词条件。谓词评估所需的一个或两个行来源可能是基于路径的; 就是消费和生成XMLType数据行。这样的基于路径的行源可以被修改为使用谓词条件来过滤其生成的行，使得仅需要进一步处理满足谓词条件的行。引入基于路径的行源中的小缓存结构可用于优化谓词行的评估。一旦填充行数据，缓存结构可能被重组，以优化谓词评估的性能。

82. 发明授权

US08713426B2 Technique for skipping irrelevant portions of documents during streaming XPath evaluation 有权
标题翻译：在流式传输XPath评估期间跳过文档的无关部分的技术
公开(公告)号：US08713426B2
公开(公告)日：2014-04-29
申请号：US12491981
申请日：2009-06-25
申请人： Sam Idicula , Nipun Agarwal , Sanket Malde
发明人： Sam Idicula , Nipun Agarwal , Sanket Malde
IPC分类号： G06F17/00
CPC分类号： G06F17/2247 , G06F17/22 , G06F17/30929
摘要： A method and apparatus are described for summarizing a document. For each node in the document that satisfies a marking criteria, a start and end mark pair is stored in a summary in document order. The start mark specifies a location in the document where the node starts, and the end mark specifies a location in the document where the node ends. When evaluating a query for a hierarchical path, the document is streamed into memory until the mark of a tag matches a start mark in the summary. If that tag does not fit within the path, then streaming of the document may resume at the end mark, thereby skipping the node during streaming evaluation. Translation information may be used to indicate a logical position relative to the marks in the summary when the document is modified.
摘要翻译：描述用于总结文档的方法和装置。对于满足标记条件的文档中的每个节点，开始和结束标记对将以文档顺序存储在摘要中。开始标记指定文档中节点启动的位置，结束标记指定节点结束的文档中的位置。当评估分层路径的查询时，文档将流式传输到内存中，直到标记的标记与摘要中的起始标记相匹配。如果该标签不适合路径，则可以在结束标记处恢复文档的流传输，从而在流评估期间跳过该节点。当文档被修改时，翻译信息可以用于指示在摘要中相对于标记的逻辑位置。

83. 发明授权

US08584196B2 Technique for efficiently evaluating a security policy 有权
标题翻译：有效评估安全策略的技术
公开(公告)号：US08584196B2
公开(公告)日：2013-11-12
申请号：US12114915
申请日：2008-05-05
申请人： Mohammed Irfan Rafiq , Sabina Petride , Sam Idicula , Ashwini Surpur , Nipun Agarwal , Bhushan Khaladkar , Tim Wing Yu
发明人： Mohammed Irfan Rafiq , Sabina Petride , Sam Idicula , Ashwini Surpur , Nipun Agarwal , Bhushan Khaladkar , Tim Wing Yu
IPC分类号： G06F21/00
CPC分类号： G06F21/604
摘要： One embodiment of the present invention provides a system for efficiently evaluating a security policy. During operation, the system retrieves one or more roles associated with the user. Next, the system checks if a session-level cache exists for a set of Access Control Entries (ACEs) which is associated with the one or more roles. If this session-level cache exists, the system returns the set of ACEs from the session-level cache. Otherwise, the system generates the set of ACEs associated with the one or more roles from an Access Control List (ACL). During operation, the system can also update the one or more roles associated with the user and update the set of ACEs based on the updated one or more roles and the ACL. The system subsequently updates the session level cache with the updated set of ACEs and updated one or more roles.
摘要翻译：本发明的一个实施例提供了一种用于有效评估安全策略的系统。在操作期间，系统检索与用户相关联的一个或多个角色。接下来，系统检查与一个或多个角色相关联的一组访问控制条目（ACE）是否存在会话级缓存。如果此会话级缓存存在，系统会从会话级缓存中返回一组ACE。否则，系统将从访问控制列表（ACL）生成与一个或多个角色相关联的一组ACE。在操作期间，系统还可以更新与用户相关联的一个或多个角色，并根据更新的一个或多个角色和ACL更新ACE集合。系统随后使用更新的一组ACE更新会话级缓存并更新一个或多个角色。

84. 发明授权

US08392405B2 Performing cost-based optimizations of authorization checks in database systems 有权
标题翻译：在数据库系统中执行基于成本优化的授权检查
公开(公告)号：US08392405B2
公开(公告)日：2013-03-05
申请号：US12144028
申请日：2008-06-23
申请人： Sam Idicula , Mohammed Irfan Rafiq , Nipun Agarwal
发明人： Sam Idicula , Mohammed Irfan Rafiq , Nipun Agarwal
IPC分类号： G06F7/00
CPC分类号： G06F17/30448
摘要： One embodiment of the present invention provides a system that facilitates performing a cost-based optimization of authorization checks in a database system. During operation, the system receives a query at the database system. Next, the system estimates a cost for executing the query, which involves estimating a cost for evaluating authorization checks, which involve functional evaluations of access rights for data accessed by the query. The system then rewrites the query to include evaluating authorization checks within the query. The system also estimates a cost for executing the rewritten query. Next, the system determines if executing the rewritten query has a lower cost than executing the query and performing the authorization checks. If so, the system executes the rewritten query. However, if not, the system executes the query.
摘要翻译：本发明的一个实施例提供一种有助于在数据库系统中执行授权检查的基于成本的优化的系统。在操作过程中，系统在数据库系统中接收查询。接下来，系统估计执行查询的成本，其涉及估计用于评估授权检查的成本，其涉及对查询访问的数据的访问权限的功能评估。然后系统重写查询以包括在查询中评估授权检查。该系统还估计执行重写查询的成本。接下来，系统确定执行重写查询是否具有比执行查询并执行授权检查更低的成本。如果是这样，系统将执行重写的查询。但是，如果没有，则系统执行查询。

85. 发明授权

US08301620B2 Efficient way to evaluate aggregations on XML data using path-based row sources 有权
标题翻译：使用基于路径的行源来评估XML数据的聚合的高效方法
公开(公告)号：US08301620B2
公开(公告)日：2012-10-30
申请号：US12474133
申请日：2009-05-28
申请人： Balasubramanyam Sthanikam , Sam Idicula , Nipun Agarwal
发明人： Balasubramanyam Sthanikam , Sam Idicula , Nipun Agarwal
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30935
摘要： The approaches described herein provide an efficient way for a database server to process certain kinds of queries that require the evaluation of an aggregation function over XML data stored in an object-relational database. An aggregation function takes multiple inputs and generates a single output. A database server first determines whether the query qualifies for this particular kind of optimization, then creates a query execution plan that specifies the use of an enhanced path-based row source, eliminating the need for a second path-based row source for computing the aggregation function. The enhanced path-based row source specified in the query execution plan computes an aggregation function and stores the result of that function computation in a column of each row. The XPath evaluation results that are the individual inputs to the aggregation function are only stored temporarily until they are used to compute the aggregation function.
摘要翻译：本文描述的方法为数据库服务器处理需要通过存储在对象关系数据库中的XML数据对聚合函数进行评估的某些类型的查询提供了有效的方式。聚合函数需要多个输入并生成单个输出。数据库服务器首先确定查询是否符合这种特定类型的优化，然后创建一个查询执行计划，该计划指定使用基于增强路径的行源，从而无需使用第二个基于路径的行源来计算聚合功能。在查询执行计划中指定的基于增强路径的行源计算聚合函数，并将该函数计算的结果存储在每行的列中。作为聚合函数的各个输入的XPath评估结果只能临时存储，直到它们用于计算聚合函数为止。

86. 发明授权

US08255372B2 Efficient validation of binary XML data 有权
标题翻译：二进制XML数据的有效验证
公开(公告)号：US08255372B2
公开(公告)日：2012-08-28
申请号：US12689196
申请日：2010-01-18
申请人： Vijay Medi , Sam Idicula , Nipun Agarwal
发明人： Vijay Medi , Sam Idicula , Nipun Agarwal
IPC分类号： G06F17/30
CPC分类号： G06F17/2252 , G06F17/2247 , G06F17/2725 , G06F17/30917
摘要： Data used and generated by the process of validating XML documents is divided into two categories: compile-time static data and runtime data. Runtime data may be specific to a particular XML document and changes when validating the XML document, while compile-time data does not change in this way. For example, compile-time data may be data that defines, according to a schema, the descendant elements and ordering between them. Runtime data is information generated to track which descendants occurred in a particular XML document being validated. Compile-time static data, once generated to validate a particular XML document, is cached within a shared volatile memory. Once the compile-time data is cached, the compile-time static data may be used to validate other XML documents without the need to regenerate the compile-time static data.
摘要翻译：通过验证XML文档的过程使用和生成的数据分为两类：编译时静态数据和运行时数据。运行时数据可能特定于特定的XML文档，并在验证XML文档时进行更改，而编译时数据不会以此方式更改。例如，编译时数据可以是根据模式定义后代元素和它们之间的排序的数据。运行时数据是生成的信息，用于跟踪正在验证的特定XML文档中发生的哪些后代。编译时静态数据，一旦生成以验证特定的XML文档，就被缓存在共享的易失性存储器中。一旦编译时数据被缓存，编译时静态数据就可以用于验证其他XML文档，而不需要重新生成编译时静态数据。

87. 发明授权

US08161035B2 Query optimization by specifying path-based predicate evaluation in a path-based query operator 有权
标题翻译：通过在基于路径的查询运算符中指定基于路径的谓词评估来查询优化
公开(公告)号：US08161035B2
公开(公告)日：2012-04-17
申请号：US12478147
申请日：2009-06-04
申请人： Ning Zhang , Sam Idicula , Balasubramanyam Sthanikam , Nipun Agarwal
发明人： Ning Zhang , Sam Idicula , Balasubramanyam Sthanikam , Nipun Agarwal
IPC分类号： G06F17/30
CPC分类号： G06F17/30938 , G06F17/30463
摘要： The approaches described herein provide an efficient way for a database server to process certain kinds of queries over XML data stored in an object-relational database that require the evaluation of a predicate expression with one or more path-based operands. A predicate expression part of a XQuery or SQL WHERE clause that returns a boolean value. A database server first determines whether the query qualifies for this particular kind of optimization, then rewrites the query using an enhanced query operator syntax for specifying the predicate expression to be evaluated. The enhanced query operator subsumes the work of a second path-based query operator, resulting in the suppression of the WHERE EXISTS subquery. The rewritten query operator is used to generate a query execution plan that provides for several query execution optimizations.
摘要翻译：本文描述的方法为数据库服务器处理某些类型的查询提供了一种有效的方法，该XML数据存储在需要使用一个或多个基于路径的操作数的谓词表达式的对象关系数据库中。 XQuery或SQL WHERE子句的谓词表达式部分，返回一个布尔值。数据库服务器首先确定查询是否符合此特定类型的优化，然后使用增强型查询运算符语法重写查询，以指定要评估的谓词表达式。增强型查询操作符包含第二个基于路径的查询运算符的工作，从而抑制了WHERE EXISTS子查询。重写的查询运算符用于生成提供多个查询执行优化的查询执行计划。

88. 发明申请

US20120066271A1 Operationally Complete Hierarchical Repository In A Relational Database 有权
标题翻译：关系数据库中的操作完整的分层存储库
公开(公告)号：US20120066271A1
公开(公告)日：2012-03-15
申请号：US13301690
申请日：2011-11-21
申请人： Sivasankaran Chandrasekar , Sam Idicula , Nipun Agarwal , Viswanathan Krishnamurthy
发明人： Sivasankaran Chandrasekar , Sam Idicula , Nipun Agarwal , Viswanathan Krishnamurthy
IPC分类号： G06F7/00
CPC分类号： G06F17/30917 , G06F17/30451 , Y10S707/99945
摘要： A modular repository is described, where operational features may be implemented without the need to scan every resource included in the modular repository. A modular repository includes a dedicated set of database objects containing all information needed to access the resources in the repository. For example, the database objects of a modular repository may include those user identifier mappings and ACL mappings, etc., to which metadata in the modular repository refers. A database system may also include a mechanism through which a modular repository may be mounted under a subdirectory of a common directory in the database system. The resources of a modular repository that are mounted under the common directory may be accessed through the common directory. Further, a client may query the resources of any modular repository mounted under the common directory by making the federated repository, represented by the common directory, the context of the query.
摘要翻译：描述了模块化存储库，其中可以实现操作特征，而不需要扫描模块化存储库中包括的每个资源。模块化存储库包括一组专用的数据库对象，其中包含访问存储库中资源所需的所有信息。例如，模块化存储库的数据库对象可以包括模块化存储库中的元数据引用的那些用户标识符映射和ACL映射等。数据库系统还可以包括机构，模块化存储库可以通过该机制安装在数据库系统中的公用目录的子目录下。安装在公共目录下的模块化存储库的资源可以通过公共目录访问。此外，客户端可以通过使由共同目录表示的联合存储库，查询的上下文来查询安装在公用目录下的任何模块化存储库的资源。

89. 发明授权

US08073843B2 Mechanism for deferred rewrite of multiple XPath evaluations over binary XML 有权
标题翻译：对二进制XML进行多个XPath评估的延迟重写的机制
公开(公告)号：US08073843B2
公开(公告)日：2011-12-06
申请号：US12181725
申请日：2008-07-29
申请人： Sivasankaran Chandrasekar , Balasubramanyam Sthanikam , Sam Idicula , Nipun Agarwal
发明人： Sivasankaran Chandrasekar , Balasubramanyam Sthanikam , Sam Idicula , Nipun Agarwal
IPC分类号： G06F7/00
CPC分类号： G06F17/30935 , G06F17/30911
摘要： A mechanism is provided for improving the performance of particular database queries operating on a view comprising binary-encoded XML. A determination is made about whether a XML index is available to improve the computation of XPath data before deriving an optimized execution plan for a particular query. When a XML index is not available to help expedite the computation of binary-encoded XML, then deferring the computation of the XPath data until after the view merge stage avoids unnecessary computation of XPaths that are part of the view but not needed for the particular query.
摘要翻译：提供了一种机制，用于提高在包含二进制编码XML的视图上操作的特定数据库查询的性能。在为特定查询导出优化的执行计划之前，确定XML索引是否可用于改进XPath数据的计算。当XML索引不可用以帮助加速二进制编码的XML的计算时，则推迟XPath数据的计算，直到视图合并阶段之后，避免不必要的计算XPath作为视图的一部分，但不需要特定的查询。

90. 发明申请

US20110066654A1 OPERATIONALLY COMPLETE HIERARCHICAL REPOSITORY IN A RELATIONAL DATABASE 有权
标题翻译：在关系数据库中运行完整的分层报告
公开(公告)号：US20110066654A1
公开(公告)日：2011-03-17
申请号：US12560242
申请日：2009-09-15
申请人： Sivasankaran Chandrasekar , Sam Idicula , Nipun Agarwal , Viswanathan Krishnamurthy
发明人： Sivasankaran Chandrasekar , Sam Idicula , Nipun Agarwal , Viswanathan Krishnamurthy
IPC分类号： G06F7/00
CPC分类号： G06F17/30917 , G06F17/30451 , Y10S707/99945
摘要： A modular repository is described, where operational features may be implemented without the need to scan every resource included in the modular repository. A modular repository includes a dedicated set of database objects containing all information needed to access the resources in the repository. For example, the database objects of a modular repository may include those user identifier mappings and ACL mappings, etc., to which metadata in the modular repository refers. A database system may also include a mechanism through which a modular repository may be mounted under a subdirectory of a common directory in the database system. The resources of a modular repository that are mounted under the common directory may be accessed through the common directory. Further, a client may query the resources of any modular repository mounted under the common directory by making the federated repository, represented by the common directory, the context of the query.
摘要翻译：描述了模块化存储库，其中可以实现操作特征，而不需要扫描模块化存储库中包括的每个资源。模块化存储库包括一组专用的数据库对象，其中包含访问存储库中资源所需的所有信息。例如，模块化存储库的数据库对象可以包括模块化存储库中的元数据引用的那些用户标识符映射和ACL映射等。数据库系统还可以包括机构，模块化存储库可以通过该机制安装在数据库系统中的公用目录的子目录下。安装在公共目录下的模块化存储库的资源可以通过公共目录访问。此外，客户端可以通过使由共同目录表示的联合存储库，查询的上下文来查询安装在公用目录下的任何模块化存储库的资源。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式