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

1. 发明授权

US08903814B2 Indexing timestamp with time zone value 有权
标题翻译：使用时区值索引时间戳
公开(公告)号：US08903814B2
公开(公告)日：2014-12-02
申请号：US13177606
申请日：2011-07-07
申请人： Mengchu Cai , Yao Ching Stephen Chen , Ruiping Li , Wei Li , Robert William Lyle
发明人： Mengchu Cai , Yao Ching Stephen Chen , Ruiping Li , Wei Li , Robert William Lyle
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30336
摘要： Techniques are described for processing a query to produce query results, the query specifying at least a first timestamp value. Embodiments receive the query for processing and access a database index containing a plurality of database keys. The database index contains one or more database index keys, each of which includes at least a timestamp value and a time zone value. Embodiments compare the first timestamp value specified in the query with a portion of one the database index keys to locate at least a portion of the query results. More specifically, the compared portion of the database index key excludes the time zone value. The located portion of the query results is then retrieved.
摘要翻译：描述了用于处理查询以产生查询结果的技术，所述查询指定至少第一时间戳值。实施例接收用于处理和访问包含多个数据库密钥的数据库索引的查询。数据库索引包含一个或多个数据库索引关键字，每个索引关键字至少包含时间戳值和时区值。实施例将查询中指定的第一个时间戳值与数据库索引键的一部分进行比较，以查找查询结果的至少一部分。更具体地，数据库索引关键字的比较部分排除时区值。然后检索查询结果的位置部分。

2. 发明授权

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过程部署系统将包含过程逻辑组件和数据库请求组件的查询过程从源系统部署到目标系统。在生成查询过程时，系统生成查询过程源代码，符号表和封装的优化结果，以重新生成数据库请求组件的查询语句的运行时指令，并使查询语句具有部署的过程逻辑零件。在部署期间，系统维护程序逻辑组件和数据库请求组件之间的关联。系统将程序逻辑组件的内部表示复制到目标系统，而无需再生。系统重新生成数据库请求组件以在目标系统上重新创建查询过程，并在过程逻辑组件和数据库请求组件之间保持一致的接口。

3. 发明授权

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语句，该例程的第二个版本被激活。

4. 发明授权

US07246115B2 Materialized view signature and efficient identification of materialized view candidates for queries 失效
标题翻译：物化视图签名和有效识别用于查询的物化视图候选
公开(公告)号：US07246115B2
公开(公告)日：2007-07-17
申请号：US10324800
申请日：2002-12-19
申请人： Guogen Zhang , Irene Ching-Hua Liu , Ding-Wei Chieh , Lee-Chin Hsu Liu , Yao-Ching Stephen Chen , Hsuiying Yen Cheng , Brian Thinh-Vinh Tran , Yun Wang , Ruiping Li
发明人： Guogen Zhang , Irene Ching-Hua Liu , Ding-Wei Chieh , Lee-Chin Hsu Liu , Yao-Ching Stephen Chen , Hsuiying Yen Cheng , Brian Thinh-Vinh Tran , Yun Wang , Ruiping Li
IPC分类号： G06F17/30
CPC分类号： G06F17/30457 , Y10S707/99933 , Y10S707/99934 , Y10S707/99942 , Y10S707/99943
摘要： A method and system for efficiently identifying materialized view candidates for queries filters materialized views using certain criteria, using the materialized view signatures. This filtering rejects some of the unqualified materialized views prior to the performance of the query rewrite matching algorithm, resulting in a group of materialized view candidates. The query rewrite matching algorithm is then performed on the materialized view candidates. By first filtering the materialized views based on their signatures, the number of materialized views on which the query rewrite matching algorithm is performed is significantly reduced, improving performance.
摘要翻译：用于有效地识别用于查询的物化视图候选的方法和系统使用特定的视图签名使用特定标准过滤物化视图。该过滤在执行查询重写匹配算法之前拒绝一些不合格的物化视图，导致一组物化视图候选。然后对物化视图候选进行查询重写匹配算法。通过首先根据其签名过滤物化视图，大大减少了执行查询重写匹配算法的物化视图数量，从而提高了性能。

5. 发明授权

US07124137B2 Method, system, and program for optimizing processing of nested functions 有权
标题翻译：用于优化嵌套函数处理的方法，系统和程序
公开(公告)号：US07124137B2
公开(公告)日：2006-10-17
申请号：US10325781
申请日：2002-12-19
申请人： Fen-Ling Lin , Yao Ching Stephen Chen , Yun Wang , Guogen Zhang , Mengchu Cai , Jason Alexander Cu , Li-Mey Lee
发明人： Fen-Ling Lin , Yao Ching Stephen Chen , Yun Wang , Guogen Zhang , Mengchu Cai , Jason Alexander Cu , Li-Mey Lee
IPC分类号： G06F17/30 , G06F15/177
CPC分类号： G06F17/30917 , Y10S707/99934
摘要： Disclosed is a method, system, and program for processing a function. A set of nested functions are received. A composite function is generated for the set of nested functions. A tagging template is generated for the set of nested functions that corresponds to the composite function. A result is produced by evaluating the composite function using the tagging template.
摘要翻译：公开了一种用于处理功能的方法，系统和程序。接收一组嵌套函数。为嵌套函数集生成一个复合函数。为与复合函数对应的嵌套函数集生成标记模板。通过使用标签模板评估复合函数产生结果。

6. 发明授权

