Patents
Literature
Hiro is an intelligent assistant for R&D personnel, combined with Patent DNA, to facilitate innovative research.
Hiro

63 results about "Source schema" patented technology

A source schema defines the structure of the instance messages from which you are taking data. The destination schema defines the structure of the instance messages the map produces. For example, if you want to map the shipping and billing information from a purchase order to an invoice,...

Data transformation system, graphical mapping tool, and method for creating a schema map

Graphical mapping interface embodiments and method are provided for creating and displaying a schema map, which may be used by a data transformation system to perform a data transformation between at least one source schema and at least one target schema. According to one embodiment, the graphical mapping interface may comprise a source schema region for displaying a graphical representation of at least one source schema, a target schema region for displaying a graphical representation of at least one target schema, and a mapping region for displaying graphical representations of a plurality of links connecting the source nodes displayed in the source schema region to the target nodes displayed in the target schema region. The plurality of links may comprise at least one control link having at least one ECA rule associated therewith and at least one data link having at least one textual-based target field expression associated therewith.
Owner:ACTIAN CORP

Method of compiling schema mapping

A method for compiling a mapping between a source schema and a target schema is provided. The method comprises multiple passes, including determining source node dependencies, matching hierarchy, and generating code. The method may further comprise initializing node dependency memory prior to determining source node dependencies, and freeing node dependency memory after code generation. The compiler algorithm provides for compiling user-defined functions in the mapping into the compiled representation. Another aspect of the invention provides for generating an XSL code representation of the mapping. An XSL style sheet representation may thus be generated from a visual mapping in accordance with the invention.
Owner:MICROSOFT TECH LICENSING LLC

System and method for asynchronous wireless services using reverse service schema generation

A notification service and correspondingly configured wireless device for providing asynchronous communications over a communication network for an application of the wireless device in communication with a selected service. The selected service has a source schema definition including an output notification definition associated with a correlation ID. The notification service comprises a reverse schema definition of the source schema definition such that the reverse schema definition includes an input notification operation definition corresponding to the output notification definition. The input definition is associated with the correlation ID and a parameter list of the output definition. The output definition is for defining an output message of the selected source that corresponds to an input message of the notification service defined by the input definition. The notification service has a first communication port adapted for receiving the output message of the selected service as the input message to the notification service, wherein the messages are adapted to include the correlation ID for identifying the network address of the wireless device. The information contents of the output message of the selected source are transmitted as an asynchronous communication to the application of the wireless device identified by the correlation ID.
Owner:GOOGLE TECH HLDG LLC

Automatic composition of services through semantic attribute matching

A method of automatically matching schemas begins by extracting schemas from sources and targets. Then, source and target attributes are extracted from the schemas. Each source schema will have multiple source attributes and each target schema will also have multiple target attributes. The source attributes and the target attributes are presented as nodes in a bipartite graph. This bipartite graph has edges between nodes that are related to each other. A plurality of similarity scores are defined between each set of related nodes. Each of the similarity scores is based on a different context-specific cue of the attributes that the nodes represent. These context-specific cues can comprise lexical name, semantic name, type, structure, functional mappings, etc. An overall weight is computed for each edge in the bipartite graph by combining the similarity scores of each set of nodes that form an edge. In addition, an optimal matching of the schemas is assembled, so as to indicate the level of similarity between each of the source and target schemas. The optimal matching selects pairs of nodes between source and target schemas that maximizes the number of nodes matched as well as the overall score of match for the nodes selected.
Owner:SERVICENOW INC

Methods and apparatus for mapping source schemas to a target schema using schema embedding

Methods and apparatus are provided for mapping XML source documents to target documents using schema embeddings. According to one aspect of the invention, one or more edges in the one or more source schemas are mapped to one or more paths in at least one target schema. The disclosed mapping techniques ensure that (i) one or more source documents that conform to one or more of the source schemas can be recovered from one or more target documents that conform to the at least one target schema, if a mapping exists between the one or more of the source schemas and the at least one target schema; (ii) queries on one or more source documents that conform to one or more of the source schemas in a given query language can be answered on one or more target documents that conform to the at least one target schema; and (iii) the one or more target documents conform to a target schema.
Owner:WSOU INVESTMENTS LLC

Schema evolution of complex objects

Schema conversion approaches convert images of complex objects. The schema conversion is performed on images of complex objects belonging to a root class, whether those objects are instances of the root class or instances of a subclass of the root class. A complex object is an object that is comprised of a collection of objects or that has another object as an attribute. The approaches use change vectors to represent changes to make to an image to convert it between the target schema version and source schema version. Change vectors are generated based on schema version records, each of which describes the properties of a schema version, including the attributes in the schema version and the data type of each of the attributes. The approaches evolve changes that includes addition, modification and deletion of object attributes. They convert from an earlier schema version to a later schema version, and vice versa, i.e. from a later schema version to a earlier schema version.
Owner:ORACLE INT CORP

