Compiling mappings to bridge applications and databases

ACM Transactions on Database Systems

Volumn 33, Issue 4, 2008, Pages

  Melnik, Sergey ^a,b   Adya, Atul ^a,b   Bernstein, Philip A ^a,b  

^a MICROSOFT RESEARCH   (United States)

^b NONE   (United States)

Author keywords

Mapping; Query rewriting; Updateable views

Indexed keywords

APPLICATIONS; CONFORMAL MAPPING; MANAGEMENT INFORMATION SYSTEMS; OBJECT ORIENTED PROGRAMMING;

APPLICATION DATUMS; APPLICATION MODELS; BRIDGE APPLICATIONS; COMMERCIAL PRODUCTS; CONCEPTUAL SCHEMATA; DATA ACCESS OPERATIONS; DATA MANAGEMENT PROBLEMS; DATA TRANSFORMATIONS; DATABASE SCHEMATA; OBJECT-ORIENTED PROGRAMMINGS; QUERY REWRITING; RELATIONAL DATABASES; UPDATEABLE VIEWS; VIEW MAINTENANCES;

DATABASE SYSTEMS;

EID: 57949112536     PISSN: 03625915     EISSN: 15574644     Source Type: Journal    
DOI: 10.1145/1412331.1412334     Document Type: Article

References (46)