US06829616B2 Method, system, and program for implementing a database trigger 失效
标题翻译：用于实现数据库触发的方法，系统和程序
公开(公告)号：US06829616B2
公开(公告)日：2004-12-07
申请号：US09817501
申请日：2001-03-26
申请人： Yao Ching Stephen Chen , Karelle Lynne Cornwell , Tammie Dang , Beth Rivenes Moore , Kalpana Shyam
发明人： Yao Ching Stephen Chen , Karelle Lynne Cornwell , Tammie Dang , Beth Rivenes Moore , Kalpana Shyam
IPC分类号： G06F1730
CPC分类号： G06F17/3051 , G06F17/30318 , Y10S707/99932 , Y10S707/99933 , Y10S707/99934 , Y10S707/99942 , Y10S707/99943
摘要： Provided is a method, system, and program for implementing a database trigger. Upon detecting a trigger event, a determination is made of at least one row in a base table affected by the trigger event. For each column in the base table of a data type that is referenced in a triggered action associated with the trigger event, a reference is generated referencing the data of the data type. The reference is inserted in a transition table column including data of the data type from the affected row in the base table referenced in the triggered action. The reference is used to access the data of the data type when performing the triggered action.
摘要翻译：提供了一种用于实现数据库触发的方法，系统和程序。在检测到触发事件时，确定受触发事件影响的基表中的至少一行。对于在与触发事件相关联的触发动作中引用的数据类型的基表中的每一列，生成引用数据类型数据的引用。引用被插入到转换表列中，包括在触发操作中引用的基表中的受影响行的数据类型的数据。该参考用于在执行触发动作时访问数据类型的数据。

7. 发明授权

US08572125B2 Scalable storage schemes for native XML column data of relational tables 有权
标题翻译：关系表的本机XML列数据的可扩展存储方案
公开(公告)号：US08572125B2
公开(公告)日：2013-10-29
申请号：US11209598
申请日：2005-08-22
申请人： Yao-Ching Stephen Chen , Fen-Ling Lin , Jerry Mukai , Kalpana Shyam , James Zu-Chia Teng , Guogen Zhang
发明人： Yao-Ching Stephen Chen , Fen-Ling Lin , Jerry Mukai , Kalpana Shyam , James Zu-Chia Teng , Guogen Zhang
IPC分类号： G06F17/30
CPC分类号： G06F17/30595 , G06F17/30923
摘要： A method and system for providing a scalable storage scheme for native hierarchically structured data of relational tables, includes a base table with indicator columns with information pertaining to hierarchically structured data of a document, data tables for storing the hierarchically structured data corresponding to the indicator columns, and node identifier indexes corresponding to the data tables for mapping between the indicator columns and the hierarchically structured data in the data tables. In an embodiment, actual data for each hierarchically structured data (such as XML) column is stored in a separate data table, and each data table has a separate node identifier index. The node identifier index is searched with a key containing the document identifier and a logical node identifier is used, and a record identifier of a record in the data table containing the node assigned the logical node identifier is retrieved.
摘要翻译：提供用于关系表的本机分层结构化数据的可伸缩存储方案的方法和系统包括具有与文档的分层结构化数据有关的信息的指示符列的基表，用于存储对应于指示符列的分层结构化数据的数据表，以及与数据表对应的节点标识符索引，用于在指标列与数据表中的分层结构化数据之间进行映射。在一个实施例中，每个分级结构化数据（例如XML）列的实际数据被存储在单独的数据表中，并且每个数据表具有单独的节点标识符索引。使用包含文档标识符的密钥搜索节点标识符索引，并且使用逻辑节点标识符，并且检索包含分配有逻辑节点标识符的节点的数据表中的记录的记录标识符。

8. 发明授权

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.
摘要翻译：已经公开了用于在十进制浮点数和订单保留格式之间进行转换的方法。该方法将十进制浮点格式的数字编码为保留值排序的格式。该编码允许对两个值进行快速和直接的字符串比较。这样的编码提供十进制浮点数的归一化表示，并且支持类型不敏感的比较。类型不敏感的比较通常用于数据库管理系统，其中数据类型未指定用于比较的值。另外，原始的十进制浮点格式可以从订单保留格式中恢复。

9. 发明申请

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）将数据库的表标记为受保护，为数据库表创建系统授权类，系统授权类具有默认行授权，可以阻止访问所有行该表，系统授权类是不可修改的，为数据库的表创建用户授权类，用户授权类具有默认行授权以防止访问表中的所有行，可修改用户授权类和关联系统授权类和用户授权类与数据库的表。

10. 发明授权

US07376646B2 Cost-based subquery correlation and decorrelation 失效
标题翻译：基于成本的子查询相关和去相关
公开(公告)号：US07376646B2
公开(公告)日：2008-05-20
申请号：US11156500
申请日：2005-06-17
申请人： Thomas Abel Beavin , Mengchu Cai , Yao-Ching Stephen Chen , Hsiuying Yen Cheng , Fen-Ling Lin , Irene Ching-Hua Liu , Jerry Mukai , Demai Ni , Yoichi Tsuji , Li Xia , Ying Zeng
发明人： Thomas Abel Beavin , Mengchu Cai , Yao-Ching Stephen Chen , Hsiuying Yen Cheng , Fen-Ling Lin , Irene Ching-Hua Liu , Jerry Mukai , Demai Ni , Yoichi Tsuji , Li Xia , Ying Zeng
IPC分类号： G06F17/30
CPC分类号： G06F17/30436 , G06F17/30442 , Y10S707/99933 , Y10S707/99934 , Y10S707/99943
摘要： Techniques are provided that determine that a query includes at least one subquery that may be correlated or decorrelated. An internal representation of the query that represents the subquery in both correlated and decorrelated form is generated, wherein the internal representation includes at least one virtual table.
摘要翻译：提供了确定查询包括至少一个可以相关或解相关的子查询的技术。生成表示相关和解相关形式的子查询的查询的内部表示，其中内部表示包括至少一个虚拟表。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式