Anatomy of the ADO.NET entity framework

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

• 1: ADO.NET, http://msdn.microsoft.com/data/ref/adonetnext/
• 2: ANSI/X3/SPARC Study Group on Data Base Management Systems. Interim Report. FDT (ACM SIGMOD bulletin) 7,No. 2, 1975.
• 3: Malcolm P. Atkinson , O. Peter Buneman, Types and persistence in database programming languages, ACM Computing Surveys (CSUR), v.19 n.2, p.105-170, June 1987 [doi>10.1145/62070.45066]
• 4: Barsalou, T., Keller, A. M., Siambela, N., Wiederhold, G. Updating Relational Databases through Object-Based Views. SIGMOD, 1991.
• 5: Blakeley, J. A., Larson, P., Tompa, F. W. Efficiently Updating Materialized Views, SIGMOD, 1986.
• 6: Blakeley, J. A., S. Muralidhar, Nori, A. The ADO.NET Entity Framework: Making the Conceptual Level Real, ER 2006.
• 7: Bohannon, A., Pierce, B. C., Vaughan, J. A. Relational Lenses: A Language for Updatable Views. PODS, 2006.
• 8: Bauer, C., King, G. Java Persistence with Hibernate, Manning Publications, Nov. 2006.
• 9: Carey, M. J. et al. Data Delivery in a Service Oriented World: The BEA AquaLogic Data Services Platform, SIGMOD 2006.
• 10: 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.
• 11: Carey, M. J., DeWitt, D. J. Of Objects and Databases: A Decade of Turmoil. VLDB, 1996.
• 12: Castro, P., Melnik, S., Adya, A. ADO.NET Entity Framework: Raising the Level of Abstraction in Data Programming. SIGMOD (demo), 2007.
• 13: Peter Pin-Shan Chen, The entity-relationship model—toward a unified view of data, ACM Transactions on Database Systems (TODS), v.1 n.1, p.9-36, March 1976 [doi>10.1145/320434.320440]
• 14: Common Language Runtime (CLR),http://msdn2.microsoft.com/en-us/library/ms131047.aspx
• 15: Cook, W. R., Ibrahim, A. H. Integrating Programming Languages and Databases: What is the Problem? ODBMS.ORG, Expert Article, Sept. 2006.
• 16: Dayal, U., Bernstein, P. A. On the Updatability of Relational Views. VLDB, 1978.
• 17: EJB 3.0, http://java.sun.com/products/ejb/
• 18: Entity Data Model, http://msdn2.microsoft.com/enus/library/aa697428(vs.80).aspx
• 19: Grimes, S. Object/Relational Reality Check. Database Programming & Design (DBPD), 11(7), July 1998.
• 20: Gupta, A., Mumick, I. S. Materialized Views: Techniques, Implementations, and Applications, The MIT Press, 1999.
• 21: Alon Y. Halevy, Answering queries using views: A survey, The VLDB Journal — The International Journal on Very Large Data Bases, v.10 n.4, p.270-294, December 2001 [doi>10.1007/s007780100054]
• 22: IBM Rational Data Architect. www.ibm.com/software/data/integration/rda/
• 23: IntelliSense, http://msdn2.microsoft.com/enus/library/hcw1s69b(vs.71).aspx
• 24: JDO (Java Data Objects), http://java.sun.com/products/jdo/
• 25: Keller, A. M., R. Jensen, S. Agrawal. Persistence Software: Bridging Object-Oriented Programming and Relational Databases. SIGMOD, 1993.
• 26: Keene, C. Data Services for Next-Generation SOAs. SOA WebServices Journal, 4(12), 2004.
• 27: Krishnamurthy, V., Banerjee, S., Nori, A. Bringing Object-Relational Technology to Mainstream. SIGMOD, 1999.
• 28: The LINQ Project. http://msdn.microsoft.com/library/enus/dndotnet/html/linqprojectovw.asp
• 29: LLBLGen Pro O/R Mapper -- Generator. www.llblgen.com
• 30: Microsoft BizTalk Server. www.microsoft.com/biztalk/
• 31: Meijer, E., Beckman, B., Bierman, G. M. LINQ: Reconciling Objects, Relations and XML in the .NET Framework. SIGMOD, 2006.
• 32: Melnik, S., Adya, A., Bernstein, P. A. Compiling Mappings to Bridge Applications and Databases. SIGMOD, 2007.
• 33: Oracle TopLink. www.oracle.com/technology/products/ias/toplink/
• 34: M. Roth , M. A. Hernandez , P. Coulthard , L. Yan , L. Popa , H. C.-T. Ho , C. C. Salter, XML Mapping technology: making connections in an XML-centric world, IBM Systems Journal, v.45 n.2, p.389-409, January 2006
• 35: SDO, http://www.osoa.org/display/Main/Service+Data+Objects+Home
• 36: Unified Modeling Language. http://www.uml.org/
• 37: Zhang, W., Ritter, N. The Real Benefits of Object-Relational DB-Technology for Object-Oriented Software Development. In BNCOD, 2001.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT

Additional Classification:
  D. Software
  D.3 PROGRAMMING LANGUAGES

General Terms:
Algorithms, Design, Languages, Management

Keywords:
ADO.NET, conceptual modeling, data programming