| 摘要 |
The present invention relates to a system and method for accessing non-relational data stored in records on a host system by a relational access method. The implementation of a relational interface component allows data transformation and type conversion and gives a relational interface to non-relational data. An integrated mapping component is used to define the relational structure of non-relational records or data. This relational structure is used by the application program or database request. The mapping component allows one to define columns with their characteristic (i.e. byte offset, data type, length). The definitions can be grouped in maps equivalent to a relational table and views representing a subset of the columns defined in a map. Multiple different maps and views can be defined for one record. The information of the maps, columns and views are stored in a repository. The inventive interface component uses the definitions stored in the repository to access the non-relational data and splits the records. Preferably based on the SQL language non-relational data like VSAM data can be accessed from any program using the relational interface component. The original non-relational data remains unchanged and older programs work without changes. The present invention gives new possibilities for host based programs using non-relational access methods and supports the integration, transition and migration into relational environments.
|
