University of Surrey

Test tubes in the lab Research in the ATI Dance Research

Generating SQL queries from SBVR rules

Moschoyiannis, Sotiris, Marinos, A and Krause, Paul (2010) Generating SQL queries from SBVR rules Lecture Notes in Computer Science: Semantic Web Rules, 6403. pp. 128-143.

[img]
Preview
Text
Generating_SQL_from_SBVR_RuleML2010.pdf
Available under License : See the attached licence file.

Download (386kB)
[img]
Preview
Text (licence)
SRI_deposit_agreement.pdf

Download (33kB)

Abstract

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.

Item Type: Article
Divisions : Faculty of Engineering and Physical Sciences > Computing Science
Authors :
NameEmailORCID
Moschoyiannis, SotirisS.Moschoyiannis@surrey.ac.uk
Marinos, A
Krause, PaulP.Krause@surrey.ac.uk
Date : 2010
Identification Number : 10.1007/978-3-642-16289-3_12
Copyright Disclaimer : The original publication is available at http://www.springerlink.com
Contributors :
ContributionNameEmailORCID
http://www.loc.gov/loc.terms/relators/PBLSPRINGER-VERLAG BERLIN,
Additional Information : Rule ML 2010: The 4th International Web Rule Symposium: Research Based and Industry Focused. 21 - 23 October 2010, Washington, DC, USA
Depositing User : Symplectic Elements
Date Deposited : 29 Apr 2013 07:58
Last Modified : 19 Oct 2018 14:59
URI: http://epubs.surrey.ac.uk/id/eprint/738714

Actions (login required)

View Item View Item

Downloads

Downloads per month over past year


Information about this web site

© The University of Surrey, Guildford, Surrey, GU2 7XH, United Kingdom.
+44 (0)1483 300800