CN106599014A - View data service management system and view display method thereof - Google Patents
View data service management system and view display method thereof Download PDFInfo
- Publication number
- CN106599014A CN106599014A CN201610782284.3A CN201610782284A CN106599014A CN 106599014 A CN106599014 A CN 106599014A CN 201610782284 A CN201610782284 A CN 201610782284A CN 106599014 A CN106599014 A CN 106599014A
- Authority
- CN
- China
- Prior art keywords
- viewdata
- view
- service
- management system
- content
- 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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
Abstract
The invention discloses a view data service management system and a view display method thereof. The system comprises a calling end, an agent layer, a service layer and a database; definition of a view data service resource is added into a view service management system; the view data service resource is previewed and published, and allowed to be accessed; the calling end introduces view data service resource ID and context parameters; a view service public interface of the data service management system is called through a client side API; definition information of the view data service resource is obtained; the service layer accesses the database according to the definition information of the view data service resource, obtains a result, and converts into a corresponding data structure according to a view data service resource definition specification; the data structure is encapsulated in a unified result data structure, and returned to the calling end; the calling end analyzes a feedback content, and fills the feedback content in a target container component; and thus, display of the view content is realized. By means of the view data service management system and the view display method thereof disclosed by the invention, standard definition and centralized management of the view data service resource are carried out; and thus, the system has standardability and stability.
Description
Technical field
The present invention relates to internet data technical field, specifically a kind of viewdata service management system and its view exhibition
Show method.
Background technology
Current data, services management, the scheme for generally adopting：1) note of interface is provided using ESB (ESB)
Volume and access control, realize the centralized management of data, services；2) great majority are all based on http communication, it is common to use standard Web
Service modes (XML codings), the self-defined mode of employing (JSON codings) of lightweight interacts communication；3) called side is led to
The mode crossed asynchronously or synchronously directly invokes service interface.
There is following major defect in prior art：(1) type classification is not carried out to data Service Source, does not provide right
The definition standard answered, is unfavorable for being managed concentratedly；(2) the management control of data-interface is only limitted to visible and invisible, does not wrap
Include definition, maintenance of docking port etc. deeply to manage；(3) do not provide about the specification called and method to called side, cause to lead to
The unstability of letter process.
The present invention is in order to solve the problems, such as in terms of viewdata Service Management：
(1) there is provided a kind of specification for defining viewdata Service Source；
(2) there is provided a kind of method by configuration means administration view data, services resource；
(3) there is provided a kind of method of stable access viewdata Service Source.
The content of the invention
It is an object of the invention to provide a kind of be easy to centralized management, the viewdata Service Management of normative and stability
System and its view methods of exhibiting, to solve the problems, such as above-mentioned background technology in propose.
For achieving the above object, the present invention provides following technical scheme：
A kind of viewdata service management system, including calling end, Agent layer, service layer, database,
Agent layer, for incoming viewdata Service Source ID and context parameters；Obtain viewdata Service Source
Definition information, calls service layer；The unified result data structure of feedback is received, and is returned to and is called end；
End is called, viewdata service request is initiated；The result of parsing Agent layer return simultaneously fills it into target container
Component, realizes the displaying of view content；
Service layer, for accessing database according to the definition information of viewdata Service Source, obtains result, and according to regarding
Diagram data Service Source definition standard is converted into corresponding data structure；
Database, for storing the related data information of viewdata Service Source.
As further scheme of the invention：End is called to include page end, Agent layer, client end AP I.
As further scheme of the invention：Target container component includes but is not limited to DIV, SPAN.
A kind of view methods of exhibiting of viewdata service management system, comprises the following steps：
(1) definition of viewdata Service Source is added in view service management system；
(2) the viewdata Service Source to defining carries out preview and issues, it is allowed to which it is accessed；
(3) page end for calling end calls Agent layer, incoming viewdata Service Source ID and context parameters；
(4) Agent layer services common interface by the view of client API Calls data, services management system；
(5) by incoming viewdata Service Source ID, the definition information of viewdata Service Source is obtained, calls clothes
Business layer；
(6) service layer accesses database according to the definition information of viewdata Service Source, obtains result, and according to view
The normative translation of data, services resource definition is into corresponding data structure；
(7) database can record invoked procedure, and statistics calls efficiency；
(8) service layer is encapsulated into view data structures in unified result data structure, and returns to the agency for calling end
Layer；
(9) result is fed back to Agent layer the page end for calling end；
(10) page end parsing feedback content, and target container component is filled into, realize the displaying of view content.
As further scheme of the invention：Viewdata Service Source is defined as two classes：Show that view and dictionary are regarded
Figure.
As further scheme of the invention：Show view：With the view that list or self-defined form show, can directly exist
Page end shows；Show the defined item of view：Subsystem, service identifiers, title, data source, type of database, data set class
Type, DSD, parameter declaration, per page of record number, every page of default records number, template header, main template body, template afterbody,
DISPLAY ORDER, creation time stamp, issued state.
As further scheme of the invention：Dictionary view：With the view that drop-down tabular form shows, can directly in webpage
End shows；The defined item of dictionary view：Subsystem, service identifiers, title, dictionary type, data source, type of database, data
Table, Sorted list, title bar, value row, screening conditions, parameter declaration, per page of record number, every page of default records number, template header,
Main template body, template afterbody, DISPLAY ORDER, creation time stamp, issued state.
As further scheme of the invention：The content body of viewdata resource is：Content headers, content body and interior
Hold afterbody.
As further scheme of the invention：Unified result data structure includes：Call state, content type, content item,
Record strip number, page number, per page of URL for recording number, redirecting that content is included.
As further scheme of the invention：The content item storage of unified result data structure is viewdata resource
Content body, content type is JSON objects.
Compared with prior art, the invention has the beneficial effects as follows：
The invention mainly relates to the technology such as JAVA, WEB exploitation, internet, database, data safety.Specifically include：
The technologies such as J2EE, http communication, JNDI, database connection pool, JavaScript, web front end.
It is an advantage of the current invention that：
(1) specification definition is carried out to viewdata Service Source and resource body content, and Service Source is concentrated
Management；
(2) it is deep to define viewdata Service Source, support preview, issue, deactivation, modification etc. there is provided configurationization mode
Enter management；
(3) a set of client end AP I is provided to call to hold, it is ensured that the specification for calling end to interact with service management system
Property and stability.
Description of the drawings
Fig. 1 is view methods of exhibiting flow chart of the present invention；
Fig. 2 is the structure chart of viewdata Service Source；
Fig. 3 is the schematic diagram of the present invention.
Specific embodiment
Below in conjunction with the embodiment of the present invention, the technical scheme in the embodiment of the present invention is clearly and completely described,
Obviously, described embodiment is only a part of embodiment of the invention, rather than the embodiment of whole.Based in the present invention
Embodiment, the every other embodiment that those of ordinary skill in the art are obtained under the premise of creative work is not made, all
Belong to the scope of protection of the invention.
Embodiment 1
In the embodiment of the present invention, a kind of view methods of exhibiting of viewdata service management system is comprised the following steps：
(1) operator adds the definition of viewdata Service Source in view service management system；
(2) the viewdata Service Source to defining carries out preview and issues, it is allowed to which it is accessed；
(3) page end for calling end calls Agent layer, incoming viewdata Service Source ID and context parameters；
(4) client API Calls data, services management system that Agent layer is provided by data, services management system is regarded
Figure service common interface；
(5) service management system obtains determining for viewdata Service Source by incoming viewdata Service Source ID
Adopted information, calls service layer；
(6) service layer accesses database according to the definition information of viewdata Service Source, obtains result, and according to view
The normative translation of data, services resource definition is into corresponding data structure；
(7) data, services management system can record invoked procedure, and statistics calls efficiency；
(8) service management system is encapsulated into view data structures in unified result data structure, and returns to and call end
Agent layer；
(9) result is fed back to Agent layer the page end for calling end；
(10) page end parsing feedback content, and it is filled into target container component (for example：DIV, SPAN), realize in view
The displaying of appearance.
The structure of viewdata Service Source, as shown in Figure 2：
(1) viewdata Service Source is defined as two classes：Show view and dictionary view.
(1.1) view is shown：With the view that list or self-defined form show, directly can show in page end.
Its defined item：Subsystem, service identifiers, title, data source, type of database, data set type, data set are fixed
Justice, parameter declaration, per page of record number, every page of default records number, template header, main template body, template afterbody, DISPLAY ORDER, wound
Build timestamp, issued state；
(1.2) dictionary view：With the view that drop-down tabular form shows, directly can show in page end.
Its defined item：Subsystem, service identifiers, title, dictionary type, data source, type of database, tables of data, sequence
Row, title bar, value row, screening conditions, parameter declaration, per page of record number, every page of default records number, template header, template master
Body, template afterbody, DISPLAY ORDER, creation time stamp, issued state.
(2) content body of viewdata resource is：Content headers, content body and content afterbody.
(3) data structure definition of unified result：The record strip for calling state, content type, content item, content to be included
Number, page number, per page of URL for recording number, redirecting.Wherein what content item was deposited is the content in (2), and content type is JSON pair
As.
(4) content (3) main body for accessing the return of viewdata Service Source is in fact webpage design template+data set filling
Content blocks (HTML) afterwards, directly can be shown on webpage.
The principle of the invention, refers to Fig. 3：
(1) for view service, its essence is exactly to perform SQL statement (SELECT FROM sentences) or process, obtains result
Collection, then result set is filled in the design template of view, and generation calls the end can be with the content blocks (HTML) of Direct Recognition, most
Returned to JSON forms eventually and call end, called end (page end) parsing wherein text block and be filled in target container component,
Realize the displaying of content blocks；
(2) in view of the problems such as multi-data source, the compatibility of disparate databases type and data set paging, for view
Data, services resource will not only define DSD (being exactly SQL statement or invocation of procedure sentence), in addition it is also necessary to define data source
(JNDI), type of database, data set type and paging information (per page of record number, every page of default records number)；Data, services pipe
Reason system passes through these definition informations it is known that how to go to connect database, according to which kind of type of database perform SQL or
Process, exports how many records；
(3) parameter of SQL or process is passed in data, services management system by calling end.For the ginseng in SQL
Number by placeholder (1～9) matched with the order of context parameters；For process parameter from the 3rd start with it is upper
Hereafter parameter the 1st is matched successively.
(4) view template mainly includes three parts：Template header, main template body and template afterbody.
Template content supports following data label：Train value label ([%=col (row name) %]), expression formula label ([%=
Exp (row name) %]), context parameters label ([%=ctx (context parameters index) %]).
Wherein there is no cyclic pac king in template header and afterbody, and context parameters label is included in template content；
There is cyclic pac king in main template body, cycle-index is the record number of data set, train value label is included in template content
With expression formula label.
(5) in template content label Substitution Rules：
(5.1) the row name in train value label can be matched with row name in result set, be replaced using end value after matching
All row name identical train value labels, are otherwise replaced with NUL in template.
(5.2) the row name in expression formula label can be matched with the row name in viewdata Service Source subitem, then be led to
Crossing the expression formula defined in subitem carries out the replacement values that script is calculated label.Type expression includes：Constant expression, on
Hereafter expression formula, SQL statement expression formula, IF expression, branch's expression formula.
(5.3) context parameters label directly obtains corresponding value by its parameter index value from context parameters array
As tag replacement value.
(6) in data, services management system, service is carried out by safeguarding the defined item of viewdata Service Source
Configurableization is managed, for example：Definition, adjustment data source, modification template content of modification data set etc.；
(7) because viewdata Service Source carries out unified definition, Service Management is changed into viewdata Service Source
The record management of definition, its operation includes：Newly-increased, modification, preview, disable, check details and deletion.
It is obvious to a person skilled in the art that the invention is not restricted to the details of above-mentioned one exemplary embodiment, Er Qie
In the case of spirit or essential attributes without departing substantially from the present invention, the present invention can be in other specific forms realized.Therefore, no matter
From the point of view of which point, embodiment all should be regarded as exemplary, and be nonrestrictive, the scope of the present invention is by appended power
Profit is required rather than described above is limited, it is intended that all in the implication and scope of the equivalency of claim by falling
Change is included in the present invention.
Moreover, it will be appreciated that although this specification is been described by according to embodiment, not each embodiment is only wrapped
Containing an independent technical scheme, this narrating mode of specification is only that for clarity those skilled in the art should
Using specification as an entirety, the technical scheme in each embodiment can also Jing it is appropriately combined, form those skilled in the art
Understandable other embodiment.
Claims (10)
1. a kind of viewdata service management system, it is characterised in that including calling end, Agent layer, service layer, database,
Agent layer, for incoming viewdata Service Source ID and context parameters；Obtain the definition of viewdata Service Source
Information, calls service layer；The unified result data structure of feedback is received, and is returned to and is called end；
End is called, viewdata service request is initiated；The result of parsing Agent layer return simultaneously fills it into target container component,
Realize the displaying of view content；
Service layer, for accessing database according to the definition information of viewdata Service Source, obtains result, and according to number of views
Corresponding data structure is converted into according to Service Source definition standard；
Database, for storing the related data information of viewdata Service Source.
2. viewdata service management system according to claim 1, it is characterised in that call end to include page end, generation
Reason layer, client end AP I.
3. viewdata service management system according to claim 1, it is characterised in that target container component is included but not
It is limited to DIV, SPAN.
4. a kind of view methods of exhibiting of the viewdata service management system as described in claim 1-3 is arbitrary, its feature exists
In comprising the following steps：
(1) definition of viewdata Service Source is added in view service management system；
(2) the viewdata Service Source to defining carries out preview and issues, it is allowed to which it is accessed；
(3) page end for calling end calls Agent layer, incoming viewdata Service Source ID and context parameters；
(4) Agent layer services common interface by the view of client API Calls data, services management system；
(5) by incoming viewdata Service Source ID, the definition information of viewdata Service Source is obtained, calls service
Layer；
(6) service layer accesses database according to the definition information of viewdata Service Source, obtains result, and according to viewdata
Service Source definition standard is converted into corresponding data structure；
(7) database can record invoked procedure, and statistics calls efficiency；
(8) service layer is encapsulated into view data structures in unified result data structure, and returns to the Agent layer for calling end；
(9) result is fed back to Agent layer the page end for calling end；
(10) page end parsing feedback content, and target container component is filled into, realize the displaying of view content.
5. the view methods of exhibiting of viewdata service management system according to claim 4, it is characterised in that number of views
It is defined as two classes according to Service Source：Show view and dictionary view.
6. the view methods of exhibiting of viewdata service management system according to claim 5, it is characterised in that displaying is regarded
Figure：With the view that list or self-defined form show, directly can show in page end；Show the defined item of view：Subsystem, clothes
Business mark, title, data source, type of database, data set type, DSD, parameter declaration, per page record number, per page
Default records number, template header, main template body, template afterbody, DISPLAY ORDER, creation time stamp, issued state.
7. the view methods of exhibiting of viewdata service management system according to claim 5, it is characterised in that dictionary is regarded
Figure：With the view that drop-down tabular form shows, directly can show in page end；The defined item of dictionary view：Subsystem, service mark
Knowledge, title, dictionary type, data source, type of database, tables of data, Sorted list, title bar, value row, screening conditions, parameter
Illustrate, per page record number, every page of default records number, template header, main template body, template afterbody, DISPLAY ORDER, creation time
Stamp, issued state.
8. the view methods of exhibiting of viewdata service management system according to claim 4, it is characterised in that number of views
It is according to the content body of resource：Content headers, content body and content afterbody.
9. the view methods of exhibiting of viewdata service management system according to claim 4, it is characterised in that unified knot
Fruit data structure includes：Call record strip number, page number that state, content type, content item, content included, per page of record number,
The URL for redirecting.
10. the view methods of exhibiting of viewdata service management system according to claim 9, it is characterised in that unified
What the content item of result data structure was deposited is the content body of viewdata resource, and content type is JSON objects.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610782284.3A CN106599014A (en) | 2016-08-31 | 2016-08-31 | View data service management system and view display method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610782284.3A CN106599014A (en) | 2016-08-31 | 2016-08-31 | View data service management system and view display method thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106599014A true CN106599014A (en) | 2017-04-26 |
Family
ID=58555986
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610782284.3A Pending CN106599014A (en) | 2016-08-31 | 2016-08-31 | View data service management system and view display method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106599014A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2000072197A2 (en) * | 1999-05-21 | 2000-11-30 | E-Numerate Solutions, Inc. | Reusable data markup language |
| CN101042751A (en) * | 2007-01-18 | 2007-09-26 | 北京佳讯飞鸿电气有限责任公司 | Implementing method and system for flexible and expandable dynamic statistics |
| CN102609256A (en) * | 2012-01-19 | 2012-07-25 | 北京神州数码思特奇信息技术股份有限公司 | Motion chart generating method based on webpages |
-
2016
- 2016-08-31 CN CN201610782284.3A patent/CN106599014A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2000072197A2 (en) * | 1999-05-21 | 2000-11-30 | E-Numerate Solutions, Inc. | Reusable data markup language |
| CN101042751A (en) * | 2007-01-18 | 2007-09-26 | 北京佳讯飞鸿电气有限责任公司 | Implementing method and system for flexible and expandable dynamic statistics |
| CN102609256A (en) * | 2012-01-19 | 2012-07-25 | 北京神州数码思特奇信息技术股份有限公司 | Motion chart generating method based on webpages |
Non-Patent Citations (4)
| Title |
|---|
| 张文康: ""地纬智能报表平台的设计与实现"", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
| 李广等: ""基于Silverlight的柔性生产报表系统的设计"", 《计算机工程与设计》 * |
| 杜嘉: ""呼叫中心自定义报表生成系统的设计与实现"", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
| 袁小珍: ""基于数据仓库的动态报表查询系统"", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107451296B (en) | A kind of Website Module rendering intent component-based | |
| US8700988B2 (en) | Selectively interpreted portal page layout template | |
| CN104573066B (en) | Page multiplexing method and device | |
| CN108763387A (en) | Big data fusion method, electronic equipment, storage medium and the system of heterogeneous platform | |
| CN101609399B (en) | Intelligent website development system based on modeling and method thereof | |
| CN106599015A (en) | Data service management system and method | |
| US20130007586A1 (en) | Method and system for creating and using web feed display templates | |
| KR20190039230A (en) | Method and system for server-side rendering of native content for presentations | |
| CN104714982A (en) | Method and system for loading webpage | |
| WO2008141432A1 (en) | Web page transcoding method and system applying queries to plain text | |
| CA2448787A1 (en) | Method and computer-readable medium for importing and exporting hierarchically structured data | |
| CN103176778B (en) | Web development methods and device | |
| CN104699748B (en) | It is a kind of to show the method and its system for being not fixed row report | |
| US20190065444A1 (en) | Techniques for efficient & high-throughput web content-creation | |
| CN103258015A (en) | Method for dynamically generating questionnaire based on XML | |
| CN103049536A (en) | Webpage main text content extracting method and webpage text content extracting system | |
| CN110222251A (en) | A kind of Service encapsulating method based on Web-page segmentation and searching algorithm | |
| CN105224544A (en) | A kind of data editing method of database and device | |
| CN104657123B (en) | A kind of method of dynamic export | |
| CN105740355B (en) | Webpage context extraction method and device based on aggregation text density | |
| CN109240784A (en) | A kind of the chart rendering method and system of memory object | |
| US20130007047A1 (en) | Method and system for managing a database having a plurality of tables | |
| CN106326403A (en) | Web page generating method and device | |
| CN102982138A (en) | Customer relation graphically showing method and device | |
| CN106599014A (en) | View data service management system and view display method thereof |
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 |
Application publication date: 20170426 |
|
| RJ01 | Rejection of invention patent application after publication |