Integration of Composite Objects into Relational Query Processing: The SQL/XNF Approach

Abstract

Complex database applications, such as design applications, multi-media and AI applications, and even enhanced business applications can benefit significantly from a database language that supports composite objects. The data used by such applications are often shared with more traditional applications, such as cost accounting, project management, etc. Hence, sharing of the data among traditional applications and complex object applications is important. Our approach, called SQL Extended Normal Form (short SQL/XNF) provides a general framework that supports novel processing models based on composite objects. Especially, it enhances relational technology by a composite object facility, which comprises not only extraction of composite objects from a shared database, but also adequate browsing and manipulation facilities provided by an appropriate application programming interface.