Interfacing with a virtual database system
User interactions with a database storage system allow creation of virtual databases based on point-in-time copies associated with a source database. Multiple point-in-time copies are obtained for each source database. A point-in-time copy retrieves data changed in the source database since the retrieval of a previous point-in-time copy. A virtual database (VDB) is created by creating a set of files in the data storage system and mounting the files on a database server allowing the database server to access the files. User interactions allow the user to specify the source database, a point in time associated with the source database and a destination server to create the virtual database. User input can specify other attributes associated with the virtual database including the file paths, database parameters etc. The user can specify schedules of various actions, including making and retention of point-in-time copies.
1. A method of creating virtual databases, the method comprising:
configuring for presentation, by a database storage system, one or more user interfaces for receiving a request for creating a virtual database, the one or more user interfaces configured to receive:
information identifying a particular source database executing on a database system;
information identifying a particular point in time associated with the source database, and
information identifying a particular destination database server for accessing the virtual database being created;
receiving, by the database storage system, point-in-time copies of the source database from the database system according to a first schedule;
receiving, by the database storage system, transaction logs of the source database from the database system according to a second schedule;
storing, by the database storage system, a plurality of point-in-time copies of the source database, each point-in-time copy comprising database blocks such that at least some of the database blocks are associated with other point-in-time copies of the source database;
receiving information identifying a source database for providing database blocks, wherein each database block includes metadata associated with the database block;
receiving information identifying a point in time, such that the source database comprises information stored prior to the point in time;
receiving information identifying a destination database server for accessing the virtual database being created; and
creating, by the database storage system, the virtual database based on a stored point-in-time copy of the source database associated with the point-in-time and transaction logs received after the point in time, wherein the virtual database shares database blocks with one or more other virtual databases.
2. The method of claim 1 , wherein the metadata of a database block includes one or more of information related to the data stored in the database block, information related to objects of database that the database block is part of, or information indicating when the data in the database block was updated.
3. The method of claim 1 , further comprising:
receiving information identifying a server machine hosting a plurality of databases;
analyzing the server machine to identify each of the plurality of databases hosted by the server machine;
presenting the plurality of databases as potential source databases; and
receiving a selection of a particular database of the server machine as the source database.
4. The method of claim 1 , wherein the source database is one of:
a live production database;
a storage level snapshot of a production database;
a clone of a production database; or
a previously created virtual database.
5. The method of claim 1 , wherein the one or more user interfaces are configured to present a geometric shape, wherein a position in the geometric shape corresponds to a time value, and wherein receiving the information identifying the point in time comprises:
receiving a selection of a position in the geometric shape; and
mapping the selection of the position in the geometric shape to the identified point in time.
6. The method of claim 1 , wherein the one or more user interfaces are configured to present a geometric shape, wherein a position in the geometric shape corresponds to database operations in the source database and wherein receiving the information identifying the point in time comprises:
receiving a selection of a position in the geometric shape;
mapping the selection of the position in the geometric shape to a database operation performed in the source database; and
determining the identified point in time based on a time of execution of the database operation.
7. The method of claim 1 , wherein the one or more user interfaces are further configured to receive a policy defining retention schedule for point-in-time copies.
8. The method of claim 1 , wherein the source database is a first source database and the database system is a first database system, the method further comprising:
receiving, by the database storage system, point-in-time copies of a second source database from a second database system; and
storing, by the database storage system, a plurality of point-in-time copies of the second source database, the point-in-time copies comprising database blocks such that at least some of the database blocks are associated with multiple point-in-time copies of the second source database.
9. The method of claim 1 , further comprising:
determining a metric representing storage savings obtained as a result of storing data in a set of virtual databases, the metric based on a measure of storage used by the set of virtual databases and a set of database corresponding to the virtual databases that do not share database blocks; and
sending the metric for presentation.
10. The method of claim 1 , further comprising:
determining a metric representing storage savings obtained as a result of storing data in a set of virtual databases based on the source database, the metric based on an estimate of an amount of storage used in virtualized form compared to an estimate of an amount of storage used in unvirtualized form, the storage used for storing:
database blocks obtained initially by the database storage system from the source database,
database blocks for each point-in-time copy of the source database stored on the database storage system, and
transaction logs obtained by the database storage system from the source database,
sending the metric for presentation.
11. A non-transitory computer readable storage medium storing instructions for:
configuring for presentation, by a database storage system, one or more user interfaces for receiving a request for creating a virtual database, the one or more user interfaces configured to receive:
information identifying a particular source database executing on a database system;
information identifying a particular point in time associated with the source database, and
information identifying a particular destination database server for accessing the virtual database being created;
receiving, by the database storage system, point-in-time copies of the source database from the database system according to a first schedule;
receiving, by the database storage system, transaction logs of the source database from the database system according to a second schedule;
storing, by the database storage system, a plurality of point-in-time copies of the source database, each point-in-time copy comprising database blocks such that at least some of the database blocks are associated with other point-in-time copies of the source database;
receiving information identifying a source database for providing database blocks, wherein each database block includes metadata associated with the database block;
receiving information identifying a point in time, such that the source database comprises information stored prior to the point in time;
receiving information identifying a destination database server for accessing the virtual database being created; and
creating, by the database storage system, the virtual database based on a stored point-in-time copy of the source database associated with the point-in-time and transaction logs received after the point in time, wherein the virtual database shares database blocks with one or more other virtual databases.
12. The non-transitory computer readable storage medium of claim 11 , wherein the metadata of a database block includes one or more of information related to the data stored in the database block, information related to objects of database that the database block is part of, or information indicating when the data in the database block was updated.
13. The non-transitory computer readable storage medium of claim 11 , wherein the stored instructions are further for:
receiving information identifying a server machine hosting a plurality of databases;
analyzing the server machine to identify each of the plurality of databases hosted by the server machine;
presenting the plurality of databases as potential source databases; and
receiving a selection of a particular database of the server machine as the source database.
14. The non-transitory computer readable storage medium of claim 11 , wherein the source database is one of:
a live production database;
a storage level snapshot of a production database;
a clone of a production database; or
a previously created virtual database.
15. The non-transitory computer readable storage medium of claim 11 , wherein the one or more user interfaces are configured to present a geometric shape, wherein a position in the geometric shape corresponds to a time value, and wherein instructions for receiving the information identifying the point in time comprise instructions for:
receiving a selection of a position in the geometric shape; and
mapping the selection of the position in the geometric shape to the identified point in time.
16. The non-transitory computer readable storage medium of claim 11 , wherein the one or more user interfaces are configured to present a geometric shape, wherein a position in the geometric shape corresponds to database operations in the source database and wherein instructions for receiving the information identifying the point in time comprise instructions for:
receiving a selection of a position in the geometric shape;
mapping the selection of the position in the geometric shape to a database operation performed in the source database; and
determining the identified point in time based on a time of execution of the database operation.
17. The non-transitory computer readable storage medium of claim 11 , wherein the source database is a first source database and the database system is a first database system, wherein the stored instructions further comprise instructions for:
receiving, by the database storage system, point-in-time copies of a second source database from a second database system; and
storing, by the database storage system, a plurality of point-in-time copies of the second source database, the point-in-time copies comprising database blocks such that at least some of the database blocks are associated with multiple point-in-time copies of the second source database.
18. The non-transitory computer readable storage medium of claim 11 , wherein the stored instructions further comprise instructions for:
determining a metric representing storage savings obtained as a result of storing data in a set of virtual databases, the metric based on a measure of storage used by the set of virtual databases and a set of database corresponding to the virtual databases that do not share database blocks; and
sending the metric for presentation.
19. The non-transitory computer readable storage medium of claim 11 , wherein the stored instructions further comprise instructions for:
determining a metric representing storage savings obtained as a result of storing data in a set of virtual databases based on the source database, the metric based on an estimate of an amount of storage used in virtualized form compared to an estimate of an amount of storage used in unvirtualized form, the storage used for storing:
database blocks obtained initially by the database storage system from the source database,
database blocks for each point-in-time copy of the source database stored on the database storage system, and
transaction logs obtained by the database storage system from the source database,
sending the metric for presentation.
20. A computer system comprising:
a processor; and
a non-transitory computer readable storage medium storing instructions for execution by the processor, the instructions for:
configuring for presentation, by a database storage system, one or more user interfaces for receiving a request for creating a virtual database, the one or more user interfaces configured to receive:
information identifying a particular source database executing on a database system;
information identifying a particular point in time associated with the source database, and
information identifying a particular destination database server for accessing the virtual database being created;
receiving, by the database storage system, point-in-time copies of the source database from the database system according to a first schedule;
receiving, by the database storage system, transaction logs of the source database from the database system according to a second schedule;
storing, by the database storage system, a plurality of point-in-time copies of the source database, each point-in-time copy comprising database blocks such that at least some of the database blocks are associated with other point-in-time copies of the source database;
receiving information identifying a source database for providing database blocks, wherein each database block includes metadata associated with the database block;
receiving information identifying a point in time, such that the source database comprises information stored prior to the point in time;
receiving information identifying a destination database server for accessing the virtual database being created; and
creating, by the database storage system, the virtual database based on a stored point-in-time copy of the source database associated with the point-in-time and transaction logs received after the point in time, wherein the virtual database shares database blocks with one or more other virtual databases.
21. The computer system of claim 20 , wherein the metadata of a database block includes one or more of information related to the data stored in the database block, information related to objects of database that the database block is part of, or information indicating when the data in the database block was updated.
22. The computer system of claim 20 , wherein the one or more user interfaces are configured to present a geometric shape, wherein a position in the geometric shape corresponds to a time value, and wherein instructions for receiving the information identifying the point in time comprise instructions for:
receiving a selection of a position in the geometric shape; and
mapping the selection of the position in the geometric shape to the identified point in time.
23. The computer system of claim 20 , wherein the source database is a first source database and the database system is a first database system, wherein the stored instructions further comprise instructions for:
receiving, by the database storage system, point-in-time copies of a second source database from a second database system; and
storing, by the database storage system, a plurality of point-in-time copies of the second source database, the point-in-time copies comprising database blocks such that at least some of the database blocks are associated with multiple point-in-time copies of the second source database.
24. The computer system of claim 20 , wherein the stored instructions further comprise instructions for:
determining a metric representing storage savings obtained as a result of storing data in a set of virtual databases, the metric based on a measure of storage used by the set of virtual databases and a set of database corresponding to the virtual databases that do not share database blocks; and
sending the metric for presentation.