Generating extract, transform, and load (ETL) jobs for loading data incrementally

InactiveUS20110055147A1Digital data processing detailsMultiprogramming arrangementsAbstraction operatorOperator model
Systems, methods and articles of manufacture are disclosed for generating an incremental ETL job from an instance of an abstract ETL operator model representing an exhaustive ETL job for loading data from a source schema to a target schema. In one embodiment, the abstract operator model may be extended to include incremental variants of operators of the abstract ETL operator model. From the instance of the abstract ETL operator model and from the extended ETL operator model, a corresponding instance of the extended ETL operator model may be generated. An incremental ETL job may be deployed from the instance of the extended ETL operator model. The incremental ETL job may be executed to load data from the source schema to the target schema.
Owner:IBM CORP

Data transformation system, graphical mapping tool, and method for creating a schema map

Graphical mapping interface embodiments and method are provided for creating and displaying a schema map, which may be used by a data transformation system to perform a data transformation between at least one source schema and at least one target schema. According to one embodiment, the graphical mapping interface may comprise a source schema region for displaying a graphical representation of at least one source schema, a target schema region for displaying a graphical representation of at least one target schema, and a mapping region for displaying graphical representations of a plurality of links connecting the source nodes displayed in the source schema region to the target nodes displayed in the target schema region. The plurality of links may comprise at least one control link having at least one ECA rule associated therewith and at least one data link having at least one textual-based target field expression associated therewith.
Owner:ACTIAN CORP

Dynamic data discovery of a source data schema and mapping to a target data schema

A computerized method, program product, and a service that discovers trace data inserted into a source database having an unknown schema. Once the trace data is found by a dynamic data discovery engine, the tables, the fields, and the attributes of the fields in the source schema in which the trace data were located can be evaluated to determine if the data in the fields are pertinent to a target database. If so, then the data in those fields can be mapped and transferred to a target database. The dynamic data discovery engine generates the commands in both the source and the target database command language to find all pertinent data, map and transfer the data from the source database to a target database. The dynamic data discovery engine generates commands to create the target database and / or fields within an existing target database for the mapped and transferred data.
Owner:IBM CORP

System and method for schema matching

A system and method for matching one or more source schemas with one or more target schemas is provided. The matching between source and target schemas is performed by gathering inputs pertaining to the source and target schemas, wherein the inputs comprises a set of details in a predefined format. Thereafter, the gathered inputs are processed by comparing the source schemas with the target schemas. The processing is performed to identify a set of matches between the source and target schemas based on the linguistic similarity, structural similarity and functional similarity and relationship between the source and target schemas. Subsequently, the identified matches are stored.
Owner:INFOSYS LTD

Constraint-based XML query rewriting for data integration

A system and method for data integration by querying multiple extensible markup language (XML) source schemas through a common XML target schema, wherein the system comprises XML mapping connections between the XML source schemas and the XML target schema, wherein the XML mapping connections accommodate XML mappings, the XML source schemas comprise data, and the XML target schema comprise a set of constraints, which comprise data merging rules for integrating the data from multiple source schemas comprising overlapping information; a target query associated with the target schema; and a query rewriter adapted to reformulate the target query in terms of the source schemas based on the mappings, and to integrate the data based on the set of constraints. The query rewriter is adapted to rewrite the target query into a set of source queries comprising the source schemas. A processor evaluates a union of the set of source queries.
Owner:SAP AG

Method of compiling schema mapping

A method for compiling a mapping between a source schema and a target schema is provided. The method comprises multiple passes, including determining source node dependencies, matching hierarchy, and generating code. The method may further comprise initializing node dependency memory prior to determining source node dependencies, and freeing node dependency memory after code generation. The compiler algorithm provides for compiling user-defined functions in the mapping into the compiled representation. Another aspect of the invention provides for generating an XSL code representation of the mapping. An XSL style sheet representation may thus be generated from a visual mapping in accordance with the invention.
Owner:MICROSOFT TECH LICENSING LLC

Interactive generation of integrated schemas

Methods, systems and computer program products for interactive generation of integrated schemas. Exemplary embodiments include a method for schema integration, the method including recasting a first source schema into a first graph of concepts with HasA relationships, recasting a second source schema into a second graph of concepts with HasA relationships, identifying matching concepts in the first graph and the second graph based on correspondences between attributes of the concepts of the first and second graphs, producing an integrated schema, based on a fixed specification of matching concepts to merge, and generating a mapping from the first source schema to the integrated schema and from the second source schema to the integrated schema.
Owner:IBM CORP