1. ABITEBOUL, S. AND DUSCHKA, O. M. 1998. Complexity of answering queries using materialized views. In Proceedings of the ACM SIGACT SIGMOD SIGART Symposium on Principles of Database Systems (PODS). ACM, New York, NY, 254-263.
2. ABITEBOUL, S., HULL, R., AND VIANU, V. 1995. Foundations of Databases. Addison Wesley.
3. ADYA, A., BLAKBLEY, J. A., MELNIK, S., MURALIDHAR, S., AND The ADO.NET TEAM. 2007. Anatomy of the ADO.NET Entity Framework. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD). ACM, New York, NY, 877-888.
4. ATKINSON, M. P. AND BUNEMAN, P. 1987. Types and persistence in database programming languages. ACM Comput. Surv. 19, 2, 105-190.
5. BANCILHON, F. and SPYRATOS, N. 1981. UPDATE semantics of relational views. ACM Trans. Database Syst. ACM, New York, NY, 6, 4, 557-575.
6. BARBOSA, D., FREIRE, J., AND MENDELZON, A. O. 2005. Designing information-preserving mapping schemes for XML. In Proceedings of the International Conference on Very Large Data, Bases (VLDB). VLDB Endowment, 109-120.
7. BARSALOU, T., KELLER, A. M., SIAMBELA, N., AND WIEDERHOLD, G. 1991. Updating relational databases through object-based views. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD). ACM, New York, NY, 248-257.
8. BATINI, C, CERI, S., AND NAVATHE, S. B. 1992. Conceptual Database Design: an Entity-Relationship Approach. Benjamin-Cummings Publishing Co., Inc., Redwood City, CA, USA.
9. BAUER, C. AND KING, G. 2006. Java Persistence with Hibernate. Manning Publications.
10. BERNSTEIN, P. A., GREEN, T. J., MELNIK, S., AND NASH, A. 2006. Implementing mapping composition. In Proceedings of the International Conference on Very Large Data, Bases (VLDB). VLDB Endowment, 55-66.
11. BERNSTEIN, P. A. and MELNIK, S. 2007. Model management 2.0: manipulating richer mappings. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD). ACM, New York, NY, 1-12.
12. BLAKELEY, J. A., LARSON, P.-Å., AND TOMPA, F. W. 1986. Efficiently updating materialized views. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD). ACM, New York, NY, 61-71.
13. BLAKELEY, J. A., MURALIDHAR, S., AND NORI, A. 2006. The ADO.NET Entity Framework: making the conceptual level real. In International Conference on Conceptual Modeling (ER). Lecture Notes in Computer Science, vol. 4312, Springer, Berlin, Heidelberg, New York, 552-565.
14. BOHANNON, A., PIERCE, B. C., AND VAUGHAN, J. A. 2006. Relational lenses: a language for updatable views. In Proceedings of the ACM SIGACT SIGMOD SIGART Symposium on Principles of Database Systems (PODS). ACM, New York, NY, 338-347.
15. BOHANNON, P., FAN, W., FLASTER, M., AND NARAYAN, P. P. S. 2005. Information preserving XML schema embedding. In Proceedings of the International Conference on Very Large Data Bases (VLDB). 85-96.
16. 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 the International Conference on Very Large Data Bases (VLDB). VLDB Endowment, 276-287.
17. BRYANT, R. E. 1986. Graph-based algorithms for boolean function manipulation. IEEE Trans. Comput. 35, 8, 677-691.
18. CAREY, M. J., CHAMBERLIN, D. D., NARAYANAN, S., VANCE, B., DOOLE, D., RIELAU, S., SWAGER-MAN, R., AND MATTOS, N. M. 1999. O-o, what have they done to DB2? In Proceedings of the International Conference on Very Large Data Bases (VLDB). VLDB Endowment, 542-553.
19. CAREY, M. J. AND DEWITT, D. J. 1996. Of objects and databases: a decade of turmoil. In Proceedings of the International, Conference on Very Large Data Bases (VLDB). VLDB Endowment, Morgan Kaufmann, 3-14.
20. CASTRO, P., MELNIK, S., AND ADYA, A. 2007. ADO.NET Entity Framework: raising the level of abstraction in data programming. In Proceedings of the ACM SIGMOD International Conference on Management of Data. (SIGMOD). ACM, New York, NY, 1070-1072.
21. CHEN, P. P. 1976. The entity-relationship model-toward a unified view of data. ACM Trans. Database Syst. 1, 1, 9-36.
22. COOK, W. R. AND IBRAHIM, A. H. 2006. Integrating programming languages and databases: what is the problem? ODBMS.ORG, Expert Article.
23. DAYAL, U. AND BERNSTEIN, P. A. 1978. On the updatability of relational views. In Proceedings of the International Conference on Very Large Data Bases (VLDB). VLDB Endowment, 368-377.
24. DI PAOLA, R. A. 1969. The recursive unsolvability of the decision problem for the class of definite formulas. J. ACM 16, 2, 324-327.
25. EJB 3.0 Expert Group. 2006. JSR 220: Enterprise JavaBeans, Version 3.0, Final Release.
26. FAGIN, R., KOLAITIS, P. G., POPA, L., AND TAN, W. C 2005. Composing schema mappings: second-order dependencies to the rescue. ACM Trans. Database Syst. 30, 4, 994-1055.
27. FOSTER, J. N., GREENWALD, M. B., MOORE, J. T., PIERCE, B. C., AND SCHMITT, A. 2007. Combinators for bidirectional tree transformations: a linguistic approach to the view-update problem. ACM Trans. Prog. Lang. Syst. 29, 3 (May), 17.
28. FUXMAN, A., HERNANDEZ, M. A., HO, H., MILLER, R. J., PAPOTTI, P., and POPA, L. 2006. Nested mappings: schema mapping reloaded. In Proceedings of the International Conference on Very Large Data Bases (VLDB). VLDB Endowment, 67-78.
29. GOTTLOB, G., PAOLINI, P., AND ZICARI, R. 1988. Properties and update semantics of consistent views. ACM Trans, on Database Syst. 13, 4, 486-524.
30. GOU, G., KORMILITSIN, M., AND CHIRKOVA, R. 2006. Query evaluation using overlapping views: completeness and efficiency. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD). ACM Press, New York, NY, 37-48.
31. GRIMES, S. 1998. Object/relational reality check. Database Program. Des. 11, 7.
32. GUPTA, A. AND MUMICK, I. S. 1995. Maintenance of materialized views: problems, techniques, and applications. IEEE Data Eng. Bull. 18, 2, 3-18.
33. HALEVY, A. Y. 2001. Answering queries using views: A Survey. VLDB J. 10, 4, 270-294.
34. JDO EXPERT GROUP. 2006. JSR 243: Java Data Objects, Version 2.0, Final Release.
35. KEENE, C. 2004. Data services for next-generation SOAs. SOA WebServices J. 4, 12.
36. KELLER, A. M., JENSEN, R., AND AGRAWAL, S. 1993. Persistence software: bridging object-oriented programming and relational databases. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD). ACM, New York, NY, 523-528.
37. KOTIDIS, Y, SRIVASTAVA, D., AND VELEGRAKIS, Y. 2006. Updates through views: a new hope. In Proceedings of the International Conference on Data Engineering (ICDE). 2.
38. KRISHNAMURTHY, V., BANERJEE, S., AND NORI, A. 1999. Bringing object-relational technology to mainstream. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD). ACM, New York, NY, 513-514.
39. LARSON, P.-Å. AND ZHOU, J. 2007. View matching for outer-join views. VLDB J. 16, 1, 29-53.
40. MEHRA, K. K., RAJAMANI, S. K., SISTLA, A. P., AND JHA, S. K. 2007. Verification of object relational maps. In Proceedings of the 5th IEEE Software Engineering and Formal Methods (SEFM). IEEE Computer Society, Washington, DC, 283-292.
41. MEIJER, E., BECKMAN, B., AND BIERMAN, G. M. 2006. LINQ: reconciling object, relations and XML in the .NET framework. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD). ACM, New York, NY, 706.
42. MELNIK, S., ADYA, A., AND BERNSTEIN, P. A. 2007. Compiling mappings to bridge applications and databases. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD). ACM, New York, NY, 461-472.
43. MILLER, R. J., HAAS, L. M., AND HERNÁNDEZ, M. A. 2000. Schema mapping as query discovery. In Proceedings of the International Conference on Very Large Data Bases (VLDB). VLDB Endowment, 77-88.
44. NASH, A., BERNSTEIN, P. A., AND MELNIK, S. 2007. Composition of mappings given by embedded dependencies. ACM Trans. Database Syst. 32, 1, 4.
45. SEGOUFIN, L. AND VIANU, V. 2005. Views and queries: determinacy and rewriting. In Proceedings of the ACM SIGACT SIGMOD SIGART Symposium on Principles of Database Systems (PODS). ACM, New York, NY, 49-60.
46. ZHANG, W. AND RITTER, N. 2001. The real benefits of object-relational db-technology for objectoriented software development. In Proceedings of the British National Conference on Databases (BNCOD). Lecture Notes in Computer Science, Vol. 2097, Springer, Berlin, Heidelberg, New York, 89-104.