Extended Tuple Constraint Type as a Complex Integrity Constraint Type in XML Data Model – Definition and Enforcement

Jovana Vidaković1, Sonja Ristić2, Slavica Kordić3 and Ivan Luković3

  1. University of Novi Sad, Faculty of Sciences, Department of Mathematics and Informatics
    Trg Dositeja Obradovića 4, 21000 Novi Sad, Serbia
    jovana@uns.ac.rs
  2. University of Novi Sad, Faculty of Technical Sciences, Department of Industrial Engineering and Engineering Management
    Trg Dositeja Obradovića 6, 21000 Novi Sad, Serbia
    sdristic@uns.ac.rs
  3. University of Novi Sad, Faculty of Technical Sciences, Department of Computing and Control
    Trg Dositeja Obradovića 6, 21000 Novi Sad, Serbia
    {slavica, ivan}@uns.ac.rs

Abstract

A database management system (DBMS) is based on a data model whose concepts are used to express a database schema. Each data model has a specific set of integrity constraint types. There are integrity constraint types, such as key constraint, unique constraint and foreign key constraint that are supported by most DBMSs. Other, more complex constraint types are difficult to express and enforce and are mostly completely disregarded by actual DBMSs. The users have to manage those using custom procedures or triggers. eXtended Markup Language (XML) has become the universal format for representing and exchanging data. Very often XML data are generated from relational databases and exported to a target application or another database. In this context, integrity constraints play the essential role in preserving the original semantics of data. Integrity constraints have been extensively studied in the relational data model. Mechanisms provided by XML schema languages rely on a simple form of constraints that is sufficient neither for expressing semantic constraints commonly found in databases nor for expressing more complex constraints induced by the business rules of the system under study. In this paper we present a classification of constraint types in relational data model, discuss possible declarative mechanisms for their specification and enforcement in the XML data model, and illustrate our approach to the definition and enforcement of complex constraint types in the XML data model on the example of extended tuple constraint type.

Key words

XML Data Model, extended tuple constraint, code generation, XQuery functions, database triggers

Digital Object Identifier (DOI)

https://doi.org/10.2298/CSIS180324029V

Publication information

Volume 15, Issue 3 (October 2018)
Year of Publication: 2018
ISSN: 2406-1018 (Online)
Publisher: ComSIS Consortium

Full text

DownloadAvailable in PDF
Portable Document Format

How to cite

Vidaković, J., Ristić, S., Kordić, S., Luković, I.: Extended Tuple Constraint Type as a Complex Integrity Constraint Type in XML Data Model – Definition and Enforcement. Computer Science and Information Systems, Vol. 15, No. 3, 821–843. (2018), https://doi.org/10.2298/CSIS180324029V