Method and system for implementing a unified DB clone system

• US 10,042,908 B2
• Filed: 09/25/2015
• Issued: 08/07/2018
• Est. Priority Date: 09/26/2014
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Kuchibhotla, Balasubrahmanyam, Paliwal, Bharat, Vijayaraghavan, Srivatsan, Ediga, Sanjay Chinnappaiah, Fulay, Adeesh, Datta, Sudip
• Primary Examiner(s): Wong, Leslie
• Application Number:
  US14/866,118
• Publication Number:
  US 20160092535A1
• Time in Patent Office: 1,047 Days
• CPC Class Codes: G06F 11/10 Adding special bits or symbols to the coded information, e.g. parity check, casting out 9's or 11's
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence

Abstract

Disclosed are a system, method, and computer program product for a unified system for implementing clones. The unified system includes the appropriate infrastructure to create, maintain, and administer clones and supporting data sources in the computing environment. In addition, a user interface is provided that is capable of visually displaying relationships and lineages of sources and clones in the system. The user interface provides functionality to select any given object, and to trace its parent-child relationships to highlight its related parent and/or child source/clone.

Claims

1. A method, comprising:

receiving a first request to create a data source from a production database;

responsive to the first request;

creating the data source derived from the production database and storing a first entry in a lineage map structure, the first entry comprising a first parent-child relationship between the production database and the data source;

receiving a second request to create a clone from the data source;

responsive to the second request, creating the clone from the data source;

storing a second entry in the lineage map structure comprising a second parent-child relationship between the data source and the clone;

presenting, in a user interface, a display of the lineage map structure, the display comprising;

(a) a first plurality of objects respectively representing a plurality of production databases,

(b) a second plurality of objects respectively representing a plurality of data sources, and

(c) a third plurality of objects respectively representing a plurality of clones;

receiving a selection of a first object representing the data source;

searching the lineage map structure for objects, related to the first object, by identifying;

(a) the first parent-child relationship between the production database and the data source, and

(b) the second parent-child relationship between the data source and the clone; and

responsive to identifying the first parent-child relationship and the second parent-child relationship, visually identifying in the display;

(a) a second object representing the clone derived from the data source; and

(b) a third object representing the production database used to derive the data source.

2. The method of claim 1, wherein the user interface comprises a first interface portion having a visual timeline of the plurality of data sources, a second interface portion having a selected set of data sources selected from the plurality of data sources from the visual timeline, and a third interface portion that displays clones, of the plurality of clones, that correspond to the selected set of the data sources.

3. The method of claim 2, wherein receiving the selection of the first object representing the data source comprises receiving the selection of the first object in the second interface portion.

4. The method of claim 3, wherein visually identifying the second object and the third object in the display comprises highlighting the second object and the third object in the display.

5. The method of claim 2, wherein the third interface portion displays information for each of the clones displayed in the third interface portion, the information for said each clone comprising at least one of a refresh policy, an aging policy, expiration information, overdue date information, or statistics.

6. The method of claim 1, wherein the operations further comprise:

creating a cloned database with clones derived from a respective set of data sources located on a plurality of different database platforms.

7. The method of claim 1, wherein a transformation is applied to the data source to create the clone, the transformation comprising at least one of masking, configuration changes, binary changes, or content changes.

8. The method of claim 1, wherein at least one of a retention policy or a purge policy is applied to maintain the data source or the clone.

9. The method of claim 1, wherein a profile is maintained for each data source of the plurality of data sources, the profile identifying one or more versions of said each data source.

10. The method of claim 1, wherein the creating the clone further comprises storing information about the clone in association with the second entry created for the clone in the lineage map structure, the information about the clone including at least a plurality of:

(a) transformation, (b) purge policy, (c) refresh policy, and (d) version of the clone;

wherein the transformation is applied to the data source to derive the clone;

wherein the purge policy indicates conditions for deleting the clone; and

wherein the refresh policy indicates conditions for updating the data in the clone.

11. The method of claim 1, further comprising:

receiving a selection of the second object representing the clone derived from the data source;

responsive to receiving the selection of the second object representing the clone derived from the data source;

visually identifying in the display the second object representing the clone derived from the data source;

finding the data source from which the clone was derived by searching the lineage map structure for the second parent-child relationship between the data source and the clone;

visually identifying in the display the first object representing the data source;

finding the production database from which the data source was derived by searching the lineage map structure for the first parent-child relationship between the production database and the data source; and

visually identifying in the display the third object representing the production database.

12. The method of claim 1, wherein visually identifying the third object in the display comprises highlighting the third object in the display.

13. A computer readable medium having stored thereon a sequence of instructions which, when executed by a processor causes the processor to execute operations comprising:

receiving a first request to create a data source from a production database;

responsive to the first request;

