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

1. 发明申请

US20140040310A1 QUERY-LEVEL ACCESS TO EXTERNAL PETABYTE-SCALE DISTRIBUTED FILE SYSTEMS 有权
标题翻译： QUERY-LEVEL访问外部PETABYTE-SCALE分布式文件系统
公开(公告)号：US20140040310A1
公开(公告)日：2014-02-06
申请号：US13564204
申请日：2012-08-01
申请人： Robert HANCKEL , Garret SWART
发明人： Robert HANCKEL , Garret SWART
IPC分类号： G06F17/30
CPC分类号： G06F17/30557 , G06F17/30126 , G06F17/30194 , G06F17/30283 , G06F17/30445 , G06F17/30516 , G06F17/3056
摘要： A system to implement query-level access by a database engine to an external distributed file system by identifying a results file location of one or more results files on the external distributed file system, and storing the results file locations in external table files on the database engine for subsequent use during retrieval of data from the results files. The database engine serves to process queries where the query specifies the external table (which in turn references locations of the results files). Execution of the query streams data from the external distributed file system into the database engine. The data from the external distributed file system is not stored in the external table files on the database engine; rather, the external table files specify a location of code or operational directives which, when executed, streams results from the external distributed file system to at least one parallel query engine.
摘要翻译：通过在外部分布式文件系统上识别一个或多个结果文件的结果文件位置，并将结果文件位置存储在数据库中的外部表格文件中，来实现数据库引擎对外部分布式文件系统的查询级别访问的系统引擎，用于在从结果文件检索数据时随后使用。数据库引擎用于处理查询，其中查询指定了外部表（又反映了结果文件的位置）。从外部分布式文件系统执行查询流数据到数据库引擎。来自外部分布式文件系统的数据不存储在数据库引擎的外部表文件中; 相反，外部表文件指定代码或操作指令的位置，当执行时，将来自外部分布式文件系统的结果传送到至少一个并行查询引擎。

2. 发明申请

US20120191682A1 DATABASE SYSTEM THAT PROVIDES FOR HISTORY-ENABLED TABLES 有权
标题翻译：为历史启动表提供的数据库系统
公开(公告)号：US20120191682A1
公开(公告)日：2012-07-26
申请号：US13440702
申请日：2012-04-05
申请人： Jayanta BANERJEE , Robert Hanckel , Siva Ravada
发明人： Jayanta BANERJEE , Robert Hanckel , Siva Ravada
IPC分类号： G06F17/30 , G06F7/00
CPC分类号： G06F17/30306
摘要： Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The start time field's value in a row of the history-enabled table indicates when the contents of the row last changed. The rows of the history table are copies of rows of the history-enabled table that have been deleted or updated. The rows include end time fields whose values indicate when the row was updated or deleted. A history table's row thus indicates a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table.
摘要翻译：用于历史的技术，使数据库系统中的表能够使历史启用的表的行的历史版本可用于时间查询。通过向表中添加开始时间列并为启用历史记录的表创建历史记录表来启用表。历史使能表中的行的起始时间字段的值指示行的内容何时更改。历史记录表的行是已经被删除或更新的启用历史记录的表的行的副本。这些行包括结束时间字段，其值指示行何时更新或删除。历史表格的行因此表示历史记录表的行在启用历史记录的表中的一段时间。时间查询是在具有历史记录功能的表和历史记录表的联合的视图上执行的。

3. 发明授权

US07970742B2 Techniques for implementing indexes on columns in database tables whose values specify periods of time 有权
标题翻译：在值指定时间段的数据库表中的列上实现索引的技术
公开(公告)号：US07970742B2
公开(公告)日：2011-06-28
申请号：US11292138
申请日：2005-12-01
申请人： Robert Hanckel , Jayanta Banerjee , Siva Ravada
发明人： Robert Hanckel , Jayanta Banerjee , Siva Ravada
IPC分类号： G06F17/30
CPC分类号： G06F17/30551
摘要： Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The history table's rows are copies of rows of the history-enabled table that have changed and include start time and end time fields whose values indicate a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table. The temporal queries are speeded up by period of time indexes in which the leaves are grouped based on time period size, identifiers are assigned to the groups, and the keys of the index include the group identifiers.
摘要翻译：用于历史的技术，使数据库系统中的表能够使历史启用的表的行的历史版本可用于时间查询。通过向表中添加开始时间列并为启用历史记录的表创建历史记录表，可以启用历史记录。历史记录表的行是已更改的历史记录表的行的副本，并且包含起始时间和结束时间字段，其值表示历史记录表的行在启用历史记录的表中的一段时间。时间查询是在具有历史记录功能的表和历史记录表的联合的视图上执行的。时间查询通过基于时间段大小对叶片进行分组的时间段索引进行加速，标识符被分配给组，索引的密钥包括组标识符。

