Search Images Maps Play YouTube News Gmail Drive More »
Sign in
Screen reader users: click this link for accessible mode. Accessible mode has the same essential features but works better with your reader.

Patents

  1. Advanced Patent Search
Publication numberUS20060064666 A1
Publication typeApplication
Application numberUS 11/219,039
Publication dateMar 23, 2006
Filing dateSep 1, 2005
Priority dateMay 25, 2001
Also published asUS8548938, US20120215592
Publication number11219039, 219039, US 2006/0064666 A1, US 2006/064666 A1, US 20060064666 A1, US 20060064666A1, US 2006064666 A1, US 2006064666A1, US-A1-20060064666, US-A1-2006064666, US2006/0064666A1, US2006/064666A1, US20060064666 A1, US20060064666A1, US2006064666 A1, US2006064666A1
InventorsRuth Amaru, Joshua Fox, Benjamin Halberstadt, Boris Melamed, Zvi Schreiber
Original AssigneeAmaru Ruth M, Joshua Fox, Benjamin Halberstadt, Boris Melamed, Zvi Schreiber
Export CitationBiBTeX, EndNote, RefMan
External Links: USPTO, USPTO Assignment, Espacenet
Business rules for configurable metamodels and enterprise impact analysis
US 20060064666 A1
Abstract
A metadata management system for importing, integrating and federating metadata, including a configurable metamodel, a metadata repository for storing metadata whose structure reflects the metamodel, at least one external metadata source, which is able to persist metadata in accordance with the structure of a meta-schema, a mapping module for mapping the meta-schema to the metamodel, and a transformation module, operatively coupled to the metadata mapping module, for translating specific metadata from the at least one external metadata source to the metadata repository, for use in import, export or synchronization of metadata between the external metadata source and the metadata repository. A method and a computer-readable storage medium are also described.
Images(14)
Previous page
Next page
Claims(62)
1. A metadata management system for importing, integrating and federating metadata, comprising:
a configurable metamodel for modeling metadata that describes enterprise IT assets;
a metadata repository for storing metadata whose structure reflects said metamodel;
at least one external metadata source, which is able to persist metadata in accordance with the structure of a meta-schema;
a mapping module for mapping said meta-schema to the metamodel; and
a transformation module, operatively coupled to said metadata mapping module, for translating specific metadata from said at least one external metadata source to said metadata repository, for use in import, export or synchronization of metadata between said at least one external metadata source and said metadata repository.
2. The metadata management system of claim 1 wherein the mapping module is also used to map specific metadata to an information model.
3. The metadata management system of claim 2 wherein the information model is an ontology model.
4. The metadata management system of claim 1 wherein said metamodel complies with the OMG MOF standard.
5. The metadata management system of claim 1 wherein said metamodel is an ontology.
6. The metadata management system of claim 1 wherein said transformation module translates metadata from the external metadata source into an XMI document.
7. The metadata management system of claim 1 wherein said transformation module transforms metadata using an XSLT script.
8. The metadata management system of claim 1 wherein said mapping module maps data element groups, and then maps specific data elements within each group.
9. A metadata management system for validating metadata, comprising:
a configurable metamodel for modeling metadata that describes enterprise IT assets;
business rules on said metamodel; and
a metadata validation module operating on said configurable metamodel for validating specific metadata against said metamodel business rules.
10. The metadata management system of claim 9 wherein the business rules include an arithmetic conversion rule.
11. The metadata management system of claim 9 wherein the business rules include type restriction on an inherited property.
12. The metadata management system of claim 9 wherein the business rules include specifying a metadata value as being required.
13. The metadata management system of claim 9 wherein the business rules include specifying a valid range for a metadata value.
14. The metadata management system of claim 9 wherein the business rules include specifying a metadata value as being unique.
15. The metadata management system of claim 9 wherein the business rules include a lookup table.
16. The metadata management system of claim 9 wherein the business rules include a naming convention.
17. The metadata management system of claim 9 wherein the business rules are used to specify assignment of stewardship responsibility.
18. A metadata management system for generating metadata comprising:
a configurable metamodel for modeling metadata that describes enterprise IT assets;
business rules on said metamodel; and
a metadata generation module operating on said configurable metamodel for guiding the generation of specific metadata using said metamodel business rules.
19. The metadata management system of claim 18 wherein the business rules include an arithmetic conversion rule.
20. The metadata management system of claim 18 wherein the business rules include type restriction on an inherited property.
21. The metadata management system of claim 18 wherein the business rules include specifying a metadata value as being required.
22. The metadata management system of claim 18 wherein the business rules include specifying a valid range for a metadata value.
23. The metadata management system of claim 18 wherein the business rules include specifying a metadata value as being unique.
24. The metadata management system of claim 18 wherein the business rules include a lookup table.
25. The metadata management system of claim 18 wherein the business rules include a naming convention.
26. The metadata management system of claim 18 wherein the business rules are used to specify assignment of stewardship responsibility.
27. A metadata management system for managing an IT organization, comprising:
a configurable metamodel for modeling metadata that describes enterprise IT assets;
business rules on said metamodel; and
a validation module operating on said configurable metamodel for validating rules for IT governance against said metamodel business rules.
28. The metadata management system of claim 27 wherein the rules for IT governance include assignment of responsibility for assets.
29. A method for importing, integrating and federating metadata, comprising:
providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, (ii) a metadata repository for storing metadata whose structure reflects the metamodel, and (iii) at least one external metadata source, which is able to persist metadata in accordance with the structure of a meta-schema;
mapping the meta-schema to the metamodel; and
translating specific metadata from the external metadata source to the metadata repository for use in import, export or synchronization of metadata between the at least one external metadata source and the metadata repository.
30. The method of claim 29 wherein said mapping maps specific metadata to an information model.
31. The method of claim 30 wherein the information model is an ontology model.
32. The method of claim 29 wherein the metamodel complies with the OMG MOF standard.
33. The method of claim 29 wherein the metamodel is an ontology.
34. The method of claim 29 wherein said mapping translates metadata from the external metadata source into an XMI document.
35. The method of claim 29 wherein said translating uses an XSLT script.
36. The method of claim 29 wherein said mapping comprises:
mapping data element groups; and
mapping specific data elements within each group.
37. A method for validating metadata, comprising:
providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, and (ii) business rules on the metamodel; and
validating specific metadata against the metamodel business rules.
38. A method for generating metadata comprising:
providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, and (ii) business rules on the metamodel; and
guiding the generation of specific metadata using the metamodel business rules.
39. A method for managing an IT organization, comprising:
providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, and (ii) business rules on the metamodel; and
validating rules for IT governance against the metamodel business rules.
40. The method of claim 29 wherein the rules for IT governance include assignment of responsibility for assets.
41. A computer-readable storage medium storing program code for causing a computer to perform a method of:
providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, (ii) a metadata repository for storing metadata whose structure reflects the metamodel, and (iii) at least one external metadata source, which is able to persist metadata in accordance with the structure of a meta-schema;
mapping the meta-schema to the metamodel; and
translating specific metadata from the external metadata source to the metadata repository for use in import, export or synchronization of metadata between the at least one external metadata source and the metadata repository.
42. A computer-readable storage medium storing program code for causing a computer to perform a method of:
providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, and (ii) business rules on the metamodel; and
validating specific metadata against the metamodel business rules.
43. A computer-readable storage medium storing program code for causing a computer to perform a method of:
providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, and (ii) business rules on the metamodel; and
guiding the generation of specific metadata using the metamodel business rules.
44. A computer-readable storage medium storing program code for causing a computer to perform a method of:
providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, and (ii) business rules on the metamodel; and
validating responsibility assignments against the metamodel business rules.
45. A metadata management system for performing impact analysis on an IT system comprising:
a configurable metamodel for modeling metadata that describes assets of an enterprise IT system, the metamodel including meta-classes and meta-properties;
business rules on said metamodel for indicating that certain meta-properties have impact consequences; and
an impact analyzer operating on said configurable metamodel for determining which assets of the enterprise IT system are impacted by one or more specified assets.
46. The metadata management system of claim 43 whereby assets of the enterprise IT system include server computers.
47. The metadata management system of claim 43 whereby assets of the enterprise IT system include web sites.
48. The metadata management system of claim 43 whereby assets of the enterprise IT system include data sources.
49. The metadata management system of claim 43 whereby assets of the enterprise IT system include data transformations.
50. The metadata management system of claim 43 whereby assets of the enterprise IT system include software applications.
51. The metadata management system of claim 43 whereby the business rules dictate whether impact consequences are transitive and, if so, to what degree.
52. A method for generating metadata comprising:
providing (i) a configurable metamodel for modeling metadata that describes assets of an enterprise IT system, the metamodel including meta-classes and meta-properties, and (ii) business rules on said metamodel for indicating that certain meta-properties have impact consequences; and
determining which assets of the enterprise IT system are impacted by one or more specified assets.
53. The method of claim 52 whereby assets of the enterprise IT system include server computers.
54. The method of claim 52 whereby assets of the enterprise IT system include web sites.
55. The method of claim 52 whereby assets of the enterprise IT system include data sources.
56. The method of claim 52 whereby assets of the enterprise IT system include data transformations.
57. The method of claim 52 whereby assets of the enterprise IT system include software applications.
58. The method of claim 52 whereby the business rules dictate whether impact consequences are transitive and, if so, to what degree.
59. A computer-readable storage medium storing program code for causing a computer to perform a method of:
providing (i) a configurable metamodel for modeling metadata that describes assets of an enterprise IT system, the metamodel including meta-classes and meta-properties, and (ii) business rules on said metamodel for indicating that certain meta-properties have impact consequences; and
determining which assets of the enterprise IT system are impacted by one or more specified assets.
60. A metadata management system for performing impact analysis on an IT system comprising:
a configurable metamodel for modeling metadata that describes assets of an enterprise IT system, the metamodel including meta-classes and meta-properties;
a meta-descriptor for meta-properties to designate that a meta-property has an impact consequence; and
an impact analyzer operating on said configurable metamodel for determining which assets of the enterprise IT system are impacted by one or more specified assets.
61. A method for generating metadata comprising:
providing (i) a configurable metamodel for modeling metadata that describes assets of an enterprise IT system, the metamodel including meta-classes and meta-properties, and (ii) a meta-descriptor for meta-properties to designate that a meta-property has an impact consequence; and
determining which assets of the enterprise IT system are impacted by one or more specified assets.
62. A computer-readable storage medium storing program code for causing a computer to perform a method of:
providing (i) a configurable metamodel for modeling metadata that describes assets of an enterprise IT system, the metamodel including meta-classes and meta-properties, and (ii) a meta-descriptor for meta-properties to designate that a meta-property has an impact consequence; and
determining which assets of the enterprise IT system are impacted by one or more specified assets.
Description
    CROSS REFERENCES TO RELATED APPLICATIONS
  • [0001]
    This application is a continuation-in-part of assignee's pending application U.S. Ser. No. 10/053,045, filed on Jan. 15, 2002, entitled “Method and System for Deriving a Transformation by Referring Schema to an Central Model,” which is a continuation-in-part of assignee's pending application U.S. Ser. No. 09/866,101, filed on May 25, 2001, entitled “Method and System for Collaborative Ontology Modeling.”
  • FIELD OF THE INVENTION
  • [0002]
    The present invention relates to management of enterprise metadata.
  • BACKGROUND OF THE INVENTION
  • [0003]
    Large enterprises rely on vast amounts and diverse types of data for their operation—personnel data, financial data, accounting data, inventory data, capital equipment data, document management data, and more. Today, data is generally stored according to data structures referred to as a data schemas, such as XML and relational database schemas, these being a form of metadata. The term “metadata” is used to denote data about the structure of the raw data itself, and about the structures of other Information Technology (IT) systems such as applications, processes, middleware and hardware configurations. The raw data, which includes actual data about specific personnel, for example, or specific pieces of inventory, is referred to as “instance data.” Thus, for a data store having the structure of a relational database, the metadata describes the tables and their columns to be populated with data, and the raw data, referred to as instance data, is the actual data stored within the tables and columns. Similarly, for a data store of XML documents, the metadata describes the XML complexTypes and their XML elements, and the instance data is the actual data stored within the XML documents. Each data store is referred to generically as a “data asset.”
  • [0004]
    Types of metadata include inter alia data schemas such as relational and XML schemas, source code, architecture models such as information models and process models, operational metadata regarding usage of applications and up-time, hardware inventories and configurations, service level agreements, and IT budgets.
  • [0005]
    It is common for large enterprises to have thousands of different data assets, each with a unique schema; i.e., thousands of different metadata descriptions, within their IT. For example, financial data may be spread out over several different relational databases, personnel data may be spread out over several different XML document stores, and inventory data may be spread out according to several different Cobol Copybook definitions.
  • [0006]
    In order to describe all of the different types of enterprise IT assets, including inter alia data assets and applications, a metamodel is used to model the entire repertoire of IT asset types. Such asset types include inter alia relational database schemas, XML schemas, COBOL Copybook definitions, Java applications, Engage Transform and Load (ETL) middleware and the structures associated therewith. A “metamodel” is a model for metadata, and describes the types of assets within the enterprise IT, and their inter-dependencies. Actual metadata itself instantiates the metamodel.
  • [0007]
    The three levels of data—instance data, metadata and metamodel, form a data hierarchy, wherein the structure of each level of data is described by the level above it. The three data levels within the data hierarchy are denoted by M0 (instance data), M1 (metadata) and M2 (metamodel). More generally, M0 includes instance data, messages and specific interactions; M1 defines actual IT structures, such as specific schemas, interfaces and inter-dependencies; and M2 describes types of structures and cross-references of IT.
  • [0008]
    In order to enable efficient use of a rich and configurable metamodel, a system is needed that supports (i) metamodel editing; (ii) classes, properties, inheritance and multiple inheritance within a metamodel; and (iii) industry standards such as Meta-Object Facility (MOF™) for structure of the metamodel, XML Interchange (XMI™) for import and export of metadata, and standard metamodels such as the Common Warehouse Metamodel (CWM™) and the DMTF Common Information Model (CIM™). MOF™, XMI and CWM™ are standards developed by the Object Modeling Group (OMG®); and CIM is a standard developed by Distributed Management Task Force, Inc. (DMTF™).
  • [0009]
    While the prior art includes flexible metamodels such as MOF-compliant metamodels, which flexibly define the structure of metadata, metamodels have not been used to describe specific rules which metadata must obey. Therefore, metamodels have hitherto had limited use in the detailed governance of IT.
  • [0010]
    Furthermore, although there are standard languages such as MOF for specifying metamodels, in reality sources of metadata currently have their own metamodels, making it difficult to accumulate metadata from different sources into one overall metadata model of enterprise IT.
  • SUMMARY OF THE DESCRIPTION
  • [0011]
    The present invention concerns a method and system for metadata management. The present invention supports (i) a rich and configurable metamodel with run-time metamodel editing; (ii) multiple inheritance and the addition of business rules within a metamodel; (iii) industry standards such as MOF™, XMI™, CWM™ and CIM™. The metamodel of the present invention supports an endless number of types of metadata, including inter alia metadata for data assets, business applications, organization charts, process models, hardware configurations and network topographies; and (iv) mapping between incompatible metamodels to enable import, export, synchronization and federation of metadata.
  • [0012]
    There is thus provided in accordance with a preferred embodiment of the present invention a metadata management system for importing, integrating and federating meta-data, including a configurable metamodel for modeling metadata that describes enterprise IT assets, a metadata repository for storing metadata whose structure reflects the metamodel, at least one external metadata source, which is able to persist metadata in accordance with the structure of a meta-schema, a mapping module for mapping the meta-schema to the metamodel, and a transformation module, operatively coupled to the metadata mapping module, for translating specific metadata from the external metadata source to the metadata repository, for use in import, export or synchronization of metadata between the at least one external metadata source and the metadata repository.
  • [0013]
    There is further provided in accordance with a preferred embodiment of the present invention a metadata management system for validating metadata, including a configurable metamodel for modeling metadata that describes enterprise IT assets, business rules on the metamodel, and a metadata validation module operating on said configurable metamodel for validating specific metadata against the metamodel business rules.
  • [0014]
    There is yet further provided in accordance with a preferred embodiment of the present invention a metadata management system for generating metadata including a configurable metamodel for modeling metadata that describes enterprise IT assets, business rules on the metamodel, and a metadata generation module operating on said configurable metamodel for guiding the generation of specific metadata using the metamodel business rules.
  • [0015]
    There is moreover provided in accordance with a preferred embodiment of the present invention a metadata management system for managing an IT organization, including a configurable metamodel for modeling metadata that describes enterprise IT assets, business rules on the metamodel, and a validation module operating on said configurable metamodel for validating rules for IT governance against the metamodel business rules.
  • [0016]
    There is additionally provided in accordance with a preferred embodiment of the present invention a method for importing, integrating and federating metadata, including providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, (ii) a metadata repository for storing metadata whose structure reflects the metamodel, and (iii) at least one external metadata source, which is able to persist metadata in accordance with the structure of a meta-schema, mapping the meta-schema to the metamodel, and translating specific metadata from the at least one external metadata source to the metadata repository for use in import, export or synchronization of metadata between the external metadata source and the metadata repository.
  • [0017]
    There is further provided in accordance with a preferred embodiment of the present invention a method for validating metadata, including providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, and (ii) business rules on the metamodel, and validating specific metadata against the metamodel business rules.
  • [0018]
    There is yet further provided in accordance with a preferred embodiment of the present invention a method for generating metadata including providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, and (ii) business rules on the metamodel, and guiding the generation of specific metadata using the metamodel business rules.
  • [0019]
    There is moreover provided in accordance with a preferred embodiment of the present invention a method for managing an IT organization, including providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, and (ii) business rules on the metamodel, and validating rules for IT governance against the metamodel business rules.
  • [0020]
    There is additionally provided in accordance with a preferred embodiment of the present invention a computer-readable storage medium storing program code for causing a computer to perform the steps of providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, (ii) a metadata repository for storing metadata whose structure reflects the metamodel, and (iii) at least one external metadata source, which is able to persist metadata in accordance with the structure of a meta-schema, mapping the meta-schema to the metamodel, and translating specific metadata from the at least one external metadata source to the metadata repository for use in import, export or synchronization of metadata between the external metadata source and the metadata repository.
  • [0021]
    There is further provided in accordance with a preferred embodiment of the present invention a computer-readable storage medium storing program code for causing a computer to perform the steps of providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, and (ii) business rules on the metamodel, and validating specific metadata against the metamodel business rules.
  • [0022]
    There is yet further provided in accordance with a preferred embodiment of the present invention a computer-readable storage medium storing program code for causing a computer to perform the steps of providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, and (ii) business rules on the metamodel, and guiding the generation of specific metadata using the metamodel business rules.
  • [0023]
    There is moreover provided in accordance with a preferred embodiment of the present invention a computer-readable storage medium storing program code for causing a computer to perform the steps of providing (i) a configurable metamodel for modeling metadata that describes enterprise IT assets, and (ii) business rules on the metamodel, and validating responsibility assignments against the metamodel business rules.
  • [0024]
    There is additionally provided in accordance with a preferred embodiment of the present invention a metadata management system for performing impact analysis on an IT system comprising a configurable metamodel for modeling metadata that describes assets of an enterprise IT system, the metamodel including meta-classes and meta-properties, business rules on the metamodel for indicating that certain meta-properties have impact consequences, and an impact analyzer operating on the configurable metamodel for determining which assets of the enterprise IT system are impacted by one or more specified assets.
  • [0025]
    There is further provided in accordance with a preferred embodiment of the present invention A method for generating metadata comprising providing (i) a configurable metamodel for modeling metadata that describes assets of an enterprise IT system, the metamodel including meta-classes and meta-properties, and (ii) business rules on said metamodel for indicating that certain meta-properties have impact consequences, and determining which assets of the enterprise IT system are impacted by one or more specified assets.
  • [0026]
    There is yet further provided in accordance with a preferred embodiment of the present invention a computer-readable storage medium storing program code for causing a computer to perform the steps of providing (i) a configurable metamodel for modeling metadata that describes assets of an enterprise IT system, the metamodel including meta-classes and meta-properties, and (ii) business rules on said metamodel for indicating that certain meta-properties have impact consequences, and determining which assets of the enterprise IT system are impacted by one or more specified assets.
  • [0027]
    There is moreover provided in accordance with a preferred embodiment of the present invention a metadata management system for performing impact analysis on an IT system including a configurable metamodel for modeling metadata that describes assets of an enterprise IT system, the metamodel including meta-classes and meta-properties, a meta-descriptor for meta-properties to designate that a meta-property has an impact consequence, and an impact analyzer operating on said configurable metamodel for determining which assets of the enterprise IT system are impacted by one or more specified assets.
  • [0028]
    There is additionally provided in accordance with a preferred embodiment of the present invention a method for generating metadata including providing (i) a configurable metamodel for modeling metadata that describes assets of an enterprise IT system, the metamodel including meta-classes and meta-properties, and (ii) a meta-descriptor for meta-properties to designate that a meta-property has an impact consequence, and determining which assets of the enterprise IT system are impacted by one or more specified assets.
  • [0029]
    There is further provided in accordance with a preferred embodiment of the present invention a computer-readable storage medium storing program code for causing a computer to perform the steps of providing (i) a configurable metamodel for modeling metadata that describes assets of an enterprise IT system, the metamodel including meta-classes and meta-properties, and (ii) a meta-descriptor for meta-properties to designate that a meta-property has an impact consequence, and determining which assets of the enterprise IT system are impacted by one or more specified assets.
  • BRIEF DESCRIPTION OF THE DRAWINGS
  • [0030]
    The present invention will be more fully understood and appreciated from the following detailed description, taken in conjunction with the drawings in which:
  • [0031]
    FIG. 1 is a simplified illustration of an Object Management Group hierarchy including instance data, metadata and a metamodel, in accordance with a preferred embodiment of the present invention;
  • [0032]
    FIG. 2 illustrates a metamodel wherein a meta-class RDBSchema is associated with a databaseAdministrator of type Person, in accordance with a preferred embodiment of the present invention;
  • [0033]
    FIG. 3 illustrates a business rule requiring that every relational database must have a database Administrator, in accordance with a preferred embodiment of the present invention;
  • [0034]
    FIG. 4 illustrates a business rule wherein the name of a Cobol Copybook definition may be generated based on a naming standard from other meta-properties of a Cobol Copybook, such as ApplicationName, DivisionName, in accordance with a preferred embodiment of the present invention;
  • [0035]
    FIG. 5 is a simplified block diagram of a metadata management system for importing metadata, in accordance with a preferred embodiment of the present invention;
  • [0036]
    FIG. 6 is a simplified block diagram of a system for validating metadata, in accordance with a preferred embodiment of the present invention; and
  • [0037]
    FIG. 7 is a simplified block diagram of a system for automatically guiding the generation of metadata so as to ensure that the metadata is compliant with business rules of a metamodel, in accordance with a preferred embodiment of the present invention;
  • [0038]
    FIG. 8 is an illustration of a dialogue box for creating an impact analysis (IA) meta-class, in accordance with a preferred embodiment of the present invention;
  • [0039]
    FIG. 9 is an illustration of a dialogue box that continues the workflow from FIG. 8, for designating properties as being germane to a particular impact analysis, in accordance with a preferred embodiment of the present invention;
  • [0040]
    FIG. 10 is an illustration of stepwise graphical navigation of a meta-model, in accordance with a preferred embodiment of the present invention;
  • [0041]
    FIG. 11 is an illustration of a graphic display of the transitive closure of impacted notes, in accordance with a preferred embodiment of the present invention;
  • [0042]
    FIG. 12 is an illustration of a graphical user interface for viewing data lineage results arranged along a “data flow axis” and a “system composition axis”, in accordance with a preferred embodiment of the present invention; and
  • [0043]
    FIG. 13 is an illustration of a graphical user interface for marking meta-properties as being Downstream Items, Upstream Items, subunits or superUnits, in accordance with a preferred embodiment of the present invention.
  • DETAILED DESCRIPTION
  • [0044]
    The present invention is preferably embodied within at least one server computer used to store configurable information about enterprise data assets in the form of a metamodel and metadata conforming to the metamodel; and within a plurality of client computers used to generate and edit metadata, and to query the metadata. The present invention enables an enterprise to understand the structure of all of its data assets and other IT assets, even when metadata information on the structures comes from many sources in different formats. The present invention uses rules to impose restrictions on allowed metadata values and hence on the types of structures which may appear in the IT environment.
  • [0045]
    Reference is now made to FIG. 1, which is a simplified illustration of an Object Management Group hierarchy including instance data, metadata and a metamodel, in accordance with a preferred embodiment of the present invention. A metamodel, referred to as an M2, is used to define the structural elements of a data schema. For example, the M2 illustrated in FIG. 1 describes the elements of a relational database schema. As shown, a relational database schema 105 includes elements 110 referred to as “tables,” and in turn tables includes elements 115 referred to as “columns.” A relational database 105, a table 110 and a column 115 each have a text identifier referred to as its “name.”
  • [0046]
    Metadata for a data schema, referred to as an M1, is used to define a specific data schema conforming to the metamodel. As shown in FIG. 1, the M1 metadata specifies a relational database 120 named “Customer Database.” The customer database has a table 125 named “Address” and a table 130 named “State.” In turn the Address table has a column 135 named “Street Line” and a column 140 named “Zip Code;” and the State table has a column 145 named “Postal Code” and a column 150 named “Name.”
  • [0047]
    Specific instance data 155 conforming to the Customer Database, referred to as M0, is illustrated at the bottom of the hierarchy of FIG. 1. It may be appreciated that, just as M0 corresponds to instance data for an M1, in the same manner M1 corresponds to instance data for an M2.
  • [0048]
    Metamodels and metadata may be specified using the Meta-Object Facility (MOF™) specification, developed by Object Management Group, Inc. (OMG®) of Needham, Mass.
  • [0049]
    Preferably, in accordance with a preferred embodiment of the present invention, metamodels are represented in terms of an ontology having classes and properties, such as ontologies based on the W3C Web Ontology Language (OWL) standard, as described in applicant's co-pending application U.S. Ser. No. 10/053,045, filed on Jan. 15, 2002, entitled “Method and System for Deriving a Transformation by Referring Schema to an Central Model,” the contents of which are hereby incorporated by reference. In order to distinguish between M1 metadata and M2 metamodels, classes and properties within an M2 metamodel are referred to herein as meta-classes and meta-properties, respectively. In working with metamodels, it is often useful to consider meta-classes and meta-properties as being class types and property types, respectively. For example, specific relational database tables such as Address and State are of type Table; i.e., they are instance classes of a meta-class Table.
  • [0050]
    Preferably, metamodel M2 includes business rules, which relate various meta-properties. Examples of such business rules are described hereinbelow with reference to FIGS. 3 and 4.
  • [0051]
    Reference is now made to FIG. 2, which illustrates a metamodel wherein a meta-class RDBSchema 210 is associated with a databaseAdministrator 220 of type Person 230, in accordance with a preferred embodiment of the present invention.
  • [0052]
    Reference is now made to FIG. 3, which illustrates a business rule requiring that every relational database 310 must have a meta-property databaseAdministrator 320 of type Person 330, in accordance with a preferred embodiment of the present invention. The business rule is set in FIG. 3 by marking the meta-property as Required 340. The cardinality 250 of meta-property databaseAdministrator is [1 . . . 1], indicating that the minimum 350 and maximum 360 number of databaseAdministrators per RDBSchema is 1.
  • [0053]
    Referring back to FIG. 2, an integrity checker 240 preferably lists all violations of business rules. Thus, if a databaseAdministrator is not defined for an RDBSchema, then integrity checker 240 will flag this as a violation of the business rule shown in FIG. 3.
  • [0054]
    Reference is now made to FIG. 4, which illustrates a business rule wherein the name of a Cobol Copybook definition may be generated based on a naming standard from other meta-properties of a Cobol Copybook, such as ApplicationName and DivisionName, in accordance with a preferred embodiment of the present invention. Specifically, business rule 410 shown in FIG. 4 requires that the meta-property name 420 for the meta-class CobolCopybook 430 be the concatenation of the three strings ApplicationName 440, DivisionName 450 and FirstDataArchitectAssignedtothisAsset 460.
  • [0055]
    It may be appreciated by those skilled in the art that business rule 410 may be used to automatically generate the name for a CobolCopybook.
  • [0056]
    Examples of business rules that may be used with the present invention include inter alia:
      • arithmetic conversion rules;
      • type restrictions on inherited properties;
      • specifying metadata values as being required;
      • specifying valid ranges for metadata values;
      • specifying metadata values as being unique;
      • lookup tables;
      • naming conventions; and
      • assignments of stewardship responsibilities.
  • [0065]
    Business rules may also be used, in accordance with a preferred embodiment of the present invention, for type restrictions on indirect properties. Consider the following indirect sequence of meta-classes and meta-properties: C1.P1-->C2.P2-->C3. Suppose that the indirect meta-property C1.P1.P2 should be restricted to be of type S3, which is a sub-class of C3, but that C2.P2 is not to be restricted to S3. In general, there may not be an appropriate inheritance structure to impose such a restriction as a type restriction on an inherited property.
  • [0066]
    In accordance with a preferred embodiment of the present invention, a new meta-class, S2, corresponding to C1.P1, is defined as a sub-class of C2, and a business rule is used to restrict the type of S2.P2 to S3. Using this approach, none of the properties P1 or P2 in the property path are required to be inherited properties. Moreover, this approach applies to arbitrarily long property paths.
  • [0067]
    It may be appreciated by those skilled in the art that the present invention has widespread application. FIGS. 5-7 illustrate three different applications of the present invention in the area of enterprise metadata management.
  • [0068]
    Reference is now made to FIG. 5, which is a simplified block diagram of a metadata management system for importing metadata, in accordance with a preferred embodiment of the present invention. FIG. 5 illustrates a metamodel of an enterprise, such as the metamodel illustrated in FIGS. 2 and 4, including meta-classes and sub-classes for business applications and data assets. The class DataAsset includes inter alia sub-classes CobolCopybook, ErwinSchema, RDBSchema, XMISchema and XSDSchema. FIG. 2 displays meta-properties for the RDBSchema meta-class, and FIG. 4 displays metadata for the CobolCopybook meta-class.
  • [0069]
    Shown in FIG. 5 are a configurable metamodel 510, and a repository 520 of metadata that conforms to metamodel 510. Also shown in FIG. 5 are an external meta-schema 530 and a repository 540 of metadata that conforms to meta-schema 530. Since the metadata in repository 540 conforms to a different meta-schema than the metadata in repository 520, the metadata in repository 540 cannot readily be imported into repository 520. For example, the metadata in repository 540 may be metadata for XML schemas, whereas the metadata in repository 520 may be metadata for relational database schemas.
  • [0070]
    The system illustrated in FIG. 5 imports the metadata from repository 540 into repository 520. A mapping module 550 is used to generate a mapping 560 between the meta-schema 530 and the metamodel 510. Generation of mappings between schemas is described in applicant's aforementioned co-pending patent application U.S. Ser. No. 10/053,045. For example, mapping 560 may associate
    XML Schema Metamodel
    XML complexType --> class
    XML element --> property
  • [0071]
    When mapping 560 is generated, a metadata transformation module 570 uses mapping 560 to derive a data transformation for transforming metadata from repository 540 to metadata that conforms to metamodel 510. Upon transformation, the metadata in repository 540 can then be directly imported into repository 520. Derivation of transformations is also described in applicant's aforementioned co-pending patent application U.S. Ser. No. 10/053,045.
  • [0072]
    For example, if metadata from repositories 520 and 540 is represented by XML data, which may conform to the Metadata Interchange (XMI) standard, then the data transformation derived by transformation module 570 may be an XSLT script. XMI is a standard of the Object Management Group (OMG®) for interchanging metadata between modeling tools and metadata repositories, and XSLT is a language developed by the World-Wide Web Consortium (W3C®), for transforming XML documents into other XML documents.
  • [0073]
    It may be appreciated by those skilled in the art that M1 metadata can be considered as instance data for an M2 metamodel. As such the same mapping module 550 and the same transformation module 570 from FIG. 5, may also be used to map a first set of M1 metadata to a second set of M1 metadata, and to transform M0 instance data conforming to the first set of metadata to M0 instance data conforming to the second set of metadata. This allows the same tools and skills to be used for mapping metadata and transforming instance data, as is used for mapping metamodels/meta-schemas and transforming metadata.
  • [0074]
    Reference is now made to FIG. 6, which is a simplified block diagram of a system for validating metadata, in accordance with a preferred embodiment of the present invention. Shown in FIG. 6 are a configurable metamodel 610 and a repository 620 of metadata conforming to metamodel 610. Metamodel 610 includes one or more business rules 630, that relate meta-properties within metamodel 610, such as the business rules illustrated in FIGS. 3 and 4.
  • [0075]
    Shown in FIG. 6 is a validation module 640, which is preferably activated by a integrity checker control such as button 240 (FIG. 2). Preferably, validation module 640 verifies each of the business rules 630 against the metadata in repository 620, and produces a list of violations. It may be appreciated that violations of metadata rules may correspond to violations of IT policy by the actual systems that the metadata reflects.
  • [0076]
    It may be appreciated that the system of FIG. 6 applies to a variety of enterprise metadata. For example, metadata repository 620 may be metadata for an IT organization, and the business rules may define valid responsibility assignments. In such a case, validation module 640 is used to validate responsibility assignments.
  • [0077]
    Reference is now made to FIG. 7, which is a simplified block diagram of a system for automatically guiding the generation of metadata so as to ensure that the metadata is compliant with business rules of a metamodel, in accordance with a preferred embodiment of the present invention. Alternatively, the generation of metadata may be motivated by the desire to reduce the manual effort required in populating the metadata. Shown in FIG. 7 are a metamodel 710 and a repository 720 of metadata conforming to metamodel 720. Metamodel 710 includes one or more business rules 730.
  • [0078]
    Also shown in FIG. 7 is a metadata guide 740, which automatically guides a user who is generating metadata, so that the metadata complies with business rules 730. For example, with reference to FIG. 2, metadata guide 740 automatically ensures that each RDBSchema has a databaseAdministrator defined. Similarly, with reference to FIG. 4, metadata guide 740 automatically generates names of Cobol Copybooks, so that the name of a Copybook is a concatenation of an ApplicationName, a DivisionName and a FirstDataArchitectAssignedtothisAsset name.
  • [0000]
    Impact Analysis
  • [0079]
    The present invention has important application to impact analysis; namely, analyzing the impact of one or more IT assets on the rest of the IT infrastructure—i.e., determining, if one or more IT assets are shut down or modified, which other assets are impacted and how. Impact analysis is critical for routine system maintenance, system upgrade or modification, and for disaster recovery. Examples of impact analysis include inter alia:
      • determining which applications and systems will be impacted is a specific server shuts down;
      • determining who needs to be notified if a computer is replaced with a newer model;
      • determining which applications and systems will be impacted if a specific employee is promoted;
      • determining which data sources are fed by data from a specific database, either directly or indirectly; and
      • determine which data transformations are impacted if the type of a specific database column is changed, say from VARCHAR to INTEGER.
  • [0085]
    In a very general framework, in accordance with a preferred embodiment of the present invention, a binary relation such as “impacts” and its inverse binary relation “is impacted by” are imposed on meta-classes. These relations model the dependencies whereby one class may impact or may be impacted by another class, respectively. To generate these binary relations within a metamodel, appropriate meta-properties within the metamodel are characterized by “impacts” or “is impacted by”, and the binary relations then correspond to the transitive closure of these characterizations. Thus, if asset A impacts asset B, and asset B impacts asset C, then asset A also impacts asset C.
  • [0086]
    Within this general framework, the characterization of meta-properties as “impacts” or “is impacted by” is accomplished through a business rule referred to as an “Inclusion BR” and a property referred to as “impacts”. The Inclusion BR indicates that a first property P1 is included in a second property P2, where the domain of P1 is a sub-class of the domain of P2; namely, that whenever instance I is related to instance J via property P1, then instance I is also related to instance I via property P2. It may be appreciated by those skilled in the art that the Inclusion BR for P1 being included in P2 corresponds to P1 being a sub-property of P2.
  • [0087]
    To make the property “impacts” as broad as possible, it is preferably defined on a super-meta-class of the metamodel, such as a meta-class “Being” which is a super-meta-class of all meta-classes within the metamodel. Thus the Inclusion BR, indicating that a meta-property P from a domain meta-class C1 to a co-domain meta-class C2 is included in property “impacts”, requires that whenever instance I1 of meta-class C1 is related to instance I2 of meta-class C2 via meta-property P, then I1 impacts I2.
  • [0088]
    For example, for a meta-class “Server”, the Inclusion BR may specify that the two meta-properties “hasRunningApplications” (Server-->Application) and “hasRunningDBs” (Server-->Database) are impact meta-properties; i.e., included within the meta-property “impacts”. Thereafter an impact analysis on a specific server will produce all applications that run on the server and all databases that are hosted by the server. Similarly, for a meta-class “Application”, the Inclusion BR may specify that the two meta-properties “is FeedingInto” (Application-->RDBTable) and “is CreatingXML” (Application-->XMLDocument) are impact properties. Combining these by transitivity, a specific server may impact various relational database tables and various XML documents.
  • [0089]
    More specifically, as there are various type of impacts in an enterprise, a variety of different impact analyses may be performed; for example, a “downtime” impact analysis, a “procurement” impact analysis, or a “personnel” impact analysis. The same meta-class may participate in multiple impact analyses. Reference is now made to FIG. 8, which is an illustration of a dialogue box for creating an impact analysis (IA) meta-class, in accordance with a preferred embodiment of the present invention. As shown in FIG. 8, a meta-class named “DowntimeImpactItem” 810 is created, together with meta-properties “directDowntimeVictims” 820 and “allDowntimeVictims” 830, the former property corresponding to direct dependencies and the latter property corresponding to both direct and indirect dependencies. Also shown in FIG. 8 is the name of an impact analysis, “Downtime Impact Analysis” 840, which is used to perform an impact analysis vis a vis downtime impacts.
  • [0090]
    The meta-class “DowntimeImpactItem” serves as a superclass for all meta-classes whose instances can participate in the analysis. Thus, for example, if ComputingDevice is a meta-class that should participate in downtime impact analysis, then it should be designated as a sub-class of DowntimeImpactItem and, as such, it inherits the properties directDowntimeVictims and allDowntimeVictims. Instances of sub-classes of meta-class ComputingDevice, such as instances of a class ServerComputer, of a class GatewayComputer and of a class ClientComputer, will then all participate in downtime impact analysis. Any meta-class that inherits from DowntimeImpactItem can be included within a downtime impact analysis. Similarly, if a meta-class inherits from multiple meta-classes, each super-class being a specific impact analysis type, then instances of the meta-class participate in each of the specific impact analyses.
  • [0091]
    It may thus be appreciated that an IA type of entity is preferably represented by a meta-class that has a property such as inter alia “impacts”, “affects” or “hasConsequencesFor”. The name of the meta-class preferably reflects the role of an instance class of its IA type, such as inter alia “DownTimeImpactItem” or “ProcurementImpactItem”.
  • [0092]
    Reference is now made to FIG. 9, which is an illustration of a dialogue box that continues the workflow from FIG. 8, for designating properties as being germane to a particular impact analysis, in accordance with a preferred embodiment of the present invention. Shown in the left panel of FIG. 9 is a meta-class “DowntimeImpactItem” 905, as defined in the dialogue box of FIG. 8, from which meta-classes “Application” 910 and “Server” 915 inherit, by virtue of being sub-classes thereof. Shown in the right panel of FIG. 9 are various properties of the meta-class Server, such as “ApplicationID” 920, “Applications” 925, “CPU” 930 and the inherited property directDowntimeVictims 935, as also defined in the dialogue box of FIG. 8. Also shown in FIG. 8 is a business rule that assigns the meta-property “Applications” 940 to Downtime Impact Analysis 945. For convenience, a user merely selects the Applications meta-property 925 from the list of Server meta-properties, and then clicks on the Add button 950. Such a business rule indicates that instance classes of Applications are impacted when corresponding instance classes of Server go down. As such, when a downtime impact analysis is performed, applications running on server computers will be included in the analysis. It may thus be appreciated by those skilled in the art that impact analyses are conveniently defined via business rules of a meta-model.
  • [0093]
    In accordance with a preferred embodiment of the present invention, in order to simplify the workflow of defining impact analyses and in order to avoid potential errors in the metamodel, when a user adds a meta-property, such as Applications, with meta-classes C1 and C2 as its domain and co-domain, respectively, to an impact analysis, then meta-classes C1 and C2 are automatically designated as sub-classes of the appropriate IA meta-class, such as DowntimeImpactItem. As such, a user does not have to set these sub-class designations manually. It is also noted in FIG. 9 that, for convenience of implementation and management, IA meta-classes are direct sub-classes of meta-class “Analyzable” 955.
  • [0094]
    Reference is now made to FIG. 10, which is an illustration of stepwise graphical navigation of a meta-model, in accordance with a preferred embodiment of the present invention. The screen shown in FIG. 10 enables a user to explore each node in a metamodel in a controlled way. By clicking on a “plus” sign for a node A, a user instructs the navigator to display all nodes that node A has an impact relation therewith, together with arrows that are labeled in accordance with the underlying meta-properties.
  • [0095]
    Shown in FIG. 10 is a computer server 1010 which runs applications 1020 and 1030, and hosts a web site 1040. In turn, application 1020 writes to a data source 1050 and application 1030 writes to a data source 1060. Further in turn, data source 1050 is used by web sites 1070 and 1080, and data source 1060 is used in transformation 1090. All of the indicated properties are preferably included within an “impacts” property and, as such, server 1010 directly impacts the three IT assets 1020, 1030 and 1040, and indirectly impacts the five IT assets 1050, 1060, 1070, 1080 and 1090. It may thus be appreciated that using the present invention, an IT administrator is able to determine the impact of shutting down server 1010 or application 1020, for example.
  • [0096]
    In contrast to the stepwise navigation illustrated in FIG. 10, reference is now made to FIG. 11, which is an illustration of a graphic display of the transitive closure of impacted nodes, in accordance with a preferred embodiment of the present invention. Shown in FIG. 11 is a list of classes impacted by a class “Cordoba15” 1105, which is an instance of a meta-class “Computer”. The list includes a class “Market Report” 1110 and a class “Market Watch (Premium)” 1115, which are instances of a meta-class “Web Site” 1120, a class “WebSphere Business Integration Event Broker 5.0” 1125 and a class “Active Reference” 1130 which are instances of a meta-class “Application Version” 1135, a class “FRX-SAKO” 1140 and a class “Market Stage” 1145, which are instances of a meta-class “Data Source” 1150, and a class “PBDEC to AMCS” 1155, which is an instance of a meta-class “Transformation” 1160. The list includes classes that are directly and indirectly impacted by Cordoba15.
  • [0097]
    When a user clicks on a specific item in the list, the chain of impact dependencies is displayed below. For example, the graphic display in FIG. 11 shows the dependency chain 1165 from Cordoba15 to Market Watch (Premium). Each of the arrows 1170, 1175 and 1180 correspond to a direct impact dependency.
  • [0098]
    It may be appreciated by those skilled in the art that, alternatively, binary relations “impacts” and “is impacted by” may correspond to relations other than the transitive closure of “impacts” and “is impacted by” characterizations. For example, they may correspond to a transitive closure up to a specified number of levels, so that indirect impact is restricted to, say, three levels.
  • [0099]
    It may also be appreciated that property inclusion may alternatively be implemented using descriptors to tag certain meta-properties as being impact-related. However, implementation using an Inclusion BR allows more generality, including (i) allowing different types of impact or be distinguished, and (ii) allowing inference to take advantage of the “impacts” property.
  • [0000]
    Data Lineage
  • [0100]
    A somewhat similar application to impact analysis is data lineage, which is a technique for finding sources of property values. For example, a user may want to know “for a property “productName”, which is part of an Entity “Product Parameters”, which is part of a Data Asset “ProductSearchUI” where does its value come from?”
  • [0101]
    In accordance with a preferred embodiment of the present invention, data lineage is described as if it were a four-way impact analysis, using two axes. A first axis, the “data flow axis”, indicates the flow of data using a property “Downstream Items” and a corresponding inverse property “Upstream Items”. A second axis, the “system composition axis”, indicates system components using a property “subUnits” and a corresponding inverse property “superUnits.” Reference is now made to FIG. 12, which is an illustration of a graphical user interface for viewing data lineage results arranged along the two above axes, in accordance with a preferred embodiment of the present invention. The results illustrated in FIG. 12 are evoked when a user selects the productName property and invokes data lineage analysis. The horizontal arrows depict the data flow axis and the vertical arrows depict the system composition axis.
  • [0102]
    Specifically, as seen in FIG. 12 from the vertical dependencies, “productName” 1210 is an attribute of a GenericEntity “Product Parameters” 1230, and Product Parameters 1230 is an asset from a DataAsset “ProductSearchUI” 1230. Moreover, as seen from the horizontal dependencies, productName 1210 is assigned a value based on a corresponding property “productName” 1240 of class “WsdlValuePart”. In turn, productName 1240 is part of a message “product Search Response” 1250. Moreover, productName 1240 is assigned a value from a Column “longName” 1260 of a relational database table “prod” 1270.
  • [0103]
    Reference is now made to FIG. 13, which is an illustration of a graphical user interface for marking meta-properties as being Downstream Items, Upstream Items, subunits or superUnits, in accordance with a preferred embodiment of the present invention. As shown in FIG. 13, a meta-property “copiedFrom” 1310, is designated as being included in Upstream Items 1320, and its inverse meta-property, “copiedTo” 1330 is included in Downstream Items 1340. Specifically, “copiedFrom” and “copiedTo” are meta-properties from meta-class WsdlValuePart to meta-class ValueElement.
  • [0104]
    In the foregoing specification, the invention has been described with reference to specific exemplary embodiments thereof. It will, however, be evident that various modifications and changes may be made to the specific exemplary embodiments without departing from the broader spirit and scope of the invention as set forth in the appended claims. Accordingly, the specification and drawings are to be regarded in an illustrative rather than a restrictive sense.
