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

1. 发明授权

US08090751B2 Operational data store 有权
标题翻译：操作数据存储
公开(公告)号：US08090751B2
公开(公告)日：2012-01-03
申请号：US10068466
申请日：2002-02-05
申请人： Sally Elaine Saffer , Mario J. Broodbakker , Raymond J. Laliberte , John F. Reed, Jr.
发明人： Sally Elaine Saffer , Mario J. Broodbakker , Raymond J. Laliberte , John F. Reed, Jr.
IPC分类号： G06F17/00
CPC分类号： G06F17/30595
摘要： An operational data store consists of an insert table for storing new data and a history table, partitioned by range and further sub-partitioned, for storing historical data. Transfer logic periodically transfers new data from the insert table to the history table. The transfer logic includes a secondary table and fill logic for filling the secondary table with selected data from the insert table. Secondary transfer logic transfers the secondary table into the history table, such that the selected data is transferred into the history table. Indexing logic applies the history table indexing scheme to the secondary table. Table logic creates a new partition the history table, for swapping with the secondary table, by exchanging respective pointers. A query engine may apply a database query to both the history table and the insert table, so that all data is available. An aggregator accumulates new data into an aggregation buffer. The accumulated data are batched and transferred into the insert table with a single database access. A throttler throttles transactions of different classes and types independently to achieve a desired level of service. The system can be configured to execute in a plurality of processor nodes configured as a processor cluster, wherein distinct database server instances are associated with distinct processor nodes of the processor cluster.
摘要翻译：操作数据存储器包括用于存储新数据的插入表和由范围划分并进一步子分区的历史表，用于存储历史数据。传输逻辑会将新数据从插入表定期传输到历史表。传输逻辑包括用于从插入表中填充具有所选数据的辅助表的辅助表和填充逻辑。辅助传输逻辑将辅助表传输到历史表中，使得所选择的数据被传送到历史表中。索引逻辑将历史表索引方案应用于辅助表。表逻辑创建一个新分区历史表，用于与辅助表进行交换，通过交换各自的指针。查询引擎可以将数据库查询应用于历史表和插入表，以便所有数据都可用。聚合器将新数据累加到聚合缓冲区中。累积的数据被分批并转移到具有单个数据库访问的插入表中。节流器独立地调节不同类和类型的事务以实现所需的服务水平。该系统可被配置为在配置为处理器集群的多个处理器节点中执行，其中不同的数据库服务器实例与处理器集群的不同处理器节点相关联。

IPRDB

热门服务

关于我们

友情链接

联系方式