Using a Conceptual Model in Plug-and-Play SQL

Using a Conceptual Model in Plug-and-Play SQL

연구 분야: Databases

학회: International Conference on Conceptual Modeling

We propose using a conceptual model for a database query’s input type. The input type is the shape of the data needed by a query. Pairing a conceptual model with a query creates a plug-and-play query that can be type matched to a database’s schema to determine whether the query can be safely evaluated. Plug-and-play queries are portable, easier to write, and are type safe. We describe a simple conceptual model based on virtual hierarchies, show how a virtual hierarchy is type matched to a relational schema, and how to transform an SQL query into one that can be evaluated on the matched schema.