Centralizuoto duomenų vientisumo apribojimų valdymo sistema
Integrity constraints comprise an urgent part of conceptual models. For this reason, they must be structured and represented in orderly manner. The purpose of this work is to solve the problems inherent in creation, storage and retrieval of centralized data integrity constraints. This paper analyses...
Main Author: | |
---|---|
Other Authors: | , , , , , , , , , |
Format: | Master Thesis |
Language: | Lithuanian |
Published: |
Lithuanian Academic Libraries Network (LABT)
2007
|
Subjects: | |
Online Access: | http://vddb.library.lt/obj/LT-eLABa-0001:E.02~2007~D_20070116_131053-56391 |
id |
ftdisslitauen:oai:elaba.lt:LT-eLABa-0001:E.02~2007~D_20070116_131053-56391 |
---|---|
record_format |
openpolar |
spelling |
ftdisslitauen:oai:elaba.lt:LT-eLABa-0001:E.02~2007~D_20070116_131053-56391 2023-05-15T16:01:59+02:00 Centralizuoto duomenų vientisumo apribojimų valdymo sistema System for centralist management of data integrity constraints Uzdanavičiūtė, Virginija Kiauleikis, Valentinas Gudas, Saulius Butkienė, Rita Nemuraitė, Lina Bareiša, Eduardas Lopata, Andrius Butleris, Rimantas Maciulevičius, Stasys Stulpinas, Raimundas Kaunas University of Technology 2007-01-16 application/pdf http://vddb.library.lt/obj/LT-eLABa-0001:E.02~2007~D_20070116_131053-56391 lit lit Lithuanian Academic Libraries Network (LABT) Kaunas University of Technology Unrestricted LT-eLABa-0001:E.02~2007~D_20070116_131053-56391 KTU-LABT20070116-131053-56391 http://vddb.library.lt/fedora/get/LT-eLABa-0001:E.02~2007~D_20070116_131053-56391/DS.005.0.02.ETD Informatics Engineering Data integrity constraints Duomenų vientisumo apribojimai Master thesis 2007 ftdisslitauen 2015-09-24T09:42:02Z Integrity constraints comprise an urgent part of conceptual models. For this reason, they must be structured and represented in orderly manner. The purpose of this work is to solve the problems inherent in creation, storage and retrieval of centralized data integrity constraints. This paper analyses the methods for implementation of data integrity constraints and describes a Oracle RDBMS-based technique that enables for impeccable functionality of information system and protection from invalid data. After analysis of system requirements and currently available software solutions, UML models of system architecture, data and database were proposed. Suitable means were chosen for developing a system for centralist management of data integrity constraints. The Constraint Editor geared towards designing, implementing and maintaining of procedures, integrity constraints throughout their lifecycle was developed. A simple, functional and intuitive graphical user interface makes data integrity constraints easy to story, manage and retrieve. The created software makes optimal use of RDBVS resources while performing ETL processes with multi – table insertions. The ability to insert data into multiple tables ensures further possibilities of supplying standard statistical analysis software with correct data and better performance than a procedure to perform multiple insertions using "IF.THEN" syntax. Furthermore, the software verifies SQL DML functions system widethus protecting. [to full text] Master Thesis DML Lietuvos virtuali biblioteka bei visateksčių dokumentų duomenų bazės sukūrimas |
institution |
Open Polar |
collection |
Lietuvos virtuali biblioteka bei visateksčių dokumentų duomenų bazės sukūrimas |
op_collection_id |
ftdisslitauen |
language |
Lithuanian |
topic |
Informatics Engineering Data integrity constraints Duomenų vientisumo apribojimai |
spellingShingle |
Informatics Engineering Data integrity constraints Duomenų vientisumo apribojimai Uzdanavičiūtė, Virginija Centralizuoto duomenų vientisumo apribojimų valdymo sistema |
topic_facet |
Informatics Engineering Data integrity constraints Duomenų vientisumo apribojimai |
description |
Integrity constraints comprise an urgent part of conceptual models. For this reason, they must be structured and represented in orderly manner. The purpose of this work is to solve the problems inherent in creation, storage and retrieval of centralized data integrity constraints. This paper analyses the methods for implementation of data integrity constraints and describes a Oracle RDBMS-based technique that enables for impeccable functionality of information system and protection from invalid data. After analysis of system requirements and currently available software solutions, UML models of system architecture, data and database were proposed. Suitable means were chosen for developing a system for centralist management of data integrity constraints. The Constraint Editor geared towards designing, implementing and maintaining of procedures, integrity constraints throughout their lifecycle was developed. A simple, functional and intuitive graphical user interface makes data integrity constraints easy to story, manage and retrieve. The created software makes optimal use of RDBVS resources while performing ETL processes with multi – table insertions. The ability to insert data into multiple tables ensures further possibilities of supplying standard statistical analysis software with correct data and better performance than a procedure to perform multiple insertions using "IF.THEN" syntax. Furthermore, the software verifies SQL DML functions system widethus protecting. [to full text] |
author2 |
Kiauleikis, Valentinas Gudas, Saulius Butkienė, Rita Nemuraitė, Lina Bareiša, Eduardas Lopata, Andrius Butleris, Rimantas Maciulevičius, Stasys Stulpinas, Raimundas Kaunas University of Technology |
format |
Master Thesis |
author |
Uzdanavičiūtė, Virginija |
author_facet |
Uzdanavičiūtė, Virginija |
author_sort |
Uzdanavičiūtė, Virginija |
title |
Centralizuoto duomenų vientisumo apribojimų valdymo sistema |
title_short |
Centralizuoto duomenų vientisumo apribojimų valdymo sistema |
title_full |
Centralizuoto duomenų vientisumo apribojimų valdymo sistema |
title_fullStr |
Centralizuoto duomenų vientisumo apribojimų valdymo sistema |
title_full_unstemmed |
Centralizuoto duomenų vientisumo apribojimų valdymo sistema |
title_sort |
centralizuoto duomenų vientisumo apribojimų valdymo sistema |
publisher |
Lithuanian Academic Libraries Network (LABT) |
publishDate |
2007 |
url |
http://vddb.library.lt/obj/LT-eLABa-0001:E.02~2007~D_20070116_131053-56391 |
genre |
DML |
genre_facet |
DML |
op_source |
LT-eLABa-0001:E.02~2007~D_20070116_131053-56391 KTU-LABT20070116-131053-56391 http://vddb.library.lt/fedora/get/LT-eLABa-0001:E.02~2007~D_20070116_131053-56391/DS.005.0.02.ETD |
op_rights |
Unrestricted |
_version_ |
1766397642513842176 |