Method of generating user customized document incorporating at least a portion of discovery information recorded in the system of record database in data warehouse environment

• US 7,107,284 B1
• Filed: 12/28/1999
• Issued: 09/12/2006
• Est. Priority Date: 12/28/1999
• Status: Expired due to Term

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: NCR Corporation (NCR Voyix Corporation)
• Inventors: Chiang, Luo-Jen, Thaisz, James E., Betz, Eugene M., Vannavada, Mahesh P., Papierniak, Karen A.
• Primary Examiner(s): CHANNAVAJJALA, SRIRAMA T
• Application Number:
  US09/472,852
• Time in Patent Office: 2,450 Days
• Field of Search: 707 1- 10, 707100-1041, 707200-206, 707/500.1, 707/501.1, 707511-515, 707/526, 707530-531, 707900-902, 709203-205, 709215-225, 345/968, 705 1- 10, 705 26- 27, 715512-513
• US Class Current: 1/1
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 40/106 Display of layout of documents; Previewing
• CPC Class Codes: G06F 40/131 Fragmentation of text files, e.g. creating reusable text-blocks; Linking to fragments, e.g. using XInclude; Namespaces
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

The present invention is called a document customizer. The document customizer captures and records changes made to an electronic and/or physical footprint of a data warehouse engagement by a knowledgeable field practitioner. The document customizer starts with a “system-of-record” document which defines the starting system parameters of the data warehouse, as initially delivered to the customer (i.e., Logical Data Model, Physical Data Model, Metadata and system configuration templates). The document customizer allows the practitioner to archive and document the modifications made to the system-of-record and creates an on-line environment to document and time-stamp the modifications made to the data warehouse. The document customizer then creates a “current” system-of-record document. Provisions are included to make additions and modifications to the (new) current document to allow text comments and notes to be input.

Claims

1. A computer implemented method of capturing and recording changes to an electronic data warehouse or data mart, comprising:

soliciting a user for data discovery information defining data and sources of the data for a data warehouse or data mart;

documenting at least a portion of the data warehouse or data mart in an SOR (System of Record) document using the discovery information collected from the user as a result of said soliciting step; and

generating a user customized document incorporating at least a portion of the discovery information recorded in the SOR database.

2. The method of claim 1, further comprising the steps of

presenting a predefined sequence of queries for the discovery information to the user based on a set of predefined templates stored in the SOR database;

and

associating user provided answers to the queries with respective ones of the templates.

3. The method of claim 2, further comprising the steps of

generating an exception when the user answers a query out-of-sequence with the predefined sequence of queries and thereby creates at least one unanswered query;

and

storing the exception in an exception table and associating the exception with the at least one unanswered query.

4. The method of claim 3, further comprising the step of presenting a list of exceptions and associated unanswered queries to the user, to thereby inform the user of the need to collect further discovery information and record the further discovery information in the SOR database.

5. The method of claim 1, wherein said step of generating a customized document includes the further steps of:

extracting a selected portion of the SOR database from the SOR database and storing the extracted portion in a computer memory workspace;

visualizing the extracted portion residing in the workspace on a computer display; and

customizing an order of presentation and an output format of the visualized, extracted portion residing in the workspace.

6. The method of claim 5, wherein the SOR database includes templates wherein said generating step includes the further steps of:

presenting a list of the SOR templates to the user;

selecting one or more of the SOR templates from the list of SOR templates; and

extracting the selected templates and associated discovery information from the SOR database to establish the extracted portion of the SOR database in the workspace.

7. The method of claim 6, wherein the SOR database includes predefined output formats associated with generating the customized document, and wherein said generating step includes the further step of formatting the extracted portion in accordance with the output formats.

8. The method of claim 7, further comprising the steps of

presenting a list of the output formats to the user;

selecting one or more of the output formats from the list of output formats; and

associating the selected output formats with a portion of the extracted portion of the SOR database in the workspace.

9. The method of claim 8, wherein said associating step includes the step of selecting a visualized portion of the extracted portion of the SOR database, the selected, visualized portion being associated with one of the selected output formats.

10. The method of claim 5, wherein said customizing step includes the step of rearranging the order of visualized portions of the extracted portion of the SOR database residing in the workspace.

11. The method of claim 1, wherein the discovery information included in the SOR document includes at least one of:

names of source databases and source files providing a source of data to the data warehouse;

descriptions of the source databases and files;

logical data models for the source databases and files and for the data residing in the databases and files;

locations of the source databases and files including an identifier of the type of device wherein the source database and files reside and geographical locations of the devices;

names and contact information relating to administrators of the source databases and files;

updating frequency of the source databases and files;

data transferring methods and frequencies for the source databases and files;

volatility rules for the data in the source databases and files; and

business rationales for using the data from the source databases and files in the data warehouse.

12. The method of claim 1, further comprising the steps of

importing discovery information, in the form of at least one of data files and multimedia data, from sources external to the computer into a memory of the computer;

and

linking the imported discovery information to related discovery information in the SOR database, whereby the imported discovery information is accessible to the user with the related discovery information.

13. The method of claim 1, further comprising the step of recording configuration control information in the SOR database each time the SOR database is updated with discovery information.

14. The method of claim 1, further comprising the step of uploading the SOR database to a database residing in a network accessible computer.

15. The method of claim 1, wherein the SOR database includes an SOR document that defines the starting system parameters of the data warehouse.

16. The method of claim 15, wherein the starting system parameters include a logical data model, a physical data model, Metadata and system configuration templates.

17. The method of claim 1, further comprising updating the SOR database including modifications to the data warehouse.

18. The method of claim 1, further comprising synchronizing the SOR document with a centralized SOR database.

19. The method of claim 1, further comprising inputting data discovery information either manually or automatically.

20. The method of claim 19, wherein the discovery information includes at least one of text, audio, images and video.

21. The method of claim 1, wherein the customized document includes at least one of text, audio, images and video.