CN107220274A - One kind visualization data-interface fairground implementation method - Google Patents

One kind visualization data-interface fairground implementation method Download PDF

Info

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
data
interface
fairground
implementation method
according
Prior art date
Application number
CN201710240065.7A
Other languages
Chinese (zh)
Inventor
王海荣
曹鹏飞
周向军
聂林
朱文洲
鲁根成
徐云龙
Original Assignee
江苏曙光信息技术有限公司
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 江苏曙光信息技术有限公司 filed Critical 江苏曙光信息技术有限公司
Priority to CN201710240065.7A priority Critical patent/CN107220274A/en
Publication of CN107220274A publication Critical patent/CN107220274A/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results
    • GPHYSICS
    • G06COMPUTING; CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/252Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application

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

One kind visualization data-interface fairground implementation method

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.
CN201710240065.7A 2017-04-13 2017-04-13 One kind visualization data-interface fairground implementation method CN107220274A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710240065.7A CN107220274A (en) 2017-04-13 2017-04-13 One kind visualization data-interface fairground implementation method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710240065.7A CN107220274A (en) 2017-04-13 2017-04-13 One kind visualization data-interface fairground implementation method

Publications (1)

Publication Number Publication Date
CN107220274A true CN107220274A (en) 2017-09-29

Family

ID=59928243

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710240065.7A CN107220274A (en) 2017-04-13 2017-04-13 One kind visualization data-interface fairground implementation method

Country Status (1)

Country Link
CN (1) CN107220274A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110209722A (en) * 2019-06-04 2019-09-06 广东铭太信息科技有限公司 A kind of data-interface for data exchange

Citations (6)

* Cited by examiner, † Cited by third party
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
CN105718540A (en) * 2016-01-18 2016-06-29 北京京东尚科信息技术有限公司 Data loading method and apparatus

Patent Citations (6)

* Cited by examiner, † Cited by third party
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
CN105718540A (en) * 2016-01-18 2016-06-29 北京京东尚科信息技术有限公司 Data loading method and apparatus

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110209722A (en) * 2019-06-04 2019-09-06 广东铭太信息科技有限公司 A kind of data-interface for data exchange

Similar Documents

Publication Publication Date Title
US10127207B2 (en) Systems and methods for automatically creating and shortening traditional street and postal addresses
US9323731B1 (en) Data extraction using templates
Fonseca et al. Ontology-driven geographic information systems
US6247029B1 (en) Web browser form enhancements
CN102831121B (en) Method and system for extracting webpage information
US8412794B2 (en) Mobile integration of user-specific institutional content
CA2610208C (en) Learning facts from semi-structured text
CN100437573C (en) Identifying related names
CN103605706B (en) A kind of resource retrieval method of knowledge based map
US20140052778A1 (en) Method and apparatus for mapping a site on a wide area network
US7685157B2 (en) Extraction of information from structured documents
US9785624B2 (en) Method and apparatus for viewing electronic commerce-related documents
US7711743B2 (en) Process and system that dynamically links contents of websites to a directory record to display as a combined return from a search result
CN101313353B (en) System and method for image processing
CN101976235B (en) Extensible Word report automatically-generating method based on dynamic web page
US6760732B2 (en) Method and system for viewing a record of an organization having a hierarchy of departments
US7496497B2 (en) Method and system for selecting web site home page by extracting site language cookie stored in an access device to identify directional information item
US6996798B2 (en) Automatically deriving an application specification from a web-based application
EP2680161A1 (en) Uniform Resource Locator (URL) improvement methods
US5983170A (en) System and method for generating semantic analysis of textual information
US7747938B2 (en) Data insertion from a database into a fixed electronic template form
EP1447754A1 (en) Linking elements of a document to corresponding fields, queries and/or procedures in a database
JP4918174B1 (en) Information providing apparatus, information providing method, and computer program
CN101488151B (en) System and method for gathering website contents
US20080109250A1 (en) System and method for creating and rendering DICOM structured clinical reporting via the internet

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
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.