Methods and apparatus for database virtualization

• US 9,305,068 B1
• Filed: 09/28/2012
• Issued: 04/05/2016
• Est. Priority Date: 09/28/2012
• Status: Active Grant

• Current Assignee: Emc IP Holding Company LLC (Dell Technologies Inc.)
• Original Assignee: EMC Corporation (Dell Technologies Inc.)
• Inventors: Esposito, Jeffrey Daniel
• Primary Examiner(s): Bowen, Richard
• Application Number:
  US13/630,275
• Time in Patent Office: 1,285 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/256 in federated or virtual databases

Abstract

Methods and apparatus are provided for database virtualization. A virtualized database is designed by receiving a user selection of one or more existing databases for virtualization; receiving a user selection of a target virtualization platform host profile for the virtualized database; receiving a user selection of a target virtualization storage profile for the virtualized database; and providing the user with a comparison of an actual performance of the selected existing database and a projected performance of the existing database on the selected target virtualization platform host. A user can specify a backup and recovery profile for the virtualized database. Metadata affinity can optionally be analyzed for a plurality of the selected existing databases to identify an affinity correlation across the selected existing databases. Templates and/or configuration files can be generated for the selected target virtualization environment (optionally based on rule-based best practices).

Claims

1. A method, comprising:

receiving a user selection of at least one existing non-virtualized database to be converted to a virtualized database;

receiving a user selection of a profile for a target virtualization platform host for said virtualized database;

receiving a user selection of a profile for a target virtualization storage environment for said virtualized database;

determining a base virtualization factor based on one or more performance metrics of said selected existing non-virtualized database and one or more projected performance metrics of said existing non-virtualized database on said selected target virtualization platform host and said selected target virtualization storage environment as a virtualized component of a business data environment; and

selecting a predefined combination of said target virtualization platform host and said selected target virtualization storage environment based on said determined base virtualization factor.

2. The method of claim 1, further comprising the step of receiving a user selection of a backup and recovery profile for said virtualized database.

3. The method of claim 2, wherein said step of receiving said user selection of said backup and recovery profile for said virtualized database further comprises the step of presenting said user with a list of available backup and recovery profiles.

4. The method of claim 2, wherein said step of receiving said user selection of said backup and recovery profile for said virtualized database further comprises the step of receiving a user specification of one or more blackout windows when said virtualized database will be unavailable during backup.

5. The method of claim 2, further comprising the step of determining one or more of a network utilization and a processor utilization for said selected backup and recovery profile.

6. The method of claim 1, further comprising the step of analyzing a ranking of an affinity of metadata between at least two of said selected existing non-virtualized databases, wherein said metadata describes one or more aspects of data in said existing non-virtualized database.

7. The method of claim 6, further comprising the step of identifying an affinity correlation across at least two of said selected existing non-virtualized databases to link said selected existing non-virtualized databases satisfying an affinity criteria.

8. The method of claim 1, further comprising the step of presenting said user with scenario results for a selected target virtualization environment.

9. The method of claim 1, further comprising the step of generating one or more virtual machine templates for one or more of said selected target virtualization platform host and said selected target virtualization storage environment.

10. The method of claim 9, wherein said step of generating one or more virtual machine templates is guided by one or more rule-based best practices.

11. The method of claim 9, further comprising the step of storing one or more of said virtual machine templates in a template library.

12. The method of claim 1, further comprising the step of generating one or more configuration files for one or more of said selected target virtualization platform host and said selected target virtualization storage environment.

13. The method of claim 1, wherein said step of receiving said user selection of at least one existing non-virtualized database to be converted to said virtualized database further comprises the step of presenting said user with a list of existing non-virtualized databases for selection.

14. The method of claim 1, wherein said step of receiving said user selection of at least one existing non-virtualized database to be converted to said virtualized database further comprises the step of presenting performance metrics for one or more existing non-virtualized database.

15. The method of claim 1, wherein said step of receiving said user selection of said profile of said target virtualization platform host further comprises the step of presenting said user with a list of available virtualization hosts.

16. The method of claim 1, wherein said step of receiving said user selection of said profile of said target virtualization platform host further comprises the step of presenting said user with specifications for one or more available virtualization hosts.

17. The method of claim 1, wherein said step of receiving said user selection of said profile of said target virtualization storage environment further comprises the step of presenting said user with a list of available virtualization storage profiles.

18. A tangible machine-readable recordable storage medium, wherein one or more software programs when executed by one or more processing devices implement the steps of the method of claim 1.

19. A system, the system comprising:

a memory; and

at least one hardware device, coupled to the memory, operative to implement the following steps;

receive a user selection of at least one existing non-virtualized database to be converted to a virtualized database;

receive a user selection of a profile for a target virtualization platform host for said virtualized database;

receive a user selection of a profile for a target virtualization storage environment for said virtualized database;

determine a base virtualization factor based on one or more performance metrics of said selected existing non-virtualized database and one or more projected performance metrics of said existing non-virtualized database on said selected target virtualization platform host and said selected target virtualization storage environment as a virtualized component of a business data environment; and

select a predefined combination of said target virtualization platform host and said selected target virtualization storage environment based on said determined base virtualization factor.

20. The system of claim 19, wherein said at least one hardware device is further configured to receive a user selection of a backup and recovery profile for said virtualized database.

21. The system of claim 19, wherein said at least one hardware device is further configured to analyze a ranking of an affinity of metadata between at least two of said selected existing non-virtualized databases, wherein said metadata describes one or more aspects of data in said existing non-virtualized database.

22. The system of claim 21, wherein said at least one hardware device is further configured to identify an affinity correlation across at least two of said selected existing non-virtualized databases to link said selected existing non-virtualized databases satisfying an affinity criteria.

23. The system of claim 19, wherein said at least one hardware device is further configured to generate one or more virtual machine templates for one or more of said selected target virtualization platform host and said selected target virtualization storage environment.

24. The system of claim 23, wherein said one or more virtual machine templates are generated based on one or more rule-based best practices.

25. The system of claim 19, wherein said at least one hardware device is further configured to generate one or more configuration files for one or more of said selected target virtualization platform host and said selected target virtualization storage environment.

26. The system of claim 19, wherein said at least one hardware device is further configured to present performance metrics for one or more existing non-virtualized databases.