Invention Grant
US07882103B2 Using point-in-time views to provide varying levels of data freshness 有权
使用时间点视图来提供不同级别的数据新鲜度

  • Patent Title: Using point-in-time views to provide varying levels of data freshness
  • Patent Title (中): 使用时间点视图来提供不同级别的数据新鲜度
  • Application No.: US10109025
    Application Date: 2002-03-28
  • Publication No.: US07882103B2
    Publication Date: 2011-02-01
  • Inventor: Stephen A. Brobst
  • Applicant: Stephen A. Brobst
  • Applicant Address: US OH Dayton
  • Assignee: Teradata US, Inc.
  • Current Assignee: Teradata US, Inc.
  • Current Assignee Address: US OH Dayton
  • Agent John Cowart Senior Attorney
  • Main IPC: G06F17/00
  • IPC: G06F17/00
Using point-in-time views to provide varying levels of data freshness
Abstract:
A data-warehousing system allows various areas of an enterprise to view data at varying levels of data freshness. The system acquires data that represents an event in the life of a business enterprise, such as a transaction between the enterprise and one of its customers, and loads this data into a database table. The system then makes the data available for retrieval from the table and stores information indicating when the data was made available for retrieval. In some embodiments, the system also acquires data that is related to and more current than the data representing the event and stores the more current data in the database. The system then stores information indicating when the more current data was stored in the database. Such a data warehouse allows decision-makers in the business to see some information (e.g., customer transaction or account data) up-to-the-moment and other information as it stood at some specific point-in-time, such as at the end of the previous month. The data-warehousing system does this without requiring duplication of data, i.e., without requiring the replication of data in multiple databases or tables. The system allows the enterprise to maintain all of its data in a single database with refresh periods as short as the enterprise wishes. Departments that demand data that changes less frequently can view the data as it stood at some point prior to the last refresh.
Information query
Patent Agency Ranking
0/0