Invention Grant
- Patent Title: Creating a logical table from multiple differently formatted physical tables having different access methods
- Patent Title (中): 从具有不同访问方式的多个不同格式的物理表创建逻辑表
-
Application No.: US11016203Application Date: 2004-12-17
-
Publication No.: US08112459B2Publication Date: 2012-02-07
- Inventor: Richard D. Dettinger , Daniel P. Kolz , Richard J. Stevens , Jeffrey W. Tenner
- Applicant: Richard D. Dettinger , Daniel P. Kolz , Richard J. Stevens , Jeffrey W. Tenner
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Patterson & Sheridan LLP
- Main IPC: G06F17/30
- IPC: G06F17/30

Abstract:
Embodiments of the present invention provide methods for constructing a database abstraction model that includes logical fields that map to a logical table. The logical table is constructed using data extracted from multiple, differently formatted physical tables. The logical table allows logically related data stored in multiple databases to appear as data from a single table. Relationships between data stored in multiple, differently formatted databases are maintained and logical fields that include multiple access methods that map to the multiple databases are replaced with a single access method that maps to the logical table. Data relationships that are defined for the database abstraction model are modified to reflect the logical table.
Public/Granted literature
Information query