OLE DB data access system with schema modification features

Mapping of data source schema data types relating a server side database description into a set of OLE DB data types is rendered subject to user modification by provision of a dual Schema File at a client side terminal which contains an original copy and a modifiable copy of the data source schema. Selected contents of the modifiable Schema File are then displayed in a split window format, including one window which provides a tree view of the schema structure and an adjacent window which displays a set of values related to a selected element of the tree view. Selected values are then subject to modification via user point and click and data entry operations.
Owner:UNISYS CORP

Method and apparatus for mapping objects to multiple tables of a database

The present invention creates a model that maps object classes in an object-oriented environment to a data source. The model maps the relationship between properties of each object class and data of the data source. The present invention can be used with a data source such as a relational database, user interface, file system, or object-oriented database. An application's object classes and data source schema are designed independent of the other since the model can be used to map one to the other. The model is comprised of entities and attributes. An entity maps to an object class and to at least one table of the DBMS. An entity contains attributes either simple or derived. A simple attribute maps to a DBMS column. A derived attribute is a combination of other attributes and does not directly map to a DBMS column. A relationship creates a link between entities of the model. A relationship can be used to flatten an attribute or flatten a relationship. A flattened attribute is an attribute of one entity that is added to another entity. A flattened relationship is created by the elimination of intermediate relationships between two entities. Relationships can be either unidirectional or bi-directional. A unidirectional relationship has a single traversal path that has a source entity and a destination. A bi-directional relationship has two traversal paths. A reflexive relationship can be created using a single entity. The model is used to synchronize object properties and the data of the data source.
Owner:NEXT

System, service, and method for automatically discovering universal data objects

A universal data object discovery system automatically identifies candidate universal data objects, ranks the candidate universal data objects according to predetermined criteria, and merges source schemas into unified universal data objects within a set of data sources. From data inputs and a set of control parameters, the system computes a degree of sharing score for composite structures in the source schemas. The data inputs comprise source schemas, similarity values for data structures, and foreign key relationships. The system identifies as candidate universal data objects those structures whose degree of sharing score exceeds a threshold. The system calculates a similarity between candidate universal data objects and merges candidate universal data objects that are similar. The merged universal data objects are the output of the system.
Owner:IBM CORP

Method for implementing automatic database schema matching

The invention discloses a method for realizing automatic matching of database schemas, which comprises the four steps of schema information analysis, schema information classification, schema information integration and calculation of the similarity of schema elements, wherein the step of schema information analysis is used for realizing the analysis of element information of formatted source schemas and target schemas; the step of schema information classification is used for classifying schema element information analyzed in the schema information analysis stage and classifying all the elements according to the name, the description and the type respectively; the step of schema information integration is used for integrating classified results of schema information classification and element structure information and establishing weighted fuzzy concept lattices; and the step of calculation of the similarity of the schema elements is used for calculating the matching degree of the schema elements according to the weighted fuzzy concept lattices and setting a threshold to determine the matching relation between the elements. The method for realizing automatic matching of the database schemas solves the problems of schema matching in actual application, improves the efficiency of computers when solving the problem of schema matching, and reduces the waste of CPU resources.
Owner:SOUTHEAST UNIV

Methods and Systems for Developing a Data Repository for Heterogeneous MLS Systems

Systems and methods for developing a data repository containing property listing information automatically acquired from a plurality of multiple listing services (MLSs). The property listing information from various MLSs can be mapped to a common representation and stored in the data repository. The invention utilizes and transforms information from different source MLSs which may have a particular data schema that may or may not match a predetermined common schema for the data repository. The listing information is thus consolidated from MLSs even when their schema may be different from each another or the predetermined data repository schema. The data repository schema may be selected such that each of the fields that comprise the source MLS property listing information in its native schema (and all its elements including but not limited to, agent rosters, office rosters, and tax data) can be mapped from the source schema to the data repository schema (the destination). Accordingly, the data of the source property listing from various MLSs can be preserved. Possible mappings include one-to-one, one-to-many, many-to-one and others. For certain applications of the invention, mappings may be direct where the listing information data from an MLS is simply copied as is, or it can undergo a data transformation process that is based on a predetermined set of listing field mapping rules.
Owner:MLSLISTINGS

System and method for asynchronous wireless services using reverse service schema generation

