Method and system for altering the configuration of a data warehouse
First Claim
1. A method for altering a configuration of a data warehouse, the method comprising:
- representing an initial configuration of the data warehouse in terms of an initial configuration metadata;
altering at least some of the initial configuration metadata for the data warehouse;
creating a configuration script, the configuration script based, at least in part, on the altered at least some of the initial configuration metadata for the data warehouse; and
applying the configuration script to alter the initial configuration of the data warehouse.
2 Assignments
0 Petitions
Accused Products
Abstract
Disclosed are methods usable by non-experts for altering a configuration of a data warehouse. The initial configuration of the data warehouse is represented in terms of metadata, and that metadata configuration is presented to a user. The user can choose to alter the metadata configuration. If alterations are made to the metadata, then the underlying configuration of the data warehouse is altered accordingly. Because there may be multiple users wishing to alter aspects of the data warehouse, some embodiments of the present invention enforce approval guidelines so that proposed changes to the data warehouse configuration are only implemented after the appropriate approvals have been secured. By presenting a metadata representation of the data warehouse configuration, the present invention both allows non-experts to have a hand in converting a data warehouse and prevents user errors from corrupting the data warehouse conversion process.
14 Citations
20 Claims
-
1. A method for altering a configuration of a data warehouse, the method comprising:
-
representing an initial configuration of the data warehouse in terms of an initial configuration metadata; altering at least some of the initial configuration metadata for the data warehouse; creating a configuration script, the configuration script based, at least in part, on the altered at least some of the initial configuration metadata for the data warehouse; and applying the configuration script to alter the initial configuration of the data warehouse. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A computer-readable storage medium having computer-executable instructions for performing a method for altering a configuration of a data warehouse, the method comprising:
-
representing an initial configuration of the data warehouse in terms of an initial configuration metadata; altering at least some of the initial configuration metadata for the data warehouse; creating a configuration script, the configuration script based, at least in part, on the altered at least some of the initial configuration metadata for the data warehouse; and applying the configuration script to alter the initial configuration of the data warehouse. - View Dependent Claims (11, 12, 13, 14)
-
-
15. A system for altering a configuration of a data warehouse, the system comprising:
-
a configuration server comprising a processor, and an application program executed by the configuration server, comprising steps for; representing an initial configuration of the data warehouse in terms of an initial configuration metadata; providing a configuration script, the configuration script based, at least in part, on an alteration of at least part of the initial configuration metadata for the data warehouse; and applying the configuration script to alter the initial configuration of the data warehouse. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification