Table substitution
First Claim
1. A method for sharing data across a legacy application system and a core application system, comprising:
- identifying a legacy application table in the legacy application system based on data contained in a set of related core application system tables of a set of core application system tables, whereinthe set of core application system tables are associated with a business component,the set of core application system tables comprise one or more columns that are not part of the set of related core application system tables or the legacy application table,the one or more columns in the set of core application system tables are required by the core application system,the legacy application table comprises a portion, the portion corresponding to a substituted table, andthe portion is configured to be used by the core application system;
determining a structure of the portion and the set of related core application system tables;
mapping columns in the set of related core application system tables to corresponding columns in the portion based on the structure of the portion and the set of related core application system tables, whereinas a result of the mapping,the portion comprised in the legacy application table is accessible by both the core application systems and the legacy application system; and
determining that core application system data operations have been previously configured to access the columns in the set of related core application system tables;
performing the core application system data operations such that the core application system data operations access the mapped columns in the portion comprised in the legacy application table instead of the columns in the set of related core application system tables, whereinthe legacy application system is configured to concurrently access the portion, andthe core application system is configured to concurrently access the one or more columns in the set of core application system tables.
2 Assignments
0 Petitions
Accused Products
Abstract
A method and system that enables data to be shared across application systems via a table substitution scheme. Tables are identified in the legacy application system that are candidates for substitution of tables in the core application system containing similar data. Table structure meta data corresponding to these “substituted” tables are then extracted from the legacy system schema, and stored in a repository. In accordance with the meta data, business logic is defined to remap columns in the core tables to corresponding columns in the substituted tables. Accordingly, when the core application system performs data access (e.g., reads, inserts, updates, etc.), it accesses the remapped columns in the substituted tables instead of original columns in the core tables. At the same time, the legacy application system is enabled to concurrently access the substituted tables without require any changes to the business logic of the legacy application system.
18 Citations
21 Claims
-
1. A method for sharing data across a legacy application system and a core application system, comprising:
-
identifying a legacy application table in the legacy application system based on data contained in a set of related core application system tables of a set of core application system tables, wherein the set of core application system tables are associated with a business component, the set of core application system tables comprise one or more columns that are not part of the set of related core application system tables or the legacy application table, the one or more columns in the set of core application system tables are required by the core application system, the legacy application table comprises a portion, the portion corresponding to a substituted table, and the portion is configured to be used by the core application system; determining a structure of the portion and the set of related core application system tables; mapping columns in the set of related core application system tables to corresponding columns in the portion based on the structure of the portion and the set of related core application system tables, wherein as a result of the mapping, the portion comprised in the legacy application table is accessible by both the core application systems and the legacy application system; and determining that core application system data operations have been previously configured to access the columns in the set of related core application system tables; performing the core application system data operations such that the core application system data operations access the mapped columns in the portion comprised in the legacy application table instead of the columns in the set of related core application system tables, wherein the legacy application system is configured to concurrently access the portion, and the core application system is configured to concurrently access the one or more columns in the set of core application system tables. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)
-
-
17. A non-transitory computer-readable media on which a plurality of machine instructions are stored corresponding to a multi-layer software architecture implemented by one or more software modules, including:
-
a user interface layer providing a plurality of forms pertaining to various business objects used by a core application system, each form including a plurality of fields; an object management layer that interfaces with the user interface layer including a first portion of business logic that maps columns in a set of related core application system tables of a set of core application system tables to corresponding fields in the plurality of forms, wherein the set of core application system tables are associated with a business component, the set of core application system tables comprise one or more columns that are not part of the set of related core application system tables, the one or more columns in the set of core application system tables are required by the core application system, and a second portion of business logic that maps columns in at least one legacy application system table of a legacy application system to fields in at least one form corresponding to at least one business object, each of said at least one legacy application system table comprising a portion, the portion corresponding to a substituted table, wherein the one or more columns of the set of core application system tables are not part of the legacy application table, and the portion is configured to be used by the core application system, and the portion comprised in the legacy application table is accessible by both the core application system and the legacy application system; and logic that determines that core application system data operations have been previously configured to access the columns in the set of related core application system tables, the core application system data operations being performed such that the core application system data operations access mapped columns in the portion comprised in the legacy application table instead of the columns in the set of related core application system tables; a data management layer that interfaces with the object management layer and provides access to the set of core application system tables and said at least one legacy application system table through interaction with a database server instance that hosts the set of core application system tables and said at least one legacy application system table, wherein the set of core application systems tables and said at least one legacy application system table respectively correspond to different database schemas, the legacy application system is configured to concurrently access the portion, and the core application system is configured to concurrently access the one or more columns in the set of core application system tables. - View Dependent Claims (18, 19, 20, 21)
-
Specification