CN107491562A - The method of Dynamic Announce web data attribute status - Google Patents
The method of Dynamic Announce web data attribute status Download PDFInfo
- Publication number
- CN107491562A CN107491562A CN201710876692.XA CN201710876692A CN107491562A CN 107491562 A CN107491562 A CN 107491562A CN 201710876692 A CN201710876692 A CN 201710876692A CN 107491562 A CN107491562 A CN 107491562A
- Authority
- CN
- China
- Prior art keywords
- data
- conditional code
- description information
- webpage
- main table
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/958—Organisation or management of web site content, e.g. publishing, maintaining pages or automatic linking
- G06F16/972—Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9535—Search customisation based on user profiles and personalisation
Abstract
The present invention relates to field of webpage design.The present invention solves the problems, such as that time-consuming during current multilist correlation inquiry, inquiry velocity is slow and server burden weight, it is proposed that a kind of method of Dynamic Announce web data attribute status, its technical scheme can be summarized as：Data dictionary is obtained from backstage, and is deposited into browser rs cache；When being shown to webpage data information, attribute data corresponding with the data message of webpage is then read in main table, when being shown to conditional code description information, will conditional code corresponding with conditional code description information and rule set as match parameter, matched in the data dictionary of browser rs cache, and the conditional code description information after matching is shown.The invention has the advantages that when carrying out info web and being shown, only corresponding attribute data need to be read in main table corresponding to it, it is not necessary to which server is won the title correlation inquiry, accelerates inquiry velocity, and then reduces the stand-by period, improves Consumer's Experience.
Description
Technical field
The present invention relates to the technology of webpage design technology, more particularly to Dynamic Announce web data attribute status.
Background technology
In current Internet technology, during the displaying to data, base categories can be carried out.And to these classifications
Description, we are typically made a distinction with conditional code, and different classifications is different states, such as：On business website, it can distribute
Goods address：Shanghai, Beijing, Sichuan；Meeting room reservation system, state, the account management such as have in not starting, carrying out, terminated
Have it is normal, the state such as disable, freeze.Selection for state, it can nearly all run into, according to different states, for its configuration
Corresponding conditional code, and each conditional code is also corresponding with the description information to the state, conditional code is convenient to inquire about data
And modification, and the description information of state is then with being mainly used in being presented to user in a manner of people is understood that.
During being stored to data, conditional code and context information should be all stored in, it is now general at present
There is following storage mode：
Mode 1,, will when newly-increased data are carried out if two fields are stored in same table of database
Corresponding relation between conditional code and the description information of conditional code, in one-time write front-end code, it will cause, conditional code with
The situation that the description information of state is bound completely, and can not change, the flexibility of data will substantially reduce, certainly, due to rear
The modification of phase, modification be not thorough or incorrect, it is easy to the situation of conditional code and word description entanglement occurs.If by two
Field is separately write, and a storage state code in main table, another table is using the description information of conditional code and state as corresponding relation.
Multilist correlation inquiry is carried out when inquiry, then last result is packaged into Query Result and passes to front end, like this, table
Data storage is more simple, when carrying out newly-increased data or modification, it is necessary to first reading state code and the corresponding relation of word description
It is shown, user is selected according to the word description seen, only needs to deposit conditional code again when finally preservation to main table
In, this mode, it is necessary to inquiry when, carry out a multilist correlation inquiry, add to a certain extent it is time-consuming, in property
Energy aspect can decrease.
Essentially consisted in for mode 1, data almost write extremely, in alterability and flexibility, be very restricted,
It is very heavy, this, for the maintenance workload of code, will be very big on the modification amount of front-end code if necessary to change
Burden, and if modification is careless, it will the situation of the description information entanglement of conditional code and state occur, also to a certain extent
Add the workload of investigation problem.
Mode 2, essentially consist in before data display is carried out, the processing for data is closed, it is necessary to increase a multilist
Joint investigation is ask, and is decreased, is added in time time-consuming in aspect of performance.And when being modified to data, it is desired nonetheless to right
Server is once asked, and is obtained the corresponding relation of conditional code and context information, is facilitated user in a manner of intelligible
Going selection needs the state changed, and the data of this corresponding relation, need to by inquiring about mapping table in database,
Also need to just increase server access request, it is more time-consuming, increase server stress, and if when network speed is bad, when
Between it is particularly evident in cost.
The content of the invention
It is an object of the invention to provide a kind of method of Dynamic Announce web data attribute status, solves current multilist association
The problem of time-consuming in query process, inquiry velocity is slow and server burden is heavy.
The present invention solves its technical problem, and the technical scheme of use is：The method of Dynamic Announce web data attribute status,
It is characterised in that it includes following steps：
Step 1, database program corresponding with needing the webpage that shows is divided into main table and data dictionary table, it is described each
The webpage data information for needing to show respectively corresponds to a main table, and it is corresponding to the data message of webpage that the main table is used for storage
Attribute data, the data dictionary table is used for the conditional code for dividing rule set to store each main table and corresponding conditional code description letter
Breath；
Step 2, from backstage data dictionary is obtained, and be deposited into browser rs cache；
Step 3, when being shown to webpage data information, then into step 4, show when to conditional code description information
When showing, then into step 5；
Step 4, attribute data corresponding with the data message of webpage is read in main table；
Step 5, will conditional code corresponding with conditional code description information and rule set as match parameter, in browser rs cache
Data dictionary in matched, and the conditional code description information after matching is shown.
Specifically, in step 2, data dictionary is obtained from backstage by ajax functions.
Further, in step 2, interface is set from the background, for acquisition of the front end to data dictionary.
Specifically, in step 5, filter function is have invoked in matching process.
Further, in step 5, when the rule set to main table is inquired about, will be advised according to the filter function of calling
Conditional code and conditional code description information under then collecting are shown on the page, and the state under the rule set is selected using choice box
Select, according to the result of selection, inquire the data of needs.
Specifically, when corresponding relation when conditional code and/or conditional code description information and/or between the two changes,
It is adjusted correspondingly by changing the data dictionary in browser rs cache or the interface by changing setting.
The invention has the advantages that by the method for above-mentioned Dynamic Announce web data attribute status, will be with needing to show
Database program corresponding to the webpage shown is divided into main table and data dictionary table, each needs the webpage data information shown respectively
A corresponding main table, main table are used to store attribute data corresponding with the data message of webpage, and data dictionary table is used for divider then
Collection stores the conditional code of each main table and corresponding conditional code description information, only need to be from it when progress info web is shown
Corresponding attribute data is read in corresponding main table, it is not necessary to which server is won the title correlation inquiry, accelerates inquiry velocity, and then subtract
Lack the stand-by period, improve Consumer's Experience.
Embodiment
With reference to embodiment, technical scheme is described in detail.
The method of Dynamic Announce web data attribute status of the present invention, is comprised the steps of：Will be with needing to show
Webpage corresponding to database program be divided into main table and data dictionary table, wherein, each need the webpage data information that shows equal
A main table is corresponded to respectively, and main table is used to store attribute data corresponding with the data message of webpage, and data dictionary table is used to divide
Rule set stores the conditional code of each main table and corresponding conditional code description information；Data dictionary is obtained from backstage, and is deposited into
In browser rs cache；When being shown to webpage data information, then read in main table corresponding with the data message of webpage
Attribute data, then will corresponding with conditional code description information conditional code and rule when being shown to conditional code description information
Collection is used as match parameter, is matched in the data dictionary of browser rs cache, and the conditional code description information after matching is entered
Row display.
Embodiment
The method of Dynamic Announce web data attribute status of the embodiment of the present invention, comprises the following steps：
Step 1, database program corresponding with needing the webpage that shows is divided into main table and data dictionary table, wherein, often
The individual webpage data information for needing to show respectively corresponds to a main table, and it is corresponding with the data message of webpage that main table is used for storage
Attribute data, data dictionary table are used for the conditional code for dividing rule set to store each main table and corresponding conditional code description information；
Step 2, interface is set from the background, for acquisition of the front end to data dictionary, obtained by ajax functions from backstage
Data dictionary, and being deposited into browser rs cache, wherein, data dictionary includes webpage all the elements, and with data dictionary table
It is corresponding；
Step 3, when being shown to webpage data information, then into step 4, show when to conditional code description information
When showing, then into step 5；
Step 4, attribute data corresponding with the data message of webpage is read in main table；
Step 5, will conditional code corresponding with conditional code description information and rule set as match parameter, call filter function
Matched in the data dictionary of browser rs cache, and the conditional code description information after matching is shown；When to main table
Rule set when being inquired about, the conditional code under rule set and conditional code description information are included according to the filter function of calling
On the page, the state under the rule set is selected using choice box, according to the result of selection, inquires the data of needs.
In the above method, corresponding relation when conditional code and/or conditional code description information and/or between the two changes
When, it is adjusted correspondingly by changing the data dictionary in browser rs cache or the interface by changing setting.
In practical application, by taking two aspects of conference status and account state as an example, the example is described in detail below：
Assuming that conference status is divided into 0, representative does not start, state 1, represents in carrying out, state 2, and representative has terminated；
Account state is divided into 0, and representative is freezed, state 1, represents normal.
We are stored in the description to state in the table of data dictionary, conditional code repeat it is not related because be divider then
Collection, now the rule set on meeting is meeting, and the rule set on account is account, other conditional codes and tool
The correspondence of body description also has in table and can clearly expressed.
Specifically needing show information place, can according to list conditional code carry out data list additions and deletions change look into and
Information displaying is not influenceed.The place of specifying information displaying, calls filter function filter (code, rule), and first parameter is
Current conditional code, it is assumed that being to carry out the displaying of account information, if code=0, rule=account is called, is pressed
Matched according to account rule sets, finally return to " account freezing ", the description of " account freezing " this details is illustrated in
In the page, the process of entire content filtering is just completed.Whole process, it is not necessary to fetch again according to when more carry out a multilist
Correlation inquiry, server is initiated again to ask without when being embodied and filtering, has reached mitigation server stress, accelerate to visit
Speed is asked, reduces the purpose of stand-by period.
Rule set conference status and conditional code under account state and its corresponding conditional code description information form are as follows：
| Rule set | Conditional code | Conditional code description information |
| meeting | 0 | Meeting does not start |
| meeting | 1 | During meeting is carried out |
| meeting | 2 | Meeting has terminated |
| account | 0 | Account freezing |
| account | 1 | Account is normal |
Claims (6)
1. the method for Dynamic Announce web data attribute status, it is characterised in that comprise the following steps：
Step 1, database program corresponding with the webpage for needing to show is divided into main table and data dictionary table, each needs
The webpage data information of display respectively corresponds to a main table, and the main table is used to store belong to corresponding with the data message of webpage
Property data, the data dictionary table is used for the conditional code for dividing rule set to store each main table and corresponding conditional code description information；
Step 2, from backstage data dictionary is obtained, and be deposited into browser rs cache；
Step 3, when being shown to webpage data information, then into step 4, shown when to conditional code description information
When, then into step 5；
Step 4, attribute data corresponding with the data message of webpage is read in main table；
Step 5, will conditional code corresponding with conditional code description information and rule set as match parameter, in the number of browser rs cache
According to being matched in dictionary, and the conditional code description information after matching is shown.
2. the method for Dynamic Announce web data attribute status according to claim 1, it is characterised in that in step 2, lead to
Cross ajax functions and obtain data dictionary from backstage.
3. the method for Dynamic Announce web data attribute status according to claim 1, it is characterised in that in step 2, after
Platform sets interface, for acquisition of the front end to data dictionary.
4. the method for Dynamic Announce web data attribute status according to claim 1, it is characterised in that in step 5,
Filter function is have invoked during matching somebody with somebody.
5. the method for Dynamic Announce web data attribute status according to claim 4, it is characterised in that in step 5, when
When inquiring about the rule set of main table, according to the filter function of calling by the conditional code under rule set and conditional code description information
It is shown on the page, the state under the rule set is selected using choice box, according to the result of selection, inquires needs
Data.
6. the method for the Dynamic Announce web data attribute status according to claim 1-5 any one, it is characterised in that
When corresponding relation when conditional code and/or conditional code description information and/or between the two changes, delayed by changing browser
Data dictionary in depositing or the interface by changing setting are adjusted correspondingly.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710876692.XA CN107491562A (en) | 2017-09-25 | 2017-09-25 | The method of Dynamic Announce web data attribute status |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710876692.XA CN107491562A (en) | 2017-09-25 | 2017-09-25 | The method of Dynamic Announce web data attribute status |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107491562A true CN107491562A (en) | 2017-12-19 |
Family
ID=60652006
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710876692.XA Pending CN107491562A (en) | 2017-09-25 | 2017-09-25 | The method of Dynamic Announce web data attribute status |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107491562A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108153877A (en) * | 2017-12-26 | 2018-06-12 | 平安科技（深圳）有限公司 | Data dictionary methods of exhibiting, device, terminal device and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020026440A1 (en) * | 2000-08-18 | 2002-02-28 | Mark Nair | System and method for an interactive shopping news and price information service |
| CN102004766A (en) * | 2010-11-09 | 2011-04-06 | 北京神州泰岳软件股份有限公司 | Query method and system for configurable information based on information system |
| CN103345507A (en) * | 2013-07-04 | 2013-10-09 | 江西交通咨询公司 | Three-dimensional map dynamic loading method based on collision box principle |
-
2017
- 2017-09-25 CN CN201710876692.XA patent/CN107491562A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020026440A1 (en) * | 2000-08-18 | 2002-02-28 | Mark Nair | System and method for an interactive shopping news and price information service |
| CN102004766A (en) * | 2010-11-09 | 2011-04-06 | 北京神州泰岳软件股份有限公司 | Query method and system for configurable information based on information system |
| CN103345507A (en) * | 2013-07-04 | 2013-10-09 | 江西交通咨询公司 | Three-dimensional map dynamic loading method based on collision box principle |
Non-Patent Citations (2)
| Title |
|---|
| CSDN博客: "数据字典缓存解决方案", 《HTTPS://BLOG.CSDN.NET/LULIDAITIAN/ARTICLE/DETAILS/47340281》 * |
| 博客园: "数据字典的设计--4.DOM对象的ajax应用", 《HTTPS://WWW.CNBLOGS.COM/ZHSTUDY/P/7100926.HTML》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108153877A (en) * | 2017-12-26 | 2018-06-12 | 平安科技（深圳）有限公司 | Data dictionary methods of exhibiting, device, terminal device and storage medium |
| WO2019127772A1 (en) * | 2017-12-26 | 2019-07-04 | 平安科技（深圳）有限公司 | Data dictionary display method and device, terminal device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104123340B (en) | A kind of database divides table paging query method and system | |
| CN103678408B (en) | A kind of method and device of inquiry data | |
| CN107463635A (en) | The method and distributed NewSQL Database Systems of a kind of image data inquiry | |
| CN102033882B (en) | Method and system for storing performance data | |
| CN105243169B (en) | A kind of data query method and system | |
| CN107491549A (en) | A kind of data processing method and system | |
| CN103368986A (en) | Information recommendation method and information recommendation device | |
| CN107291779B (en) | Cache data management method and device | |
| CN109308296A (en) | A kind of generation method, device and the computer readable storage medium of business datum table | |
| CN103678365A (en) | Method, device and system for dynamically obtaining data | |
| CN102043859A (en) | Data updating method and device | |
| CN109299157A (en) | A kind of data export method and device of distributed big single table | |
| CN103902548B (en) | A kind of system and method and registration, ticket booking, net purchase system for accessing database | |
| CN107577749A (en) | A kind of management method of supplier | |
| CN104112010A (en) | Data storage method and device | |
| CN110852559A (en) | Resource allocation method and device, storage medium and electronic device | |
| CN109587232A (en) | Document breakpoint transmission method based on iOS network | |
| CN107153683B (en) | Method and device for realizing data query | |
| CN108563776A (en) | Off-line data acquisition methods and system, server and storage medium | |
| CN107491562A (en) | The method of Dynamic Announce web data attribute status | |
| CN106453502A (en) | Member information management method and server | |
| CN107817971A (en) | The implementation method and ORM systems of ORM systems | |
| CN110381137A (en) | Object storage usage amount statistical method and system based on ceph | |
| CN109688422A (en) | A kind of method and device of video processing | |
| US8027869B2 (en) | Method and system for monitoring achievement and attainment and calculating compensation via time-based organization hierarchies |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171219 |