数据库编程经验（Database programming experience）.docVIP

数据库编程经验（Database programming experience） 1.OLE, DB, and ADO 2.5 are programming interfaces that provide common data access methods that have nothing to do with database servers. As a programming interface, OLE DB applies the theoretical concepts of the Microsoft universal data access (UDA) strategy to practice. UDA can access various types of data through a single programming interface based on COM, including relational, non relational, and hierarchical data. OLE DB is designed as a component technology and is characterized by a multi-layer model. On one side of the COM bridge is the server component for data retention, and the other side is the client components that understand how to connect and request data. The former is called OLE DB data provider, while the latter is called OLE DB user. Users and providers are COM objects and can communicate with each other through a set of COM interfaces. This COM based communication can be summarized as operations performed on abstract objects such as DataSource, Session, Command, and Rowset. Thus, this happens when a user connects to DataSource, opens Session, sends Command, and returns the data Rowset. The evolution of ODBC UDA and OLE DB to add a function, this function as a simple relational table, enterprise data all together, whether they are relational and non relational and hierarchical. Compared to ODBC, OLE DB relies less on data physical structure. In addition, it does not have to be strictly based on SQL. The OLE DB command can be a SQL statement, It could be something else. In general, you can think of them as text strings written in any syntax that can be understood by the target provider. Like ODBC, OLE DB uses the concept of C++ to design as much as possible to improve the performance of data access in the middle tier module. For the same reason, OLE DB cannot be used directly in Visual, Basicreg, or ASP. And countless distributed systems use Visual Basic to generate components. This is the main reason for th