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

11. 发明授权

US07346609B2 Streaming XPath algorithm for XPath value index key generation 失效
标题翻译：用于XPath值索引密钥生成的流XPath算法
公开(公告)号：US07346609B2
公开(公告)日：2008-03-18
申请号：US10990834
申请日：2004-11-16
申请人： Yao-Ching Stephen Chen , Irene Ching-Hua Liu , Demai Ni , Guogen Zhang , Qinghua Zou
发明人： Yao-Ching Stephen Chen , Irene Ching-Hua Liu , Demai Ni , Guogen Zhang , Qinghua Zou
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99932 , Y10S707/99933 , Y10S707/99936
摘要： A method generates hierarchical path index keys for single and multiple indexes with one scan of a document. Each data node of the document is scanned and matches to query nodes are identified. A data node matches a query node if the three conditions hold: if it is not the root step, there is a match for the query node in the previous step of the query; the data node matches the query node of the current step; and the edges of the data and query nodes match. A sub-tree of a data node can be skipped if the data node is not matched and its level is less than the fixed levels of the query. The matched data node is then placed in the match stacks corresponding to the match query nodes. The method uses transitivity properties among matching units to reduce the number of states that need to be tracked and to improve the evaluation of path expressions significantly.
摘要翻译：一种方法是通过文档的一次扫描为单索引和多索引生成分层路径索引键。对文档的每个数据节点进行扫描，并与查询节点进行匹配。如果三个条件成立，则数据节点与查询节点相匹配：如果不是根步骤，则查询前一步骤中的查询节点匹配; 数据节点匹配当前步骤的查询节点; 数据和查询节点的边缘匹配。如果数据节点不匹配且其级别小于查询的固定级别，则可以跳过数据节点的子树。然后将匹配的数据节点放置在与匹配查询节点相对应的匹配堆栈中。该方法使用匹配单位之间的传递属性来减少需要跟踪的状态数量，并显着提高路径表达式的评估。

12. 发明授权

US07685214B2 Order-preserving encoding formats of floating-point decimal numbers for efficient value comparison 有权
标题翻译：浮点十进制数的订单保留编码格式，用于有效的价值比较
公开(公告)号：US07685214B2
公开(公告)日：2010-03-23
申请号：US11213551
申请日：2005-08-26
申请人： Yao-Ching Stephen Chen , Michael Frederic Cowlishaw , Christopher J. Crone , Fung Lee , Ronald Morton Smith, Sr. , Guogen Zhang , Qinghua Zou
发明人： Yao-Ching Stephen Chen , Michael Frederic Cowlishaw , Christopher J. Crone , Fung Lee , Ronald Morton Smith, Sr. , Guogen Zhang , Qinghua Zou
IPC分类号： G06F7/00 , G06F15/00 , G06F7/38 , H03M5/00
CPC分类号： G06F7/026 , G06F7/491 , G06F2207/4911 , G11B2020/1457 , H03M7/24
摘要： A method for conversion between a decimal floating-point number and an order-preserving format has been disclosed. The method encodes numbers in the decimal floating-point format into a format which preserves value ordering. This encoding allows for fast and direct string comparison of two values. Such an encoding provides normalized representations for decimal floating-point numbers and supports type-insensitive comparisons. Type-insensitive comparisons are often used in database management systems, where the data type is not specified for values to compare. In addition, the original decimal floating-point format can be recovered from the order-preserving format.
摘要翻译：已经公开了用于在十进制浮点数和订单保留格式之间进行转换的方法。该方法将十进制浮点格式的数字编码为保留值排序的格式。该编码允许对两个值进行快速和直接的字符串比较。这样的编码提供十进制浮点数的归一化表示，并且支持类型不敏感的比较。类型不敏感的比较通常用于数据库管理系统，其中数据类型未指定用于比较的值。另外，原始的十进制浮点格式可以从订单保留格式中恢复。

13. 发明授权

