CN101582071A - System and method for updating data - Google Patents
System and method for updating data Download PDFInfo
- Publication number
- CN101582071A CN101582071A CNA2008103015944A CN200810301594A CN101582071A CN 101582071 A CN101582071 A CN 101582071A CN A2008103015944 A CNA2008103015944 A CN A2008103015944A CN 200810301594 A CN200810301594 A CN 200810301594A CN 101582071 A CN101582071 A CN 101582071A
- Authority
- CN
- China
- Prior art keywords
- data
- updated
- database
- dynamic link
- link library
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a method for updating data, which comprises the following steps: generating an updating event to the data needed to be updated in a database according to a user request; triggering a trigger of a data table in which the data exists according to the generated updating event; controlling the triggered trigger to perform the updating event; executing a storing process in the database and transmitting updated data information to the storing process; calling a dynamic link library for connecting the database and an application system by the storing process and transmitting the updated data information to the dynamic link library; informing the application system to update the data by the dynamic link library; judging whether the data table in which the updated data exists is displayed on an operation interface; and updating the operation interface if the data table is not displayed on the operation interface. Besides, the invention also provides a system for updating the data.
Description
Technical field
The present invention relates to a kind of data update system and method.
Background technology
In today of office automation high speed development, Database Systems can be described as and have been employed maximum a kind of software.We in work and life in the applied system almost the system more than 90% can be referred to as Database Systems.These systems no matter be the Web type or multipad, they all have individual common characteristic: relate to database technology.The employing program reaches the function of safeguarding and preserving information data to operations such as database carry out that additions and deletions read to change.Its basic procedure is: system accepts user's operation; System connects database; Operations such as database carries out that additions and deletions read to change; And return results is to system interface.Under this typical case and traditional flow process are preserved always, and be in leading position in the evolution of Database Systems.
Along with the information consultation high speed development, system is more and more higher to the ageing requirement of data, and the customer requirements application system can reflect data up-to-date in the database.In the Web system, comprise JSF thus, a series of Web2.0 new technologies such as Ajax are arisen at the historic moment, and on multipad, have taked timer and so on mechanism to remove accessing database, have satisfied this demand to a great extent.But, no matter whether the data in the database are upgraded, the capital is Query Database periodically, increased the access of database number of times, so Query Database has repeatedly increased the load of database server, especially the bigger system of visit capacity greatly, to greatly reduce the performance of database server, even can cause server to work as machine.
Summary of the invention
In view of above content, be necessary to provide a kind of data update system, run in the computing machine, this computing machine comprises database, application system and the dynamic link library that connects this database and this application system, this database comprises tables of data and storing process, described tables of data comprises trigger, described computing machine also provides the operation interface of a described application system, described computing machine also comprises: execution module is used for according to customer requirements described database needs data updated being produced update event; Trigger module is used for triggering according to the update event that is produced the trigger of the existing tables of data of these data; Described execution module, also be used to control the trigger that is triggered and carry out described update event, also be used to carry out described storing process, and give described storing process with the data information transfer that is updated, control the described dynamic link library of this call stored procedure, and give this dynamic link library with the described data information transfer that is updated, and this dynamic link library of control notifies described application system to carry out Data Update; And judge module, be used to judge whether the tables of data at the described data place that is updated is shown in described operation interface, if be not shown on the described operation interface, then upgrade this operation interface.
In addition, also be necessary to provide a kind of data-updating method, this method comprises the steps: according to customer requirements needs data updated in the described database to be produced update event; Trigger the trigger of the existing tables of data of these data according to the update event that is produced; The trigger that control is triggered is carried out described update event; Carry out the storing process in this database, and give described storing process the data information transfer that is updated; This call stored procedure is used to connect the dynamic link library of database and application system, and gives this dynamic link library with the described data information transfer that is updated; This dynamic link library notifies described application system to carry out Data Update; Whether the tables of data of judging the described data place that is updated is shown on the described operation interface; And, then upgrade this operation interface if be not shown on the described operation interface.
Compared to prior art, described data update system and method, have only when data of database is upgraded, just remove Query Database, go to notify application system to upgrade the data of operation interface by dynamic link library, avoided traditional frequent Query Database, check whether this database has renewal, stop invalid unnecessary database access, improved the stability of application system operation.
Description of drawings
Fig. 1 is the hardware structure figure of data update system preferred embodiment of the present invention.
Fig. 2 is the functional block diagram of computing machine 1 among Fig. 1.
Fig. 3 is the operation process chart of data-updating method preferred embodiment of the present invention.
Embodiment
As shown in Figure 1, be the hardware structure figure of data update system preferred embodiment of the present invention.This system comprises computing machine 1, and this computing machine 1 comprises application system 2, database 3 and dynamic link library 4.This application system 2 can be book management system etc., and described database 3 can be SQL Sever database.Described application system 2 communicates by dynamic link library 4 with database 3, and the store path of this dynamic link library 4 is the catalogue of the System32 of Windows, perhaps is the execution catalogue of this database 3.Described computing machine 1 is used for the request Query Database 3 according to application system 2, also can be used for having only when the data in the database 3 are upgraded, just carry out Query Database 3, note institute's data updated information, and notify the data of described application system 2 to upgrade accordingly by described dynamic link library 4.Include a plurality of tables of data 5 in the described database 3, comprise at least one trigger 6 in each tables of data 5, this trigger 6 is triggered by the update event that needs data updated to produce in the described tables of data 5, this update event includes but not limited to upgrade, increase or delete in the described tables of data 5 data etc., described update event is carried out in this trigger 6 back that is triggered.Described database 3 also comprises storing process 7, and this storing process 7 is used to call described dynamic link library 4.This computing machine 1 also provides the operation interface of a described application system 2, is used to show the data query and the modification situation of described database 3, also is used to the tables of data 5 that shows that all users inquired about.
As shown in Figure 2, be the functional block diagram of computing machine 1 among Fig. 1.This system comprises: initialization module 10, enquiry module 12, execution module 14, trigger module 16, logging modle 18 and judge module 20.
Whether trigger 6 and storing process 7 that initialization module 10 is used for detecting database 3 exist, and read and load dynamic link library 4, show the operation interface of described application system 2.
Described execution module 14 also is used to control the trigger 6 that is triggered and carries out this update event.
Described execution module 14 also is used to carry out described storing process 7, and described data updated information passed to described storing process 7, this execution module 14 also is used to control this storing process 7 and calls described dynamic link library 4, and described data updated information is passed to this dynamic link library 4.
Described execution module 14 also is used to control this dynamic link library 4 and notifies described application system 2 to carry out Data Update.
As shown in Figure 3, be the operation process chart of data-updating method preferred embodiment of the present invention.
Step S30, whether trigger 6 and storing process 7 that initialization module 10 detects in the database 3 exist, and read and load dynamic link library 4, show the operation interface of described application system 2.
Step S32, enquiry module 12 receives the instruction that described application system 2 is sent Query Database 3, also be used for described database 3 is carried out query manipulation, and the result who returns described inquiry gives described application system 2.
Step S34 is according to the needs data updated generation update event of customer requirements to described database 3.Described update event comprises incidents such as newly-increased, the modification of data in this database 3 and deletions.
Step S36, after the update event that needs data updated in the described database 3 produced, trigger module 16 triggered the trigger 6 of the existing tables of data 5 of these data.
Step S38, the trigger 6 that described execution module 14 controls are triggered is carried out this update event.
Step S40, the described data message that is updated of logging modle 18 records.This data updated information comprises: the update mode of the address of the data that are updated in the described database 3 and the data of described database 3 etc.
Step S42, described execution module 14 is carried out described storing process 7, and described data updated information is passed to described storing process 7.
Step S44, these execution module 14 these storing processs 7 of control call described dynamic link library 4, and described data updated information is passed to this dynamic link library 4.
Step S46, described execution module 14 these dynamic link libraries 4 of control notify described application system 2 to carry out Data Update.
Step S48, judge module 20 are used to judge whether the tables of data at described data updated place is shown in described operation interface.If do not show the tables of data at described data updated place on the described operation interface, then return step S44, described execution module 14 notifies 2 pairs of these operation interfaces of described application system to upgrade, and increases the tables of data at described data updated place.
It should be noted last that, above embodiment is only unrestricted in order to technical scheme of the present invention to be described, although the present invention is had been described in detail with reference to preferred embodiment, those of ordinary skill in the art is to be understood that, can make amendment or be equal to replacement technical scheme of the present invention, and not break away from the spirit and scope of technical solution of the present invention.
Claims (6)
1. data update system, run in the computing machine, this computing machine comprises database, application system and the dynamic link library that connects this database and this application system, this database comprises tables of data and storing process, described tables of data comprises trigger, described computing machine also provides the operation interface of a described application system, it is characterized in that, described computing machine also comprises:
Execution module is used for according to customer requirements described database needs data updated being produced update event;
Trigger module is used for triggering according to the update event that is produced the trigger of the existing tables of data of these data;
Described execution module, also be used to control the trigger that is triggered and carry out described update event, also be used to carry out described storing process, and give described storing process with the data information transfer that is updated, control the described dynamic link library of this call stored procedure, and give this dynamic link library with the described data information transfer that is updated, and this dynamic link library of control notifies described application system to carry out Data Update; And
Judge module is used to judge whether the tables of data at the described data place that is updated is shown in described operation interface, if be not shown on the described operation interface, then upgrades this operation interface.
2. data update system as claimed in claim 1 is characterized in that, the described data message that is updated comprises: the address of the data that are updated in the described database and the described update mode that is updated data.
3. data update system as claimed in claim 1 is characterized in that, described computing machine also comprises: initialization module, be used to read and load dynamic link library, and show the operation interface of described application system.
4. a data-updating method is characterized in that, this method comprises the steps:
According to customer requirements needs data updated in the described database is produced update event;
Trigger the trigger of the existing tables of data of these data according to the update event that is produced;
The trigger that control is triggered is carried out described update event;
Carry out the storing process in this database, and give described storing process the data information transfer that is updated;
This call stored procedure is used to connect the dynamic link library of database and application system, and gives this dynamic link library with the described data information transfer that is updated;
This dynamic link library notifies described application system to carry out Data Update;
Whether the tables of data of judging the described data place that is updated is shown on the described operation interface; And
If be not shown on the described operation interface, then upgrade this operation interface.
5. data-updating method as claimed in claim 4 is characterized in that, the described data message that is updated comprises: the address of the data that are updated in the described database and the described update mode that is updated data.
6. data-updating method as claimed in claim 4, it is characterized in that, step according to customer requirements to described database in the needs data updated also comprise before producing update event: read and load dynamic link library, show the operation interface of described application system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008103015944A CN101582071A (en) | 2008-05-16 | 2008-05-16 | System and method for updating data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008103015944A CN101582071A (en) | 2008-05-16 | 2008-05-16 | System and method for updating data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101582071A true CN101582071A (en) | 2009-11-18 |
Family
ID=41364218
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2008103015944A Pending CN101582071A (en) | 2008-05-16 | 2008-05-16 | System and method for updating data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101582071A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2011157034A1 (en) * | 2010-06-18 | 2011-12-22 | 中兴通讯股份有限公司 | Method and device for realizing function of database trigger |
| CN103164445A (en) * | 2011-12-14 | 2013-06-19 | 深圳光启高等理工研究院 | Manual electromagnetic material design data base processing method |
| CN104462106A (en) * | 2013-09-17 | 2015-03-25 | 鸿富锦精密工业（深圳）有限公司 | Data updating method and system |
| CN104516877A (en) * | 2013-09-26 | 2015-04-15 | 江苏智软信息科技有限公司 | WEB application quickly releasing method |
| CN105141608A (en) * | 2015-08-25 | 2015-12-09 | 浪潮(北京)电子信息产业有限公司 | System and method for providing SaaS (Security as a Service) in cloud operating system |
| CN106156094A (en) * | 2015-04-01 | 2016-11-23 | 阿里巴巴集团控股有限公司 | The teledata synchronous method of a kind of data base and device |
| CN108431769A (en) * | 2016-01-21 | 2018-08-21 | 微软技术许可有限责任公司 | The database and service upgrade of no shutdown time |
| CN112035462A (en) * | 2020-07-21 | 2020-12-04 | 唐山钢铁集团有限责任公司 | Method for controlling automatic system to newly increase drawing width based on acid rolling process |
| CN113296822A (en) * | 2021-05-27 | 2021-08-24 | 北京思特奇信息技术股份有限公司 | Dynamic library-based database system online upgrading method and system |
-
2008
- 2008-05-16 CN CNA2008103015944A patent/CN101582071A/en active Pending
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2011157034A1 (en) * | 2010-06-18 | 2011-12-22 | 中兴通讯股份有限公司 | Method and device for realizing function of database trigger |
| CN103164445A (en) * | 2011-12-14 | 2013-06-19 | 深圳光启高等理工研究院 | Manual electromagnetic material design data base processing method |
| CN104462106A (en) * | 2013-09-17 | 2015-03-25 | 鸿富锦精密工业（深圳）有限公司 | Data updating method and system |
| CN104516877A (en) * | 2013-09-26 | 2015-04-15 | 江苏智软信息科技有限公司 | WEB application quickly releasing method |
| US10877990B2 (en) | 2015-04-01 | 2020-12-29 | Advanced New Technologies Co., Ltd. | Remote database synchronization |
| CN106156094A (en) * | 2015-04-01 | 2016-11-23 | 阿里巴巴集团控股有限公司 | The teledata synchronous method of a kind of data base and device |
| CN106156094B (en) * | 2015-04-01 | 2019-09-17 | 阿里巴巴集团控股有限公司 | A kind of the teledata synchronous method and device of database |
| CN105141608A (en) * | 2015-08-25 | 2015-12-09 | 浪潮(北京)电子信息产业有限公司 | System and method for providing SaaS (Security as a Service) in cloud operating system |
| CN108431769A (en) * | 2016-01-21 | 2018-08-21 | 微软技术许可有限责任公司 | The database and service upgrade of no shutdown time |
| CN108431769B (en) * | 2016-01-21 | 2021-09-17 | 微软技术许可有限责任公司 | Database and service upgrade without downtime |
| CN112035462A (en) * | 2020-07-21 | 2020-12-04 | 唐山钢铁集团有限责任公司 | Method for controlling automatic system to newly increase drawing width based on acid rolling process |
| CN113296822A (en) * | 2021-05-27 | 2021-08-24 | 北京思特奇信息技术股份有限公司 | Dynamic library-based database system online upgrading method and system |
| CN113296822B (en) * | 2021-05-27 | 2023-11-03 | 北京思特奇信息技术股份有限公司 | Online upgrading method and system for database system based on dynamic library |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101582071A (en) | System and method for updating data | |
| CN101090401B (en) | Data buffer store method and system at duster environment | |
| US8875306B2 (en) | Customization restrictions for multi-layer XML customization | |
| US8966465B2 (en) | Customization creation and update for multi-layer XML customization | |
| US8538998B2 (en) | Caching and memory optimizations for multi-layer XML customization | |
| US6820085B2 (en) | Web system having clustered application servers and clustered databases | |
| EP2605157B1 (en) | Change data capturing during an upgrade | |
| CN102436485B (en) | Dynamically splitting multi-tenant databases | |
| US6738775B2 (en) | Database communication system and method for communicating with a database | |
| US8788542B2 (en) | Customization syntax for multi-layer XML customization | |
| CA2616194C (en) | Revenue management system and method | |
| CN102142024A (en) | Logical data backup and rollback using incremental capture in a distributed database | |
| US20090204884A1 (en) | Multi-layer xml customization | |
| US20040111728A1 (en) | Method and system for managing metadata | |
| CN100527081C (en) | Computer processing system for implementing data update and data updating method | |
| CN103455526A (en) | ETL (extract-transform-load) data processing method, device and system | |
| CN104133783B (en) | Method and device for processing distributed cache data | |
| CN102355499B (en) | Cloud computing system | |
| CN102486734A (en) | Rich client application system | |
| CN100535863C (en) | Method and apparatus for realizing configuring affair | |
| CN100499853C (en) | Edition information processing method of inlaid distribution system | |
| CN109460409A (en) | Data access method and device | |
| CN102236707A (en) | Method, device and system for obtaining update data of database | |
| KR20090065416A (en) | System and method for providing integrated software management | |
| CN112035183A (en) | Access method and device for micro application |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20091118 |