Data warehouse portal

• US 6,671,689 B2
• Filed: 01/19/2001
• Issued: 12/30/2003
• Est. Priority Date: 01/19/2001
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: NCR Corporation
• Inventors: Papierniak, Karen
• Primary Examiner(s): KINDRED, ALFORD W
• Application Number:
  US09/764,115
• Publication Number:
  US 20020099710A1
• Time in Patent Office: 1,075 Days
• Field of Search: 707/1-5, 707/100-102, 707/104.1, 707/200, 707/205, 707/509, 707/513-514, 709/200-203, 715/509, 715/513-514, 715/526
• US Class Current: 1/1
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

The present invention is a data warehouse portal for providing a client with an overall view of one or more data warehouses to aid in the analysis of data in the warehouse(s). The portal allows the client to gain an insight about the data to determine how the data is used, who uses the data, if additional data sources are required, and what impact a data change may have. The portal reads and/or searches metadata and/or XML schemas from the data warehouses and tools available for accessing data stored in the data warehouse, and display the data warehouse information through a browser in numerous ways, such as hierarchical, user and application views. Other views may include extraction, usage, historical and comparison.

Claims

1. A method of presenting an implementation of a data warehouse comprising the steps of:

a) receiving an inquiry requesting information about at least a data element;

b) retrieving a data structure of the data element from the data warehouse;

c) determining (i) tools available for accessing the data element, and (ii) users using at least one of the tools to access the data element; and

d) generating a view in response to the inquiry showing at least one of (i) the data structure retrieved in said retrieving step, (ii) the tools and (iii) the users determined in said determining step.

2. The method of claim 1, wherein said retrieving step comprises accessing metadata or XML schemas describing the data element in the data warehouse.

3. The method of claim 1, further including a step of generating a hierarchical view of a hierarchy of data stored in the data warehouse, said hierarchical view comprising at least one of databases, database sections, tables, and table columns.

4. The method of claim 3, comprising selecting the data element from the data hierarchy during said receiving step.

5. The method of claim 1, wherein said determining step comprises querying an application set exploiting data stored in the data warehouse.

6. The method of claim 1, further including a step of generating a user view of users gaining access to the data warehouse, said user view comprising at least one of organizations, groups, and individuals.

7. The method of claim 1, further including a step of generating an application view of an application set exploiting data stored in the data warehouse, said application view comprising at least one of solution areas, application types, and application names.

8. The method of claim 1, further including a step of generating an extraction view comprising sources of data items stored in the data warehouse under the data element, and manipulations performed on the data items being transferred from the sources to the data warehouse.

9. The method of claim 1, further including a step of generating an usage view comprising a pattern of usage of the data element based on at least one of a group of users, a set of tools, and a period of time, whereby an impact of changes to the data element is determined.

10. The method of claim 1, further including a step of generating a historical view comprising at least one of past and future updates to the data element.

11. The method of claim 1, further including a step of generating a comparison view comparing at least one of the data structure of, the tools and the users accessing the data element with at least one of data structure of, tools and users accessing another data element, respectively.

12. The method of claim 1, further including a step of displaying at least an exemplary data item stored in the data warehouse under the data element.

13. The method of claim 1, further including a step of requesting at least one of data change and additional data based on at least one of the data structure of, the tools and the users accessing the data element.

14. The method of claim 1, further including a step of highlighting a data change by comparing at least one of the current data structure of, the tools and the users currently accessing the data element with at least one of data structure of, tools and users accessing the data element in accordance with the data change, respectively.

15. The method of claim 14, wherein the data change is one of past and future updates.

16. The method of claim 1, wherein the data element is one of a data warehouse section, a database, a database section, a table, a group of table column, and a table column.

17. A computer architecture for presenting an implementation of a data warehouse, said computer architecture comprising:

receiving means for receiving an inquiry requesting information about at least a data element;

retrieving means for retrieving a data structure of the data element from the data warehouse;

determining means for determining (i) tools available for accessing the data element, and (ii) users using at least one of the tools to access the data element; and

generating means for generating a view in response to the inquiry showing at least one of (i) the data structure retrieved by said retrieving means, (ii) the tools and (iii) the users determined by said determining means.

