A Method and Apparatus for Temporal Comparison and Validation of Heterogeneous Relational Database Objects and their Relationships
Permalink
Bookmark
Share
Twitter
Digg
Reddit
Facebook
Stumbleupon
Del.icio.us| IP.com Number | IPCOM000185063D |
|
|
|---|---|---|---|
| Dated | Jul 10, 2009 UTC | ||
| Size | 6 page(s) (164.9 KB) | ||
| Disclosed by |
|
||
Publication Summary
The technology contained in [1] enables a user to discover and understand the non-obvious relationships among data objects contained within a relational database. What is not provided is a method to programmatically analyze the modification of these discovered relationships over time. Execution of the technology outlined in [1] will provide the user with a point-in-time snapshot of existing data objects and their relationships contained within a relational database. A successive execution of the technology outlined in [1] replaces the results from the previous execution. This requires the user to manually record the results between executions if a determination of how the discovered data objects and their relationships have changed over time is to be performed. This manual recording and comparison of results is not only tedious, but error prone and is not practical for production systems. Furthermore, the results returned to the user by execution of the technology outlined in [1] provide a view of how the data objects and their relationships exist at a given point in time. What is lacking is the ability to determine if the results returned are those that are expected based upon validation against a predetermined schema model. It is the intent of the technology outlined in this disclosure to enhance that of [1] by providing the user with a means to compare the data objects and their relationships from an execution performed at Time_T1 with that of any successive executions performed at time Time_Tn. In addition, validation of the data objects and their relationships will now be possible with the compare for validation of the results from Time_T1 with that of Time_TSchemaModel. [1] The invention relates to a method and apparatus for recording and maintaining stored information system object relationship information. Information contained within a stored information system (including system catalogs, referential constraints, triggers, table hierarchies, column references, indexes, stored program packages, system catalogs, stored procedures, stored queries, log/trace files of dynamically executed code, etc.) are searched to identify dependency relationships between objects. This object relationship information is stored and maintained in an information base. Information within the information based may be organized based upon subsets of objects that support a common application, service, or capability. Object relationship data is used to facilitate stored information system administration activities such as generating/restoring from archives, physically/logically segmenting data objects, replicating data objects; optimizing the distribution of data in distributed data system; and estimating operational capacity. 1. Farber, Joel F., Leamon, Teresa L., Schwartz, David R., Smit, Bryan F., Weil, Donald A. USPTO Application: 20080016026 Method and apparatus for recording and managing data object relationship data| Country | |
|---|---|
| Language | English (United States) |
About this Publication
This document was submitted to IP.com's Prior Art Database and this preview is designed to provide you with information regarding the contents of this document by displaying up to the first four pages of the document as scaled page renderings and displaying a limited amount of text which was extracted from the document on the Text Preview Tab.
To find out more on how to obtain the entire document, click the Download tab. There is a charge for downloading some Prior Art Database documents; please examine carefully whether you believe this document fills your needs before purchasing.
For more information about the Prior Art Database, visit the Learn section of this website. Thank you for visiting IP.com's Prior Art Database! You may wish to check out our Global Patent Search website before you leave.
A Method and Apparatus for Temporal Comparison and Validation of Heterogeneous Relational Database Objects and their Relationships
Main Idea
1. Background: What is the problem solved by your invention ? Describe known solutions to this problem (if any). What are the drawbacks of such known solutions , or why is an additional solution required ? Cite any relevant technical documents or references .
The technology contained in [1] enables a user to discover and understand the non-obvious relationships among data objects contained within a relational database. What is not provided is a method to programmatically analyze the modification of these discovered relationships over time. Execution of the technology outlined in [1] will provide the user with a point-in-time snapshot of existing data objects and their relationships contained within a relational database. A successive execution of the technology outlined in [1] replaces the results from the previous execution. This requires the user to manually record the results between executions if a determination of how the discovered data objects and their relationships have changed over time is to be performed. This manual recording and comparison of results is not only tedious, but error prone and is not practical for production systems.
Furthermore, the results returned to the user by execution of the technology outlined in [1]
.
What is lacking is the ability to determine if the results returned are those that are expected based upon validation against a predetermined schema model.
It is the intent of the technology outlined in this disclosure to enhance that of [1] by providing the user with a means to compare the data objects and their relationships from an execution
provide a view of how the data objects and their relationships exist at a given point in time
_T1 with that of any successive executions performed at time Time
addition, validation of the data objects and their relationships will now be possible with the compare for validation of the results from Time
_TSchemaModel.
[1]The invention relates to a method and apparatus for recording and maintaining stored information system object relationship information. Information contained within a stored information system (including system catalogs, referential constraints, triggers, table hierarchies, column references, indexes, stored program packages, system catalogs, stored procedures, stored queries, log/trace files of dynamically executed code, etc.) are searched to identify dependency relationships between objects. This object relationship information is stored and maintained in an information base. Information within the information based may be organized based upon subsets of objects that support a common application, service, or capability. Object relationship data is used to facilitate stored in...