4. 发明授权

US09384222B2 Database system that provides for history-enabled tables 有权
标题翻译：提供启用历史记录的表的数据库系统
公开(公告)号：US09384222B2
公开(公告)日：2016-07-05
申请号：US13440702
申请日：2012-04-05
申请人： Jayanta Banerjee , Robert Hanckel , Siva Ravada
发明人： Jayanta Banerjee , Robert Hanckel , Siva Ravada
IPC分类号： G06F17/30
CPC分类号： G06F17/30306
摘要： Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The start time field's value in a row of the history-enabled table indicates when the contents of the row last changed. The rows of the history table are copies of rows of the history-enabled table that have been deleted or updated. The rows include end time fields whose values indicate when the row was updated or deleted. A history table's row thus indicates a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table.
摘要翻译：用于历史的技术，使数据库系统中的表能够使历史启用的表的行的历史版本可用于时间查询。通过向表中添加开始时间列并为启用历史记录的表创建历史记录表来启用表。历史使能表中的行的起始时间字段的值指示行的内容何时更改。历史记录表的行是已经被删除或更新的启用历史记录的表的行的副本。这些行包括结束时间字段，其值指示行何时更新或删除。历史表格的行因此表示历史记录表的行在启用历史记录的表中的一段时间。时间查询是在具有历史记录功能的表和历史记录表的联合的视图上执行的。

5. 发明申请

US20070130226A1 Database system that provides for history-enabled tables 有权
标题翻译：提供启用历史记录的表的数据库系统
公开(公告)号：US20070130226A1
公开(公告)日：2007-06-07
申请号：US11291446
申请日：2005-12-01
申请人： Jayanta Banerjee , Robert Hanckel , Siva Ravada
发明人： Jayanta Banerjee , Robert Hanckel , Siva Ravada
IPC分类号： G06F17/30
CPC分类号： G06F17/30306
摘要： Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The start time field's value in a row of the history-enabled table indicates when the contents of the row last changed. The rows of the history table are copies of rows of the history-enabled table that have been deleted or updated. The rows include end time fields whose values indicate when the row was updated or deleted. A history table's row thus indicates a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table.
摘要翻译：用于历史的技术，使数据库系统中的表能够使历史启用的表的行的历史版本可用于时间查询。通过向表中添加开始时间列并为启用历史记录的表创建历史记录表来启用表。历史使能表中的行的起始时间字段的值指示行的内容何时更改。历史记录表的行是已经被删除或更新的启用历史记录的表的行的副本。这些行包括结束时间字段，其值指示行何时更新或删除。历史表格的行因此表示历史记录表的行在启用历史记录的表中的一段时间。时间查询是在具有历史记录功能的表和历史记录表的联合的视图上执行的。

6. 发明申请

US20070130171A1 Techniques for implementing indexes on columns in database tables whose values specify periods of time 有权
标题翻译：在值指定时间段的数据库表中的列上实现索引的技术
公开(公告)号：US20070130171A1
公开(公告)日：2007-06-07
申请号：US11292138
申请日：2005-12-01
申请人： Robert Hanckel , Jayanta Banerjee , Siva Ravada
发明人： Robert Hanckel , Jayanta Banerjee , Siva Ravada
IPC分类号： G06F7/00
CPC分类号： G06F17/30551
摘要： Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The history table's rows are copies of rows of the history-enabled table that have changed and include start time and end time fields whose values indicate a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table. The temporal queries are speeded up by period of time indexes in which the leaves are grouped based on time period size, identifiers are assigned to the groups, and the keys of the index include the group identifiers.
摘要翻译：用于历史的技术，使数据库系统中的表能够使历史启用的表的行的历史版本可用于时间查询。通过向表中添加开始时间列并为启用历史记录的表创建历史记录表，可以启用历史记录。历史记录表的行是已更改的历史记录表的行的副本，并且包含起始时间和结束时间字段，其值表示历史记录表在历史记录启用的表中的行期。时间查询是在具有历史记录功能的表和历史记录表的联合的视图上执行的。时间查询通过基于时间段大小对叶片进行分组的时间段索引进行加速，标识符被分配给组，索引的密钥包括组标识符。

7. 发明授权

