摘要 |
An apparatus and a method of processing queries to a relational database (105) stored on a computer readable medium (111), said computer readable medium comprising a representation of relations (227-231) between sections (206-226) in tables (201-205) in the database, said apparatus comprising means for identifying tables (201-205) which contain a specified type of data. The apparatus is characterized by comprising means for generating a plurality of queries (e.g. SQL queries) by selecting at least some primary tables (204, 203) from the identified tables, means for selecting a set of tables, each table in the set being related to a primary table via N relations, and repeating this, N being varied for each repetition, until the set of tables contains the specified data, and means for selecting an optimal one of the generated queries.
|