James F. Terwilliger
Sergey Melnik
Abstract
Developers need to access persistent XML data programmatically. Object-oriented access is often the preferred method. Translating XML data into objects or vice-versa is a hard problem due to the data model mismatch and the difficulty of query translation. Our prototype addresses this problem by transforming object-based queries and updates into queries and updates on XML using declarative mappings between classes and XML schema types. Our prototype extends the ADO.NET Entity Framework and leverages its object-relational mapping capabilities.
We demonstrate how a developer can interact with stored relational and XML data using the Language Integrated Query (LINQ) feature of .NET. We show how LINQ queries are translated into a combination of SQL and XQuery. Finally, we illustrate how explicit mappings facilitate data independence upon database refactoring.
- A. Adya, J. A. Blakeley, S. Melnik, S. Muralidhar, The ADO.NET Team. Anatomy of the ADO.NET Entity Framework. In SIGMOD, 2007. Google Scholar
Digital Library
- W. R. Cook, A. H. Ibrahim. Integrating Programming Languages and Databases: What is the Problem? ODBMS.ORG, Expert Article, Sept. 2006.Google Scholar
- M. Harren, M. Raghavachari, O. Shmueli, M. G. Burke, R. Bordawekar, I. Pechtchanski, V. Sarkar. XJ: facilitating XML processing in Java. In WWW, 2005. Google ScholarDigital Library
- R. Lämmel. LINQ-to-XSD. In PLAN-X, 2007.Google Scholar
- R. Lämmel, E. Meijer. Revealing the X/O Impedance Mismatch (Changing Lead into Gold). In Datatype-Generic Programming, Lecture Notes in Computer Science. Springer-Verlag, June 2007. Google ScholarDigital Library
- Liquid XML. http://www.liquid-technologies.com/.Google Scholar
- E. Meijer, B. Beckman, G. M. Bierman. LINQ: Reconciling Object, Relations and XML in the .NET Framework. In SIGMOD, 2006. Google ScholarDigital Library
- S. Pather. LINQ to XML: Visual Studio 2008, Silverlight, and Beyond. XML '07, http://2007.xmlconference.org/public/schedule/detail/369.Google Scholar
- S. Resnick, R. Crane, C. Bowen. Essential Windows Communication Foundation (WCF): For .NET Framework 3.5. Addison Wesley, 2008. Google ScholarDigital Library
- XML Beans. http://xmlbeans.apache.org/.Google Scholar
Index Terms
- Language-integrated querying of XML data in SQL server
Recommendations
Integrated querying of XML data in RDBMSs
SAC '03: Proceedings of the 2003 ACM symposium on Applied computingThis paper proposes a way to integrate cleanly relational databases and XML documents. The main idea is to draw a clear line of demarcation between the two concepts by modelling XML documents as a new atomic SQL type. The standardised XML tools like ...
Efficiently Querying Large XML Data Repositories: A Survey
Extensible Markup Language (XML) is emerging as a de facto standard for information exchange among various applications on the World-Wide Web. There has been a growing need for developing high-performance techniques to query large XML data repositories ...
Comments