18. A computer system for presenting an implementation of a data warehouse, said computer system comprising:

a processor; and

a memory coupled to the processor, the memory having stored therein sequences of instructions, which, when executed by the processor, cause the processor to perform the steps of;

a) receiving an inquiry requesting information about at least a data element;

b) retrieving a data structure of the data element from the data warehouse;

c) determining (i) tools available for accessing the data element, and (ii) users using at least one of the tools to access the data element; and

d) generating a view in response to the inquiry showing at least one of (i) the data structure retrieved in said retrieving step, (ii) the tools and (iii) the users determined in said determining step.

19. An article for presenting an implementation of a data warehouse, said article comprising:

at least one sequence of machine readable instructions in machine readable form,

wherein execution of the instructions by one or more processors causes the one or more processors to perform the steps of;

a) receiving an inquiry requesting information about at least a data element;

b) retrieving a data structure of the data element from the data warehouse;

c) determining (i) tools available for accessing the data element, and (ii) users using at least one of the tools to access the data element; and

d) generating a view in response to the inquiry showing at least one of (i) the data structure retrieved in said retrieving step, (ii) the tools and (iii) the users determined in said determining step.

20. A data warehouse portal for providing an insight of a data warehouse implementation of a plurality of data warehouses, said data warehouse portal comprising:

a parser for reading metadata schemas of each of the plurality of data warehouses, and metadata sets of each of a plurality of tools available for exploiting data stored in the plurality of data warehouses;

a tools administrator for obtaining user information about users who use at least one of the plurality of tools to gain access to the data; and

a page administrator and generator for receiving an information inquiry, and generating a view in response to the information inquiry, based on at least one of the metadata schemas, the metadata sets, and the user information.

21. The data warehouse portal of claim 20, further including a historical information storage for keeping tracks of past and future updates to data and data structures of the plurality of data warehouses.

22. The data warehouse portal of claim 20, further including at least one of a search engine and a crawling tool for metadata searches within the plurality of data warehouses.

23. The data warehouse portal of claim 20, wherein said parser further reads XML schemas of each of the plurality of tools, the XML schemas being stored in at least one of the plurality of data warehouses.

24. The data warehouse portal of claim 22, wherein said at least one of a search engine and a crawling tool further searches XML schemas of the plurality of tools, the XML schemas being stored in at least one of the plurality of data warehouses.

25. The data warehouse portal of claim 20, wherein said page administrator and generator comprises at least one of HTML page and XML response generators.

26. A data warehouse portal system for providing an insight of a data warehouse implementation of a plurality of data warehouses, said data warehouse portal system comprising:

a client station housing a client browser for sending an information inquiry; and

a data warehouse portal server connectable to said client station for providing said client browser, in response to the information inquiry, with inquired information about data structures of, and tools and users accessing data elements of the data warehouses rather than actual data items stored in the data warehouses under the data elements, said data warehouse portal server comprising;

a parser for reading at least one of metadata and XML schemas of each of the plurality of data warehouses, and at least one of metadata and XML schemas of each of a plurality of tools available for exploiting data stored in the data warehouses;

a tools administrator for obtaining user information about users who use at least one of the tools to gain access to the data; and

at least one of HTML page and XML response generators for presenting the inquired information in response to the information inquiry, based on at least one of the metadata and XML schemas of the data warehouses and the tools, and the user information.

27. The data warehouse portal system of claim 26, wherein said data warehouse portal server communicates with the data warehouses through a plurality of connectivities comprising one of ODBC, JBDC and SQL database access.

28. The data warehouse portal system of claim 26, wherein said at least one of HTML page and XML response generators presents the inquired information through a XSL style sheet, whereby a customizable interface between said client browser and said data warehouse portal server is established.

29. The data warehouse portal system of claim 26, further including a web server connectable to said client station and said data warehouse portal server for transferring the information inquiry in form of a URL or other HTTP request from said client station to said data warehouse portal server, and for transferring the inquired information in form of HTML or XML response from said data warehouse portal server to said client station.

30. The data warehouse portal system of claim 26, wherein said client browser is integrated into said data warehouse portal server.