Data warehouse system

• US 20030093429A1
• Filed: 10/21/2002
• Published: 05/15/2003
• Est. Priority Date: 11/12/2001
• Status: Abandoned Application

• Current Assignee: Hitachi, Ltd.
• Original Assignee: Hitachi, Ltd.
• Inventors: Watabiki, Masahiro, Nishikawa, Norifumi, Yagawa, Yuichi, Ono, Akinori, Namba, Yasuharu, Minami, Shoichi
• Application Number:
  US10/277,628
• Publication Number:
  US 20030093429A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

A data warehouse system includes a first database configured to receive first data from a first client, a data warehouse configured to receive second data corresponding to the first data from the first database after an interval to enable a second client to access the second data, and a dynamic database configured to receive third data corresponding to the first data from the first database prior to receipt of the second data by the data warehouse in order to provide the second client with access to the third data prior to the availability of the second data to the second client.

Claims

1. A data warehouse system, comprising:

a first database configured to receive first data from a first client;

a data warehouse configured to receive second data corresponding to the first data from the first database after an interval to enable a second client to access the second data; and

a dynamic database configured to receive third data corresponding to the first data from the first database prior to receipt of the second data by the data warehouse in order to provide the second client with access to the third data prior to the availability of the second data to the second client.

2. The data warehouse system of claim 1, further comprising:

a management server configured to issue a search request for key information stored in the data warehouse, the key information providing information on the data stored in the data warehouse.

3. The data warehouse system of claim 2, wherein the key information is used to delete a portion of data stored from the dynamic database that is redundant with a portion of data stored in the data warehouse.

4. The data warehouse system of claim 3, wherein the data deletion is performed at least once in a 24-hour period.

5. The data warehouse system of claim 2, wherein the first, second, and third data are records relating to financial transactions and the key information is an information relating to a transaction identifier field or a transaction timestamp field, or both.

6. The data warehouse system of claim 2, wherein the management server is configured to store the key information in a storage area and provide the key information to the second client upon receipt of a request from the second client, wherein the second client uses the key information to determine whether to access the data warehouse or the dynamic database or both to retrieve data requested by the second client.

7. The data warehouse system of claim 1, further comprising:

a second database configured to received fourth data from a third client, wherein data corresponding to the fourth data are subsequently inputted to the data warehouse.

8. The data warehouse system of claim 1, further comprising:

a management server configured to cooperate with the dynamic database to delete a portion of data stored in the dynamic database at designated instances, wherein the dynamic database is configured to store a plurality of records, each being associated with a transaction timestamp field, wherein the portion of data deleted at the designated instances are records with the oldest timestamp values.

9. The data warehouse system of claim 1, wherein the first database is an operational database.

10. The data warehouse system of claim 1, wherein the first client and the second client are not integrated to each other, so that the second client cannot access the first database directly.

11. A management server in a data warehouse system including an operational database to store first data, a data warehouse to receive second data corresponding to the first data from the operational database, and a dynamic database to receive third data corresponding to the first data from the operational database prior to receipt of the second data by the data warehouse, the management server being configured to obtain key information from the data warehouse and store the key information into a storage area provided within the server, wherein the key information is used to purge redundant data from the dynamic database and to assist a client in determining appropriate databases to access to retrieve data requested by the client.

12. A method of managing a management server in a data warehouse system, the management server being coupled to a dynamic database server and a data warehouse server, the method comprising:

transmitting a request for key information to the data warehouse server having a data warehouse, the key information providing information about data stored in the data warehouse;

receiving the key information from the data warehouse server; and

storing the key information received from the data warehouse in a storage area.

13. The method of claim 12, wherein the dynamic database server includes a dynamic database that temporarily stores data, the method further comprising:

providing the key information to the dynamic database server to assist the dynamic database server in deleting redundant data in the dynamic database.

14. The method of claim 12, further comprising:

providing the key information to a client to assist the client in determining whether to access the dynamic database server or the data warehouse server or both in order to retrieve data requested by the client.

15. A method of managing a dynamic database server in a data warehouse system, the dynamic database server including a database to store data temporarily, the method comprising:

receiving data that have been extracted from an operational database before the data are transmitted to a data warehouse server for storage in a data warehouse; and

inputting the data into the database provided within the dynamic database server.

16. The method of claim 15, further comprising:

receiving key information from a management server provided within the data warehouse system, the key information providing information about data stored in the data warehouse; and

deleting a portion of data stored in the database that have been determined to be stored in the data warehouse system using the key information.

17. A data warehouse system, comprising:

an operational database to receive records on transactions that have been conducted, the record including a transactional identifier field, an account number field, a transaction amount field, a transaction timestamp field, and a validation field;

a dynamic database server including a dynamic database and coupled to the operational database, the dynamic database being configured to receive the records from the operational database that have not been validated; and

a data warehouse server including a data warehouse and coupled to the operational database, the data warehouse being configured to receive the records from the operational database that have been validated.

18. The system of claim 17, wherein the dynamic database receives the records from the operational database in a real time and the data warehouse receives the records from the operational database once in a 24-hour period.

19. The system of claim 17, further comprising:

a management server coupled to the operational database, the data warehouse server, and the dynamic database server and operable to retrieve key information from the data warehouse server, the key information providing information about data stored in the data warehouse and being used to assist the dynamic database server in deleting redundant data stored therein.

20. A data warehouse system, comprising:

a first saving job database to receive first records on financial transactions from a first client, the first record including a transactional identifier field, an account number field, a transaction amount field, a transaction timestamp field, and a validation field;

a second saving job database to receive second records on financial transactions from a second client, the second record including a transactional identifier field, an account number field, a transaction amount field, a transaction timestamp field, and a validation field;

a dynamic database server including a dynamic database and coupled to the first and second saving job databases, the dynamic database being configured to receive the records from the first and second saving job databases at predetermined instances;

a data warehouse server including a data warehouse and coupled to the first and second saving job databases, the data warehouse being configured to receive the records from the first and second saving job databases at predetermined intervals; and

a management server coupled to the first and second saving job databases, the data warehouse server, and the dynamic database server and operable to retrieve key information from the data warehouse server, the key information providing information about data stored in the data warehouse and is used to assist dynamic database server in deleting redundant data stored therein.

21. The data warehouse system of claim 20, wherein the predetermined instances are triggered by predetermined time intervals, inputs of a predetermined number of records in the saving job database, or user requests.

22. The data warehouse system of claim 20, wherein the dynamic database receives records from the first and second saving job databases at different times.

23. The data warehouse system of claim 20, wherein the first and second clients are non-integrated business systems.