IP Library › Granted Patent US 7,206,785

Granted Patent B1

US 7,206,785 · App. 10/000,607 · Granted Apr 17, 2007

Impact analysis of metadata

Assignee: BellSouth Intellectual Property Corporation

View Patent ↗

Loading inventors, assignments & file history…

Monitor This Case

Get email alerts when status or documents change.

Order Certified Copies

Most orders are placed with the USPTO same day — all within 24 business hours.

Order via The Patent Place →

Pre-filled with this patent's details

Quick Facts

Patent No.: US 7,206,785
App. No.: 10/000,607
Granted: Apr 17, 2007
Kind: B1

External Links

USPTO Patent Center↗ Full Patent PDF↗

Abstract

Methods and systems for estimating impact between metadata descriptors are provided. A software program compares a first metadata descriptor with a second metadata descriptor and determines an impact rating between the metadata descriptors. The impact rating may be used to map metadata descriptors or as an indication of how a change in one database will effect other interrelated databases.

Claims (98)

1. A method for estimating impact in a computer system, comprising:

extracting a first metadata descriptor from a first database, wherein the first metadata descriptor and the first database are stored in a data store on a computer system and wherein the first metadata descriptor describes customer information in an organization;

comparing the first metadata descriptor to a second metadata descriptor, wherein the second metadata descriptor is stored in the data store in the computer system and describes the customer information in an organization and wherein the second metadata descriptor includes a table and a plurality of tokens, wherein each of the plurality of tokens comprises a portion of a field name in the table; and

determining an impact rating between the first metadata descriptor and the second metadata descriptor wherein the impact rating predicts an indication of similarity between the first metadata descriptor and the second metadata descriptor in a plurality of databases in the computer system, wherein determining the impact rating comprises:

calculating a relative strength of an entity relationship (rsER) between the first metadata descriptor and the second metadata descriptor;

calculating a relative strength of an attribute relationship (rsAttr) between the first metadata descriptor and the second metadata descriptor, wherein said step of calculating a relative strength of the attribute relationship between the first metadata descriptor and the second metadata descriptor further comprises:

calculating a relative strength of the attribute relationship considering the relative strength of the entity relationship (rsAttr) between the first metadata descriptor and the second metadata descriptor; and

calculating a relative strength of the attribute relationship without considering the relative strength of the entity relationship (rsAttr*) between the first metadata descriptor and the second metadata descriptor; and

calculating a relative strength of a mapping (RsMap) between the first metadata descriptor and the second metadata descriptor, wherein RsMap is calculated using the formula:

RsMap

⁢

(

rsER

)

⁢

(

rsAttr

)

(

Attr

⁢

and wherein RsMap is the impact rating between the first metadata descriptor and the second metadata descriptor; and

saving the impact rating.

2. The method of claim 1 , wherein said step of calculating a relative strength of the attribute relationship considering the relative strength of the entity relationship (rsAttr) further comprises:

increasing the relative strength of the attribute relationship considering the relative strength of the entity relationship (rsAttr) if the relative strength of the entity relationship is above a predetermined amount.

3. The method of claim 1 , wherein said step of calculating the relative strength of the entity relationship further comprises:

adding a first rating to the relative strength of the entity relationship if the entity of the first metadata descriptor is equal to the table of the second metadata descriptor;

determining if the entity of the first metadata descriptor is related to the table of the second metadata descriptor; and

adding a second rating to the relative strength of the entity relationship if the entity of the first metadata descriptor is related to the table of the second metadata descriptor.

4. The method of claim 3 , wherein determining if any two metadata descriptor levels are related comprises:

determining if the levels are equated in an alias table and are not equal.

5. The method of claim 3 , wherein determining if any two metadata descriptor levels are related comprises:

determining if the levels contain similar characters.

6. The method of claim 3 , wherein said first rating is higher than said second rating.

7. The method of claim 1 , wherein said step of calculating the relative strength of the entity relationship further comprises:

adding a third rating to the relative strength of the entity relationship if the entity of the first metadata descriptor is equal to a token of the second metadata descriptor;

determining if the entity of the first metadata descriptor is related to a token of the second metadata descriptor; and

adding a fourth rating to the relative strength of the entity relationship if the entity of the first metadata descriptor is related to the entity of the second metadata descriptor.

8. The method of claim 7 , wherein the third rating is higher than the fourth rating.

9. The method of claim 7 , wherein determining if any two metadata descriptor levels are related comprises:

determining if the levels are equated in an alias table and are not equal.

10. The method of claim 7 , wherein determining if any two metadata descriptor levels are related comprises:

determining if the levels contain similar characters.

11. The method of claim 7 , further comprising:

decreasing the third rating and the second rating if the first metadata descriptor includes a second entity from a second database.

12. The method of claim 7 , further comprising:

decreasing the third rating by dividing the third rating by the number of entities from the first metadata descriptor in a second database.

13. The method of claim 1 , wherein said step of calculating the relative strength of the attribute relationship further comprises:

adding a fifth rating to the relative strength of the attribute relationship if the attribute of the first metadata descriptor is equal to a token of the second metadata descriptor;

determining if the attribute of the first metadata descriptor is related to a token of the second metadata descriptor; and

adding a sixth rating to the relative strength of the attribute relationship if the attribute of the first metadata descriptor is related to the entity of the second metadata descriptor.

14. The method of claim 13 , wherein the fifth rating is higher than the sixth rating.

15. The method of claim 13 , wherein determining if any two metadata descriptor levels are related comprises:

determining if the levels are equated in an alias table and are not equal.

16. The method of claim 13 , wherein determining if any two metadata descriptor levels are related comprises:

determining if the levels contain similar characters.

17. The method of claim 13 , further comprising:

decreasing the fifth rating and the sixth rating if the first metadata descriptor includes a second attribute from a second database.

18. The method of claim 13 , further comprising:

dividing the fifth rating by substantially the number of time the attribute appears in a second database.

19. A method for estimating impact in a computer system, comprising:

calculating a relative strength of an entity relationship (rsER) between the first metadata descriptor and the second metadata descriptor;

calculating a relative strength of a mapping (RsMap) between the first metadata descriptor and the second metadata descriptor, wherein RsMap is calculated using the formula:

Rs Map= rsER+rsAttr

where RsMap is the relative strength of the mapping;

rsER is the relative strength of the entity relationship;

rsAttr is the relative strength of the attribute relationship considering the entity relationship; and

wherein the relative strength of mapping is the impact rating between the first metadata descriptor and the second metadata descriptor; and

storing the impact rating.

20. A method for estimating impact in a computer system, comprising:

calculating a relative strength of an entity relationship (rsER) between the first metadata descriptor and the second metadata descriptor;

calculating a relative strength of a mapping (RsMap) between the first metadata descriptor and the second metadata descriptor wherein RsMap is calculated using the formula:

Rs Map=( rsER )+( rsAttr )+ rsAttr*

where RsMap is the relative strength of mapping;

rsER is the relative strength of the entity relationship;

rsAttr is the relative strength of the attribute relationship considering the entity relationship;

rsAttr* is the relative strength of the attribute relationship without considering the entity relationship; and

wherein the relative strength of mapping is the impact rating between the first metadata descriptor and the second metadata descriptor; and

storing the impact rating.

Assignments (5)

ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Oct 8, 2008

From: AT&T DELAWARE INTELLECTUAL PROPERTY, INC.

To: AT&T INTELLECTUAL PROPERTY I, L.P.

Reel/Frame 021640/0619 →