US07711746B2 System and method for deploying an SQL procedure 有权
标题翻译：用于部署SQL过程的系统和方法
公开(公告)号：US07711746B2
公开(公告)日：2010-05-04
申请号：US11311810
申请日：2005-12-17
申请人： Margaret Ann Bernal , Yao-Ching Stephen Chen , Ding-Wei Chieh , Curt Lee Cotner , Baoqiu Cui , Tammie Dang , Marion B. Farber , Georgia Carroll Fuller , Joe Cheng-yu Huang , Hui-An Lee , Claire Willey McFeely , Chunfeng Pei , James Willis Pickel , Yumi Kimura Tsuji , Jay A. Yothers , Margaret Alice Zagelow , Liyan Zhou
发明人： Margaret Ann Bernal , Yao-Ching Stephen Chen , Ding-Wei Chieh , Curt Lee Cotner , Baoqiu Cui , Tammie Dang , Marion B. Farber , Georgia Carroll Fuller , Joe Cheng-yu Huang , Hui-An Lee , Claire Willey McFeely , Chunfeng Pei , James Willis Pickel , Yumi Kimura Tsuji , Jay A. Yothers , Margaret Alice Zagelow , Liyan Zhou
IPC分类号： G06F7/00
CPC分类号： G06F17/30587
摘要： An SQL procedure deployment system deploys a query procedure comprising a procedural logic component and a database request component from a source system to a target system. At generation of the query procedure, the system generates a query procedure source code, a symbol table, and an encapsulated optimization results to regenerate run-time instructions for query statements of the database request component and make the query statements function with a deployed procedural logic component. The system maintains an association between the procedural logic component and the database request component during deployment. The system copies an internal representation of the procedural logic component to the target system without regeneration. The system regenerates the database request component to recreate the query procedure on the target system and to maintain a consistent interface between the procedural logic component and database request component.
摘要翻译： SQL过程部署系统将包含过程逻辑组件和数据库请求组件的查询过程从源系统部署到目标系统。在生成查询过程时，系统生成查询过程源代码，符号表和封装的优化结果，以重新生成数据库请求组件的查询语句的运行时指令，并使查询语句具有部署的过程逻辑零件。在部署期间，系统维护程序逻辑组件和数据库请求组件之间的关联。系统将程序逻辑组件的内部表示复制到目标系统，而无需再生。系统重新生成数据库请求组件以在目标系统上重新创建查询过程，并在过程逻辑组件和数据库请求组件之间保持一致的接口。

14. 发明授权

US07580958B2 Supporting multiple versions of a routine 有权
标题翻译：支持多个版本的例程
公开(公告)号：US07580958B2
公开(公告)日：2009-08-25
申请号：US11156509
申请日：2005-06-17
申请人： Yao-Ching Stephen Chen , Curt Lee Cotner , Baoqiu Cui , Tammie Dang , Joe Cheng-yu Huang , Claire Willey McFeely , Robert Thomas Miller , Manogari Nogi Simanjuntak , Yumi Kimura Tsuji , Xiaoyu Yang , Jay A. Yothers , Margaret Alice Zagelow
发明人： Yao-Ching Stephen Chen , Curt Lee Cotner , Baoqiu Cui , Tammie Dang , Joe Cheng-yu Huang , Claire Willey McFeely , Robert Thomas Miller , Manogari Nogi Simanjuntak , Yumi Kimura Tsuji , Xiaoyu Yang , Jay A. Yothers , Margaret Alice Zagelow
IPC分类号： G06F12/00 , G06F17/30
CPC分类号： G06F17/30595 , Y10S707/99952 , Y10S707/99953
摘要： Techniques are provided for supporting versions of a routine. A first version of the routine is created. A second version of the routine is generated in response to receiving an alter statement including an add version clause. The second version of the routine is activated in response to receiving an alter statement including an activate version clause.
摘要翻译：提供了用于支持例程的版本的技术。创建例程的第一个版本。响应于接收到包含add version子句的alter语句，生成该例程的第二个版本。响应于接收到包含activate version子句的alter语句，该例程的第二个版本被激活。

15. 发明申请

