Using object-oriented principles to optimize update propagation to materialized views

View materialization is known to be a valuable technique for performance optimization in relational databases, and much work has been done addressing the problem of consistently maintaining relational views under update operations. However, little progress has been made thus far regarding the topic...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Kuno, H.A., Rundensteiner, E.A.
Format: Tagungsbericht
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page 317
container_issue
container_start_page 310
container_title
container_volume
creator Kuno, H.A.
Rundensteiner, E.A.
description View materialization is known to be a valuable technique for performance optimization in relational databases, and much work has been done addressing the problem of consistently maintaining relational views under update operations. However, little progress has been made thus far regarding the topic of view materialization in object-oriented databases (OODBs). In this paper, we demonstrate that there are several significant differences between the relational and object-oriented paradigms that can be exploited when addressing the object-oriented view materialization problem. We use the subsumption relationships between classes to identify branches of classes to which we do not need to propagate updates. Similarly, we use encapsulated interfaces combined with the fact that any unique database property is inherited from a single location to provide a "registration/notification" service for optimizing incremental view updates. We also report results from the experimental studies we have run on the MultiView system measuring the impact of these optimization strategies.
doi_str_mv 10.1109/ICDE.1996.492178
format Conference Proceeding
fullrecord <record><control><sourceid>ieee_6IE</sourceid><recordid>TN_cdi_ieee_primary_492178</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><ieee_id>492178</ieee_id><sourcerecordid>492178</sourcerecordid><originalsourceid>FETCH-LOGICAL-i104t-bc60c2394b24c9b910c2e41df226f47154d1db8116aae6c4801bb9a2deafde913</originalsourceid><addsrcrecordid>eNotUE1LxDAUDH6AZe1dPOUPdM1L0zQ5Sl3XhQUvFrwt-XhdsvSLNir6662scxnezDA8hpA7YGsAph921dNmDVrLtdAcSnVBEp6XRca4fL8kqS4VU6BkyQVTVyQBJvNM5orfkHSeT2yBFgAFS0hdz6E_0sGe0MVsmAL2ET0dp9C7MLY40zjQYYyhCz9IP0ZvIi7uMJqjiWHo_-xu0aZg2iXh6WfAr_mWXDemnTH95xWpnzdv1Uu2f93uqsd9FoCJmFknmeO5FpYLp62G5UIBvuFcNqKEQnjwVgFIY1A6oRhYqw33aBqPGvIVuT_3BkQ8LE93Zvo-nDfJfwGQjlUF</addsrcrecordid><sourcetype>Publisher</sourcetype><iscdi>true</iscdi><recordtype>conference_proceeding</recordtype></control><display><type>conference_proceeding</type><title>Using object-oriented principles to optimize update propagation to materialized views</title><source>IEEE Electronic Library (IEL) Conference Proceedings</source><creator>Kuno, H.A. ; Rundensteiner, E.A.</creator><creatorcontrib>Kuno, H.A. ; Rundensteiner, E.A.</creatorcontrib><description>View materialization is known to be a valuable technique for performance optimization in relational databases, and much work has been done addressing the problem of consistently maintaining relational views under update operations. However, little progress has been made thus far regarding the topic of view materialization in object-oriented databases (OODBs). In this paper, we demonstrate that there are several significant differences between the relational and object-oriented paradigms that can be exploited when addressing the object-oriented view materialization problem. We use the subsumption relationships between classes to identify branches of classes to which we do not need to propagate updates. Similarly, we use encapsulated interfaces combined with the fact that any unique database property is inherited from a single location to provide a "registration/notification" service for optimizing incremental view updates. We also report results from the experimental studies we have run on the MultiView system measuring the impact of these optimization strategies.</description><identifier>ISSN: 1063-6382</identifier><identifier>ISBN: 9780818672408</identifier><identifier>ISBN: 0818672404</identifier><identifier>EISSN: 2375-026X</identifier><identifier>DOI: 10.1109/ICDE.1996.492178</identifier><language>eng</language><publisher>IEEE</publisher><subject>Computer science ; Laboratories ; NASA ; Object oriented databases ; Object oriented modeling ; Optimization ; Programming profession ; Prototypes ; Relational databases ; Software systems</subject><ispartof>Proceedings of the Twelfth International Conference on Data Engineering, 1996, p.310-317</ispartof><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://ieeexplore.ieee.org/document/492178$$EHTML$$P50$$Gieee$$H</linktohtml><link.rule.ids>309,310,777,781,786,787,2052,4036,4037,27906,54901</link.rule.ids><linktorsrc>$$Uhttps://ieeexplore.ieee.org/document/492178$$EView_record_in_IEEE$$FView_record_in_$$GIEEE</linktorsrc></links><search><creatorcontrib>Kuno, H.A.</creatorcontrib><creatorcontrib>Rundensteiner, E.A.</creatorcontrib><title>Using object-oriented principles to optimize update propagation to materialized views</title><title>Proceedings of the Twelfth International Conference on Data Engineering</title><addtitle>ICDE</addtitle><description>View materialization is known to be a valuable technique for performance optimization in relational databases, and much work has been done addressing the problem of consistently maintaining relational views under update operations. However, little progress has been made thus far regarding the topic of view materialization in object-oriented databases (OODBs). In this paper, we demonstrate that there are several significant differences between the relational and object-oriented paradigms that can be exploited when addressing the object-oriented view materialization problem. We use the subsumption relationships between classes to identify branches of classes to which we do not need to propagate updates. Similarly, we use encapsulated interfaces combined with the fact that any unique database property is inherited from a single location to provide a "registration/notification" service for optimizing incremental view updates. We also report results from the experimental studies we have run on the MultiView system measuring the impact of these optimization strategies.</description><subject>Computer science</subject><subject>Laboratories</subject><subject>NASA</subject><subject>Object oriented databases</subject><subject>Object oriented modeling</subject><subject>Optimization</subject><subject>Programming profession</subject><subject>Prototypes</subject><subject>Relational databases</subject><subject>Software systems</subject><issn>1063-6382</issn><issn>2375-026X</issn><isbn>9780818672408</isbn><isbn>0818672404</isbn><fulltext>true</fulltext><rsrctype>conference_proceeding</rsrctype><creationdate>1996</creationdate><recordtype>conference_proceeding</recordtype><sourceid>6IE</sourceid><sourceid>RIE</sourceid><recordid>eNotUE1LxDAUDH6AZe1dPOUPdM1L0zQ5Sl3XhQUvFrwt-XhdsvSLNir6662scxnezDA8hpA7YGsAph921dNmDVrLtdAcSnVBEp6XRca4fL8kqS4VU6BkyQVTVyQBJvNM5orfkHSeT2yBFgAFS0hdz6E_0sGe0MVsmAL2ET0dp9C7MLY40zjQYYyhCz9IP0ZvIi7uMJqjiWHo_-xu0aZg2iXh6WfAr_mWXDemnTH95xWpnzdv1Uu2f93uqsd9FoCJmFknmeO5FpYLp62G5UIBvuFcNqKEQnjwVgFIY1A6oRhYqw33aBqPGvIVuT_3BkQ8LE93Zvo-nDfJfwGQjlUF</recordid><startdate>1996</startdate><enddate>1996</enddate><creator>Kuno, H.A.</creator><creator>Rundensteiner, E.A.</creator><general>IEEE</general><scope>6IE</scope><scope>6IL</scope><scope>CBEJK</scope><scope>RIE</scope><scope>RIL</scope></search><sort><creationdate>1996</creationdate><title>Using object-oriented principles to optimize update propagation to materialized views</title><author>Kuno, H.A. ; Rundensteiner, E.A.</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-i104t-bc60c2394b24c9b910c2e41df226f47154d1db8116aae6c4801bb9a2deafde913</frbrgroupid><rsrctype>conference_proceedings</rsrctype><prefilter>conference_proceedings</prefilter><language>eng</language><creationdate>1996</creationdate><topic>Computer science</topic><topic>Laboratories</topic><topic>NASA</topic><topic>Object oriented databases</topic><topic>Object oriented modeling</topic><topic>Optimization</topic><topic>Programming profession</topic><topic>Prototypes</topic><topic>Relational databases</topic><topic>Software systems</topic><toplevel>online_resources</toplevel><creatorcontrib>Kuno, H.A.</creatorcontrib><creatorcontrib>Rundensteiner, E.A.</creatorcontrib><collection>IEEE Electronic Library (IEL) Conference Proceedings</collection><collection>IEEE Proceedings Order Plan All Online (POP All Online) 1998-present by volume</collection><collection>IEEE Xplore All Conference Proceedings</collection><collection>IEEE Electronic Library (IEL)</collection><collection>IEEE Proceedings Order Plans (POP All) 1998-Present</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Kuno, H.A.</au><au>Rundensteiner, E.A.</au><format>book</format><genre>proceeding</genre><ristype>CONF</ristype><atitle>Using object-oriented principles to optimize update propagation to materialized views</atitle><btitle>Proceedings of the Twelfth International Conference on Data Engineering</btitle><stitle>ICDE</stitle><date>1996</date><risdate>1996</risdate><spage>310</spage><epage>317</epage><pages>310-317</pages><issn>1063-6382</issn><eissn>2375-026X</eissn><isbn>9780818672408</isbn><isbn>0818672404</isbn><abstract>View materialization is known to be a valuable technique for performance optimization in relational databases, and much work has been done addressing the problem of consistently maintaining relational views under update operations. However, little progress has been made thus far regarding the topic of view materialization in object-oriented databases (OODBs). In this paper, we demonstrate that there are several significant differences between the relational and object-oriented paradigms that can be exploited when addressing the object-oriented view materialization problem. We use the subsumption relationships between classes to identify branches of classes to which we do not need to propagate updates. Similarly, we use encapsulated interfaces combined with the fact that any unique database property is inherited from a single location to provide a "registration/notification" service for optimizing incremental view updates. We also report results from the experimental studies we have run on the MultiView system measuring the impact of these optimization strategies.</abstract><pub>IEEE</pub><doi>10.1109/ICDE.1996.492178</doi><tpages>8</tpages></addata></record>
fulltext fulltext_linktorsrc
identifier ISSN: 1063-6382
ispartof Proceedings of the Twelfth International Conference on Data Engineering, 1996, p.310-317
issn 1063-6382
2375-026X
language eng
recordid cdi_ieee_primary_492178
source IEEE Electronic Library (IEL) Conference Proceedings
subjects Computer science
Laboratories
NASA
Object oriented databases
Object oriented modeling
Optimization
Programming profession
Prototypes
Relational databases
Software systems
title Using object-oriented principles to optimize update propagation to materialized views
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-18T19%3A27%3A00IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-ieee_6IE&rft_val_fmt=info:ofi/fmt:kev:mtx:book&rft.genre=proceeding&rft.atitle=Using%20object-oriented%20principles%20to%20optimize%20update%20propagation%20to%20materialized%20views&rft.btitle=Proceedings%20of%20the%20Twelfth%20International%20Conference%20on%20Data%20Engineering&rft.au=Kuno,%20H.A.&rft.date=1996&rft.spage=310&rft.epage=317&rft.pages=310-317&rft.issn=1063-6382&rft.eissn=2375-026X&rft.isbn=9780818672408&rft.isbn_list=0818672404&rft_id=info:doi/10.1109/ICDE.1996.492178&rft_dat=%3Cieee_6IE%3E492178%3C/ieee_6IE%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rft_ieee_id=492178&rfr_iscdi=true