An entity-based approach to query processing in relational databases

0
115

Authors: Kalervo Jarvelin, Timo Niemi

Tags: 1993, conceptual modeling

An entity-based query interface to relational databases is developed. The interface combines some objectoriented features with the strengths of universal relation DBMSs (UR-DBMSs) by a value-oriented high-level representation of complex entity types. It enhances logical data independence by hiding their implementation in a relational database. The abstraction level of the entity representation lies between the relations of the relational model and the universal relation. This allows higher level expressions than the relational model but avoids the weaknesses of the UR-DBMSs. The interface supports a declarative entity-based query language of the level of Quel (described in Part II). The key features of the interface are: (1) the entity type representation and associated operations which allow the derivation of the entity types of the results of entity-based queries, and (2) and unambiguous and optimizing solution to the query interpretation problem of UR-DBMSs. The interface constructs equivalentRA expressions for entity queries to be evaluated by relational DBMSs (RDBMSs). The interface is specified in a formal and general way. It has essential benefits, which support further processing of query results, improve query efficiency, clarify query semantics, enhance logical data independence, and allow use of existing RDBMS software by interfacing them to the entity level processing in a systematic way. It separates the entity type and relational levels into different domains and integrates them together through a well-defined interface. The interface exploits fully and easily the optimization capabilities of universal relation-based systems. The entity types provide the users with a high-level and natural view of the database. The users express their queries in terms of the entity types. This simplifies the expression of complex queries considerably w.r.t. conventional query systems. The interface exploits this knowledge in an effective way.

Read the full paper here: https://pdf.sciencedirectassets.com/271546/1-s2.0-S0169023X00X00948/1-s2.0-0169023X9390006B/main.pdf?X-Amz-Security-Token=IQoJb3JpZ2luX2VjEMv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMSJGMEQCICsGQUwthVhumXQAfhzya3ckB%2FRfDL2Be8I8zHVbSKCTAiAhfO9Qq8LEOXKzCx1Z4OAegZKbsQOt5wzDj%2BuKH8UzXSq9Awj0%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAMaDDA1OTAwMzU0Njg2NSIMdRTgDzPO8pa4nBBwKpEDgaPeHMIlIyUPA0yT%2F2RRFepqfcevQPNF7dXARzM%2FoVnM02m2rDo2ZjCT3BnigMaNSQnh0%2BLI9ouwnhCXY5HMW8ADiGgEZ2QecJ3%2BrV7O2nKaniW7MTxXsq4JEIKBpZA1AmRmbXcdpe28crKaKkFV1MUlZoqU9vP11o7h0i%2BqyhN6StDoU15R0B47Fno2It17sdoC7kBoPuXazDKQmZvLtLzPJh2yLPfbCqg79WfvS4ShashzT0pDsIqQjnbICjyoytalgSTt69ktqfbGx2GSJBgRTTVYJ8E8VDtqhJTSycPdvbawl%2F67qBa4GbvicJnBj3fc9CXUUY%2BDSAAW%2FveRIQlaM%2Fj%2Fz6Q7%2BnbhQ%2FL94MJ60f2ivRVkFZ9m7FjXQVppamxyS2MCOsa%2Fkxlf2Zvw0gbOk2Ai9b81%2FC7XNuDKLWim%2BKUOyPQJ0xh1K3qVE1a2JbeZxozIvt2HSOUIeVJq77CTw4KfOZZqYJfgUCFYT961WEw6tYpQIG0IQYhtXCJrADaq3%2BKxe%2BqQ7b5G1SkpBg8w9vPy%2BwU67AFO%2B16QlVDKU%2F20Am8X3A4pz8Lf238idhexzJlzwMOVgHDi%2Bj8hDyE1Bt5I3AQx6BB5Kski0nVZtD98w4zil9P9%2FzJKGsoDsD2MStzVH%2F9dBr78ZCeA%2Bi7STlRXwyGch6cCkZkCpy0MqGk8c8%2Fa3vRJeWDB7YQe3G%2BtkY2KODz6fYKbSYX6z6O7WvC6gs4I5vQFM4f%2FF66Ia%2FyUt6tYWepFx%2BeDEuIEatXhiEnMoC0oRJ3MvSVtYzqefNkUzOg61MHoK7Ydj8Ui%2BM2W%2F2AasNgH37LsUSbcIi9CtkFd0e11fuCll9bb6HcdtLqhZw%3D%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20201006T195314Z&X-Amz-SignedHeaders=host&X-Amz-Expires=300&X-Amz-Credential=ASIAQ3PHCVTYTBEKGYNK%2F20201006%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Signature=2672772116e5565f559c6c211783a1788f22462855cd6021cc20908d5e7b7bad&hash=88ba9bee3bbe97788253d5eab9d83b93f80a220b687baa6d95cf46ed82980abc&host=68042c943591013ac2b2430a89b270f6af2c76d8dfd086a07176afe7c76c2c61&pii=0169023X9390006B&tid=spdf-6681c341-d497-4097-8f78-4bedb445dd9c&sid=486d779f37b05542706a4e676167ccab2c3agxrqa&type=client