Analysis Of The Data Access Methods And Research Of Related Design Patterns

Data Access Method (DAM) is method for applications to access data or database.Its essence is the interface between applications and the database. Hundreds of DAMshas evolved during the decades of evolvement for the database industry; ESQL,ODBC, JDBC, ADO.NET, O/R Mapping, and LINQ are the most important ones ofthem. Present DAMs vary, and each has its own advantages and disadvantages andapplicable scope; one application can use different DAMs to access one database; onesystem may need to use multiple DAMs at the same time. In real projects, DAMchoosing is a vital issue.However, DAM choosing is not an easy problem. On one hand, for competitionreasons, database venders are introducing new technologies. Databases and DAMs arerapidly changing; Documents are not updated in time, and always contain viewpointsof the vender itself, which are not objective. On the other hand, since DAM choosinghasn’t high research value, the academic world is not motivated to systemize it, anddatabase-related teaching books around the world lack systematic introduction anddeep analysis on it. Thus, it is of significance to analyze the development track ofDAMs, systematically and neutrally organize major DAMs covering the principles,features and applicable scopes, perform qualitative and quantitative analysis ontypical DAMs, and provide tips for DAM choosing.Based on an analysis of the significance and necessity of studying DAM, thisthesis has3major works.1) Chapter2systematically organized various DAMs.Based on a large sum of source materials, DAMs are re-divided into4categories;overview diagram is used to describe the evolvement of DAM during the past40years; qualitative analysis are performed on mainstream DAMs.2) Chapter3performed experiments and quantitative analysis on3most frequently used DAMs.We believe such quantitative analysis may have briefer value of reference forpractitioners.3) Chapter4is a research on Data Access Patterns (DAP). DesignPattern is systematic experience solving specific problem at specific environment.This thesis introduces this concept to DAM choosing, discussed the categorizationand establishment of DAP, initially induced some DAP, and detailed the application ofusing a real project. We believe that the study in this thesis is of big practicalsignificance; it may also have some material value since relative materials are scattered.