METHOD AND APPARATUS FOR HETEROGENOUS DATABASE ACCESS BY GENERATING DIFFERENT ACCESS PROCEDURES FOR DIFFERENT DATABASE DATA STRUCTURES

A database processing system for supporting a plurality of storage structures comprises a dictionary for storing information such as basic data organizations relating to the combination of basic data organizations forming each type of storage structure, library parts names relating to said combination, and assembly pattern names an access parts library for storing information such as access parts to basic data organizations which are access methods to each of said basic data organizations, and library parts relating to the combination of said access parts; and an optimizing unit for generating procedures for processing a database by referring to said dictionary and access parts library in response to an query to a database and by combining said access parts to basic data organizations forming a storage structure and said library parts relating to the combination of said access parts. An access schedule can be generated in the optimizing process according to the stage structure of a database comprising basic data organizations.