Providing reporting database functionality using copy-on-write technology
In order to provide a reporting (read-only) copy of an original database, copy-on-write technology is used to quickly create a shadow copy which contains pointers to the data in the original database. When no changes are allowed to the shadow copy, the copy-on-write technology functions to create a static snapshot of the original database at the point in time that the reporting copy was created. The overhead in providing a reporting copy is thus reduced, as no wholesale copying of the original database is required, and updates can be performed quickly. Because the reporting copy is read-only, multiple reporting servers can use the same copy-on-write maintained copy of the original database.
1 . A method of implementing a reporting database of a production database, the method comprising:
creating a reporting volume of the production database;
creating a snapshot of a production volume of the production database; and
providing the snapshot to a read-only user through a reporting copy server instance.
2 . The method of claim 1 , wherein creating a reporting volume of a production database comprises:
connecting a reporting storage to the production database;
making data from the production database available to the reporting storage; and
connecting the reporting storage to a reporting server.
3 . The method of claim 2 , wherein making data from the production database available to the reporting storage comprises employing a data-copy method of a database program.
4 . The method of claim 2 , wherein making data from the production database available to the reporting storage comprises employing copy-on-write technology.
5 . The method of claim 1 , wherein the reporting database is a scalable shared database system.
6 . The method of claim 1 , further comprising refreshing the reporting database.
7 . The method of claim 6 , wherein refreshing the reporting database comprises:
stopping work requests to the reporting database from the reporting copy server instance;
detaching the reporting database;
dismounting a reporting storage; and
mounting an updated reporting database.
8 . A reporting database for providing a read-only copy of a production database to at least one database server instance, the reporting database comprising:
an unchanged data area storing unchanged data from the production database;
a private data area storing changed data from the production database;
unchanged data pointers pointing to the unchanged data; and
changed data pointers pointing to the changed data.
9 . The reporting database of claim 8 , wherein the changed data stored in the private data area comprises data that is about to be changed in the production database.
10 . The reporting database of claim 8 , wherein the reporting database is detached from the at least one database server instance to refresh the data in the reporting database.
11 . The reporting database of claim 8 , wherein the data in the reporting database is read-only data.
12 . The reporting database of claim 8 , wherein the reporting database is a scalable shared database system.
13 . The reporting database of claim 8 , wherein the reporting database is a copy-on-write copy of the production database.
14 . A computer-readable medium having program code stored therein for use in a system comprising a production database for providing a reporting database to at least one database server instance, the program code, when executed, causing the system to perform the following:
creating a reporting volume of the production database;
creating a snapshot of a production volume of the production database; and
providing the snapshot to a read-only user through a reporting copy server instance.
15 . The computer-readable medium of claim 14 , wherein creating a reporting volume of a production database comprises:
connecting a reporting storage to the production database;
making data from the production database available to the reporting storage; and
connecting the reporting storage to a reporting server.
16 . The computer-readable medium of claim 15 , wherein making data from the production database available to the reporting storage comprises employing a data-copy method of a database program.
17 . The computer-readable medium of claim 15 , wherein making data from the production database available to the reporting storage comprises employing copy-on-write technology.
18 . The computer-readable medium of claim 14 , wherein the reporting database is a scalable shared database system.
19 . The computer-readable medium of claim 14 , further comprising program code, when executed, causing the system to refresh the reporting database.
20 . The computer-readable medium of claim 19 , wherein causing the system to refresh the reporting database comprises:
stopping work requests to the reporting database from the reporting copy server instance;
detaching the reporting database;
dismounting a reporting storage; and
mounting an updated reporting database.