US20090182747A1 METHOD AND SYSTEM FOR USING FINE-GRAINED ACCESS CONTROL (FGAC) TO CONTROL ACCESS TO DATA IN A DATABASE 失效
标题翻译：使用细粒度访问控制（FGAC）控制数据库中数据访问的方法和系统
公开(公告)号：US20090182747A1
公开(公告)日：2009-07-16
申请号：US12013253
申请日：2008-01-11
申请人： Paul Miller Bird , Yao-Ching Stephen Chen , George Gerald Kiernan , Scott Ian Logan , Allen William Luniewski , Walid Rjaibi
发明人： Paul Miller Bird , Yao-Ching Stephen Chen , George Gerald Kiernan , Scott Ian Logan , Allen William Luniewski , Walid Rjaibi
IPC分类号： G06F7/04
CPC分类号： G06F21/6227
摘要： A method and system for controlling access to data stored in a table of a database are provided. The method includes marking the table of the database as being protected with fine-grained access control (FGAC), creating a system authorization class for the table of the database, the system authorization class having a default row authorization that prevents access to all rows in the table, the system authorization class being unmodifiable, creating a user authorization class for the table of the database, the user authorization class having a default row authorization that prevents access to all rows in the table, the user authorization class being modifiable, and associating the system authorization class and the user authorization class with the table of the database.
摘要翻译：提供了一种用于控制对存储在数据库表中的数据的访问的方法和系统。该方法包括使用细粒度访问控制（FGAC）将数据库的表标记为受保护，为数据库表创建系统授权类，系统授权类具有默认行授权，可以阻止访问所有行该表，系统授权类是不可修改的，为数据库的表创建用户授权类，用户授权类具有默认行授权以防止访问表中的所有行，可修改用户授权类和关联系统授权类和用户授权类与数据库的表。

16. 发明授权

US08234299B2 Method and system for using fine-grained access control (FGAC) to control access to data in a database 失效
标题翻译：使用细粒度访问控制（FGAC）控制数据库中数据访问的方法和系统
公开(公告)号：US08234299B2
公开(公告)日：2012-07-31
申请号：US12013253
申请日：2008-01-11
申请人： Paul Miller Bird , Yao-Ching Stephen Chen , George Gerald Kiernan , Scott Ian Logan , Allen William Luniewski , Walid Rjaibi
发明人： Paul Miller Bird , Yao-Ching Stephen Chen , George Gerald Kiernan , Scott Ian Logan , Allen William Luniewski , Walid Rjaibi
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F21/6227
摘要： A method and system for controlling access to data stored in a table of a database are provided. The method includes marking the table of the database as being protected with fine-grained access control (FGAC), creating a system authorization class for the table of the database, the system authorization class having a default row authorization that prevents access to all rows in the table, the system authorization class being unmodifiable, creating a user authorization class for the table of the database, the user authorization class having a default row authorization that prevents access to all rows in the table, the user authorization class being modifiable, and associating the system authorization class and the user authorization class with the table of the database.
摘要翻译：提供了一种用于控制对存储在数据库表中的数据的访问的方法和系统。该方法包括使用细粒度访问控制（FGAC）将数据库的表标记为受保护，为数据库表创建系统授权类，系统授权类具有默认行授权，可以阻止访问所有行该表，系统授权类是不可修改的，为数据库的表创建用户授权类，用户授权类具有默认行授权以防止访问表中的所有行，可修改用户授权类和关联系统授权类和用户授权类与数据库的表。

17. 发明授权

US07624119B2 Low-overhead built-in timestamp column for relational database systems 有权
标题翻译：关系数据库系统的低开销内置时间戳列
公开(公告)号：US07624119B2
公开(公告)日：2009-11-24
申请号：US10777604
申请日：2004-02-11
申请人： Yao-Ching Stephen Chen , Curt L. Cotner
发明人： Yao-Ching Stephen Chen , Curt L. Cotner
IPC分类号： G06F17/00
CPC分类号： G06F17/30595 , Y10S707/99933 , Y10S707/99943
摘要： A method for providing a timestamp for data in a database system, in which the database system operates in accordance with a database schema. The method includes providing a hidden timestamp column in a table in the database system, in which the hidden timestamp column includes a timestamp value for each row of data in the table. The timestamp value indicates a last time a corresponding row of data in the table was previously modified. The hidden timestamp column does not appear in the database schema by default and exposes the timestamp value for a given row of data in the table only to a query that calls the timestamp column by name.
摘要翻译：一种用于为数据库系统中的数据提供时间戳的方法，其中数据库系统根据数据库模式进行操作。该方法包括在数据库系统的表中提供隐藏的时间戳列，其中隐藏的时间戳列包括表中每行数据的时间戳值。时间戳值表示上一次表中相应的数据行先前已被修改。默认情况下，隐藏的时间戳列不会出现在数据库模式中，并将表中给定行数据的时间戳值暴露给按名称调用时间戳列的查询。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式