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

1. 发明授权

US08214408B2 Method, database system and computer program for joining temporal database tables 有权
标题翻译：用于连接时间数据库表的方法，数据库系统和计算机程序
公开(公告)号：US08214408B2
公开(公告)日：2012-07-03
申请号：US12239868
申请日：2008-09-29
申请人： Bhashyam Ramesh , Manjula Koppuravuri , Chandrasekhar Tekur
发明人： Bhashyam Ramesh , Manjula Koppuravuri , Chandrasekhar Tekur
IPC分类号： G06F7/00
CPC分类号： G06F17/30483
摘要： A method, database system and computer program are disclosed for performing a temporal join between two temporal database tables. The method includes determining a selected table intersection between a period of interest and a time period value for a selected table row, scanning an inner table for a row that matches the selected table on the join conditions and overlaps the selected table intersection, and determining the remainder time period values from the selected table intersection.
摘要翻译：公开了用于执行两个时间数据库表之间的时间连接的方法，数据库系统和计算机程序。该方法包括确定感兴趣时段和所选择的表行的时间段值之间的所选择的表交集，在连接条件上扫描与所选表匹配的行的内部表，并与所选择的表交集重叠，并且确定来自所选表交叉点的剩余时间段值。

2. 发明申请

US20100082601A1 METHOD, DATABASE SYSTEM AND COMPUTER PROGRAM FOR JOINING TEMPORAL DATABASE TABLES 有权
标题翻译：方法，数据库系统和计算机程序接收时间数据表
公开(公告)号：US20100082601A1
公开(公告)日：2010-04-01
申请号：US12239868
申请日：2008-09-29
申请人： Bhashyam Ramesh , Manjula Koppuravuri , Chandrasekhar Tekur
发明人： Bhashyam Ramesh , Manjula Koppuravuri , Chandrasekhar Tekur
IPC分类号： G06F7/06 , G06F17/30
CPC分类号： G06F17/30483
摘要： A method, database system and computer program are disclosed for performing a temporal join between two temporal database tables. The method includes determining a selected table intersection between a period of interest and a time period value for a selected table row, scanning an inner table for a row that matches the selected table on the join conditions and overlaps the selected table intersection, and determining the remainder time period values from the selected table intersection.
摘要翻译：公开了用于执行两个时间数据库表之间的时间连接的方法，数据库系统和计算机程序。该方法包括确定感兴趣时段和所选择的表行的时间段值之间的所选择的表交集，在连接条件上扫描与所选表匹配的行的内部表，并与所选择的表交集重叠，并且确定来自所选表交叉点的剩余时间段值。

3. 发明授权

US09430526B2 Method and system for temporal aggregation 有权
标题翻译：时间聚合的方法和系统
公开(公告)号：US09430526B2
公开(公告)日：2016-08-30
申请号：US12240019
申请日：2008-09-29
申请人： Bhashyam Ramesh , Manjula Koppuravuri
发明人： Bhashyam Ramesh , Manjula Koppuravuri
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30471 , G06F17/30463 , G06F17/30466 , G06F17/30489 , G06F17/30498 , G06F17/30551
摘要： A method, database system and computer program are disclosed for optimizing a SQL query, in which the SQL query seeks to aggregate temporal database information. The method includes determining whether two rows of information have a common grouping value, and if so, determining both temporal overlap and temporal non-overlap components of the two rows, aggregating each of the temporal overlap components of the two rows, and separating the temporal non-overlap components of the two rows.
摘要翻译：公开了用于优化SQL查询的方法，数据库系统和计算机程序，其中SQL查询寻求聚合时间数据库信息。该方法包括确定两行信息是否具有公共分组值，如果是，则确定两行的时间重叠和时间非重叠分量，聚合两行的每个时间重叠分量，并分离时间两行的非重叠组件。

4. 发明授权

US08250064B1 Caching execution plans for queries that use timestamps 有权
标题翻译：缓存使用时间戳的查询的执行计划
公开(公告)号：US08250064B1
公开(公告)日：2012-08-21
申请号：US12754694
申请日：2010-04-06
申请人： Bhashyam Ramesh , Manjula Koppuravuri
发明人： Bhashyam Ramesh , Manjula Koppuravuri
IPC分类号： G06F17/30
CPC分类号： G06F17/3048 , G06F17/30483
摘要： A computer system programmed as a database receives a query Q1. Q1 includes a predicate. The predicate includes a reference to a current timestamp of time TT1. The database has R data structures. The computer system creates a plan, Plan 1, to execute Q1. Plan 1 includes the identification of a first set of data structures, P1, to be accessed in executing Plan 1, at the current timestamp of time TT1. The number of data structures in P1 is less than R. The computer system determines that Plan 1 is valid for a period of time. The computer system stores in a cache Plan 1 and an indication that Plan 1 is valid for the period of time.
摘要翻译：作为数据库编程的计算机系统接收查询Q1。 Q1包含谓词。谓词包括对时间TT1的当前时间戳的引用。数据库具有R数据结构。计算机系统创建计划1，执行Q1。方案1包括在时间TT1的当前时间戳处识别在执行计划1中要访问的第一组数据结构P1。 P1中的数据结构数量小于R.计算机系统确定计划1在一段时间内有效。计算机系统存储在缓存计划1中，并且计划1在一段时间内有效的指示。

