4 results about "Source schema" patented technology

A system for converting a source data feed schema into a canonical data product including a memory for storing computer-executable instructions and a processor for executing the instructions stored on the memory. Execution of the instructions programs the processor to perform operations that include receiving a source data feed having a source schema, identifying a plurality of data fields of the source schema, assigning a data category from a plurality of predefined data categories to each data field of the plurality of data fields, modifying the source schema based on predefined parameters, wherein the source schema is modified to match a target schema, comparing the modified source schema to the target schema, and in response to a determination that the modified source schema matches the target schema, converting the source data feed to a canonical data product having the target schema based on the assigned data categories.

Systems, methods, and non-transitory, machine-readable media may facilitate testing within sub-environments with respect to resource capacity data corresponding to resources. Specifications of resource allocations for resources may be collected. Observation data, including resource metrics data, may be consolidated and used to develop resource data composites with mapped resource metrics data. A sub-environment interface may be configured to allow creation of sub-environments based on the resource data composites. Source schemas and data structures corresponding to the resource data composites may be selected. A migration plan to migrate the selected data structures to a destination schema for testing in a sub-environment may be created. A migration according to the migration plan may be executed. The destination schema may be created to match the selected source data structures and the selected source schemas. The selected data structures may be migrated to the destination schema to allow for testing in the sub-environment.

Systems, methods, and non-transitory, machine-readable media may facilitate testing within sub-environments with respect to resource capacity data corresponding to resources. Specifications of resource allocations for resources may be collected. Observation data, including resource metrics data, may be consolidated and used to develop resource data composites with mapped resource metrics data. A sub-environment interface may be configured to allow creation of sub-environments based on the resource data composites. Source schemas and data structures corresponding to the resource data composites may be selected. A migration plan to migrate the selected data structures to a destination schema for testing in a sub-environment may be created. A migration according to the migration plan may be executed. The destination schema may be created to match the selected source data structures and the selected source schemas. The selected data structures may be migrated to the destination schema to allow for testing in the sub-environment.

This enables data integration that is independent of the schema definitions and attribute information of the source data. [Solution] A data integration support system that assists in the process of integrating data from a group of source data files into a destination database comprises: a schema information generation device that generates source schema information defining a source database which is a database of the group of data files; a suggestion device that presents the user with suggestion information showing possible table options in the source database for each table in the destination database, based on the relationships between tables in the source schema information where tables refer to other tables and the relationships between tables in the destination schema information which defines the destination database, and prompts the user to select one of the options; and a data integration device that determines which tables in the source database will be integrated into each table in the destination database based on the user's selection of options.