CN102722514A - Method for creating database remotely and dynamically - Google Patents
Method for creating database remotely and dynamically Download PDFInfo
- Publication number
- CN102722514A CN102722514A CN2011104542335A CN201110454233A CN102722514A CN 102722514 A CN102722514 A CN 102722514A CN 2011104542335 A CN2011104542335 A CN 2011104542335A CN 201110454233 A CN201110454233 A CN 201110454233A CN 102722514 A CN102722514 A CN 102722514A
- Authority
- CN
- China
- Prior art keywords
- information
- user data
- user
- data
- 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.)
- Granted
Links
Images
Abstract
The invention discloses a method for creating a database remotely and dynamically. The method comprises the following steps: receiving user data packet information; receiving local data table information; judging whether user data packet name information is included in local data table name information; and feeding back the information that a request for creating a table for user data is completed to a user request client. Due to the adoption of the method provided by the invention, the problem for creating a database and database table in a remote center data server through sending data packet of a terminal display client is solved; the flexible operation performance of a data display template of each terminal display is enhanced; the data table content of the database of the data server is optimized through the operation of the display terminals towards the database of the data server; and the operation ability of the center main network of a display system and each display terminal is improved.
Description
Technical field
The present invention relates to the data exhibiting in LAN or in the data terminal, be applied to the data message issue and the interactive operation of TV station's business network, particularly a kind of Remote Dynamic is created the method for database.
Background technology
Continuous lifting along with the office automation requirement; Usually there are many workflow lines in office automation system inside, the customization of this workflow line and carry out and not only directly to have had influence on the output result, the distribution of the human and material resources that the while has also determined to match; In workflow line implementation; The each side data need collaborative work, and the action need of each XM draws through relevant nodal information judgement, as in logistics distribution field and television production field, field data being needed monitoring in real time; Thereby determine each resource of more efficiently configuration effort flow process line, thereby make work efficiency reach optimum.Generally, to above system requirements, meeting configuration data server in the centre data net; The LAN of each access terminal or visit conducts interviews to the data in the major network, thereby realizes the sharing of centre data, but along with the interpolation of each displaying terminal to indicating template; And each newly-increased displaying template different database list item of contrast usually, in order to satisfy above-mentioned since add indicating template thereupon needs in central database, increase the requirement of corresponding list, need pass through to the major network server operation; In central database, increase list to; Thereby realize calling of displaying terminal, but with in the upper type, the interpolation of each list all need be added operation back display terminal at the major network server and just can use; Limited to and showed the flexible operating of data terminal indicating template; Particularly under the situation that display terminal is on the increase, all need operate the maintenance of database at every turn, also significantly increase the number of operations of major network data server same data server; Meanwhile, increased the labile factor of data server.
Realize in the process of the present invention that the inventor finding has following defective in the prior art, each access terminal is directly added data form in the prior art; The data form that it added need add in the major network data server of center, and under the numerous situation of displaying terminal, or display terminal need carry out under the situation of frequent operation the data list; Need be to major network centre data server frequent operation; Be unfavorable on the one hand the terminal explicit user to the calling flexibly of data, simultaneously because to the frequent operation of major network centre data server, therefore; Influence data stability in the system, lowered the dirigibility of system simultaneously.
Summary of the invention
To defective of the prior art, the invention solves through the terminal and show the problem of the transmission packet of client at remote center's data server establishment database and database list.
The invention provides the method that a kind of Remote Dynamic is created database in order to solve above technical matters, specifically comprise:
The receiving subscriber data package informatin comprises in the said user data package informatin: user data package name information, user data item quantity information reach corresponding user data association information with it;
Receive local data table information, comprise at least in this information: local data table name information and the local data item quantity information corresponding with its tables of data;
Judge whether said user data package name information is present in the local data table name information; If; Judge then whether said local data item quantity is consistent with said user data item quantity, if, then according to the corresponding local data association of upgrading of said user data item data message; If not, then return user data table and had information to the user data package transmitting terminal;
Judge whether said user data package name information is present in the local data table name information; If not; Then confirm that according to said user data package name information user's newdata table name claims; Confirm user's newdata literary name hop count amount according to said user data item quantity, and import said user data item data message, obtain local newdata table according to newly-built field.
Return user data to the user request end and build table request completion information, comprise said local newdata table information in this information.
Wherein, receiving subscriber data bag step also specifically comprises: the receiving subscriber data bag, said packet is encrypted according to AES.
Wherein, also specifically comprise in the said receiving subscriber data bag step: receiving subscriber data bag decipherment algorithm; According to said user data package decipherment algorithm said user's bag is deciphered.
Wherein, Saidly confirm that according to said user data package name information user's newdata table name claims; Confirm user's newdata literary name hop count amount according to said user data item quantity; And import said user data item data message according to newly-built field, obtain that step also specifically comprises in the local newdata table: obtain user data visit LAN Information according to said user data package informatin; Confirm that according to said user data package name information user's newdata table name claims; Confirm user's newdata literary name hop count amount according to said user data item quantity; And import said user data item data message according to newly-built field; According to said user data visit LAN Information specified data table source-information, obtain local newdata table.
Wherein, also specifically comprise in the reception local data table information step: receive local data table name information and the data table items information corresponding with it; Set up the local data tabulation based on said local data table name information and corresponding data table items information.
Wherein, Saidly judge whether said user data package name information is present in that step also specifically comprises in the local data table name information: judge whether said user data package title is present in the said local data tabulation, if judge then whether said local data item quantity is consistent with said user data item quantity; If, then according to the corresponding local data association of upgrading of said user data item data message; If not, then return user data table and had information to the user data package transmitting terminal.
Wherein, said returning to the user request end also specifically comprises after user data is built table request completion information step: generate the user based on described request completion information and create the table record table.
Wherein, Saidly judge whether said user data package name information is present in the local data table name information and also specifically comprise in the step: saidly judge whether said user data package is present in the user and creates in the table record table; If then return user data and build table and had information, if not to the user request end; Judge then whether said user data package title is present in said local data table; Judge then whether said local data item quantity is consistent with said user data item quantity, if, then according to the corresponding local data association of upgrading of said user data item data message; If not, then return user data table and had information to the user data package transmitting terminal.
Compared with prior art; The embodiment of the invention has the following advantages: through the processing of receiving subscriber data bag, according to the data message in the packet, in centre data data in server storehouse, set up new data form; And according to data supplementing or the newly-built operation of the selection of the form information in the existing database to user's list; The terminal shows that the user can be through sending packet, and the list that centre data data in server storehouse list is carried out in the database adds, therefore; Strengthened the ability of flexible operating of the data display template of each displaying terminal; And, optimized the database data list content in the data server, and then improved the service ability of display systems center major network and each displaying terminal through the operation of displaying terminal to the data server database.
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 synoptic diagram that a kind of Remote Dynamic is created the method for database in the embodiment of the invention 1;
Fig. 2: be the synoptic diagram that another kind of Remote Dynamic is created the method for database 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.
The method that provides a kind of Remote Dynamic to create database in the embodiment of the invention 1, as shown in Figure 1, may further comprise the steps:
S101: receiving subscriber data package informatin;
This step specifically comprises: the receiving subscriber data package informatin comprises in the said user data package informatin: user data package name information, user data item quantity information reach corresponding user data association information with it;
S102: receive local data table information;
This step specifically comprises: receive local data table information, comprise at least in this information: local data table name information and the local data item quantity information corresponding with its tables of data;
S103: whether judges packet name information is present in the local data table name information;
This step specifically comprises: judge whether said user data package name information is present in the local data table name information; If; Judge then whether said local data item quantity is consistent with said user data item quantity; If, then according to the corresponding local data association of upgrading of said user data item data message; If not, then return user data table and had information to the user data package transmitting terminal;
Judge whether said user data package name information is present in the local data table name information; If not; Then confirm that according to said user data package name information user's newdata table name claims; Confirm user's newdata literary name hop count amount according to said user data item quantity, and import said user data item data message, obtain local newdata table according to newly-built field;
S104: return user data and build table request completion information;
This step specifically comprises: return user data to the user request end and build table request completion information, comprise said local newdata table information in this information.
The method that provides another kind of Remote Dynamic to create database in the embodiment of the invention 2, as shown in Figure 2, may further comprise the steps:
S201: receiving subscriber data package informatin;
This step specifically comprises: step S2011: the receiving subscriber data bag; Step S2012: receiving subscriber data bag decipherment algorithm; The receiving subscriber data package informatin comprises in the said user data package informatin: user data package name information, user data item quantity information reach corresponding user data association information with it;
Receiving subscriber data bag step also specifically comprises: the receiving subscriber data bag, and said packet is encrypted according to AES;
Also specifically comprise in the said receiving subscriber data bag step: receiving subscriber data bag decipherment algorithm; According to said user data package decipherment algorithm said user's bag is deciphered;
Saidly confirm that according to said user data package name information user's newdata table name claims; Confirm user's newdata literary name hop count amount according to said user data item quantity; And import said user data item data message according to newly-built field, obtain that step also specifically comprises in the local newdata table:
Obtain user data visit LAN Information according to said user data package informatin;
Confirm that based on said user data package name information user's newdata table name claims; Confirm user's newdata literary name hop count amount based on said user data item quantity; And import said user data item data message based on newly-built field; Based on said user data visit LAN Information specified data table source-information, obtain local newdata table;
S202: receive local data table information;
This step specifically comprises: step S2021: receive local data table name information and the tables of data corresponding with it;
Item information; At least comprise in this information: local data table name information and the local data item quantity information corresponding with its tables of data;
Receive in the local data table information step and also specifically comprise: receive local data table name information and the data table items information corresponding with it; Set up the local data tabulation based on said local data table name information and corresponding data table items information;
S203: whether judges packet name information is present in the local data table name information;
This step specifically comprises: judge whether said user data package name information is present in the local data table name information; If; Judge then whether said local data item quantity is consistent with said user data item quantity; If, then according to the corresponding local data association of upgrading of said user data item data message; If not, then return user data table and had information to the user data package transmitting terminal;
Saidly judge whether said user data package name information is present in that step also specifically comprises in the local data table name information:
Judge whether said user data package title is present in the said local data tabulation; If; Judge then whether said local data item quantity is consistent with said user data item quantity, if, then according to the corresponding local data association of upgrading of said user data item data message; If not, then return user data table and had information to the user data package transmitting terminal;
Judge whether said user data package name information is present in the local data table name information; If not; Then confirm that according to said user data package name information user's newdata table name claims; Confirm user's newdata literary name hop count amount according to said user data item quantity, and import said user data item data message, obtain local newdata table according to newly-built field;
Saidly judge whether said user data package name information is present in the local data table name information and also specifically comprise in the step:
Saidly judge whether said user data package is present in the user and creates in the table record table; If then return user data and build table and had information, if not to the user request end; Judge then whether said user data package title is present in said local data table; Judge then whether said local data item quantity is consistent with said user data item quantity, if, then according to the corresponding local data association of upgrading of said user data item data message; If not, then return user data table and had information to the user data package transmitting terminal;
S204: return user data and build table request completion information;
This step specifically comprises: step S2041: generate the user and create the table record table; Return user data to the user request end and build table request completion information, comprise said local newdata table information in this information.
Said returning to the user request end also specifically comprises after user data is built table request completion information step: generate the user based on described request completion information and create the table record table.
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 (8)
1. the method for a Remote Dynamic establishment database is characterized in that, comprising:
The receiving subscriber data package informatin comprises in the said user data package informatin: user data package name information, user data item quantity information reach corresponding user data association information with it;
Receive local data table information, comprise at least in this information: local data table name information and the local data item quantity information corresponding with its tables of data;
Judge whether said user data package name information is present in the local data table name information; If; Judge then whether said local data item quantity is consistent with said user data item quantity, if, then according to the corresponding local data association of upgrading of said user data item data message; If not, then return user data table and had information to the user data package transmitting terminal;
Judge whether said user data package name information is present in the local data table name information; If not; Then confirm that according to said user data package name information user's newdata table name claims; Confirm user's newdata literary name hop count amount according to said user data item quantity, and import said user data item data message, obtain local newdata table according to newly-built field;
Return user data to the user request end and build table request completion information, comprise said local newdata table information in this information.
2. the method described in claim 1 is characterized in that, receiving subscriber data bag step also specifically comprises:
Receive user data package, said packet is encrypted based on AES.
3. the method described in claim 2 is characterized in that, also specifically comprises in the said receiving subscriber data bag step:
Receiving subscriber data bag decipherment algorithm;
According to said user data package decipherment algorithm said user's bag is deciphered.
4. the method described in claim 1; It is characterized in that; Saidly confirm that according to said user data package name information user's newdata table name claims; Confirm user's newdata literary name hop count amount according to said user data item quantity, and import said user data item data message, obtain that step also specifically comprises in the local newdata table according to newly-built field:
Obtain user data visit LAN Information according to said user data package informatin;
Confirm that according to said user data package name information user's newdata table name claims; Confirm user's newdata literary name hop count amount according to said user data item quantity; And import said user data item data message according to newly-built field; According to said user data visit LAN Information specified data table source-information, obtain local newdata table.
5. the method described in claim 1 is characterized in that, receives in the local data table information step also specifically to comprise:
Receive local data table name information and the data table items information corresponding with it;
Set up the local data tabulation based on said local data table name information and corresponding data table items information.
6. the method described in claim 5 is characterized in that, saidly judges whether said user data package name information is present in that step also specifically comprises in the local data table name information:
Judge whether said user data package title is present in the said local data tabulation; If; Judge then whether said local data item quantity is consistent with said user data item quantity, if, then according to the corresponding local data association of upgrading of said user data item data message; If not, then return user data table and had information to the user data package transmitting terminal.
7. the method described in claim 1 is characterized in that, said returning to the user request end also specifically comprises after user data is built table request completion information step:
Generate the user according to described request completion information and create the table record table.
8. the method described in claim 7 is characterized in that, saidly judges whether said user data package name information is present in the local data table name information and also specifically comprises in the step:
Saidly judge whether said user data package is present in the user and creates in the table record table, if,
Then returning user data to the user request end builds table and has had information; If not; Judge then whether said user data package title is present in said local data table; Judge then whether said local data item quantity is consistent with said user data item quantity, if, then according to the corresponding local data association of upgrading of said user data item data message; If not, then return user data table and had information to the user data package transmitting terminal.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110454233.5A CN102722514B (en) | 2011-12-30 | 2011-12-30 | A kind of method that Remote Dynamic creates database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201110454233.5A CN102722514B (en) | 2011-12-30 | 2011-12-30 | A kind of method that Remote Dynamic creates database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102722514A true CN102722514A (en) | 2012-10-10 |
| CN102722514B CN102722514B (en) | 2017-11-10 |
Family
ID=46948278
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201110454233.5A Active CN102722514B (en) | 2011-12-30 | 2011-12-30 | A kind of method that Remote Dynamic creates database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102722514B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110489467A (en) * | 2019-07-03 | 2019-11-22 | 深圳市九洲电器有限公司 | The collecting method and Related product of easy iteration |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100359482C (en) * | 2004-08-04 | 2008-01-02 | 上海宝信软件股份有限公司 | Dynamic monitoring system and method for data base list update |
| CN101046825A (en) * | 2007-04-18 | 2007-10-03 | 北京润乾信息系统技术有限公司 | Method for data input after report fill-in |
| CN101609462B (en) * | 2009-07-29 | 2011-05-18 | 孟小峰 | Task recognition system in spatial environment of personal data and method |
| CN102202073B (en) * | 2010-03-24 | 2014-05-07 | 杭州华三通信技术有限公司 | Distributed system and data synchronization method thereof |
-
2011
- 2011-12-30 CN CN201110454233.5A patent/CN102722514B/en active Active
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110489467A (en) * | 2019-07-03 | 2019-11-22 | 深圳市九洲电器有限公司 | The collecting method and Related product of easy iteration |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102722514B (en) | 2017-11-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102549557B (en) | For specialization, centralized, the robotization establishment of the media guidance of online content | |
| WO2019056640A1 (en) | Order processing method and device | |
| Giessmann et al. | Mobile enterprise applications--current state and future directions | |
| CN101739439B (en) | Method and system for dynamically customizing statistical object based on template | |
| CN101478662A (en) | File content distributing method and apparatus | |
| CN101901146A (en) | Information processing apparatus and information processing method | |
| KR102203893B1 (en) | System for automating customer management using auto-call based on Artificial Intelligence and method thereof | |
| CN109309712A (en) | Data transmission method, server and the storage medium called based on interface asynchronous | |
| CN106301885A (en) | The method and system of uniform traffic management | |
| CN104901927A (en) | Method and device for business processing | |
| CN103647870A (en) | Terminal and terminal expression display method | |
| CN102567402A (en) | Electronic equipment and information processing method | |
| CN103593794A (en) | Method and apparatus for implementing information interaction | |
| CN102722512A (en) | Method for remotely maintaining and displaying database at database client | |
| US8903075B2 (en) | Customer/subscriber/user identification via utilized service node/point | |
| CN102137287A (en) | Television system capable of providing three-screen seamless fusion service | |
| US20120060096A1 (en) | Methods and Systems for Managing Support Cases Based on Support Issues Received by way of Social Media Outlets | |
| CN102722514A (en) | Method for creating database remotely and dynamically | |
| JP2012226017A (en) | Digital signage system and signage terminal management server | |
| EP4296922A1 (en) | Method and apparatus for determining logistics product, and electronic device and computer-readable medium | |
| CN115776486A (en) | Electronic file exchange method and system based on exchange node hierarchical grouping | |
| CN101291370B (en) | Method and system for guaranteeing dynamic service quality | |
| Shim et al. | The transformative effect of 5G on business and society in the age of the Fourth Industrial Revolution | |
| CN102413067A (en) | Techniques to support large numbers of subscribers to a real-time event | |
| CN105741136A (en) | Information processing system and using method thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |