{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,1,12]],"date-time":"2023-01-12T05:41:17Z","timestamp":1673502077169},"reference-count":56,"publisher":"Association for Computing Machinery (ACM)","issue":"3","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["ACM Trans. Database Syst."],"published-print":{"date-parts":[[2006,9]]},"abstract":"<jats:p>\n            Current systems that publish relational data as nested (XML) views are\n            <jats:italic>passive<\/jats:italic>\n            in the sense that they can only respond to user-initiated queries over the nested views. In this article, we propose an\n            <jats:italic>active<\/jats:italic>\n            system whereby users can place triggers on (unmaterialized) nested views of relational data. In this architecture, we present scalable and efficient techniques for processing triggers over nested views by leveraging existing support for SQL triggers over flat relations in commercial relational databases. We have implemented our proposed techniques in the context of the Quark XML middleware system. Our performance results indicate that our proposed techniques are a feasible approach to supporting triggers over nested views of relational data.\n          <\/jats:p>","DOI":"10.1145\/1166074.1166080","type":"journal-article","created":{"date-parts":[[2006,10,18]],"date-time":"2006-10-18T18:11:32Z","timestamp":1161195092000},"page":"921-967","update-policy":"http:\/\/dx.doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":4,"title":["Triggers over nested views of relational data"],"prefix":"10.1145","volume":"31","author":[{"given":"Feng","family":"Shao","sequence":"first","affiliation":[{"name":"Cornell University, Ithaca, NY"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Antal","family":"Novak","sequence":"additional","affiliation":[{"name":"Stanford University, Stanford, CA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jayavel","family":"Shanmugasundaram","sequence":"additional","affiliation":[{"name":"Cornell University, Ithaca, NY"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2006,9]]},"reference":[{"key":"e_1_2_2_1_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB","author":"Abiteboul S.","unstructured":"Abiteboul , S. , McHugh , J. , Rys , M. , Vassalos , V. , and Wiener , J . 1998. Incremental maintenance for materialized views over semistructured data . In Proceedings of the International Conference on Very Large Databases (VLDB , New York City, NY). 38--49. Abiteboul, S., McHugh, J., Rys, M., Vassalos, V., and Wiener, J. 1998. Incremental maintenance for materialized views over semistructured data. In Proceedings of the International Conference on Very Large Databases (VLDB, New York City, NY). 38--49."},{"key":"e_1_2_2_2_1","doi-asserted-by":"publisher","DOI":"10.1007\/s007990050005"},{"key":"e_1_2_2_3_1","doi-asserted-by":"publisher","DOI":"10.1137\/0208017"},{"key":"e_1_2_2_4_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB","author":"Altinel M.","unstructured":"Altinel , M. and Franklin , M. J . 2000. Efficient filtering of XML documents for selective dissemination of information . In Proceedings of the International Conference on Very Large Databases (VLDB , San Francisco, CA). 53--64. Altinel, M. and Franklin, M. J. 2000. Efficient filtering of XML documents for selective dissemination of information. In Proceedings of the International Conference on Very Large Databases (VLDB, San Francisco, CA). 53--64."},{"key":"e_1_2_2_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/543613.543625"},{"key":"e_1_2_2_6_1","volume-title":"Proceedings of the International Conferences on Data Engineering (ICDE). 561--568","author":"Banerjee S.","unstructured":"Banerjee , S. , Krishnamurthy , V. , Krishnaprasad , M. , and Murthy , R . 2000. Oracle8i---the XML enabled data management system . In Proceedings of the International Conferences on Data Engineering (ICDE). 561--568 . Banerjee, S., Krishnamurthy, V., Krishnaprasad, M., and Murthy, R. 2000. Oracle8i---the XML enabled data management system. In Proceedings of the International Conferences on Data Engineering (ICDE). 561--568."},{"key":"e_1_2_2_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066299"},{"key":"e_1_2_2_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142588"},{"key":"e_1_2_2_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/1007568.1007625"},{"key":"e_1_2_2_10_1","volume-title":"Active XQuery. In Proceedings of the International Conference on Data Engineering (ICDE","author":"Bonifati A.","unstructured":"Bonifati , A. , Braga , D. , Campi , A. , and Ceri , S . 2002 . Active XQuery. In Proceedings of the International Conference on Data Engineering (ICDE , San Jose, CA). 403--414. Bonifati, A., Braga, D., Campi, A., and Ceri, S. 2002. Active XQuery. In Proceedings of the International Conference on Data Engineering (ICDE, San Jose, CA). 403--414."},{"key":"e_1_2_2_11_1","volume-title":"Proceedings of VLDB","author":"Braganholo V. P.","unstructured":"Braganholo , V. P. , Davidson , S. B. , and Heuser , C. A . 2004. From XML view updates to relational view updates: Old solutions to a new problem . In Proceedings of VLDB ( Toronto, Ont., Canada). 276--287. Braganholo, V. P., Davidson, S. B., and Heuser, C. A. 2004. From XML view updates to relational view updates: Old solutions to a new problem. In Proceedings of VLDB (Toronto, Ont., Canada). 276--287."},{"key":"e_1_2_2_12_1","volume-title":"Proceedings of WebDB. 31--36","author":"Braganholo V. P.","unstructured":"Braganholo , V. P. , Davidson , S. B. , and Heuser , C. A . 2003. On the updatability of XML views over relational databases . In Proceedings of WebDB. 31--36 . Braganholo, V. P., Davidson, S. B., and Heuser, C. A. 2003. On the updatability of XML views over relational databases. In Proceedings of WebDB. 31--36."},{"key":"e_1_2_2_13_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB","author":"Ceri S.","unstructured":"Ceri , S. and Widom , J . 1990. Deriving production rules for constraint maintenance . In Proceedings of the International Conference on Very Large Databases (VLDB , Brisbane, Queensland, Australia). 566--577. Ceri, S. and Widom, J. 1990. Deriving production rules for constraint maintenance. In Proceedings of the International Conference on Very Large Databases (VLDB, Brisbane, Queensland, Australia). 566--577."},{"key":"e_1_2_2_14_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB","author":"Ceri S.","unstructured":"Ceri , S. and Widom , J . 1991. Deriving production rules for incremental view maintenance . In Proceedings of the International Conference on Very Large Databases (VLDB , Barcelona, Catalonia, Spain). 577--589. Ceri, S. and Widom, J. 1991. Deriving production rules for incremental view maintenance. In Proceedings of the International Conference on Very Large Databases (VLDB, Barcelona, Catalonia, Spain). 577--589."},{"key":"e_1_2_2_15_1","doi-asserted-by":"publisher","DOI":"10.1007\/s00778-002-0077-6"},{"key":"e_1_2_2_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/800105.803397"},{"key":"e_1_2_2_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/342009.335432"},{"key":"e_1_2_2_18_1","doi-asserted-by":"crossref","unstructured":"Cochrane R. Kulkarni K. and Mattos N. 1999. Active database features in SQL3. In Active Rules in Database Systems. Springer-Verlag Berlin Germany 197--220.  Cochrane R. Kulkarni K. and Mattos N. 1999. Active database features in SQL3. In Active Rules in Database Systems. Springer-Verlag Berlin Germany 197--220.","DOI":"10.1007\/978-1-4419-8656-6_10"},{"key":"e_1_2_2_19_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB, Mumbai (Bombay), India). 567--578","author":"Cochrane R.","unstructured":"Cochrane , R. , Pirahesh , H. , and Mattos , N . 1996. Integrating triggers and declarative constraints in SQL database systems . In Proceedings of the International Conference on Very Large Databases (VLDB, Mumbai (Bombay), India). 567--578 . Cochrane, R., Pirahesh, H., and Mattos, N. 1996. Integrating triggers and declarative constraints in SQL database systems. In Proceedings of the International Conference on Very Large Databases (VLDB, Mumbai (Bombay), India). 567--578."},{"key":"e_1_2_2_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/357980.358007"},{"key":"e_1_2_2_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/319732.319740"},{"key":"e_1_2_2_22_1","volume-title":"Proceedings of the International Conference on Data Engineering (ICDE","author":"Diao Y.","unstructured":"Diao , Y. , Fischer , P. , Franklin , M. , and To , R . 2002. YFilter: Efficient and scalable filtering of XML documents . In Proceedings of the International Conference on Data Engineering (ICDE , San Jose, CA). 341--352. Diao, Y., Fischer, P., Franklin, M., and To, R. 2002. YFilter: Efficient and scalable filtering of XML documents. In Proceedings of the International Conference on Data Engineering (ICDE, San Jose, CA). 341--352."},{"key":"e_1_2_2_23_1","volume-title":"Proceedings of the International Conference on Conceptual Modeling(ER)","author":"Dimitrova K.","unstructured":"Dimitrova , K. , El-Sayed , M. , and Rundensteiner , E . 2003. Order-sensitive view maintenance of materialized XQuery views . In Proceedings of the International Conference on Conceptual Modeling(ER) ( Chicago, IL). 144--157. Dimitrova, K., El-Sayed, M., and Rundensteiner, E. 2003. Order-sensitive view maintenance of materialized XQuery views. In Proceedings of the International Conference on Conceptual Modeling(ER) (Chicago, IL). 144--157."},{"key":"e_1_2_2_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/584931.584950"},{"key":"e_1_2_2_25_1","doi-asserted-by":"publisher","DOI":"10.1016\/S1389-1286(00)00061-X"},{"key":"e_1_2_2_26_1","volume-title":"Proceedings of the International Conference on Deductive and Object-Oriented Databases (DOOD","author":"Gluche D.","unstructured":"Gluche , D. , Grust , T. , Mainberger , C. , and Scholl , M . 1997. Incremental updates for materialized OQL views . In Proceedings of the International Conference on Deductive and Object-Oriented Databases (DOOD , Montreux, Switzerland). 52--66. Gluche, D., Grust, T., Mainberger, C., and Scholl, M. 1997. Incremental updates for materialized OQL views. In Proceedings of the International Conference on Deductive and Object-Oriented Databases (DOOD, Montreux, Switzerland). 52--66."},{"key":"e_1_2_2_27_1","doi-asserted-by":"publisher","DOI":"10.1145\/223784.223849"},{"key":"e_1_2_2_28_1","first-page":"3","article-title":"Maintenance of materialized views: Problems, techniques and applications","volume":"18","author":"Gupta A.","year":"1995","unstructured":"Gupta , A. and Mumick , I. S. 1995 . Maintenance of materialized views: Problems, techniques and applications . IEEE Quart. Bull. Data Eng. (Special Issue on Materialized Views and Data Warehousing) 18 , 2, 3 -- 18 . Gupta, A. and Mumick, I. S. 1995. Maintenance of materialized views: Problems, techniques and applications. IEEE Quart. Bull. Data Eng. (Special Issue on Materialized Views and Data Warehousing) 18, 2, 3--18.","journal-title":"IEEE Quart. Bull. Data Eng. (Special Issue on Materialized Views and Data Warehousing)"},{"key":"e_1_2_2_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/872757.872809"},{"key":"e_1_2_2_30_1","volume-title":"Proceedings of the International Conference on Data Engineering (ICDE","author":"Hanson E.","unstructured":"Hanson , E. , Carnes , C. , Huang , L. , Konyala , M., L. Noronha , S. P. , Park , J. , and Vernon , A . 1999. Scalable trigger processing . In Proceedings of the International Conference on Data Engineering (ICDE , Sydney, Australia). 266--275. Hanson, E., Carnes, C., Huang, L., Konyala, M., L. Noronha, S. P., Park, J., and Vernon, A. 1999. Scalable trigger processing. In Proceedings of the International Conference on Data Engineering (ICDE, Sydney, Australia). 266--275."},{"key":"e_1_2_2_31_1","doi-asserted-by":"publisher","DOI":"10.1145\/588111.588133"},{"key":"e_1_2_2_32_1","volume-title":"Proceedings of the International Workshop on Database Programming Languages (DBPL","author":"Kawaguchi A.","unstructured":"Kawaguchi , A. , Lieuwen , D. , Mumick , I. , and Ross , K . 1997. Implementing incremental view maintenance in nested data models . In Proceedings of the International Workshop on Database Programming Languages (DBPL , Estes Park, CO). 202--221. Kawaguchi, A., Lieuwen, D., Mumick, I., and Ross, K. 1997. Implementing incremental view maintenance in nested data models. In Proceedings of the International Workshop on Database Programming Languages (DBPL, Estes Park, CO). 202--221."},{"key":"e_1_2_2_33_1","doi-asserted-by":"publisher","DOI":"10.1145\/325405.325423"},{"key":"e_1_2_2_34_1","doi-asserted-by":"publisher","DOI":"10.1109\/69.729731"},{"key":"e_1_2_2_35_1","doi-asserted-by":"publisher","DOI":"10.1145\/77643.77645"},{"key":"e_1_2_2_36_1","doi-asserted-by":"publisher","DOI":"10.1145\/375663.375723"},{"key":"e_1_2_2_37_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB","author":"Palpanas T.","unstructured":"Palpanas , T. , Sidle , R. , Cochrane , R. , and Pirahesh , H . 2002. Incremental maintenance for non-distributive aggregate functions . In Proceedings of the International Conference on Very Large Databases (VLDB , Hong Kong, China). 802--813. Palpanas, T., Sidle, R., Cochrane, R., and Pirahesh, H. 2002. Incremental maintenance for non-distributive aggregate functions. In Proceedings of the International Conference on Very Large Databases (VLDB, Hong Kong, China). 802--813."},{"key":"e_1_2_2_38_1","volume-title":"Proceedings of the 11th Conference on Data Engineering, P. S. Yu and A. L. P. Chen, Eds. IEEE Computer Society Press","author":"Papakonstantinou Y.","unstructured":"Papakonstantinou , Y. , Garcia-Molina , H. , and Widom , J . 1995. Object exchange across heterogeneous information sources . In Proceedings of the 11th Conference on Data Engineering, P. S. Yu and A. L. P. Chen, Eds. IEEE Computer Society Press , Los Alamitos, CA, 251--260. Papakonstantinou, Y., Garcia-Molina, H., and Widom, J. 1995. Object exchange across heterogeneous information sources. In Proceedings of the 11th Conference on Data Engineering, P. S. Yu and A. L. P. Chen, Eds. IEEE Computer Society Press, Los Alamitos, CA, 251--260."},{"key":"e_1_2_2_39_1","volume-title":"Proceedings of the Workshopon Semantics Web and Databases.","author":"Papamarkos G.","unstructured":"Papamarkos , G. , Poulovassilis , A. , and Wood , P . 2003. Event-condition-action rule languages for the semantic Web . In Proceedings of the Workshopon Semantics Web and Databases. Papamarkos, G., Poulovassilis, A., and Wood, P. 2003. Event-condition-action rule languages for the semantic Web. In Proceedings of the Workshopon Semantics Web and Databases."},{"key":"e_1_2_2_40_1","doi-asserted-by":"publisher","DOI":"10.1145\/141484.130294"},{"key":"e_1_2_2_41_1","volume-title":"Proceedings of the Workshop on Materialized Views: Techniques and Applications (VIEWS). 110--118","author":"Quass D.","year":"1996","unstructured":"Quass , D. 1996 . Maintenance expressions for views with aggregation . In Proceedings of the Workshop on Materialized Views: Techniques and Applications (VIEWS). 110--118 . Quass, D. 1996. Maintenance expressions for views with aggregation. In Proceedings of the Workshop on Materialized Views: Techniques and Applications (VIEWS). 110--118."},{"key":"e_1_2_2_42_1","doi-asserted-by":"publisher","DOI":"10.1145\/49346.49347"},{"key":"e_1_2_2_43_1","first-page":"3","article-title":"State-of-the-art XML support in RDBMS: Microsoft SQL server's XML features","volume":"24","author":"Rys M.","year":"2001","unstructured":"Rys , M. 2001 . State-of-the-art XML support in RDBMS: Microsoft SQL server's XML features . IEEE Data Eng. Bull. 24 , 2, 3 -- 11 . Rys, M. 2001. State-of-the-art XML support in RDBMS: Microsoft SQL server's XML features. IEEE Data Eng. Bull. 24, 2, 3--11.","journal-title":"IEEE Data Eng. Bull."},{"key":"e_1_2_2_44_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066301"},{"key":"e_1_2_2_45_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB, Mumbai (Bombay), India). 460--471","author":"Rys M.","unstructured":"Rys , M. , Norrie , M. , and Schek , H . 1996. Intra-transaction parallelism in the mapping of an object-model to a relational multi-processor system . In Proceedings of the International Conference on Very Large Databases (VLDB, Mumbai (Bombay), India). 460--471 . Rys, M., Norrie, M., and Schek, H. 1996. Intra-transaction parallelism in the mapping of an object-model to a relational multi-processor system. In Proceedings of the International Conference on Very Large Databases (VLDB, Mumbai (Bombay), India). 460--471."},{"key":"e_1_2_2_46_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB). 535--548","author":"Sagiv Y.","unstructured":"Sagiv , Y. and Yannakakis , M . 1978. Equivalence among relational expressions with the union and difference operation . In Proceedings of the International Conference on Very Large Databases (VLDB). 535--548 . Sagiv, Y. and Yannakakis, M. 1978. Equivalence among relational expressions with the union and difference operation. In Proceedings of the International Conference on Very Large Databases (VLDB). 535--548."},{"key":"e_1_2_2_47_1","volume-title":"Proceedings of the International Conference on Data Engineering (ICDE","author":"Seshadri P.","unstructured":"Seshadri , P. , Pirahesh , H. , and Leung , T . 1996. Complex query decorrelation . In Proceedings of the International Conference on Data Engineering (ICDE , New Orleans, LA), 450--458. Seshadri, P., Pirahesh, H., and Leung, T. 1996. Complex query decorrelation. In Proceedings of the International Conference on Data Engineering (ICDE, New Orleans, LA), 450--458."},{"key":"e_1_2_2_48_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB","author":"Shanmugasundaram J.","unstructured":"Shanmugasundaram , J. , Kiernan , J. , Shekita , E. , Fan , C. , and Funderburk , J . 2001. Querying XML views of relational data . In Proceedings of the International Conference on Very Large Databases (VLDB , Rome, Italy). 261--270. Shanmugasundaram, J., Kiernan, J., Shekita, E., Fan, C., and Funderburk, J. 2001. Querying XML views of relational data. In Proceedings of the International Conference on Very Large Databases (VLDB, Rome, Italy). 261--270."},{"key":"e_1_2_2_49_1","volume-title":"Proceedings of the International Conference on Very Large Databases (VLDB","author":"Shanmugasundaram J.","unstructured":"Shanmugasundaram , J. , Shekita , E. , Barr , R. , Carey , M. , Lindsay , B. , Pirahesh , H. , and Reinwald , B . 2000. Efficiently publishing relational data as XML documents . In Proceedings of the International Conference on Very Large Databases (VLDB , Edinburgh, Scotland). 65--76. Shanmugasundaram, J., Shekita, E., Barr, R., Carey, M., Lindsay, B., Pirahesh, H., and Reinwald, B. 2000. Efficiently publishing relational data as XML documents. In Proceedings of the International Conference on Very Large Databases (VLDB, Edinburgh, Scotland). 65--76."},{"key":"e_1_2_2_50_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2005.147"},{"key":"e_1_2_2_51_1","volume-title":"Proceedings of the International Conference on Conceptual Modeling","author":"Silva A.","unstructured":"Silva , A. , Filha , I. , Laender , A. , and Embley , D . 2002. Representing and querying semistructured Web data using nested tables with structural variants . In Proceedings of the International Conference on Conceptual Modeling ( Tampere, Finland). 135--151. Silva, A., Filha, I., Laender, A., and Embley, D. 2002. Representing and querying semistructured Web data using nested tables with structural variants. In Proceedings of the International Conference on Conceptual Modeling (Tampere, Finland). 135--151."},{"key":"e_1_2_2_52_1","doi-asserted-by":"publisher","DOI":"10.1145\/93597.98737"},{"key":"e_1_2_2_53_1","first-page":"269","article-title":"Nested relational structures","volume":"3","author":"Thomas S.","year":"1986","unstructured":"Thomas , S. and Fischer , P. C. 1986 . Nested relational structures . In Adv. Comput. Res. 3 , 269 -- 307 . Thomas, S. and Fischer, P. C. 1986. Nested relational structures. In Adv. Comput. Res. 3, 269--307.","journal-title":"Adv. Comput. Res."},{"key":"e_1_2_2_54_1","doi-asserted-by":"publisher","DOI":"10.1145\/1007568.1007623"},{"key":"e_1_2_2_55_1","doi-asserted-by":"publisher","DOI":"10.1145\/582192.582226"},{"key":"e_1_2_2_56_1","doi-asserted-by":"publisher","DOI":"10.1145\/564691.564767"}],"container-title":["ACM Transactions on Database Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/1166074.1166080","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T21:20:38Z","timestamp":1672262438000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1166074.1166080"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2006,9]]},"references-count":56,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2006,9]]}},"alternative-id":["10.1145\/1166074.1166080"],"URL":"https:\/\/doi.org\/10.1145\/1166074.1166080","relation":{},"ISSN":["0362-5915","1557-4644"],"issn-type":[{"value":"0362-5915","type":"print"},{"value":"1557-4644","type":"electronic"}],"subject":[],"published":{"date-parts":[[2006,9]]},"assertion":[{"value":"2006-09-01","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}