U.S. patents available from 1976 to present.
U.S. patent applications available from 2005 to present.

Method and apparatus for automatically populating a data warehouse system

Patent 6167405 Issued on December 26, 2000. Estimated Expiration Date: Icon_subject April 27, 2018. Estimated Expiration Date is calculated based on simple USPTO term provisions. It does not account for terminal disclaimers, term adjustments, failure to pay maintenance fees, or other factors which might affect the term of a patent.

Patent References

System for converting data from input data environment using first format to output data environment using second format by executing the associations between their fields
Patent #: 5708828
Issued on: 01/13/1998
Inventor: Coleman

System and method for segmenting a database based upon data attributes
Patent #: 5870746
Issued on: 02/09/1999
Inventor: Knutson, et al.

Multidimensional domain modeling method and system Patent #: 5918232
Issued on: 06/29/1999
Inventor: Pouschine, et al.

Inventors

Assignee

Application

No. 067101 filed on 04/27/1998

US Classes:

707/102Generating database or data structure (e.g., via user interface)

Examiners

Primary: Amsbury, Wayne

Attorney, Agent or Firm

International Class

G06F 017/30

Abstract

A method and system for facilitating the creation of warehouse requests in a data warehouse system. During the design of the data warehouse tables, a repository tool is used for storing a number of new objects such as source and target databases, source and target tables and warehouse requests that are graphically defined and linked together by an administrator with the repository tool. The resulting visual design is so drawn so as to serve as input for each warehouse request to be generated. The administrator invokes a data replication component that operatively couples to the repository tool signaling that the warehouse request is to be implemented. The data replication component automatically creates the different subcomponents of the request by accessing various links stored by the repository tool and displays a visual representation of the subcomponents and their relationships to each other to the administrator. Thereafter, the replication component provides access to menu screens for enabling the administrator to visualize each of the subcomponents of the request and their properties for enabling modifications to be made to such subcomponents for completing configuration of all request subcomponents. Subsequently, the warehouse request can be scheduled to execute and populate the warehouse tables.

Other References

  • "Data Warehousing An Introduction", by Grayce Booth, Groupe Bull Technical Update, Man/Jun. 1995, pp. 1-9, Copyright Jun. 1995
  • "The Distributed Data Warehouse Solution", by Kirk Mosher and Ken Rosensteel, Groupe Bull Technical Update, May/Jun. 1995, pp. 11-18 Copyright Jun. 1995
  • "Bull Warehouse Initiative", by Wayne W. Eckerson, Oct. 1996, Patricia Seybold Group, pp. 1-28, Copyright 199
PatentsPlus Images
Enhanced PDF formats
loading...
PatentsPlus: add to cart
PatentsPlus: add to cartSearch-enhanced full patent PDF image
$9.95more info
PatentsPlus: add to cart
PatentsPlus: add to cartIntelligent turbocharged patent PDFs with marked up images
$16.95more info
 
Sign InRegister
Username  
Password   
forgot password?