Patent
Automated data warehouse migration
TLDR
In this article, the authors describe a method for analysis, migration, and validation of data from a source environment (such as an RDBMS system) to a target environment (e.g., a data warehouse appliance).Abstract:
Systems, apparatus, computer-readable storage media, and methods are disclosed for allowing analysis, migration, and validation of data from a source environment (such as an RDBMS system) to a target environment (such as a data warehouse (DW) appliance). In one example, a method comprises analyzing a source database, a source ETL environment, a target database, and a target ETL environment to produce configuration data, the configuration data being used for generating a mapping of the source database to a target database in the target database environment, a mapping of the source DDL code to target DDL code in the target database environment, and a mapping of source ETL code to target ETL code for the target database environment, and migrating at least one table from the source database, at least a portion of the source DDL code, and at least a portion of the source ETL code to the target database environment, where the migrating is based at least in part on the mapping generated using the configuration data.read more
Citations
More filters
Patent
Managing tenant-specific data sets in a multi-tenant environment
TL;DR: In this article, a method, computer program product and system for managing tenant-specific data sets in a multi-tenant system, by receiving a request to convert a data set in a physical data store from a first type of multiantenant deployment to a second type of multitenant deployment, retrieving tenant identification metadata identifying a tenant making the request.
Patent
Processing data in data migration
TL;DR: In this paper, a computer-implemented method for processing information related to an extract-transform-load (ETL) data migration, including aggregating operational metadata and determining: a plurality of metrics, organized by business object, corresponding to the migration; a number of business object instances not successfully loaded; a first end-to-end execution time for at least one business object; relevant input metadata; load readiness status per business object.
Patent
Automated database migration architecture
Antony Higginson,John Masterson,Sean Fitzpatrick,Peter Robertshaw,Elmar Spiegelberg,Stephan Buhne,Michael Weick,Nick Balch,Florin Popescu +8 more
TL;DR: In this article, a pre-migration analysis for a plurality of objects stored in the one or more source databases, and a migration plan that defines an execution order for the plurality of migration scripts is presented.
Patent
System and method for automating data warehousing processes
TL;DR: In this article, a system and computer-implemented method for automating data warehousing processes is provided, which comprises a code generator configured to generate codes for Extract, Transform and Load (ETL) tools, wherein the codes facilitate the ETL tools in extracting, transforming and loading data read from data sources.
Patent
Migration services for systems
TL;DR: In this article, a migration engine to perform system migration operations is provided and a migration strategy may be determined at least partially based on the information indicative of one or more migration candidates.
References
More filters
Patent
System and method for database conversion
TL;DR: In this paper, a database conversion engine comprising a method and system to convert business information residing on one system to another system is presented, which facilitates identification of basic minimum required data for conversion leading to efficiencies in volume of data, performance, validations, reusability and conversion turnover time.
Patent
Migrating data integration processes through use of externalized metadata representations
Richard Harken,Robert Johnston +1 more
TL;DR: In this paper, the authors present methods and systems for migrating a data integration facility such as an ETL job from a source data integration platform to a target data integration platforms, where the target job is adapted to perform substantially the same functions as the source job.
Patent
Modularized extraction, transformation, and loading for a database
TL;DR: In this article, the authors present techniques for extracting metadata that describes one or more items, the data for which is in the source database, where the one OR more items include at least one of a view, a sequence, a dimension, a cube, an ETL mapping, and any database object for which the metadata is stored outside of the source and target databases.
Patent
Apparatus and method for database migration
TL;DR: In this paper, the authors present a method for database migration from one database (source database platform) platform to another (target database platform), which is consistent with concepts of the present embodiment of the inventive concept.
Patent
Data warehousing systems and methods having reusable user transforms
TL;DR: In this paper, a plurality of transformation templates are stored in a transformation library, each transformation template including software objects that describe how to transform extracted data prior to loading the data into the data warehouse.