5. 发明授权

US08666956B1 Sequenced modifications of multiple rows in a temporal table 有权
标题翻译：在时间表中对多行进行了顺序修改
公开(公告)号：US08666956B1
公开(公告)日：2014-03-04
申请号：US12969795
申请日：2010-12-16
申请人： Bhashyam Ramesh , Manjula Koppuravuri
发明人： Bhashyam Ramesh , Manjula Koppuravuri
IPC分类号： G06F17/30
CPC分类号： G06F17/30551 , G06F17/30498 , G06F17/30548
摘要： A SEQUENCED request a) to apply a temporal Source table to a temporal Target table under a predicate is received. The Source table includes a plurality of rows that qualify to apply to a single Target table row under the predicate. The predicate specifies a Source table join column. Each of the plurality of Source table rows and the single Target table row include a ValidTime dimension. The plurality of Source table rows is b) ordered by the Source table join column and a period-to-be-modified. The next of the ordered plurality of Source table rows is c) applied by determining that the Target table row has a TransactionTime and, in response, closing out the TransactionTime of the Target table row. Applying the next of the ordered plurality of Source table rows includes identifying an RDIFF range as the period-to-be-modified of the Source table row being applied that is later than the ValidTime range of the single Target table row. Applying the next of the ordered plurality of Source table rows includes creating an RDIFF row being the same as the Target table row except the ValidTime of the RDIFF row is set to RDIFF range. A second of the ordered plurality of Source table rows d) is applied by applying c) to the RDIFF row as the Target table row.
摘要翻译： SEQUENCED请求a）将时间源表应用于谓词下的时间目标表。源表包含多个行，这些行有资格应用于谓词下的单个目标表行。谓词指定了源表连接列。多个源表行和单个目标表行中的每一个包括一个有效时间维度。多个源表行是b）由源表连接列排序并进行修改。通过确定目标表行具有TransactionTime并且作为响应关闭目标表行的TransactionTime，应用下一个排序的多个源表行。应用下一个有序的多个源表行包括将RDIFF范围标识为正在应用的源表行的周期，该时间段晚于单个目标表行的ValidTime范围。应用下一个有序的多个源表行包括创建与目标表行相同的RDIFF行，但RDIFF行的有效时间值被设置为RDIFF范围。通过将c）应用到RDIFF行作为目标表行来应用订购的多个源表行d）中的第二行。

6. 发明授权

US08621482B1 Deciding whether to cache a generic plan for executing a request based on a system performance metric 有权
标题翻译：决定是否缓存基于系统性能指标执行请求的通用计划
公开(公告)号：US08621482B1
公开(公告)日：2013-12-31
申请号：US12205380
申请日：2008-09-05
申请人： Bhashyam Ramesh , Donald Pederson , Manjula Koppuravuri
发明人： Bhashyam Ramesh , Donald Pederson , Manjula Koppuravuri
IPC分类号： G06F9/46 , G06F7/00
CPC分类号： G06F9/5027 , G06F17/30433 , G06F2209/501
摘要： A method, computer program, and database system are disclosed. A plurality of instances of a request to a database system are received. All instances of the request have a same set of variables to use in executing the request. The values of the variables are supplied by data in a data source. A specific plan for executing one instance of the request is generated. Generating the specific plan includes taking into account data in the data source. The specific plan is executed on the database system. A system run-time metric and a parsing time for executing the specific plan are captured and saved. A generic plan is generated and cached based on a comparison of the system run-time metric and the parsing time for executing the specific plan.
摘要翻译：公开了一种方法，计算机程序和数据库系统。接收到对数据库系统的请求的多个实例。请求的所有实例都有一组相同的变量用于执行请求。变量的值由数据源中的数据提供。生成用于执行请求的一个实例的具体计划。生成具体计划包括考虑数据源中的数据。具体计划在数据库系统上执行。捕获并保存用于执行特定计划的系统运行时度量和解析时间。基于系统运行时间度量和执行特定计划的解析时间的比较，生成和缓存通用计划。

7. 发明授权

