Atul Adya
Sergey Melnik
ABSTRACT
Traditional client-server applications relegate query and persistence operations on their data to database systems. The database system operates on data in the form of rows and tables, while the application operates on data in terms of higher-level programming language constructs (classes, structures etc.). The impedance mismatch in the data manipulation services between the application and the database tier was problematic even in traditional systems. With the advent of service-oriented architectures (SOA), application servers and multi-tier applications, the need for data access and manipulation services that are well-integrated with programming environments and can operate in any tier has increased tremendously.
Microsoft's ADO.NET Entity Framework is a platform for programming against data that raises the level of abstraction from the relational level to the conceptual (entity) level, and thereby significantly reduces the impedance mismatch for applications and data-centric services. This paper describes the key aspects of the Entity Framework, the overall system architecture, and the underlying technologies.
References
- ADO.NET, http://msdn.microsoft.com/data/ref/adonetnext/Google Scholar
- ANSI/X3/SPARC Study Group on Data Base Management Systems. Interim Report. FDT (ACM SIGMOD bulletin) 7,No. 2, 1975.Google Scholar
- Atkinson, M. P., Buneman, P. Types and Persistence in Database Programming Languages. ACM Comput. Surv.,19(2):105--190, 1987. Google ScholarDigital Library
- Barsalou, T., Keller, A. M., Siambela, N., Wiederhold, G. Updating Relational Databases through Object-Based Views. SIGMOD, 1991.Google ScholarDigital Library
- Blakeley, J. A., Larson, P., Tompa, F. W. Efficiently Updating Materialized Views, SIGMOD, 1986.Google ScholarDigital Library
- Blakeley, J. A., S. Muralidhar, Nori, A. The ADO.NET Entity Framework: Making the Conceptual Level Real, ER 2006.Google Scholar
- Bohannon, A., Pierce, B. C., Vaughan, J. A. Relational Lenses: A Language for Updatable Views. PODS, 2006.Google Scholar
- Bauer, C., King, G. Java Persistence with Hibernate, Manning Publications, Nov. 2006.Google ScholarDigital Library
- Carey, M. J. et al. Data Delivery in a Service Oriented World: The BEA AquaLogic Data Services Platform, SIGMOD 2006.Google Scholar
- Carey, M. J., Chamberlin, D. D., Narayanan, S., Vance, B.,Doole, D., Rielau, S., Swagerman, R., Mattos, N. M. O-O, What Have They Done to DB2? VLDB, 1999. Google ScholarDigital Library
- Carey, M. J., DeWitt, D. J. Of Objects and Databases: A Decade of Turmoil. VLDB, 1996. Google ScholarDigital Library
- Castro, P., Melnik, S., Adya, A. ADO.NET Entity Framework: Raising the Level of Abstraction in Data Programming. SIGMOD (demo), 2007.Google Scholar
- Chen, P. The Entity-Relationship Model--Toward a Unified View of Data, ACM Trans. on Database Syst., 1(1), 1976. Google ScholarDigital Library
- Common Language Runtime (CLR),http://msdn2.microsoft.com/en-us/library/ms131047.aspxGoogle Scholar
- Cook, W. R., Ibrahim, A. H. Integrating Programming Languages and Databases: What is the Problem? ODBMS.ORG, Expert Article, Sept. 2006.Google Scholar
- Dayal, U., Bernstein, P. A. On the Updatability of Relational Views. VLDB, 1978.Google ScholarDigital Library
- EJB 3.0, http://java.sun.com/products/ejb/Google Scholar
- Entity Data Model, http://msdn2.microsoft.com/enus/library/aa697428(vs.80).aspxGoogle Scholar
- Grimes, S. Object/Relational Reality Check. Database Programming & Design (DBPD), 11(7), July 1998. Google ScholarDigital Library
- Gupta, A., Mumick, I. S. Materialized Views: Techniques, Implementations, and Applications, The MIT Press, 1999.Google ScholarDigital Library
- Halevy, A. Y. Answering Queries Using Views: A Survey.VLDB Journal, 10(4):270--294, 2001. Google ScholarDigital Library
- IBM Rational Data Architect. www.ibm.com/software/data/integration/rda/Google Scholar
- IntelliSense, http://msdn2.microsoft.com/enus/library/hcw1s69b(vs.71).aspxGoogle Scholar
- JDO (Java Data Objects), http://java.sun.com/products/jdo/Google Scholar
- Keller, A. M., R. Jensen, S. Agrawal. Persistence Software: Bridging Object-Oriented Programming and Relational Databases. SIGMOD, 1993.Google Scholar
- Keene, C. Data Services for Next-Generation SOAs. SOA WebServices Journal, 4(12), 2004.Google Scholar
- Krishnamurthy, V., Banerjee, S., Nori, A. Bringing Object-Relational Technology to Mainstream. SIGMOD, 1999.Google ScholarDigital Library
- The LINQ Project. http://msdn.microsoft.com/library/enus/dndotnet/html/linqprojectovw.aspGoogle Scholar
- LLBLGen Pro O/R Mapper -- Generator. www.llblgen.comGoogle Scholar
- Microsoft BizTalk Server. www.microsoft.com/biztalk/Google Scholar
- Meijer, E., Beckman, B., Bierman, G. M. LINQ: Reconciling Objects, Relations and XML in the .NET Framework. SIGMOD, 2006.Google ScholarDigital Library
- Melnik, S., Adya, A., Bernstein, P. A. Compiling Mappings to Bridge Applications and Databases. SIGMOD, 2007.Google ScholarDigital Library
- Oracle TopLink. www.oracle.com/technology/products/ias/toplink/Google Scholar
- Roth, M., Hernandez, M. A., Coulthard, P., Yan, L., Popa, L.,Ho, H. C.-T., Salter, C. C. XML Mapping Technology: Making Connections in an XML-Centric World. IBM Systems J., 45(2), 2006. Google ScholarDigital Library
- SDO, http://www.osoa.org/display/Main/Service+Data+Objects+HomeGoogle Scholar
- Unified Modeling Language. http://www.uml.org/Google Scholar
- Zhang, W., Ritter, N. The Real Benefits of Object-Relational DB-Technology for Object-Oriented Software Development. In BNCOD, 2001. Google ScholarDigital Library
Index Terms
Anatomy of the ADO.NET entity framework
Comments