Data source name

Abstract: The invention belongs to the casting workshop equipment information acquisition field and discloses a casting equipment data acquisition and storage method based on configuration software KingView anda PLC. The method comprises the following steps of S1, carrying out communication preparation; S2, setting an ODBC data source: setting the ODBC data source on a local PC to connect a remote databaseSQL Server, then, setting an ODBC data source name, selecting ODBC driving for connecting the remote database, and selecting a database name where data needs to be stored; S3, creating a remote datastorage table; S4, connecting the PLC and an upper computer; S5, exploiting a configuration frame; and S6, setting a data storage mechanism. In the invention, through the PLC and the upper computer software KingView, casting equipment data can be effectively read and stored, PLC connection modes are diversified, and according to an actual state, serial port connection and network port connection can be achieved.

Abstract: Microsoft has developed or patronized several technologies to access data from a wide range of data stores in order to comply with its universal data access strategy. Three such primary and interrelated technologies are ODBC, OLE DB, and ADO. Although ODBC is restricted to traditional SQL (structured query language) data stores, OLE DB provides universal data access. ODBC and OLE DB are low-level, complex interfaces between applications and data stores. Microsoft developed ADO to provide simple and easy-to-use interfaces for both traditional and nontraditional data stores. ADO is an OLE DB data consumer optimized for building both client/server and Web-based applications. This chapter blends theory with practical examples from Web-based applications that interact with data stores. Keywords: data source name; data stores; database server system; open database connectivity (ODBC); universal data access (UDA)

Abstract: The invention discloses a data inquiry method, a device and a service server integrated with multiple data sources. The method comprises the following steps: receiving a data inquiry request, whereinthe data inquiry request carries data attributes of data to be inquired; determining a target data source attribute according to a mapping relationship between a pre-configured data attribute and a data source attribute, wherein the data source attribute comprises a data source name and a field name; determining a target atomic interface of the target data source attribute mapping according to a pre-configured mapping relationship between the data source attribute and the atomic interface; according to the mapping relationship between the pre-configured atomic interface and the underlying data, the data being extracted from the underlying data mapped by the target atomic interface to obtain the data to be queried.

Abstract: The invention provides a database connection acquisition method and device based on a ThreadLocal connection container. The database connection acquisition method based on the ThreadLocal connection container comprises the steps: receiving a database connection acquisition request, and determining a data source name corresponding to a current access command; if the ThreadLocal connection container enables sharing, judging whether database connection corresponding to the data source name exists in a ThreadLocal connection container HashMap; if the database connection corresponding to the data source name exists in the ThreadLocal connection container HashMap, acquiring the database connection from the ThreadLocal connection container HashMap; if the database connection corresponding to the data source name does not exist in the ThreadLocal connection container HashMap, acquiring the database connection from a database connection pool, and putting the database connection into the ThreadLocal connection container HashMap; determining a data source name corresponding to a next access command. According to the database connection acquisition method and device based on the ThreadLocal connection container, connection can be prevented from being established from the database pool every time, the times of acquiring the database connection from the database pool is reduced, the use efficiency of the database connection is improved, the resource occupancy of the database connection pool is reduced, the database pressure is reduced, and the acquisition efficiency of the database connection is improved.