Introducing custom language extensions to SQL: 1999
CAiSE'03 Proceedings of the 15th international conference on Advanced information systems engineering
Whole-part relationships in the object-relational databases
ICCOMP'06 Proceedings of the 10th WSEAS international conference on Computers
Hi-index | 0.00 |
In this paper, we bring together two important topics of current database research: enhancing the data model by refined relationship semantics and exploiting ORDBMS extensibility to equip the system with new functionality. Regarding the first topic, we introduce a framework to capture diverse semantic characteristics of application-specific relationships. Then, in order to integrate the conceptual extensions with the data model provided by SQL:1999, the second topic comes into play. Our efforts to realize semantically rich relationships by employing current ORDB technology clearly point up the benefits as well as the shortcomings of its extensibility facilities. Unfortunately, deficiencies still prevail in the OR-infrastructure, since the features specific to the extensions cannot sufficiently be taken into account by DBMS-internal processing such as query optimization, and there are very limited mechanisms of adequately supporting the required properties, e. g., by adjusted index and storage structures as well as suitable operational units of processing.