Database Integrity Mechanism between OLTP and Offline Data

Lade...
Vorschaubild
Dateien
Zu diesem Dokument gibt es keine Dateien.
Datum
2012
Autor:innen
Salman, Muhammad
Shahid, Muhammad
Herausgeber:innen
Kontakt
ISSN der Zeitschrift
Electronic ISSN
ISBN
Bibliografische Daten
Verlag
Schriftenreihe
Auflagebezeichnung
URI (zitierfähiger Link)
ArXiv-ID
Internationale Patentnummer
Angaben zur Forschungsförderung
Projekt
Open Access-Veröffentlichung
Core Facility der Universität Konstanz
Gesperrt bis
Titel in einer weiteren Sprache
Forschungsvorhaben
Organisationseinheiten
Zeitschriftenheft
Publikationstyp
Beitrag zu einem Konferenzband
Publikationsstatus
Published
Erschienen 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, 2012, pp. 371-380. Lecture Notes in Artificial Intelligence. 7197. ISSN 0302-9743. eISSN 1611-3349. ISBN 978-3-642-28489-2. Available under: doi: 10.1007/978-3-642-28490-8_39
Zusammenfassung

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.

Zusammenfassung in einer weiteren Sprache
Fachgebiet (DDC)
004 Informatik
Schlagwörter
Integrity Constraints, OLTPs Performance, Offline Data
Konferenz
4th Asian Conference, ACIIDS 2012, 19. März 2012 - 21. März 2012, Kaohsiung, Taiwan
Rezension
undefined / . - undefined, undefined
Zitieren
ISO 690SALMAN, Muhammad, Nafees Ur REHMAN, Muhammad SHAHID, 2012. Database Integrity Mechanism between OLTP and Offline Data. 4th Asian Conference, ACIIDS 2012. Kaohsiung, Taiwan, 19. März 2012 - 21. März 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, 2012, pp. 371-380. Lecture Notes in Artificial Intelligence. 7197. 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>
Interner Vermerk
xmlui.Submission.submit.DescribeStep.inputForms.label.kops_note_fromSubmitter
Kontakt
URL der Originalveröffentl.
Prüfdatum der URL
Prüfungsdatum der Dissertation
Finanzierungsart
Kommentar zur Publikation
Allianzlizenz
Corresponding Authors der Uni Konstanz vorhanden
Internationale Co-Autor:innen
Universitätsbibliographie
Begutachtet
Diese Publikation teilen