CN102779146A - Method and system for updating data in local database in real time - Google Patents
Method and system for updating data in local database in real time Download PDFInfo
- Publication number
- CN102779146A CN102779146A CN2012101264099A CN201210126409A CN102779146A CN 102779146 A CN102779146 A CN 102779146A CN 2012101264099 A CN2012101264099 A CN 2012101264099A CN 201210126409 A CN201210126409 A CN 201210126409A CN 102779146 A CN102779146 A CN 102779146A
- Authority
- CN
- China
- Prior art keywords
- data
- source address
- latest data
- latest
- local
- 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 Transfer Between Computers (AREA)
Abstract
The invention discloses a method and a system for updating data in a local database in real time. The method comprises the following steps: obtaining the latest data from a network server; analyzing the latest data to obtain a source address corresponding to the latest data; judging whether the source address corresponding to the latest data exists or not; if yes, replacing original data by the latest data; and if not, adding the source address and latest data corresponding to the source address. According to the method provided by the invention, the data in the local database is updated in real time, so that a user can conveniently obtain the latest data, the efficiency of data updating is increased, the internal memory occupied by the data updating is reduced and the system speed is increased.
Description
Technical field
The present invention relates to data communication field, data in real time method for updating and system in particularly a kind of local data base.
Background technology
Because fast development of information technology, the world has got into the epoch of information, and information is numerous and jumbled, because information can be supported utilization for some crowd, thereby is regarded as a kind of resource, these information that can support utilization are claimed information.So-called information broadcasting system also is image-text information broadcasting system, is for traditional television broadcast system.Traditional video broadcast system is a main task to broadcast movable television image and sound accompaniment all, and information broadcasting system is to be major-minor with dynamic image with literal, figure, chart, propagates the system of various information.It can independently accomplish the broadcast of a television channel (information channel, TV shopping channel), also can be attached in traditional broadcast system, increases the broadcast quantity of information of channel.Existing information broadcasting system has following characteristic: 1, picture, video, on roll, a left side flies, the animation footmark with screen broadcast 2, multirow information real time modifying broadcasts 3 in real time, all kinds of TV column templates of customizing; The column packing directly applies mechanically 4, board-like versatile and flexible; Can set a plurality of advertisement position 5 arbitrarily, unlimited layer captions can add a large amount of display advertising information and animation file in stack 6, the advertisement show window in real time; And title and Word message 7 can be arranged in every advertising message, can broadcast Financial Information simultaneously; Exchange rate window, stock market's wind and cloud, weather forecast etc.
Realize in the process of the present invention the inventor; Finding has following defective in the prior art: when information broadcasting system is play; Usually the data of playing are to be stored in earlier in the database; Be provided with again and then play or obtain the database of Data Update, play again to information broadcasting system from network data provider, and how to make data in the information broadcasting system database can real-time update and synchronous playing be exactly the problem that we will solve.
Summary of the invention
To defective of the prior art, the invention solves the problem that data in real time is upgraded in the local data base.
The invention provides data in real time method for updating in a kind of local data base in order to solve above technical matters, specifically comprise:
Obtain latest data from the webserver;
Said latest data is analyzed, obtained and the corresponding source address of said latest data;
Judge whether the corresponding source address of said latest data exists, if, then with said latest data replacement raw data, if not, then add said source address and with the corresponding latest data of said source address.
Wherein, said obtain latest data from the webserver before, also comprise:
The temporal frequency of latest data is obtained in setting.
Wherein, saidly judge that whether the corresponding source address of said latest data exists, and specifically comprises:
To compare with the source address in the object table in corresponding source address of said latest data and the local data base; If have the pairing source address of said latest data in the object table in the local data base; Then said latest data is replaced raw data according to said source address; Upgrade, otherwise, said source address and pairing latest data are added in the object table of local data base into.
Wherein, said raw data abandons.
Wherein, said latest data is the XML file.
The present invention also provides the system that data in real time is upgraded in a kind of local data base, specifically comprises:
Acquisition module, analysis module and data update module, wherein,
Acquisition module is used for obtaining latest data from the webserver;
Analysis module is used for said latest data is analyzed, and obtains and the corresponding source address of said latest data;
Data update module is used to judge whether the corresponding source address of said latest data exists, if, then with said latest data replacement raw data, otherwise, add said source address and with the corresponding latest data of said source address.
Wherein, before the said acquisition module, also comprise module is set, be used to be provided with the temporal frequency of obtaining latest data.
Wherein, saidly judge that whether the corresponding source address of said latest data exists, and specifically comprises:
To compare with the source address in the object table in corresponding source address of said latest data and the local data base; If have the pairing source address of said latest data in the object table in the local data base; Then said latest data is replaced raw data according to said source address; Upgrade, otherwise, said source address and pairing latest data are added in the object table of local data base into.
Wherein, said raw data abandons.
Wherein, said latest data is the XML file.
Compared with prior art; The embodiment of the invention has the following advantages: through the real-time update to data in the local data base, made things convenient for user real time to obtain latest data, improved the efficient of Data Update; Reduced the internal memory that Data Update takies, elevator system speed.
Description of drawings
In order to be illustrated more clearly in the embodiment of the invention or technical scheme of the prior art; To do to introduce simply to the accompanying drawing of required use in embodiment or the description of the Prior Art below; Obviously, the accompanying drawing in describing below only is some embodiments of the present invention, for those of ordinary skills; Under the prerequisite of not paying creative work property, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1: be the process flow diagram of data in real time method for updating in a kind of local data base in the embodiment of the invention 1;
Fig. 2: the structural drawing that is the system that data in real time is upgraded in a kind of local data base in the embodiment of the invention 2.
Embodiment
To combine the accompanying drawing in the embodiment of the invention below, the technical scheme in the embodiment of the invention is carried out clear, intactly description, obvious described embodiment is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment among the present invention, those of ordinary skills are not making the every other embodiment that is obtained under the creative work prerequisite, all belong to the scope of the present invention's protection.
Data in real time method for updating in a kind of local data base is provided in the embodiment of the invention 1, as shown in Figure 1, may further comprise the steps:
Step S101 obtains latest data from the webserver, and said latest data is the XML file.
Step S102 analyzes said latest data, obtains and the corresponding source address of said latest data.
Step S103 judges whether the corresponding source address of said latest data exists, if, implementation step S104 then; If not, implementation step S105 then.
Step S104 is with said latest data replacement raw data.
Step S105, add said source address and with the corresponding latest data of said source address.
Step S104 and step S105 specifically comprise:
To compare with the source address in the object table in corresponding source address of said latest data and the local data base; If have the pairing source address of said latest data in the object table in the local data base; Then said latest data is replaced raw data according to said source address; Upgrade, otherwise, said source address and pairing latest data are added in the object table of local data base into;
Said raw data, the data that are capped after promptly upgrading abandon, and do not carry out reservation record.
Wherein, said obtain latest data from the webserver before, also comprise:
The temporal frequency of latest data is obtained in setting, can the temporal frequency that import latest data from the internet be set according to the demand that data are obtained.
The technical scheme of embodiments of the invention bring beneficial effect following: through real-time update to data in the local data base; Made things convenient for user real time to obtain latest data; Improve the efficient of Data Update, reduced the internal memory that Data Update takies, elevator system speed.
The system that data in real time is upgraded in a kind of local data base is provided in the embodiment of the invention 2, as shown in Figure 2, specifically comprise:
To compare with the source address in the object table in corresponding source address of said latest data and the local data base; If have the pairing source address of said latest data in the object table in the local data base; Then said latest data is replaced raw data according to said source address; Upgrade, otherwise, said source address and pairing latest data are added in the object table of local data base into.
Before the wherein said acquisition module, also comprise module is set, be used to be provided with the temporal frequency of obtaining latest data, can the temporal frequency that import latest data from the internet be set according to the demand that data are obtained.
Wherein, said raw data abandons, and the data that are capped after promptly upgrading abandon, and do not carry out reservation record.
The beneficial effect that the technical scheme of embodiments of the invention obtains is following: through the real-time update to data in the local data base; Made things convenient for user real time to obtain latest data; Improve the efficient of Data Update, reduced the internal memory that Data Update takies, elevator system speed.
Through the description of above embodiment, those skilled in the art can be well understood to the present invention and can realize through hardware, also can realize by the mode that software adds necessary general hardware platform.Based on such understanding; Technical scheme of the present invention can be come out with the embodied of software product, this software product can be stored in a non-volatile memory medium (can be CD-ROM, USB flash disk; Portable hard drive etc.) in; Comprise some instructions with so that computer equipment (can be personal computer, server, the perhaps network equipment etc.) carry out the described method of each embodiment of the present invention.
It will be appreciated by those skilled in the art that accompanying drawing is the synoptic diagram of a preferred embodiment, module in the accompanying drawing or flow process might not be that embodiment of the present invention is necessary.
It will be appreciated by those skilled in the art that the module in the device among the embodiment can be distributed in the device of embodiment according to the embodiment description, also can carry out respective change and be arranged in the one or more devices that are different from present embodiment.The module of the foregoing description can be merged into a module, also can further split into a plurality of submodules.
The invention described above embodiment sequence number is not represented the quality of embodiment just to description.
More than disclosedly be merely several specific embodiment of the present invention, still, the present invention is not limited thereto, any those skilled in the art can think variation all should fall into protection scope of the present invention.
Claims (10)
1. data in real time method for updating in the local data base is characterized in that, comprising:
Obtain latest data from the webserver;
Said latest data is analyzed, obtained and the corresponding source address of said latest data;
Judge whether the corresponding source address of said latest data exists, if, then with said latest data replacement raw data, if not, then add said source address and with the corresponding latest data of said source address.
2. the method for claim 1 is characterized in that, said obtain latest data from the webserver before, also comprise:
The temporal frequency of latest data is obtained in setting.
3. the method for claim 1 is characterized in that, saidly judges that whether the corresponding source address of said latest data exists, and specifically comprises:
To compare with the source address in the object table in corresponding source address of said latest data and the local data base; If have the pairing source address of said latest data in the object table in the local data base; Then said latest data is replaced raw data according to said source address; Upgrade, otherwise, said source address and pairing latest data are added in the object table of local data base into.
4. like claim 1 or 3 described methods, it is characterized in that said raw data abandons.
5. like any described method in the claim 1 to 3, it is characterized in that said latest data is the XML file.
6. the system that data in real time is upgraded in the local data base is characterized in that, comprises acquisition module, analysis module and data update module, wherein,
Acquisition module is used for obtaining latest data from the webserver;
Analysis module is used for said latest data is analyzed, and obtains and the corresponding source address of said latest data;
Data update module is used to judge whether the corresponding source address of said latest data exists, if, then with said latest data replacement raw data, otherwise, add said source address and with the corresponding latest data of said source address.
7. method as claimed in claim 6 is characterized in that, before the said acquisition module, also comprises module is set, and is used to be provided with the temporal frequency of obtaining latest data.
8. method as claimed in claim 6 is characterized in that, saidly judges that whether the corresponding source address of said latest data exists, and specifically comprises:
To compare with the source address in the object table in corresponding source address of said latest data and the local data base; If have the pairing source address of said latest data in the object table in the local data base; Then said latest data is replaced raw data according to said source address; Upgrade, otherwise, said source address and pairing latest data are added in the object table of local data base into.
9. like claim 6 or 8 described methods, it is characterized in that said raw data abandons.
10. like any described method in the claim 6 to 8, it is characterized in that said latest data is the XML file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012101264099A CN102779146A (en) | 2012-04-26 | 2012-04-26 | Method and system for updating data in local database in real time |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012101264099A CN102779146A (en) | 2012-04-26 | 2012-04-26 | Method and system for updating data in local database in real time |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102779146A true CN102779146A (en) | 2012-11-14 |
Family
ID=47124062
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2012101264099A Pending CN102779146A (en) | 2012-04-26 | 2012-04-26 | Method and system for updating data in local database in real time |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102779146A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110457267A (en) * | 2019-07-26 | 2019-11-15 | 精英数智科技股份有限公司 | Method, apparatus, equipment and the storage medium of new data are extracted from backlog document |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1407475A (en) * | 2001-08-24 | 2003-04-02 | 前锦网络信息技术(上海)有限公司 | Synchronous updating personnel resume database method based on internet |
| US6570849B1 (en) * | 1999-10-15 | 2003-05-27 | Tropic Networks Inc. | TDM-quality voice over packet |
| US20050163117A1 (en) * | 2004-01-28 | 2005-07-28 | Samsung Electronics Co., Ltd | System-on-chip establishing paths between routers and method therefor |
| CN1735049A (en) * | 2004-08-02 | 2006-02-15 | 中兴通讯股份有限公司 | Address learning method based on station point information in resilient packet ring |
| CN101212426A (en) * | 2006-12-27 | 2008-07-02 | 鸿富锦精密工业（深圳）有限公司 | Network device and encapsulated packet transmission method |
| CN101763419A (en) * | 2009-12-28 | 2010-06-30 | 山东大学 | Method for synchronously updating remote rss data by local database |
-
2012
- 2012-04-26 CN CN2012101264099A patent/CN102779146A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6570849B1 (en) * | 1999-10-15 | 2003-05-27 | Tropic Networks Inc. | TDM-quality voice over packet |
| CN1407475A (en) * | 2001-08-24 | 2003-04-02 | 前锦网络信息技术(上海)有限公司 | Synchronous updating personnel resume database method based on internet |
| US20050163117A1 (en) * | 2004-01-28 | 2005-07-28 | Samsung Electronics Co., Ltd | System-on-chip establishing paths between routers and method therefor |
| CN1735049A (en) * | 2004-08-02 | 2006-02-15 | 中兴通讯股份有限公司 | Address learning method based on station point information in resilient packet ring |
| CN101212426A (en) * | 2006-12-27 | 2008-07-02 | 鸿富锦精密工业（深圳）有限公司 | Network device and encapsulated packet transmission method |
| CN101763419A (en) * | 2009-12-28 | 2010-06-30 | 山东大学 | Method for synchronously updating remote rss data by local database |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110457267A (en) * | 2019-07-26 | 2019-11-15 | 精英数智科技股份有限公司 | Method, apparatus, equipment and the storage medium of new data are extracted from backlog document |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6322836B2 (en) | System, method, and computer readable medium for determining program promotion outcomes | |
| CN104065979A (en) | Method for dynamically displaying information related with video content and system thereof | |
| CN103747301B (en) | Log file is play in a kind of advertisement placement method, system and storage advertisement | |
| US20170142463A1 (en) | Using cluster computing for generating personalized dynamic videos | |
| CN102780577A (en) | Method for detecting network fault | |
| CN103646340A (en) | A method for playing front-pasted advertisements in a cross-screen manner and a video system using the same | |
| KR20140022013A (en) | Determination of advertisement impact | |
| CN102497580B (en) | Video information synthesizing method based on audio feature information | |
| CN114422821A (en) | Live broadcast home page interaction method, device, medium and equipment based on virtual gift | |
| Lin | Market competitiveness of mobile TV industry in China | |
| CN103856817A (en) | Interactive play method and system of hypermedia | |
| CN106254931B (en) | Program commercial dissemination method and device based on IPTV | |
| CN103020847A (en) | Directional advertisement and information customization service management system based on specific two-dimensional code | |
| CN102779146A (en) | Method and system for updating data in local database in real time | |
| US20150089521A1 (en) | Data translation for video-viewing activity | |
| CN103150151A (en) | Constructing method and system of distributed type page of interactive television | |
| KR101856626B1 (en) | Creative production and play system Web type based DIY | |
| CN102769610A (en) | Method for selecting information from XML document | |
| JP5005782B2 (en) | Image generation system | |
| CN104683883A (en) | Method and device for generating playing strategy | |
| CN102724425B (en) | A kind of method that teletext template is broadcasted | |
| Sumartias et al. | Convergence Trends in the Television Media Industry-A Case Study on the Implementation of Media Convergence in Metro TV Jakarta | |
| CN116089757A (en) | Page display method and device, electronic equipment, storage medium and program product | |
| CN102768814A (en) | Method for synchronizing data import and broadcast | |
| US20140317655A1 (en) | Method for advertising based on audio/video content and method for creating an audio/video playback application |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20121114 |
|
| RJ01 | Rejection of invention patent application after publication |