creating the data source derived from the production database and storing a first entry in a lineage map structure, the first entry comprising a first parent-child relationship between the production database and the data source;

receiving a second request to create a clone from the data source;

responsive to the second request, creating the clone from the data source;

storing a second entry in the lineage map structure comprising a second parent-child relationship between the data source and the clone;

presenting, in a user interface, a display of the lineage map structure, the display comprising;

(a) a first plurality of objects respectively representing a plurality of production databases,

(b) a second plurality of objects respectively representing a plurality of data sources, and

(c) a third plurality of objects respectively representing a plurality of clones;

receiving a selection of a first object representing the data source;

searching the lineage map structure for objects, related to the first object, by identifying;

(a) the first parent-child relationship between the production database and the data source, and

(b) the second parent-child relationship between the data source and the clone; and

responsive to identifying the first parent-child relationship and the second parent-child relationship, visually identifying in the display;

(a) a second object representing the clone derived from the data source; and

(b) a third object representing the production database used to derive the data source.

14. The computer readable medium of claim 13, wherein the user interface comprises a first interface portion having a visual timeline of the plurality of data sources, a second interface portion having a selected set of data sources selected from the plurality of data sources from the visual timeline, and a third interface portion that displays clones, of the plurality of clones, that correspond to the selected set of the data sources.

15. The computer readable medium of claim 14, wherein receiving the selection of the first object representing the data source comprises receiving the selection of the first object in the second interface portion.

16. The computer readable medium of claim 15, wherein visually identifying the second object and the third object in the display comprises highlighting the second object and the third object in the display.

17. The computer readable medium of claim 14, wherein the third interface portion displays information for each of the clones displayed in the third interface portion, the information for said each clone comprising at least one of a refresh policy, an aging policy, expiration information, overdue date information, or statistics.

18. The computer readable medium of claim 13, wherein the operations further comprise:

creating a cloned database with clones derived from a respective set of data sources located on a plurality of different database platforms.

19. The computer readable medium of claim 13, wherein a transformation is applied to the data source to create the clone, the transformation comprising at least one of masking, configuration changes, binary changes, or content changes.

20. The computer readable medium of claim 13, wherein at least one of a retention policy or a purge policy is applied to maintain the data source or the clone.

21. The computer readable medium of claim 13, wherein a profile is maintained for each data source of the plurality of data sources, the profile identifying one or more versions of said each data source.

22. A system, comprising:

a processor;

a memory having stored thereon a sequence of instructions which, when executed by a processor causes the processor to execute operations comprising;

receiving a first request to create a data source from a production database;

responsive to the first request;

creating the data source derived from the production database and storing a first entry in a lineage map structure, the first entry comprising a first parent-child relationship between the production database and the data source;

receiving a second request to create a clone from the data source;

responsive to the second request, creating the clone from the data source;

storing a second entry in the lineage map structure comprising a second parent-child relationship between the data source and the clone;

presenting, in a user interface, a display of the lineage map structure, the display comprising;

(a) a first plurality of objects respectively representing a plurality of production databases,

(b) a second plurality of objects respectively representing a plurality of data sources, and

(c) a third plurality of objects respectively representing a plurality of clones;

receiving a selection of a first object representing the data source;

searching the lineage map structure for objects, related to the first object, by identifying;

(a) the first parent-child relationship between the production database and the data source, and

(b) the second parent-child relationship between the data source and the clone; and

responsive to identifying the first parent-child relationship and the second parent-child relationship, visually identifying in the display;

(a) a second object representing the clone derived from the data source; and

(b) a third object representing the production database used to derive the data source.

23. The system of claim 22, wherein the user interface comprises a first interface portion having a visual timeline of the plurality of data sources, a second interface portion having a selected set of data sources selected from the plurality of data sources from the visual timeline, and a third interface portion that displays clones, of the plurality of clones, that correspond to the selected set of the data sources.

24. The system of claim 23, wherein receiving the selection of the first object representing the data source comprises receiving the selection of the first object in the second interface portion.

25. The system of claim 24, wherein visually identifying the second object and the third object in the display comprises highlighting the second object and the third object in the display.

26. The system of claim 23, wherein the third interface portion displays information for each of the clones displayed in the third interface portion, the information for said each clone comprising at least one of a refresh policy, an aging policy, expiration information, overdue date information, or statistics.

27. The system of claim 22, wherein the operations further comprise:

creating a cloned database with clones derived from a respective set of data sources located on a plurality of different database platforms.

28. The system of claim 22, wherein a transformation is applied to the data source to create the clone, the transformation comprising at least one of masking, configuration changes, binary changes, or content changes.

29. The system of claim 22, wherein at least one of a retention policy or a purge policy is applied to maintain the data source or the clone.

30. The system of claim 22, wherein a profile is maintained for each data source of the plurality of data sources, the profile identifying one or more versions of said each data source.