THE STRUCTURE OF A SUBSCHEMA AND ITS XML SPECIFICATION
Ivan Luković, Pavle Mogin, Miro Govedarica, Sonja Ristić · University of Zagreb University Computing Centre (SRCE) · 2002
Abstract: The notion of a subschema, as a formal and abstract definition of data, constraints, and database update activities that are needed to make a transaction program, is introduced in the paper. A subschema is designed with respect to a user requirement and an existing relational database schema. A subschema design is done in the course of a transaction program design. Establishing methods for the design of a transaction program specification asks for a definition of a general and formal structure of that program. Our recent research shows that this goal may be achieved by means of XML specifications. Using XML specifications provides an automatic procedure for generating an executable specification of a transaction program. In the paper we present a formal way to describe the structure of a subschema by means of XML. This description supports SQL subschema specification using concepts of ANSI SQL92 standard.