A notification service and correspondingly configured wireless device for providing asynchronous communications over a communication network for an application of the wireless device in communication with a selected service. The selected service has a source schema definition including an output notification definition associated with a correlation ID. The notification service comprises a reverse schema definition of the source schema definition such that the reverse schema definition includes an input notification operation definition corresponding to the output notification definition. The input definition is associated with the correlation ID and a parameter list of the output definition. The output definition is for defining an output message of the selected source that corresponds to an input message of the notification service defined by the input definition. The notification service has a first communication port adapted for receiving the output message of the selected service as the input message to the notification service, wherein the messages are adapted to include the correlation ID for identifying the network address of the wireless device. The information contents of the output message of the selected source are transmitted as an asynchronous communication to the application of the wireless device identified by the correlation ID.
Owner:GOOGLE TECHNOLOGY HOLDINGS LLC

Method and apparatus for mapping objects to multiple tables of a database

The present invention creates a model that maps object classes in an object-oriented environment to a data source. The model maps the relationship between properties of each object class and data of the data source. The present invention can be used with a data source such as a relational database, user interface, file system, or object-oriented database. An application's object classes and data source schema are designed independent of the other since the model can be used to map one to the other. The model is comprised of entities and attributes. An entity maps to an object class and to at least one table of the DBMS. An entity contains attributes either simple or derived. A simple attribute maps to a DBMS column. A derived attribute is a combination of other attributes and does not directly map to a DBMS column. A relationship creates a link between entities of the model. A relationship can be used to flatten an attribute or flatten a relationship. A flattened attribute is an attribute of one entity that is added to another entity. A flattened relationship is created by the elimination of intermediate relationships between two entities. Relationships can be either unidirectional or bi-directional. A unidirectional relationship has a single traversal path that has a source entity and a destination. A bi-directional relationship has two traversal paths. A reflexive relationship can be created using a single entity. The model is used to synchronize object properties and the data of the data source.
Owner:APPLE INC

Automatic composition of services through semantic attribute matching

A method of automatically matching schemas begins by extracting schemas from sources and targets. Then, source and target attributes are extracted from the schemas. Each source schema will have multiple source attributes and each target schema will also have multiple target attributes. The source attributes and the target attributes are presented as nodes in a bipartite graph. This bipartite graph has edges between nodes that are related to each other. A plurality of similarity scores are defined between each set of related nodes. Each of the similarity scores is based on a different context-specific cue of the attributes that the nodes represent. These context-specific cues can comprise lexical name, semantic name, type, structure, functional mappings, etc. An overall weight is computed for each edge in the bipartite graph by combining the similarity scores of each set of nodes that form an edge.
Owner:SERVICENOW INC

Data processing method and apparatus employing OLE DB and having dual schema and auto update features

Mapping of data source schema data types relating a server side database description into a set of OLE DB data types is rendered subject to user modification by provision of a dual Schema File at a client side terminal which contains an original unmodifiable copy and a modifiable working copy of the data source schema. When the server side database description is altered, user modifications to the modifiable copy are preserved as much as possible by performing a matching process on the client side in the course of generating new unmodifiable and modifiable schema files which comprise a new dual Schema File.
Owner:UNISYS CORP

Generating extract, transform, and load (ETL) jobs for loading data incrementally

Systems, methods and articles of manufacture are disclosed for generating an incremental ETL job from an instance of an abstract ETL operator model representing an exhaustive ETL job for loading data from a source schema to a target schema. In one embodiment, the abstract operator model may be extended to include incremental variants of operators of the abstract ETL operator model. From the instance of the abstract ETL operator model and from the extended ETL operator model, a corresponding instance of the extended ETL operator model may be generated. An incremental ETL job may be deployed from the instance of the extended ETL operator model. The incremental ETL job may be executed to load data from the source schema to the target schema.
Owner:IBM CORP

Indexes with embedded data

A value field index for data stored in a data source is generated by analyzing a data source schema, analyzing intended queries of the data and analyzing the data. Problematic queries are identified and token fields are designated. The value field indexes are then created using the data source schema; and the value indexes are embedded in other indexes.
Owner:WHAMTECH

Method and system of document transformation between a source extensible markup language (XML) schema and a target XML schema

A method and system for the transformation of extensible markup language (XML) documents. Specifically, one embodiment of the present invention discloses a method comprising modeling a source XML document corresponding to a source schema as a source tree having a plurality of source nodes, and modeling a target XML document corresponding to a target schema as a target tree having a plurality of target nodes. A sequence of transformation operations that transforms the source tree to the target tree is then generated.
Owner:HEWLETT-PACKARD ENTERPRISE DEV LP +1
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products