Database Integrity Mechanism between OLTP and Offline Data

No Thumbnail Available
Files
There are no files associated with this item.
Date
2012
Authors
Salman, Muhammad
Shahid, Muhammad
Editors
Contact
Journal ISSN
Electronic ISSN
ISBN
Bibliographical data
Publisher
Series
URI (citable link)
ArXiv-ID
International patent number
Link to the license
oops
EU project number
Project
Open Access publication
Restricted until
Title in another language
Research Projects
Organizational Units
Journal Issue
Publication type
Contribution to a conference collection
Publication status
Published
Published in
Intelligent Information and Database Systems : 4th Asian Conference, ACIIDS 2012, Kaohsiung, Taiwan, March 19-21, 2012, Proceedings, Part II / Pan, Jeng-Shyang et al. (ed.). - Berlin : Springer, 2012. - (Lecture Notes in Artificial Intelligence ; 7197). - pp. 371-380. - ISSN 0302-9743. - eISSN 1611-3349. - ISBN 978-3-642-28489-2
Abstract
This paper describes integrity mechanism between OLTPs and offline data. Normally every RDBMS supports five Integrity Constraints (ICs) namely primary key or composite key, unique key, foreign key, not null and check constraints. Online database integrity is achieved through these five ICs. However, as per the retention period data is backed up and removed from the OLTPs for space and performance efficiency. But there is no standardized protocol on keeping integrity between offline data and data present in the OLTPs. Therefore, we present a solution to address the problem of offline data integrity by keeping a representative set of purged data & ICs in the online database to ensure data integrity between OLTPs and offline data. We further support our proposed solution with the help of two types of integrity tests i.e., sufficient and complete test.
Summary in another language
Subject (DDC)
004 Computer Science
Keywords
Integrity Constraints, OLTPs Performance, Offline Data
Conference
4th Asian Conference, ACIIDS 2012, Mar 19, 2012 - Mar 21, 2012, Kaohsiung, Taiwan
Review
undefined / . - undefined, undefined. - (undefined; undefined)
Cite This
ISO 690SALMAN, Muhammad, Nafees Ur REHMAN, Muhammad SHAHID, 2012. Database Integrity Mechanism between OLTP and Offline Data. 4th Asian Conference, ACIIDS 2012. Kaohsiung, Taiwan, Mar 19, 2012 - Mar 21, 2012. In: PAN, Jeng-Shyang, ed. and others. Intelligent Information and Database Systems : 4th Asian Conference, ACIIDS 2012, Kaohsiung, Taiwan, March 19-21, 2012, Proceedings, Part II. Berlin:Springer, pp. 371-380. ISSN 0302-9743. eISSN 1611-3349. ISBN 978-3-642-28489-2. Available under: doi: 10.1007/978-3-642-28490-8_39
BibTex
@inproceedings{Salman2012Datab-49268,
  year={2012},
  doi={10.1007/978-3-642-28490-8_39},
  title={Database Integrity Mechanism between OLTP and Offline Data},
  number={7197},
  isbn={978-3-642-28489-2},
  issn={0302-9743},
  publisher={Springer},
  address={Berlin},
  series={Lecture Notes in Artificial Intelligence},
  booktitle={Intelligent Information and Database Systems : 4th Asian Conference, ACIIDS 2012, Kaohsiung, Taiwan, March 19-21, 2012, Proceedings, Part II},
  pages={371--380},
  editor={Pan, Jeng-Shyang},
  author={Salman, Muhammad and Rehman, Nafees Ur and Shahid, Muhammad}
}
RDF
<rdf:RDF
    xmlns:dcterms="http://purl.org/dc/terms/"
    xmlns:dc="http://purl.org/dc/elements/1.1/"
    xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
    xmlns:bibo="http://purl.org/ontology/bibo/"
    xmlns:dspace="http://digital-repositories.org/ontologies/dspace/0.1.0#"
    xmlns:foaf="http://xmlns.com/foaf/0.1/"
    xmlns:void="http://rdfs.org/ns/void#"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema#" > 
  <rdf:Description rdf:about="https://kops.uni-konstanz.de/server/rdf/resource/123456789/49268">
    <foaf:homepage rdf:resource="http://localhost:8080/"/>
    <dc:date rdf:datatype="http://www.w3.org/2001/XMLSchema#dateTime">2020-04-23T09:51:08Z</dc:date>
    <dspace:isPartOfCollection rdf:resource="https://kops.uni-konstanz.de/server/rdf/resource/123456789/36"/>
    <dc:creator>Rehman, Nafees Ur</dc:creator>
    <dc:creator>Shahid, Muhammad</dc:creator>
    <bibo:uri rdf:resource="https://kops.uni-konstanz.de/handle/123456789/49268"/>
    <void:sparqlEndpoint rdf:resource="http://localhost/fuseki/dspace/sparql"/>
    <dcterms:issued>2012</dcterms:issued>
    <dc:language>eng</dc:language>
    <dc:creator>Salman, Muhammad</dc:creator>
    <dcterms:abstract xml:lang="eng">This paper describes integrity mechanism between OLTPs and offline data. Normally every RDBMS supports five Integrity Constraints (ICs) namely primary key or composite key, unique key, foreign key, not null and check constraints. Online database integrity is achieved through these five ICs. However, as per the retention period data is backed up and removed from the OLTPs for space and performance efficiency. But there is no standardized protocol on keeping integrity between offline data and data present in the OLTPs. Therefore, we present a solution to address the problem of offline data integrity by keeping a representative set of purged data &amp; ICs in the online database to ensure data integrity between OLTPs and offline data. We further support our proposed solution with the help of two types of integrity tests i.e., sufficient and complete test.</dcterms:abstract>
    <dc:contributor>Rehman, Nafees Ur</dc:contributor>
    <dcterms:title>Database Integrity Mechanism between OLTP and Offline Data</dcterms:title>
    <dc:contributor>Shahid, Muhammad</dc:contributor>
    <dc:contributor>Salman, Muhammad</dc:contributor>
    <dcterms:available rdf:datatype="http://www.w3.org/2001/XMLSchema#dateTime">2020-04-23T09:51:08Z</dcterms:available>
    <dcterms:isPartOf rdf:resource="https://kops.uni-konstanz.de/server/rdf/resource/123456789/36"/>
  </rdf:Description>
</rdf:RDF>
Internal note
xmlui.Submission.submit.DescribeStep.inputForms.label.kops_note_fromSubmitter
Contact
URL of original publication
Test date of URL
Examination date of dissertation
Method of financing
Comment on publication
Alliance license
Corresponding Authors der Uni Konstanz vorhanden
International Co-Authors
Bibliography of Konstanz
Refereed