Generating SQL queries from SBVR rules

• Main Authors: Moschoyiannis, Sotiris, Marinos, A, Krause, Paul
• Format: Article in Journal/Newspaper
• Language: English
• Published: Springer 2010
• Subjects: DML
• Online Access: http://epubs.surrey.ac.uk/738714/1/Generating_SQL_from_SBVR_RuleML2010.pdf; http://epubs.surrey.ac.uk/738714/2/SRI_deposit_agreement.pdf; https://doi.org/10.1007/978-3-642-16289-3_12

Declarative technologies have made great strides in expressivity between SQL and SBVR. SBVR models are more expressive that SQL schemas, but not as imminently executable yet. In this paper, we complete the architecture of a system that can execute SBVR models. We do this by describing how SBVR rules can be transformed into SQL DML so that they can be automatically checked against the database using a standard SQL query. In particular, we describe a formalization of the basic structure of an SQL query which includes aggregate functions, arithmetic operations, grouping, and grouping on condition. We do this while staying within a predicate calculus semantics which can be related to the standard SBVR-LF specification and equip it with a concrete semantics for expressing business rules formally. Our approach to transforming SBVR rules into standard SQL queries is thus generic, and the resulting queries can be readily executed on a relational schema generated from the SBVR model.