Method for developing data warehouse logical data models using shared subject areas

• US 7,359,906 B1
• Filed: 12/15/2003
• Issued: 04/15/2008
• Est. Priority Date: 12/15/2003
• Status: Active Grant

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: NCR Corporation
• Inventors: Brobst, Stephen A., Young, Lily W., Matera, William A., Crosby, Mark L., Hargett, Kim Nguyen, Lessing, Pieter
• Primary Examiner(s): Gaffin; Jeffrey
• Assistant Examiner(s): Veillard; Jacques
• Application Number:
  US10/735,952
• Time in Patent Office: 1,583 Days
• Field of Search: 707100-103 R, 707/103.Y, 707 1- 4, 707/104.1, 707/200, 707/10, 705/1, 705/5, 705/14, 705/7, 705/10, 705 26- 28, 709/223, 709/224, 709/217
• US Class Current: 1/1
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06Q 10/10 Office automation; Time management
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A logical data model (LDM) design methodology that utilizes common or shared subject areas, developed for applications across two or more industries, in the design and construction of data warehouse solutions and logical data models for specific customers. The development and use of shared subject areas provides for more effective new LDM development through re-use of common elements and quicker deployment of horizontal applications on all industries.

Claims

1. A method for constructing a data warehouse for a customer within a specific industry, said method comprising the steps of:

selecting at least one shared subject area from a plurality of predefined shared subject areas for inclusion in a logical data model for said data warehouse, each one of said predefined shared subject areas comprising a plurality of entities and relationships defining the manner in which basic information common to two or more industries is stored within a database; and

populating said data warehouse with data in accordance with said logical data model.

2. The method for constructing a data warehouse for a customer within a specific industry in accordance with claim 1, said method further comprising the step of:

including industry specific entities and attributes add-ons to said selected shared subject area within said logical data model for said data warehouse.

3. The method for constructing a data warehouse for a customer within a specific industry in accordance with claim 1, said method further comprising the step of:

including an industry specific extension to said selected shared subject area within said logical data model for said data warehouse.

4. The method for constructing a data warehouse for a customer within a specific industry in accordance with claim 1, wherein said specific industry comprises one member of the group of industries comprising:

communications;

retail;

manufacturing;

financial services;

insurance;

e-business;

travel; and

transportation.

5. The method for constructing a data warehouse for a customer within a specific industry in accordance with claim 1, wherein said at least one shared subject area comprises at least one member of the group of predefined subject areas comprising:

an advertisement subject area defining the manner in which information about sales, promotions and advertising of interest to two or more industries is stored within a database;

a clickstream subject area defining the manner in which information concerning web visitors and visitor web activity of interest to two or more industries is stored within a database;

a financial management subject area defining the manner in which financial information of interest to two or more industries is stored within a database;

a location subject area defining the manner in which information concerning physical and virtual properties of interest to two or more industries is stored within a database;

a party subject area defining the manner in which information about any person, business, group, or association that is of business interest to two or more industries is stored within a database; and

a privacy subject area defining the manner in which information about privacy permissions from individuals, households and organizations of interest to two or more industries is stored within a database.

6. A data warehouse system for a customer within a specific industry, comprising:

a processor

a relational database for holding information, said information being organized within said relational database in accordance with a logical data model;

said logical data model including a plurality of subject areas, each one of said subject areas including entities and relationships defining the manner in which subsets of said information is stored and organized within said data warehouse; and

said plurality of subject areas including at least one shared subject area selected from a plurality of predefined shared subject areas, each one of said predefined shared subject area comprising a plurality of entities and relationships defining the manner in which basic information common to two or more industries is stored within a database.

7. The data warehouse system for a customer within a specific industry in accordance with claim 6, wherein:

said logical data model further includes industry specific entities and attributes add-ons included in said at least one shared subject area.

8. The data warehouse for a customer within a specific industry in accordance with claim 6, wherein:

said logical data model further includes an industry specific extension appended to said at least one shared subject area.

9. The data warehouse for a customer within a specific industry in accordance with claim 6, wherein said specific industry comprises one member of the group of industries comprising:

communications;

retail;

manufacturing;

financial services;

insurance;

e-business;

travel; and

transportation.

10. The data warehouse for a customer within a specific industry in accordance with claim 6, wherein said at least one shared subject area comprises at least one member of the group of predefined subject areas comprising:

an advertisement subject area defining the manner in which information about sales, promotions and advertising of interest to two or more industries is stored within a database;

a clickstream subject area defining the manner in which information concerning web visitors and visitor web activity of interest to two or more industries is stored within a database;

a financial management subject area defining the manner in which financial information of interest to two or more industries is stored within a database;

a location subject area defining the manner in which information concerning physical and virtual properties of interest to two or more industries is stored within a database;

a party subject area defining the manner in which information about any person, business, group, or association that is of business interest to two or more industries is stored within a database; and

a privacy subject area defining the manner in which information about privacy permissions from individuals, households and organizations of interest to two or more industries is stored within a database.