US09589036B2 Query-level access to external petabyte-scale distributed file systems 有权
标题翻译：查询级访问外部PB级分布式文件系统
公开(公告)号：US09589036B2
公开(公告)日：2017-03-07
申请号：US13564204
申请日：2012-08-01
申请人： Robert Hanckel , Garret Swart
发明人： Robert Hanckel , Garret Swart
IPC分类号： G06F17/30
CPC分类号： G06F17/30557 , G06F17/30126 , G06F17/30194 , G06F17/30283 , G06F17/30445 , G06F17/30516 , G06F17/3056
摘要： A system to implement query-level access by a database engine to an external distributed file system by identifying a results file location of one or more results files on the external distributed file system, and storing the results file locations in external table files on the database engine for subsequent use during retrieval of data from the results files. The database engine serves to process queries where the query specifies the external table (which in turn references locations of the results files). Execution of the query streams data from the external distributed file system into the database engine. The data from the external distributed file system is not stored in the external table files on the database engine; rather, the external table files specify a location of code or operational directives which, when executed, streams results from the external distributed file system to at least one parallel query engine.
摘要翻译：通过在外部分布式文件系统上识别一个或多个结果文件的结果文件位置，并将结果文件位置存储在数据库中的外部表格文件中，来实现数据库引擎对外部分布式文件系统的查询级别访问的系统引擎，用于在从结果文件检索数据时随后使用。数据库引擎用于处理查询，其中查询指定了外部表（又反映了结果文件的位置）。从外部分布式文件系统执行查询流数据到数据库引擎。来自外部分布式文件系统的数据不存储在数据库引擎的外部表文件中; 相反，外部表文件指定代码或操作指令的位置，当执行时，将来自外部分布式文件系统的结果传送到至少一个并行查询引擎。

8. 发明授权

US08156083B2 Database system that provides for history-enabled tables 有权
标题翻译：提供启用历史记录的表的数据库系统
公开(公告)号：US08156083B2
公开(公告)日：2012-04-10
申请号：US11291446
申请日：2005-12-01
申请人： Jayanta Banerjee , Robert Hanckel , Siva Ravada
发明人： Jayanta Banerjee , Robert Hanckel , Siva Ravada
IPC分类号： G07F17/30
CPC分类号： G06F17/30306
摘要： Techniques for history enabling a table in a database system so that past versions of rows of the history-enabled table are available for temporal querying. The table is history enabled by adding a start time column to the table and creating a history table for the history-enabled table. The start time field's value in a row of the history-enabled table indicates when the contents of the row last changed. The rows of the history table are copies of rows of the history-enabled table that have been deleted or updated. The rows include end time fields whose values indicate when the row was updated or deleted. A history table's row thus indicates a period in which the history table's row was in the history-enabled table. Temporal queries are performed on a view which is the union of the history-enabled table and the history table.
摘要翻译：用于历史的技术，使数据库系统中的表能够使历史启用的表的行的历史版本可用于时间查询。通过向表中添加开始时间列并为启用历史记录的表创建历史记录表，可以启用历史记录。历史使能表中的行的起始时间字段的值指示行的内容何时更改。历史记录表的行是已经被删除或更新的启用历史记录的表的行的副本。这些行包括结束时间字段，其值指示行何时更新或删除。历史表格的行因此表示历史记录表的行在启用历史记录的表中的一段时间。时间查询是在具有历史记录功能的表和历史记录表的联合的视图上执行的。

9. 发明授权

US07174340B1 Interval-based adjustment data includes computing an adjustment value from the data for a pending adjustment in response to retrieval of an adjusted data value from a database 有权
标题翻译：基于间隔的调整数据包括响应于从数据库检索调整后的数据值，从待处理的调整数据中计算调整值
公开(公告)号：US07174340B1
公开(公告)日：2007-02-06
申请号：US09641223
申请日：2000-08-17
申请人： Lory Molesky , Robert Hanckel
发明人： Lory Molesky , Robert Hanckel
IPC分类号： G06F17/00 , G06F17/30 , G06F15/00
CPC分类号： G06F17/30548 , G06Q40/04 , Y10S707/95 , Y10S707/99933 , Y10S707/99943 , Y10S707/99945
摘要： Interval-based adjustments to data are applied by a relational database engine. The engine stores raw, unadjusted data values in a separate table from adjustment values. The adjustment values are dynamically updated in response to a new adjustment interval. The adjustments are applied to the raw data during retrieval from the database. This results in an efficient and transparent adjustment to data.
摘要翻译：数据的基于间隔的调整由关系数据库引擎应用。引擎将原始的，未调整的数据值存储在单独的表格和调整值中。响应于新的调整间隔动态更新调整值。在从数据库检索期间将调整应用于原始数据。这样可以高效透明地调整数据。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式