CN107220274A - One kind visualization data-interface fairground implementation method - Google Patents
One kind visualization data-interface fairground implementation method Download PDFInfo
- Publication number
- CN107220274A CN107220274A CN201710240065.7A CN201710240065A CN107220274A CN 107220274 A CN107220274 A CN 107220274A CN 201710240065 A CN201710240065 A CN 201710240065A CN 107220274 A CN107220274 A CN 107220274A
- Authority
- CN
- China
- Prior art keywords
- interface
- data
- fairground
- implementation method
- file
- 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
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/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
-
- 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
Abstract
The invention discloses one kind visualization data-interface fairground implementation method, comprise the following steps：1st, inquire about the essential information of all tables of data and be shown in foreground client graphical interfaces, selection needs the data source registered；2nd, the data content fields stored in the data source that selection is shown in foreground client graphical interfaces；3rd, according to data-interface use requirement, each data content fields are set for display field or condition field, and set content conversion regime；4th, the interface that being generated according to configuration information and transformation rule needs is defined.Visualization data-interface fairground disclosed by the invention implementation method, carries out data-interface definition by the way of visual definition and inquiry, uses the data in the system to provide extremely convenient means for third party system.
Description
Technical field
The invention belongs to data processing field, and in particular to one kind visualization data-interface fairground and its implementation.
Background technology
With the various informatizations of enterprises and institutions, the information-based operation systems of substantial amounts of IT are generated, these are information-based
There are substantial amounts of data transfer each other, content exchange, data conversion, data according to the business demand of constituent parts in operation system
The use of data such as collect, and different operation system Construction Party is different, the mode of its output data, data format also very much not phase
Together.Used to carry out the data cross between different system, must just carry out substantial amounts of conversion work；One system is using it
When his system data, the general way of present industry has two kinds：1st, require data output system according to data consumer's
It is required that modifying；2nd, data consumer carries out conversion adaptation according to the data mode of output system.In actual treatment no matter
Using any in two ways, reviser or converter are required for according to the design documentation of original system, exploitation document, very
Go to inquire about definition format, acquisition modes of initial data etc. into test document, the data that then can define correlation connect
Mouthful, then swapped in the form of document.So exist workload big, interface definition and using it is unclear, not in time, it is inaccurate
Really, in addition mistake situation.
If the relevant design of an existed system, exploitation, test document have been lost or document is in itself with true system
There is certain deviation between system, then regardless of the developer of original system, or use the exploitation of the other system of the system data
Personnel according to these relevant documentations define come interface will there is a situation where to use, error in data occurs；And once
There is no relevant documentation or paper trail not comprehensive, to enter line interface and define, need costly manpower and materials to original system
The data of system analyze or even debugging original system, and this not only wastes manpower and materials it is also possible to causing original system not
It is stable.
The content of the invention
Goal of the invention：For problems of the prior art, the invention discloses one kind visualization data-interface fairground
Implementation method, carries out data-interface definition by the way of visual definition and inquiry, is that third party system uses the system
In data extremely convenient means are provided.
Technical scheme：One kind visualization data-interface fairground implementation method, comprises the following steps：
Step 1, the essential information of all tables of data of inquiry are simultaneously shown in foreground client graphical interfaces, and selection needs registration
Data source；
Step 2, the data content fields stored in the data source of selection are shown in foreground client graphical interfaces；
Step 3, according to data-interface use requirement, it is display field or condition field to set each data content fields,
And set content conversion regime；
Step 4, the interface for generating needs according to configuration information and transformation rule are defined.
Preferably, the tables of data is stored in hive.
Preferably, the Content Transformation mode includes the content format conversion pre-defined and calls custom script to carry out
Special conversion.
Preferably, the specifying information for generating interface in addition to is shown with document form.
The generation method of the file comprises the following steps：
Step 51, the file for increasing a blank newly, generate the form of one 2 row, preferentially write public Table Header information：Connect
The url of mouth, the title of interface, the form of required parameter；
Step 52, reading interface are defined in the related call parameters deposit List selected during registration, and traversal list row writes enter
Form；
Step 53, the form of generation write in file, and deposited in specified path, check that this file can be by interface
Information is shown in systems.
Beneficial effect：Compared with prior art, visualization data-interface implementation method disclosed by the invention has following excellent
Point：1st, the data-interface fairground obtained by visualization data-interface implementation method disclosed by the invention, can deposit bottom data
Data register in storage system is the interface needed, and is illustrated in the data-interface fairground；2nd, by the data-interface fairground,
Can with the gem-pure understanding definition of each data-interface, method of calling, call path, required parameter, interface can be with
The data of return, and data form etc.；3rd, system can be open to it as needed the interface message in Data Mart
The third party system that he needs, third party system can just obtain the related data needed according to the interface interchange and carry out correspondence
Parsing use；4th, the present invention is defined in visual mode and using the interface that data exchange is carried out between operation system, reduced
Interface defines mistake.
Brief description of the drawings
Fig. 1 is the system composition schematic diagram in embodiment；
Fig. 2 is the flow chart disclosed by the invention for visualizing data-interface fairground implementation method；
Fig. 3 is the textual presentation schematic diagram of interface message in embodiment；
Fig. 4 is the public Table Header information in interface message file in embodiment；
Fig. 5 defines the form that the related call parameters selected during registration are generated to read interface in embodiment；
Fig. 6 is the final content of interface message file preservation in embodiment；
Fig. 7 is flow chart of the third party system using generation interface.
Embodiment
With reference to the accompanying drawings and detailed description, the present invention is furture elucidated.
When business datum has been converged in the data-storage system of the system, system provides visualization data-interface collection
City, concentrates in the data-interface fairground and illustrates all associated data interface definition.The present embodiment is with outside relation data
Exemplified by data import the system and are stored in hive in storehouse, carry out operation example to illustrate the specific of presently disclosed method
Realize step.As shown in figure 1, the business datum of the system is stored in data-storage system, third party system can by calling
The data in data-storage system are accessed depending on changing the interface in data-interface fairground, so as to access the data of the system.This reality
Data-storage system in example is applied to realize using hive frameworks.
As shown in Fig. 2 being the flow chart of visualization data-interface fairground disclosed by the invention implementation method, including walk as follows
Suddenly：
Step 1, the essential information of all tables of data of inquiry are simultaneously shown in foreground client graphical interfaces, and selection needs registration
Data source；Wherein tables of data is stored in hive；
Foreground jsp (Java Server Pages, the java servers page) uses ajax
(AsynchronousJavascript And XML, asynchronous JavaScript and XML) is sent to backstage and asked, and paging query is arrived
The essential information of all tables for being pooled to hive, and with js (JavaScript) render list presentation of information in front page layout, point
The detail information of each hive table can be checked by hitting, and user shows the number that list selects needs to register in list page according to visual
According to source；
Step 2, the data content fields stored in the data source of selection are shown in foreground client graphical interfaces；
Step 3, according to data-interface use requirement, it is display field or condition field to set each data content fields,
And set content conversion regime；Setting can be by the way of choosing；
Content Transformation mode includes pre-defined content format conversion and the special conversion for calling custom script to carry out.
Step 4, the interface for generating needs according to configuration information and transformation rule are defined.
System preserves all configuration informations, is then set according to the selection in graphic interface, by calculating accordingly,
Conversion, rule process etc. are operated, and such as conversion of field name capital and small letter, Chinese Fields conversion phonetic is plus the new field of serial number gencration
Name, find according to field type field length limitation and be stored in the corresponding external table structure of field as the tune verified, chosen
With field and return field all in outside corresponding table plus flag bit etc. is chosen, the interface definition that generation needs.
It is available for third party system to call after generation interface.In order to visually show that physical interface defines it is detailed in
Hold, all registration interface information can be uniformly shown in system data sets of interfaces city, with pdf or textual form displaying interface
The specifying information of information.As shown in figure 3, showing some interface message in pdf modes, there are the various phases of interface inside the information
Close the information such as information, including request path, required parameter, relevant parameter explanation, and return value.
The generation of visualization data-interface message file comprises the following steps：
Step 51, the file for increasing a blank newly, such as pdf files or txt file generate the form of one 2 row, preferentially write
Enter public Table Header information：The url of interface, the title of interface, the form of required parameter, as shown in Figure 4；
Step 52, reading interface are defined in the related call parameters deposit list selected during registration, and traversal list row writes enter
Form, as shown in Figure 5；
Step 53, the form of generation write in file, and deposited in specified path, check that this file can be by interface
Information is shown in systems, as shown in Figure 6.
Data that can be directly in access system inside hive databases by this visual mode.
As shown in fig. 7, third party system is comprised the following steps using the interface of generation：
Step 61, the interface specification generated in third party's operation system according to registration, call the interface, exploitation correlation
Service code；
After step 62, third party's calling service interface, the system can be verified and authentication process, including parameter is effective
Property, whether verification is the system interface, and whether verification password protection parameter is correct, just can subsequently be located after the completion of complete verification
Reason；
The inquiry data source and querying condition part of step 63, system according to parameter information splicing sql, according to interface
The definition rule splicing sql of relevant parameter Query Result part, ultimately generates an inquiry sql sentence during definition；
Step 64, the sql sentences of generation are put into spark query facility classes operated above, inquire hive memory storages
Data；
Step 65, the data of generation are with List<Map<String,Object>>Form assembling returns to third party system visitor
Family end.
Claims (5)
1. one kind visualization data-interface fairground implementation method, it is characterised in that comprise the following steps：
(1) inquire about the essential information of all tables of data and be shown in foreground client graphical interfaces, selection needs the data registered
Source；
(2) data content fields stored in the data source that selection is shown in foreground client graphical interfaces；
(3) according to data-interface use requirement, it is display field or condition field to set each data content fields, and sets interior
Hold conversion regime；
(4) interface that being generated according to configuration information and transformation rule needs is defined.
2. visualization data-interface fairground according to claim 1 implementation method, it is characterised in that the tables of data storage
In hive.
3. visualization data-interface fairground according to claim 1 implementation method, it is characterised in that the Content Transformation side
Formula includes pre-defined content format conversion and the special conversion for calling custom script to carry out.
4. visualization data-interface fairground according to claim 1 implementation method, it is characterised in that also including with file shape
The specifying information of formula displaying generation interface.
5. visualization data-interface fairground according to claim 4 implementation method, it is characterised in that the generation of the file
Method comprises the following steps：
(51) increase the file of a blank newly, generate the form of one 2 row, preferentially write public Table Header information：Interface
Url, the title of interface, the form of required parameter；
(52) read interface to define in the related call parameters deposit List selected during registration, traversal list row writes enter form；
(53) form of generation is write in file, and deposited in specified path, check that this file can exist interface message
Shown in system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710240065.7A CN107220274B (en) | 2017-04-13 | 2017-04-13 | Visual data interface market realization method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710240065.7A CN107220274B (en) | 2017-04-13 | 2017-04-13 | Visual data interface market realization method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107220274A true CN107220274A (en) | 2017-09-29 |
| CN107220274B CN107220274B (en) | 2020-10-09 |
Family
ID=59928243
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710240065.7A Active CN107220274B (en) | 2017-04-13 | 2017-04-13 | Visual data interface market realization method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107220274B (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108647012A (en) * | 2018-05-04 | 2018-10-12 | 山东汇贸电子口岸有限公司 | A kind of management method and managing device of service-Engine |
| CN108694249A (en) * | 2018-05-30 | 2018-10-23 | 平安科技（深圳）有限公司 | Data processing method, device, computer equipment and storage medium |
| CN110071951A (en) * | 2018-01-24 | 2019-07-30 | 江苏迪纳数字科技股份有限公司 | Data query display systems and method under the conditions of a kind of big data |
| CN110209722A (en) * | 2019-06-04 | 2019-09-06 | 广东铭太信息科技有限公司 | A kind of data-interface for data exchange |
| CN110263281A (en) * | 2019-06-17 | 2019-09-20 | 北京亚鸿世纪科技发展有限公司 | The adaptive device and method of page resolution in a kind of exploitation of data visualization |
| CN110825388A (en) * | 2019-11-15 | 2020-02-21 | 中科院计算技术研究所大数据研究院 | Method for directly converting SQL statement into corresponding REST interface |
| CN111143187A (en) * | 2018-11-02 | 2020-05-12 | 易保网络技术(上海)有限公司 | Method and apparatus for application program interface API testing |
| CN112685032A (en) * | 2020-12-31 | 2021-04-20 | 北京赛思信安技术股份有限公司 | Dynamic api visualization generation method based on spring boot frame |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101145163A (en) * | 2007-10-30 | 2008-03-19 | 金蝶软件（中国）有限公司 | Method and system for obtaining data from a plurality of data pool |
| EP2592812A2 (en) * | 2011-11-11 | 2013-05-15 | Rockwell Automation Technologies, Inc. | Integrated and scalable architecture for accessing and delivering data |
| CN103220259A (en) * | 2012-01-20 | 2013-07-24 | 华为技术有限公司 | Using method, call method, device and system of Oauth application programming interface (API) |
| CN104754045A (en) * | 2015-03-23 | 2015-07-01 | 国网辽宁省电力有限公司信息通信分公司 | Data center service and application interface management platform |
| WO2015162588A1 (en) * | 2014-04-23 | 2015-10-29 | Mescal Gerald | Database interface creation system and method |
| CN105389402A (en) * | 2015-12-29 | 2016-03-09 | 曙光信息产业(北京)有限公司 | Big-data-oriented ETL (Extraction-Transformation-Loading) method and device |
| CN105389619A (en) * | 2014-08-31 | 2016-03-09 | 通用电气公司 | Methods and systems for improving connections within healthcare ecosystem |
| CN105512139A (en) * | 2014-09-26 | 2016-04-20 | 阿里巴巴集团控股有限公司 | Method and device for implementing data visualization |
| CN105718540A (en) * | 2016-01-18 | 2016-06-29 | 北京京东尚科信息技术有限公司 | Data loading method and apparatus |
| CN106484785A (en) * | 2016-09-19 | 2017-03-08 | 济南浪潮高新科技投资发展有限公司 | A kind of method of efficient Automatic Adaptation Data field mapping |
-
2017
- 2017-04-13 CN CN201710240065.7A patent/CN107220274B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101145163A (en) * | 2007-10-30 | 2008-03-19 | 金蝶软件（中国）有限公司 | Method and system for obtaining data from a plurality of data pool |
| EP2592812A2 (en) * | 2011-11-11 | 2013-05-15 | Rockwell Automation Technologies, Inc. | Integrated and scalable architecture for accessing and delivering data |
| CN103220259A (en) * | 2012-01-20 | 2013-07-24 | 华为技术有限公司 | Using method, call method, device and system of Oauth application programming interface (API) |
| WO2015162588A1 (en) * | 2014-04-23 | 2015-10-29 | Mescal Gerald | Database interface creation system and method |
| CN105389619A (en) * | 2014-08-31 | 2016-03-09 | 通用电气公司 | Methods and systems for improving connections within healthcare ecosystem |
| CN105512139A (en) * | 2014-09-26 | 2016-04-20 | 阿里巴巴集团控股有限公司 | Method and device for implementing data visualization |
| CN104754045A (en) * | 2015-03-23 | 2015-07-01 | 国网辽宁省电力有限公司信息通信分公司 | Data center service and application interface management platform |
| CN105389402A (en) * | 2015-12-29 | 2016-03-09 | 曙光信息产业(北京)有限公司 | Big-data-oriented ETL (Extraction-Transformation-Loading) method and device |
| CN105718540A (en) * | 2016-01-18 | 2016-06-29 | 北京京东尚科信息技术有限公司 | Data loading method and apparatus |
| CN106484785A (en) * | 2016-09-19 | 2017-03-08 | 济南浪潮高新科技投资发展有限公司 | A kind of method of efficient Automatic Adaptation Data field mapping |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110071951A (en) * | 2018-01-24 | 2019-07-30 | 江苏迪纳数字科技股份有限公司 | Data query display systems and method under the conditions of a kind of big data |
| CN108647012A (en) * | 2018-05-04 | 2018-10-12 | 山东汇贸电子口岸有限公司 | A kind of management method and managing device of service-Engine |
| CN108694249A (en) * | 2018-05-30 | 2018-10-23 | 平安科技（深圳）有限公司 | Data processing method, device, computer equipment and storage medium |
| CN108694249B (en) * | 2018-05-30 | 2022-02-25 | 平安科技（深圳）有限公司 | Data processing method, data processing device, computer equipment and storage medium |
| CN111143187A (en) * | 2018-11-02 | 2020-05-12 | 易保网络技术(上海)有限公司 | Method and apparatus for application program interface API testing |
| CN110209722A (en) * | 2019-06-04 | 2019-09-06 | 广东铭太信息科技有限公司 | A kind of data-interface for data exchange |
| CN110263281A (en) * | 2019-06-17 | 2019-09-20 | 北京亚鸿世纪科技发展有限公司 | The adaptive device and method of page resolution in a kind of exploitation of data visualization |
| CN110825388A (en) * | 2019-11-15 | 2020-02-21 | 中科院计算技术研究所大数据研究院 | Method for directly converting SQL statement into corresponding REST interface |
| CN112685032A (en) * | 2020-12-31 | 2021-04-20 | 北京赛思信安技术股份有限公司 | Dynamic api visualization generation method based on spring boot frame |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107220274B (en) | 2020-10-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107220274A (en) | One kind visualization data-interface fairground implementation method | |
| US11294968B2 (en) | Combining website characteristics in an automatically generated website | |
| US11423042B2 (en) | Extracting information from unstructured documents using natural language processing and conversion of unstructured documents into structured documents | |
| CN101211364B (en) | Method and system for social bookmarking of resources exposed in web pages | |
| CN106708480A (en) | Management platform realization method and apparatus | |
| US20080120257A1 (en) | Automatic online form filling using semantic inference | |
| CN108196880A (en) | Software project knowledge mapping method for automatically constructing and system | |
| CN103793372A (en) | Extracting semantic relationships from table structures in electronic documents | |
| CN102193906A (en) | Method for automatically introducing examination paper in WORD format into database system | |
| CN103605706A (en) | Knowledge map based resource retrieval method | |
| WO2019153685A1 (en) | Text processing method, apparatus, computer device and storage medium | |
| CN103246963B (en) | Based on the staffs training system of Internet of Things | |
| US20170109442A1 (en) | Customizing a website string content specific to an industry | |
| CN103336794B (en) | For providing the corresponding method and apparatus that information is presented in target pages | |
| US9646004B2 (en) | Hierarchical database report generation with automated query generation for placeholders | |
| CN102760150A (en) | Webpage extraction method based on attribute reproduction and labeled path | |
| CN112052414A (en) | Data processing method and device and readable storage medium | |
| US11392753B2 (en) | Navigating unstructured documents using structured documents including information extracted from unstructured documents | |
| CN107480262A (en) | A kind of general management system of database based on webpage | |
| CN106570750A (en) | Browser plug-in-based automatic tax declaration method, system and browser plug-in | |
| CN108334622A (en) | A method of it obtains and formats complex data | |
| US20140280352A1 (en) | Processing semi-structured data | |
| CN103744987B (en) | Video website media asset integrating method and system based on DOM tree matching | |
| CN107423037A (en) | Application programming interfaces localization method and equipment | |
| CN109933803B (en) | Idiom information display method, idiom information display device, electronic equipment and storage medium |
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 | ||
| CB02 | Change of applicant information |
Address after: Jiangning district general road in Nanjing city Jiangsu province 211100 No. 37 Ping Branch Park Building No. three building Applicant after: Zhongke dawning Nanjing Research Institute Co., Ltd. Address before: Ping Chong Park No. 37 Jiangning district general road in Nanjing city Jiangsu province 211100 Building No. 3 Applicant before: JIANGSU DAWN INFORMATION TECHNOLOGY CO., LTD. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |