Table substitution

Data processing: database and file management or data structures – Database design – Data structure types

Reexamination Certificate

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

C707S793000, C707S793000

Reexamination Certificate

active

10234417

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.

REFERENCES:
patent: 5564113 (1996-10-01), Bergen et al.
patent: 6389429 (2002-05-01), Kane et al.
patent: 6529921 (2003-03-01), Berkowitz et al.
patent: 6970880 (2005-11-01), Camarillo
patent: 2002/0055932 (2002-05-01), Wheeler et al.
“Metadatabase solutions for enterprise information integration problems”, Cheng Hsu and Laurie Rattner, Jan. 1993 ACM SIGMIS Database, vol. 24, issue 1.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

Table substitution does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Table substitution, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Table substitution will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-3839222

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.