CN102841783A - Delphi-based three-layer database system implementation method - Google Patents
Delphi-based three-layer database system implementation method Download PDFInfo
- Publication number
- CN102841783A CN102841783A CN2011101723381A CN201110172338A CN102841783A CN 102841783 A CN102841783 A CN 102841783A CN 2011101723381 A CN2011101723381 A CN 2011101723381A CN 201110172338 A CN201110172338 A CN 201110172338A CN 102841783 A CN102841783 A CN 102841783A
- Authority
- CN
- China
- Prior art keywords
- data
- assembly
- client
- delphi
- layer
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Abstract
The invention discloses a Delphi-based three-layer database system implementation method. With the development of middleware and Web technology, three-layer or multi-layer distributed application systems become more and more popular. The middleware, as the key technology of the distributed system applications, gives powerful impetus to various distributed applications based on own special advantages, and greatly boosts the development of integration of the application systems. The method is used for implementing a high-efficiency connection and operation for visiting the database information based on the three-layer structure of the Delphi middleware.
Description
Technical field
The present invention relates to the exploitation of database application system, through the distinctive database application of realization that can be efficient, safe based on the realization of the three layer data storehouse systems of Delphi.
Background technology
In the current database application system, be divided into two types by its structure, one type is the database application system of double-layer structure, and another kind of is the database application system of sandwich construction.The database application system of double-layer structure comprises client/server (C/S) pattern and browser/server (B/S) pattern, and its feature is that data are separated with program, the database server side management data; Client computer or browser display, visit and Update Information, therefore can develop respectively and safeguard, also reduced the workload of database server simultaneously; Reduced the flow of network, had stronger security, but when client-side program or browser more for a long time; The performance of server can obviously descend; And applied logic is installed on each client computer, if system will upgrade, just can only carry out one by one client computer; If client computer is distributed in different places, maintenance and upgrading task will be very heavy.In order to solve the deficiency of double-layer structure application system, people have proposed the tactic pattern of multi-layered database application system, and representative is three-decker.
Summary of the invention
To above deficiency, the objective of the invention is to propose a kind of implementation method of three layer data storehouse systems based on Delphi, be that a kind of standard engine ADO of the Microsoft of utilization access general data source operates.
Application server is a teledata module, and it is a COM program, and it is connected with database server with SQL statement through ADO.It is responsible for from the database server access data and through the DataSetProvider assembly data being divided into packet, is delivered to the client on the network through the DCOM agreement then.The assembly of client is responsible for restoring data, and this work is accomplished by DCOMConnection.The ClientDataSet assembly is a client data collection assembly; It is responsible for receiving the data that the reduction of DCOMConnection assembly is come; And give the client data processing components data transfer; Client data is handled and display module mainly contains ADOQuery, ADOTable, DataSource, DBGrid, DBEdit, DBComboBox or the like, and conversely, the ClientDataSet assembly is responsible for collecting the data of client process; And the data submission DCOMConnection assembly after handling, this assembly correctly writes database with data through DCOM agreement and application server.
Embodiment
At first set up application server programs and on forms, add ADOConnection1, ADOTable1, DataSource, four assemblies of DBGrid1, the attribute of these four assemblies is set.Preserve All Files, item file is called AppServer, and unit file is called Server1.A newly-built teledata module (RemoteData Module), type of setting is called rdstu, in its Uses clause, adds Server1, and the rdstu module just can have been visited the assembly of Server1 the inside like this.In module, add assembly DataSetProvider, the DataSet attribute that it is set is Form1.Table1, can local data be read on the dcom server like this, and offer client by the DataSetProvider assembly.Preserve unit file, called after Server2.
Next is a newly-built application program, on forms, adds assemblies such as DCOMConnection1, ClientDataSet1, DataSource1, DBGrid1, DBNavigator1.The ComputerName attribute that DCOMConnection1 is set is the computer name at server place, and program can be sought server on network like this, if book server then is not provided with the ComputerName attribute in the registration of this machine; The ServerName attribute that it is set is AppServer.rdstu; The Connected attribute is True, at this moment the activation server program.The RemoteServer attribute that ClientDataSet1 is set is DCOMConnection1; The ProviderName attribute is DataSetProvider1.ClientDataSet1 just can be through DCOMConnection1 from DataSetProvider1 assembly reading of data like this.The DataDet attribute of DataSource1 is set to ClientDataSet1.The DataSource attribute of DBGrid1 and DBNavigator1 is set to DataSource1.
Three layers of C/S structure have hardware system formation more flexibly, can select the hardware that adapts with its processing load and treatment characteristic for each layer.Reasonably cut apart three-decker and make it independent, can make the structure of system become simply clear, improved the maintainability of program.In three layers of C/S structure, each of application layer can concurrent development, and each layer also can be selected optimal separately development language, helps change and maintenance application technical manual.Make the processing logic of each program become very simple by layer dividing function.In Delphi, mainly realize through technology such as DataSnap.
Claims (2)
1. implementation method based on the three layer data storehouse systems of Delphi: it is characterized in that application server is a teledata module, it is a COM program, and it is connected with database server with SQL statement through ADO.It is responsible for from the database server access data and through the DataSetProvider assembly data being divided into packet, is delivered to the client on the network through the DCOM agreement then.The assembly of client is responsible for restoring data, and this work is accomplished by DCOMConnection.
2. according to claim 1; Implementation method based on the three layer data storehouse systems of Delphi; It is characterized in that the ClientDataSet assembly is a client data collection assembly; It is responsible for receiving the data that the reduction of DCOMConnection assembly is come, and gives the client data processing components data transfer, and client data is handled and display module mainly contains ADOQuery, ADOTable, DataSource, DBGrid, DBEdit, DBComboBox or the like; Conversely; The ClientDataSet assembly is responsible for collecting the data of client process, and submits the data after handling to the DCOMConnection assembly, and this assembly correctly writes database with data through DCOM agreement and application server.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2011101723381A CN102841783A (en) | 2011-06-24 | 2011-06-24 | Delphi-based three-layer database system implementation method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2011101723381A CN102841783A (en) | 2011-06-24 | 2011-06-24 | Delphi-based three-layer database system implementation method |
Publications (1)
Publication Number | Publication Date |
---|---|
CN102841783A true CN102841783A (en) | 2012-12-26 |
Family
ID=47369188
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN2011101723381A Pending CN102841783A (en) | 2011-06-24 | 2011-06-24 | Delphi-based three-layer database system implementation method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN102841783A (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104090874A (en) * | 2013-04-01 | 2014-10-08 | 北京畅游天下网络技术有限公司 | Management method and system of cross-platform data |
CN111724262A (en) * | 2020-06-24 | 2020-09-29 | 上海金仕达软件科技有限公司 | Follow-up packet query system of application server and working method thereof |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070061379A1 (en) * | 2005-09-09 | 2007-03-15 | Frankie Wong | Method and apparatus for sequencing transactions globally in a distributed database cluster |
CN101013435A (en) * | 2007-02-05 | 2007-08-08 | 浪潮乐金信息系统有限公司 | Three-layer implementation method for JDBC-ODBC drive |
-
2011
- 2011-06-24 CN CN2011101723381A patent/CN102841783A/en active Pending
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20070061379A1 (en) * | 2005-09-09 | 2007-03-15 | Frankie Wong | Method and apparatus for sequencing transactions globally in a distributed database cluster |
CN101013435A (en) * | 2007-02-05 | 2007-08-08 | 浪潮乐金信息系统有限公司 | Three-layer implementation method for JDBC-ODBC drive |
Non-Patent Citations (1)
Title |
---|
邵泳兵: "基于Delphi的三层数据库系统的实现方法", 《广西轻工业》 * |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104090874A (en) * | 2013-04-01 | 2014-10-08 | 北京畅游天下网络技术有限公司 | Management method and system of cross-platform data |
CN104090874B (en) * | 2013-04-01 | 2018-01-26 | 北京畅游天下网络技术有限公司 | A kind of cross-platform data management method and system |
CN111724262A (en) * | 2020-06-24 | 2020-09-29 | 上海金仕达软件科技有限公司 | Follow-up packet query system of application server and working method thereof |
CN111724262B (en) * | 2020-06-24 | 2024-03-22 | 上海金仕达软件科技股份有限公司 | Subsequent package query system of application server and working method thereof |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US9508048B2 (en) | System and method for integrated real time reporting and analytics across networked applications | |
US20180068004A1 (en) | Systems and methods for automatic transferring of at least one stage of big data operations from centralized systems to at least one of event producers and edge devices | |
CN101120340B (en) | Ultra-shared-nothing parallel database | |
US20140156724A1 (en) | Propagation and adoption of extensions across applications in networked solutions | |
CN101261644A (en) | Method and device for accessing united resource positioning symbol database | |
CN104145257A (en) | Semantic cache cloud services for connected devices | |
CN103440301B (en) | A kind of data multi-duplicate hybrid storage method and system | |
WO2007028160A3 (en) | Database system and method for access control and workflow routing | |
CN102546707A (en) | Client information management method and management system | |
CN104320482A (en) | Bank teller front-end system | |
US20120197840A1 (en) | Push replication for use with a distributed data grid | |
Sokolov et al. | Database problems of maritime transport industry on high load platform | |
CN102724323A (en) | Efficient Internet of things (IOT) architecture based on multi-level disaster tolerance | |
CN101615270A (en) | A kind of based on the workflow analysis of B/S pattern and the system and method that presents | |
CN105095496A (en) | Method for monitoring MYSQL table space through ZABBIX | |
Nyrkov et al. | Databases problems for maritime transport industry on platform highload | |
KR20170053013A (en) | Data Virtualization System for Bigdata Analysis | |
CN102841783A (en) | Delphi-based three-layer database system implementation method | |
CN105550351B (en) | The extemporaneous inquiry system of passenger's run-length data and method | |
Yeh et al. | Analysis of E-government service platform based on cloud computing | |
CN101221584A (en) | Search engine, search method and system | |
CN104346678A (en) | High-efficiency legal service method capable of integrating service receiving with service management and high-efficiency legal service system | |
Yu et al. | Design of cloud computing and microservice-based urban rail transit integrated supervisory control system plus | |
US9092338B1 (en) | Multi-level caching event lookup | |
CN101834902A (en) | Front-end processor system and method for comprehensive management of remote power distribution room |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C05 | Deemed withdrawal (patent law before 1993) | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20121226 |