Patent Citations
Cited PatentFiling datePublication dateApplicantTitle
US5295242 *Nov 2, 1990Mar 15, 1994Consilium, Inc.Apparatus and method for viewing relationships in a factory management system
US5499371 *Mar 22, 1995Mar 12, 1996Persistence Software, Inc.Method and apparatus for automatic generation of object oriented code for mapping relational data to objects
US5627979 *Jul 18, 1994May 6, 1997International Business Machines CorporationSystem and method for providing a graphical user interface for mapping and accessing objects in data stores
US5710917 *Jun 7, 1995Jan 20, 1998International Business Machines CorporationMethod for deriving data mappings and data aliases
US5734887 *Sep 29, 1995Mar 31, 1998International Business Machines CorporationMethod and apparatus for logical data access to a physical relational database
US5768580 *May 31, 1995Jun 16, 1998Oracle CorporationMethods and apparatus for dynamic classification of discourse
US5838965 *Nov 10, 1994Nov 17, 1998Cadis, Inc.Object oriented database management system
US5857197 *Mar 20, 1997Jan 5, 1999Thought Inc.System and method for accessing data stores as objects
US5873093 *May 28, 1997Feb 16, 1999Next Software, Inc.Method and apparatus for mapping objects to a data source
US5905987 *Mar 19, 1997May 18, 1999Microsoft CorporationMethod, data structure, and computer program product for object state storage in a repository
US5937409 *Jul 25, 1997Aug 10, 1999Oracle CorporationIntegrating relational databases in an object oriented environment
US5970490 *Nov 4, 1997Oct 19, 1999Xerox CorporationIntegration platform for heterogeneous databases
US5995756 *Feb 14, 1997Nov 30, 1999Inprise CorporationSystem for internet-based delivery of computer applications
US6014666 *Oct 28, 1997Jan 11, 2000Microsoft CorporationDeclarative and programmatic access control of component-based server applications using roles
US6035342 *Mar 19, 1997Mar 7, 2000Microsoft CorporationMethod and computer program product for implementing object relationships
US6192365 *Jul 18, 1996Feb 20, 2001Novell, Inc.Transaction log management in a disconnectable computer and network
US6199059 *Apr 22, 1998Mar 6, 2001International Computex, Inc.System and method for classifying and retrieving information with virtual object hierarchy
US6219654 *Aug 30, 1999Apr 17, 2001International Business Machines CorporationMethod, system and program product for performing cost analysis of an information technology implementation
US6233586 *Apr 1, 1998May 15, 2001International Business Machines Corp.Federated searching of heterogeneous datastores using a federated query object
US6289338 *Dec 1, 1999Sep 11, 2001Manning & Napier Information ServicesDatabase analysis using a probabilistic ontology
US6292804 *Dec 13, 1999Sep 18, 2001Intergraph CorporationObject relationship management system
US6301584 *Aug 21, 1998Oct 9, 2001Home Information Services, Inc.System and method for retrieving entities and integrating data
US6311194 *Aug 21, 2000Oct 30, 2001Taalee, Inc.System and method for creating a semantic web and its applications in browsing, searching, profiling, personalization and advertising
US6327593 *Dec 23, 1998Dec 4, 2001Unisys CorporationAutomated system and method for capturing and managing user knowledge within a search system
US6343265 *Jul 28, 1998Jan 29, 2002International Business Machines CorporationSystem and method for mapping a design model to a common repository with context preservation
US6374252 *Oct 16, 1997Apr 16, 2002I2 Technologies Us, Inc.Modeling of object-oriented database structures, translation to relational database structures, and dynamic searches thereon
US6397232 *Aug 23, 2001May 28, 2002Acer Inc.Method and system for translating the format of the content of document file
US6424973 *Jul 23, 1999Jul 23, 2002Jarg CorporationSearch system and method based on multiple ontologies
US6424974 *Sep 12, 1997Jul 23, 2002International Business Machines CorporationStoring P-code in a database
US6497943 *Feb 14, 2000Dec 24, 2002International Business Machines CorporationSurface metal balancing to reduce chip carrier flexing
US6498795 *May 28, 1999Dec 24, 2002Nec Usa Inc.Method and apparatus for active information discovery and retrieval
US6513059 *Aug 24, 2000Jan 28, 2003Cambira CorporationAdaptive collaborative intelligent network system
US6526416 *Jun 30, 1998Feb 25, 2003Microsoft CorporationCompensating resource managers
US6532471 *Dec 11, 2000Mar 11, 2003International Business Machines CorporationInterface repository browser and editor
US6560595 *Nov 15, 1999May 6, 2003Novell, Inc.Operator for correlated predicates in a query
US6578046 *Jun 5, 2001Jun 10, 2003International Business Machines CorporationFederated searches of heterogeneous datastores using a federated datastore object
US6591272 *Feb 22, 2000Jul 8, 2003Tricoron Networks, Inc.Method and apparatus to make and transmit objects from a database on a server computer to a client computer
US6633869 *Apr 28, 2000Oct 14, 2003Intergraph CorporationManaging object relationships using an object repository
US6633878 *Jul 30, 1999Oct 14, 2003Accenture LlpInitializing an ecommerce database framework
US6640231 *Oct 6, 2000Oct 28, 2003Ontology Works, Inc.Ontology for database design and application development
US6651244 *Jul 26, 1999Nov 18, 2003Cisco Technology, Inc.System and method for determining program complexity
US6687873 *Mar 9, 2000Feb 3, 2004Electronic Data Systems CorporationMethod and system for reporting XML data from a legacy computer system
US6704744 *Sep 18, 2000Mar 9, 2004Next Computer, Inc.Method and apparatus for mapping objects to multiple tables of a database
US6711579 *Apr 20, 2001Mar 23, 2004Sree Ayyanar Spinning And Weaving Mills LimitedData storage schema independent programming for data retrieval using semantic bridge
US6711585 *Jun 15, 2000Mar 23, 2004Kanisa Inc.System and method for implementing a knowledge management system
US6718320 *Oct 4, 1999Apr 6, 2004International Business Machines CorporationSchema mapping system and method
US6728692 *Dec 23, 1999Apr 27, 2004Hewlett-Packard CompanyApparatus for a multi-modal ontology engine
US6742054 *Apr 7, 2000May 25, 2004Vitria Technology, Inc.Method of executing a data transformation specification
US6772031 *May 30, 2000Aug 3, 2004International Business Machines CorporationMethod of, system for, and computer program product for providing a job monitor
US6778990 *Jul 27, 2001Aug 17, 2004Hewlett-Packard Development Company, L.P.Dynamic component activation method using a relational database as the repository for registration information
US6792580 *Jan 31, 2002Sep 14, 2004Kabushiki Kaisha ToshibaMethod and computer program product for software/hardware language model conversion
US6871204 *Sep 6, 2001Mar 22, 2005Oracle International CorporationApparatus and method for mapping relational data and metadata to XML
US6874146 *Jun 30, 1999Mar 29, 2005Unisys CorporationMetadata driven system for effecting extensible data interchange based on universal modeling language (UML), meta object facility (MOF) and extensible markup language (XML) standards
US6892238 *Mar 13, 2002May 10, 2005International Business Machines CorporationAggregating and analyzing information about content requested in an e-commerce web environment to determine conversion rates
US6957214 *Jun 22, 2001Oct 18, 2005The Johns Hopkins UniversityArchitecture for distributed database information access
US6978257 *Jan 31, 2000Dec 20, 2005International Business Machines CorporationSystem and method for measuring and pricing midrange computer server outsourcing services
US6999956 *Nov 15, 2001Feb 14, 2006Ward MullinsDynamic object-driven database manipulation and mapping system
US7024425 *Sep 6, 2001Apr 4, 2006Oracle International CorporationMethod and apparatus for flexible storage and uniform manipulation of XML data in a relational database system
US7027974 *Oct 27, 2000Apr 11, 2006Science Applications International CorporationOntology-based parser for natural language processing
US7096224 *Sep 27, 2002Aug 22, 2006Oracle International CorporationMechanism for mapping XML schemas to object-relational database systems
US7111297 *May 2, 2000Sep 19, 2006Microsoft CorporationMethods and architectures for resource management
US7200563 *Aug 18, 2000Apr 3, 2007Acl International Inc.Ontology-driven information system
US7254589 *May 21, 2004Aug 7, 2007International Business Machines CorporationApparatus and method for managing and inferencing contextural relationships accessed by the context engine to answer queries received from the application program interface, wherein ontology manager is operationally coupled with a working memory
US7278164 *Jan 5, 2001Oct 2, 2007Revit Technology CorporationSoftware usage/procurement management
US7302410 *Dec 22, 2000Nov 27, 2007Demandtec, Inc.Econometric optimization engine
US7315849 *Dec 9, 2002Jan 1, 2008Hyperroll Israel, Ltd.Enterprise-wide data-warehouse with integrated data aggregation engine
US7475084 *May 20, 2005Jan 6, 2009International Business Machines CorporationData query and location through a central ontology model
US20020059183 *Sep 24, 2001May 16, 2002Li-Wen ChenMethod and system for managing event attributes
US20020059187 *Oct 16, 2001May 16, 2002Microsoft CorporationInternal database validation
US20020099738 *Nov 21, 2001Jul 25, 2002Grant Hugh AlexanderAutomated web access for back-end enterprise systems
US20020107844 *May 8, 2001Aug 8, 2002Keon-Hoe ChaInformation generation and retrieval method based on standardized format of sentence structure and semantic structure and system using the same
US20020169842 *Apr 1, 2002Nov 14, 2002Centegy CorporationMethod and system for facilitating the integration of a plurality of dissimilar systems
US20020194154 *May 13, 2002Dec 19, 2002Levy Joshua LernerSystems, methods and computer program products for integrating biological/chemical databases using aliases
US20030018616 *May 23, 2002Jan 23, 2003Wilbanks John ThompsonSystems, methods and computer program products for integrating databases to create an ontology network
US20030036917 *Apr 25, 2002Feb 20, 2003Metallect CorporationService provision system and method
US20030050932 *Sep 4, 2001Mar 13, 2003Pace Charles P.System and method for transactional deployment of J2EE web components, enterprise java bean components, and application data over multi-tiered computer networks
US20030101170 *May 31, 2002May 29, 2003Joseph EdelsteinData query and location through a central ontology model
US20030110055 *Apr 10, 2001Jun 12, 2003Chau Bang ThinhElectronic catalogue
US20030120665 *Mar 22, 2002Jun 26, 2003Joshua FoxRun-time architecture for enterprise integration with transformation generation
US20030163597 *May 25, 2001Aug 28, 2003Hellman Ziv ZalmanMethod and system for collaborative ontology modeling
US20030167445 *Mar 4, 2002Sep 4, 2003Hong SuMethod and system of document transformation between a source extensible markup language (XML) schema and a target XML schema
US20030172368 *Dec 23, 2002Sep 11, 2003Elizabeth AlumbaughSystem and method for autonomously generating heterogeneous data source interoperability bridges based on semantic modeling derived from self adapting ontology
US20030191608 *Apr 30, 2002Oct 9, 2003Anderson Mark StephenData processing and observation system
US20030233224 *Feb 19, 2003Dec 18, 2003Insightful CorporationMethod and system for enhanced data searching
US20040010491 *Mar 13, 2003Jan 15, 2004Markus RiedingerUser interface framework
US20040054690 *Mar 10, 2003Mar 18, 2004Hillerbrand Eric T.Modeling and using computer resources over a heterogeneous distributed network using semantic ontologies
US20040093344 *Aug 8, 2003May 13, 2004Ben BergerMethod and system for mapping enterprise data assets to a semantic information model
US20040117346 *Sep 19, 2003Jun 17, 2004Kilian StoffelComputer-based method and apparatus for repurposing an ontology
US20040220893 *Nov 20, 2003Nov 4, 2004Radar Networks, Inc.User interface for managing semantic objects
US20050060371 *Sep 15, 2003Mar 17, 2005Cohen Mitchell A.Method and system for providing a common collaboration framework accessible from within multiple applications
US20050080656 *Oct 10, 2003Apr 14, 2005Unicru, Inc.Conceptualization of job candidate information
US20050138173 *Jun 16, 2004Jun 23, 2005Ha Young G.Ontology-based service discovery system and method for ad hoc networks
US20050197926 *Apr 6, 2005Sep 8, 2005I2 Technologies Us, Inc.System and method for identifying a product
US20050251533 *Mar 16, 2005Nov 10, 2005Ascential Software CorporationMigrating data integration processes through use of externalized metadata representations
US20050267871 *Dec 13, 2004Dec 1, 2005Insightful CorporationMethod and system for extending keyword searching to syntactically and semantically annotated data
US20060218177 *Mar 25, 2005Sep 28, 2006Yuan-Chi ChangSystem and method for storing and retrieving data through an inferencing-enabled metadata system
US20070038500 *Oct 20, 2006Feb 15, 2007ACL International, Inc.,Ontology-driven information system
US20080140549 *Aug 21, 2003Jun 12, 2008Jeff Scott EderAutomated method of and system for identifying, measuring and enhancing categories of value for a value chain
US20090077051 *Oct 17, 2008Mar 19, 2009International Business Machines CorporationData Query and Location Through a Central Ontology Model
Referenced by
Citing PatentFiling datePublication dateApplicantTitle
US7343377 *Jul 7, 2003Mar 11, 2008Unisys CorporationMethod and system for verifying the integrity of a database
US7451403 *Dec 19, 2003Nov 11, 2008Rage Frameworks, Inc.System and method for developing user interfaces purely by modeling as meta data in software application
US7533103 *Dec 23, 2003May 12, 2009Sap AgSelf-describing business objects
US7640261Jun 16, 2006Dec 29, 2009Business Objects Software Ltd.Apparatus and method for processing data corresponding to multiple COBOL data record schemas
US7987159Sep 15, 2006Jul 26, 2011Microsoft CorporationDetecting and managing changes in business data integration solutions
US8108483 *Jan 30, 2004Jan 31, 2012Microsoft CorporationSystem and method for generating a consistent user namespace on networked devices
US8135757Jun 10, 2009Mar 13, 2012International Business Machines CorporationGenerating references to reusable code in a schema
US8190562 *Oct 31, 2007May 29, 2012Microsoft CorporationLinking framework for information technology management
US8412746Dec 29, 2004Apr 2, 2013International Business Machines CorporationMethod and system for federated querying of data sources
US8548938Mar 15, 2012Oct 1, 2013International Business Machines CorporationBusiness rules for configurable metamodels and enterprise impact analysis
US8656374Jun 16, 2006Feb 18, 2014Business Objects Software Ltd.Processing cobol data record schemas having disparate formats
US8666960Jun 26, 2008Mar 4, 2014Microsoft CorporationSchema-based data transfer between a data-based application and a document application
US8719770 *Sep 9, 2010May 6, 2014International Business Machines CorporationVerifying programming artifacts generated from ontology artifacts or models
US8756258Jan 24, 2012Jun 17, 2014International Business Machines CorporationGenerating references to reusable code in a schema
US8826225 *Oct 21, 2008Sep 2, 2014Accenture Global Services LimitedModel transformation unit
US8826232Sep 29, 2009Sep 2, 2014International Business Machines CorporationMetamodeling contextual navigation of computer software applications
US8843896Mar 12, 2013Sep 23, 2014International Business Machines CorporationMetamodeling contextual navigation of computer software applications
US9098538 *Sep 30, 2011Aug 4, 2015Teradata Us, Inc.Master data management versioning
US9239854Jun 10, 2013Jan 19, 2016Sas Institute Inc.Multi-domain impact analysis using object relationships
US9286368May 8, 2012Mar 15, 2016Microsoft Technology Licensing, LlcLinking framework for information technology management
US9372669 *Nov 25, 2014Jun 21, 2016International Business Machines CorporationMultiple architecture viewpoints in single unified modeling language (UML) model
US20050021537 *Dec 23, 2003Jan 27, 2005Rainer BrendleSelf-describing business objects
US20050022160 *Apr 30, 2004Jan 27, 2005Adaptik CorporationMethod and apparatus for creating an adaptive application
US20050198385 *Jan 30, 2004Sep 8, 2005Aust Brian S.System and method for generating a consistent user name-space on networked devices
US20070032855 *Oct 10, 2006Feb 8, 2007Advanced Stent Technologies, Inc.Extendible stent apparatus
US20070106797 *Aug 31, 2006May 10, 2007Nortel Networks LimitedMission goal statement to policy statement translation
US20070294246 *Jun 16, 2006Dec 20, 2007Microsoft CorporationAssociating metadata on a per-user basis
US20070294267 *Jun 16, 2006Dec 20, 2007Business Objects, S.A.Apparatus and method for processing of COBOL nested data record schemas
US20070294677 *Jun 16, 2006Dec 20, 2007Business Objects, S.A.Apparatus and method for processing cobol data record schemas having disparate formats
US20080133594 *Dec 1, 2006Jun 5, 2008Goldman, Sachs & Co.Application Directory
US20080189265 *Feb 6, 2007Aug 7, 2008Microsoft CorporationTechniques to manage vocabulary terms for a taxonomy system
US20090030880 *Jul 27, 2007Jan 29, 2009Boris MelamedModel-Based Analysis
US20090037360 *Aug 1, 2007Feb 5, 2009International Business Machines CorporationAuto-Triggered Incremental Execution of Object Business Rules in Database Applications
US20090112939 *Oct 31, 2007Apr 30, 2009Microsoft CorporationLinking framework for information technology management
US20090327343 *Jun 26, 2008Dec 31, 2009Microsoft CorporationSchema-based data transfer between a data-based application and a document application
US20100274823 *Apr 23, 2009Oct 28, 2010Sailesh SathishMethod, apparatus and computer program product for providing an adaptive context model framework
US20100318574 *Jun 10, 2009Dec 16, 2010International Business Machines CorporationGenerating references to reusable code in a schema
US20110078660 *Sep 29, 2009Mar 31, 2011International Business Machines CorporationMetamodeling Contextual Navigation of Computer Software Applications
US20120042299 *Oct 21, 2008Feb 16, 2012Oswald PerrinModel transformation unit
US20120066661 *Sep 9, 2010Mar 15, 2012International Business Machines CorporationVerifying programming artifacts generated from ontology artifacts or models
US20120084257 *Sep 30, 2011Apr 5, 2012Teradata Us, Inc.Master data management versioning
US20130332423 *Jun 12, 2012Dec 12, 2013Accenture Global Services LimitedData lineage tracking
US20150082272 *Nov 25, 2014Mar 19, 2015International Business Machines CorporationMultiple Architecture Viewpoints In Single Unified Modeling Language (UML) Model
US20150082291 *Jan 9, 2014Mar 19, 2015Microsoft CorporationUpdate installer with technical impact analysis
US20150187103 *Dec 26, 2013Jul 2, 2015International Business Machines CorporationObscured relationship data within a graph
US20150187104 *Jun 5, 2014Jul 2, 2015International Business Machines CorporationObscured relationship data within a graph
WO2010122420A1 *Apr 23, 2010Oct 28, 2010Nokia CorporationMethod, apparatus and computer program product for providing an adaptive context model framework
WO2012057382A1 *Oct 29, 2010May 3, 2012Korea Institute Of Science And Technology InformationOntology-based method for managing the integration of metadata
Classifications
U.S. Classification717/100, 707/999.101
International ClassificationG06F9/44
Cooperative ClassificationG06F17/30557
European ClassificationG06F17/30S
Legal Events
DateCodeEventDescription
Dec 7, 2005ASAssignment
Owner name: UNICORN SOLUTIONS, INC., NEW YORK
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:AMARU, RUTH M.;FOX, JOSHUA;HALBERSTADT, BENJAMIN;AND OTHERS;REEL/FRAME:017100/0252;SIGNING DATES FROM 20051031 TO 20051109
Jul 27, 2006ASAssignment
Owner name: 2006 TRIDENT COMPANY, MASSACHUSETTS
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:UNICORN SOLUTIONS, INC.;REEL/FRAME:018012/0908
Effective date: 20060505
Owner name: 2006 TRIDENT COMPANY,MASSACHUSETTS
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:UNICORN SOLUTIONS, INC.;REEL/FRAME:018012/0908
Effective date: 20060505
Dec 14, 2006ASAssignment
Owner name: INTERNATIONAL BUSINESS MACHINES CORPORATION, NEW Y
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:2006 TRIDENT COMPANY, INC.;REEL/FRAME:018627/0913
Effective date: 20061117
Owner name: INTERNATIONAL BUSINESS MACHINES CORPORATION,NEW YO
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:2006 TRIDENT COMPANY, INC.;REEL/FRAME:018627/0913
Effective date: 20061117