Method and apparatus for functional integration of metadata

a functional integration and metadata technology, applied in relational databases, database models, instruments, etc., can solve problems such as failure to achieve transformation with transaction tables such as orders and payments, failure to achieve data functional integration, and failure of federated databases to reconstruct conceptual entities

Inactive Publication Date: 2014-08-12
INT BUSINESS MASCH CORP
View PDF54 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This leads to the multiplicity of definitions of business entities, which creates problems in data integration endeavors, particular in those directly concerned with information access and analysis.
Although the federated database approach accomplishes the structural integration of data, it fails in the functional integration of data.
However, the federated database fails to reconstruct the conceptual entities.
Further, the federated approach does not deal with the metadata of non-relational data schemas.
However, such transformation cannot be accomplished with transaction tables such as Orders and Payments.
This requirement is impractical for business users to learn the intricacies of the databases.
Thus, data integration projects require architects to acquire perfect knowledge of databases involved, which is a costly, time consuming, and impractical process.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0018]As will be appreciated by one skilled in the art, aspects of the present invention may be embodied as a system, method or computer program product. Accordingly, aspects of the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment (including firmware, resident software, micro-code, etc.) or an embodiment combining software and hardware aspects that may all generally be referred to herein as a “circuit,”“module” or “system.” Furthermore, aspects of the present invention may take the form of a computer program product embodied in one or more computer readable medium(s) having computer readable program code embodied thereon.

[0019]Any combination of one or more computer readable medium(s) may be utilized. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagne...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

A computer implemented method for functional integration of metadata for a plurality of databases, includes: creating a single set of classes and instances for the classes for metadata of at least one relational data schema and at least one non-relational data schema for the plurality of databases; defining semantic relationships between the instances based on the structural information in the relational data schema and the non-relational data schema for the plurality of databases; associating the semantic relationships with a property class; creating a single set of triples for the semantic relationships between the instances; storing the single set of triples in a file; and using the set of triples stored in the file to navigate between the plurality of databases to formulate a response to a query.

Description

CROSS-REFERENCE TO RELATED APPLICATIONS[0001]The present application is a continuation-in-part of co-pending U.S. patent application Ser. No. 12 / 179,903, filed on Jul. 25, 2008.BACKGROUND[0002]Multiple data models, and the consequent databases, allow business processes to be automated through both custom-built applications and commercial off-the-shelf software package-built applications. Each data model rests upon its own domain of attributes, defined by data schemas. Often, the same business entities exist concurrently in several data schemas, with a combination of database schemas for relational databases and non-relational databases, such as Cubes, Reports, Dashboards, and Scorecards. Often, the attributes defined by the data schemas are differently named, data-typed and constraint-typed. This leads to the multiplicity of definitions of business entities, which creates problems in data integration endeavors, particular in those directly concerned with information access and analy...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & AuthorityPatents(United States)
IPC IPC(8): G06F7/00G06F17/30
CPCG06F17/30604
InventorMOHAN, MUKUND
OwnerINT BUSINESS MASCH CORP