US08301934B1 Commit-time timestamping of temporal rows 有权
标题翻译：时间行的提交时间戳
公开(公告)号：US08301934B1
公开(公告)日：2012-10-30
申请号：US12425692
申请日：2009-04-17
申请人： Bhashyam Ramesh , Manjula Koppuravuri
发明人： Bhashyam Ramesh , Manjula Koppuravuri
IPC分类号： G06F11/00
CPC分类号： G06F17/30705
摘要： A base table temporal row affected by a transaction is timestamped. The temporal row has a row ID. The temporal row in the base table is modified according to the transaction. The row ID for the modified temporal row is associated with an identifier for the transaction in a temporal work table. Upon committing the transaction: the temporal work table is searched to determine the row ID of the temporal row modified by the transaction, and a commit-time is saved into the temporal row identified by the row ID.
摘要翻译：受事务影响的基表时间行是时间戳的。时间行有行ID。根据交易修改基表中的时间行。修改的时间行的行ID与时间工作表中的事务的标识符相关联。在提交事务时：搜索时间工作表以确定由事务修改的时间行的行ID，并将提交时间保存到由行ID标识的时间行中。

8. 发明授权

US08335772B1 Optimizing DML statement execution for a temporal database 有权
标题翻译：优化时间数据库的DML语句执行
公开(公告)号：US08335772B1
公开(公告)日：2012-12-18
申请号：US12269331
申请日：2008-11-12
申请人： Bhashyam Ramesh , Manjula Koppuravuri
发明人： Bhashyam Ramesh , Manjula Koppuravuri
IPC分类号： G06F17/30
CPC分类号： G06F17/30377
摘要： A method, system, and computer program for optimizing execution of a DML statement on a temporal database are disclosed. A first execution package is provided to an execution engine. The first execution package includes a plurality of operations to be executed if the contents of a row in a table in the temporal database indicate the row has a first temporal condition. A second execution package is provided to the execution engine. The second execution package includes a plurality of operations to be executed if the contents of the row in the table in the temporal database indicate the row has a second temporal condition. The execution engine is run to produce a result. The result is saved.
摘要翻译：公开了一种用于在时间数据库上优化DML语句的执行的方法，系统和计算机程序。向执行引擎提供第一执行包。如果时间数据库中的表中的行的内容指示行具有第一时间条件，则第一执行包包括要执行的多个操作。向执行引擎提供第二个执行包。如果时间数据库中的表中的行的内容指示行具有第二时间条件，则第二执行包包括要执行的多个操作。执行引擎运行以产生结果。结果得到保存。

9. 发明申请

US20100082705A1 METHOD AND SYSTEM FOR TEMPORAL AGGREGATION 有权
标题翻译：用于时间聚集的方法和系统
公开(公告)号：US20100082705A1
公开(公告)日：2010-04-01
申请号：US12240019
申请日：2008-09-29
申请人： Bhashyam Ramesh , Manjula Koppuravuri
发明人： Bhashyam Ramesh , Manjula Koppuravuri
IPC分类号： G06F17/30
CPC分类号： G06F17/30471 , G06F17/30463 , G06F17/30466 , G06F17/30489 , G06F17/30498 , G06F17/30551
摘要： A method, database system and computer program are disclosed for optimizing a SQL query, in which the SQL query seeks to aggregate temporal database information. The method includes determining whether two rows of information have a common grouping value, and if so, determining both temporal overlap and temporal non-overlap components of the two rows, aggregating each of the temporal overlap components of the two rows, and separating the temporal non-overlap components of the two rows.
摘要翻译：公开了用于优化SQL查询的方法，数据库系统和计算机程序，其中SQL查询寻求聚合时间数据库信息。该方法包括确定两行信息是否具有公共分组值，如果是，则确定两行的时间重叠和时间非重叠分量，聚合两行的每个时间重叠分量，并分离时间两行的非重叠组件。

10. 发明授权

US07962521B2 Index selection in a database system 有权
标题翻译：数据库系统中的索引选择
公开(公告)号：US07962521B2
公开(公告)日：2011-06-14
申请号：US12396184
申请日：2009-03-02
申请人： Douglas P. Brown , Jeetendra Chaware , Manjula Koppuravuri
发明人： Douglas P. Brown , Jeetendra Chaware , Manjula Koppuravuri
IPC分类号： G06F17/30
CPC分类号： G06F17/30336 , Y10S707/99932 , Y10S707/99933 , Y10S707/99937 , Y10S707/99938 , Y10S707/99939
摘要： An index selection mechanism allows for efficient generation of index recommendations for a given workload of a database system. The workload includes a set of queries that are used to access tables in a database system. The index recommendations are validated to verify improved performance, followed by application of the indexes. Graphical user interface screens are provided to receive user input as well as to present reports to the user.
摘要翻译：索引选择机制允许为数据库系统的给定工作负载高效地生成索引建议。工作负载包括用于访问数据库系统中的表的一组查询。索引建议被验证以验证性能提高，然后应用索引。提供图形用户界面屏幕以接收用户输入以及向用户呈现报告。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式