CN104750810A - Data querying and processing method based on configuration - Google Patents
Data querying and processing method based on configuration Download PDFInfo
- Publication number
- CN104750810A CN104750810A CN201510143045.9A CN201510143045A CN104750810A CN 104750810 A CN104750810 A CN 104750810A CN 201510143045 A CN201510143045 A CN 201510143045A CN 104750810 A CN104750810 A CN 104750810A
- Authority
- CN
- China
- Prior art keywords
- data
- configuration
- field
- interface
- querying
- 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
Abstract
The invention discloses a data querying and processing method based on configuration and relates to the field of open data interface services. The data querying and processing method is based on mapping configuration, and querying and processing of data of an open data interface are controlled, the data fields are flexibly increased and decreased, and data field names are flexibly defined and described. The data querying and processing method mainly comprises the steps that field mapping configuration is conducted on different data, querying conditions are packaged according to the mapping configuration, and a querying result is formatted according to the mapping configuration. By the adoption of the data querying and processing method, various problems caused when data source formats are not matched, data fields change and data definition is not uniform are solved, the interface can be flexibly adjusted according to the change of source data, and frequent correction and maintenance are avoided.
Description
Technical field
The present invention relates to opening interface (Open API) service field, is exactly a kind of data query disposal route based on configuration specifically.
Background technology
Internet has entered large data age.In the develop rapidly of large data correlation techniques, opening interface (Open API) more and more comes into one's own.Opening interface is a kind of calling for third party and the application programming interface of interaction data, is a kind of important application in the large data, services in internet.
But the large data age in internet, product iteration is very fast, and data layout also ensues change, data grows present a kind of random, without the feature of trade classification.Because the data layout of service side may change because demand changes, cause data-interface needs to be followed and change together.And then causing the local data of data-interface service side not mate with existing interface data layout, Data field names does not mate, or the available data content situation that cannot meet third party's data analysis requirements such as very few.
Summary of the invention
For the weak point that prior art exists, the present invention proposes a kind of based on mapping configuration, control the method for data query and process in opening interface (OpenAPI).
A kind of data query disposal route based on configuration of the present invention, the technical scheme solving the problems of the technologies described above employing is as follows: this data query disposal route, based on mapping configuration, realize the control to opening interface data query and process, realize the increase and decrease of data field, field name definition flexibly and describe; Its main contents comprise: carry out field mappings configuration, according to mapping configuration packages querying condition and according to mapping configuration format Query Result to different pieces of information.
Preferably, according to the data that different pieces of information interface will be inquired about, whether whether the local source database field of configuration data, data-interface output field, field meaning describe and show, as the mapping relations of filtercondition.
Preferably, when Third party system calls service side API, backstage first obtains the field mappings configuration of corresponding data content according to the data that will inquire about.
Preferably, according to mapping configuration, querying condition is encapsulated, obtain the querying condition can inquiring about field, remove the field do not shown, inquire about again according to the querying condition after encapsulation.
Preferably, according to mapping configuration, the data result inquired is formatd, the field name in data is converted to the field name in interface.
A kind of beneficial effect compared with prior art had based on the data query disposal route of configuration of the present invention is: the method is based on mapping configuration, control data query and process in opening interface (Open API), can data content in flexible configuration data-interface, meet multiple demand, solve because the various problems that Data Source format mismatching, field change, data definition disunity brings; When the data layout of service side changes, the inquiry of data and process all can adjust according to field mappings configuration, only need Reconfigurations, do not need to revise maintenance frequently to application itself.
Accompanying drawing explanation
Accompanying drawing 1 is the structural representation of described field mappings allocation list;
Accompanying drawing 2 is the process flow diagram of the data query disposal route based on configuration.
Embodiment
For making the object, technical solutions and advantages of the present invention clearly understand, below in conjunction with specific embodiment, and with reference to accompanying drawing, a kind of data query disposal route based on configuration of the present invention is further described.
A kind of data query disposal route based on configuration of the present invention, based on mapping configuration, realizes the control to opening interface data query and process, realizes the increase and decrease of data field, field name definition flexibly and describes; Its main contents comprise: carry out field mappings configuration, according to mapping configuration packages querying condition and according to mapping configuration format Query Result to different pieces of information.
By data query disposal route of the present invention, the inquiry of data and process all can adjust according to mapping configuration, conveniently adjust interface flexibly according to the change of derived data, avoid and revise maintenance frequently.
Embodiment:
Described in the present embodiment, a kind of data query disposal route based on configuration, first needs to increase a field mappings allocation list in systems in which.According to the data that different pieces of information interface will be inquired about, whether whether the local source database field of configuration data, data-interface output field, field meaning describe and show, as the mapping relations of the contents such as filtercondition, other fields.As shown in Figure 1,
Secondly, the process need of data query and process controls according to field mappings configuration, and specific implementation process is as follows:
1) when Third party system calls service side API, backstage first obtains the field mappings configuration of corresponding data content according to the data that will inquire about;
2) according to mapping configuration, querying condition is encapsulated, obtain the querying condition can inquiring about field, remove the field do not shown, inquire about again according to the querying condition after encapsulation;
3) according to mapping configuration, the data result inquired is formatd again after, the field name in data is converted to the field name in interface;
4) finally the result after format is returned.
Based on the data query disposal route of configuration described in the present embodiment, be mainly used in data query and the processing procedure of opening interface, as shown in Figure 2, concrete execution step is as follows:
Whether step one, according to demand, carry out the local field name of data and interface field name to different pieces of information, show, the mapping configuration of the whether content such as filtercondition; Carry out field mappings configuration
Step 2, first obtains mapping configuration according to data type when third party initiates inquiry request;
Step 3, if do not have relevant configuration information, illustrates that querying condition is wrong, then return sky result to third party;
Step 4, if containing relevant configuration information, then encapsulate inquiry according to mapping configuration, configuration querying condition and inquiry field;
Step 5, according to mapping configuration formatted inquiry result, is converted to the field of interface definition by local data fields;
Step 6, return data is to third party.
Above-mentioned embodiment is only concrete case of the present invention; scope of patent protection of the present invention includes but not limited to above-mentioned embodiment; any claims according to the invention and any person of an ordinary skill in the technical field to its suitable change done or replacement, all should fall into scope of patent protection of the present invention.
Claims (5)
1. the data query disposal route based on configuration, it is characterized in that, based on mapping configuration, realize the control to opening interface data query and process, its main contents comprise: carry out field mappings configuration, according to mapping configuration packages querying condition and according to mapping configuration format Query Result to different pieces of information.
2. according to claim 1 a kind of based on configuration data query disposal route, it is characterized in that, according to the data that different pieces of information interface will be inquired about, whether whether the local source database field of configuration data, data-interface output field, field meaning describe and show, as the mapping relations of filtercondition.
3. a kind of data query disposal route based on configuration according to claim 1 or 2, is characterized in that, when Third party system calls service side API, backstage first obtains the field mappings configuration of corresponding data content according to the data that will inquire about.
4. according to claim 3 a kind of based on configuration data query disposal route, it is characterized in that, according to mapping configuration, querying condition is encapsulated, obtain the querying condition can inquiring about field, remove the field do not shown, inquire about again according to the querying condition after encapsulation.
5. according to claim 4 a kind of based on configuration data query disposal route, it is characterized in that, according to mapping configuration the data result inquired is formatd, the field name in data is converted to the field name in interface.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510143045.9A CN104750810A (en) | 2015-03-30 | 2015-03-30 | Data querying and processing method based on configuration |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510143045.9A CN104750810A (en) | 2015-03-30 | 2015-03-30 | Data querying and processing method based on configuration |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104750810A true CN104750810A (en) | 2015-07-01 |
Family
ID=53590494
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510143045.9A Pending CN104750810A (en) | 2015-03-30 | 2015-03-30 | Data querying and processing method based on configuration |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104750810A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106126692A (en) * | 2016-06-29 | 2016-11-16 | 北京奇虎科技有限公司 | The searching method of a kind of sample data and device |
| CN106453603A (en) * | 2016-10-28 | 2017-02-22 | 努比亚技术有限公司 | Interface data information management and control method and management and control system thereof |
| CN106649314A (en) * | 2015-10-29 | 2017-05-10 | 北京国双科技有限公司 | Data query method and device |
| CN109800229A (en) * | 2018-12-29 | 2019-05-24 | 深圳云天励飞技术有限公司 | Data access method and relevant device |
| CN110413161A (en) * | 2019-06-14 | 2019-11-05 | 深圳爱根斯通科技有限公司 | Arrrangement method, device and electronic equipment |
| CN110610069A (en) * | 2019-09-09 | 2019-12-24 | 苏州浪潮智能科技有限公司 | Method and device for calling REST interface in web system |
| CN110825796A (en) * | 2019-10-09 | 2020-02-21 | 上海易点时空网络有限公司 | Data acquisition method, device and system |
| CN111104421A (en) * | 2019-12-31 | 2020-05-05 | 新奥数能科技有限公司 | Data query method and device based on data interface standard configuration |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US564981A (en) * | 1896-08-04 | Fluid-pressure brake | ||
| US20040254924A1 (en) * | 2003-06-12 | 2004-12-16 | International Business Machines Corporation | Iterative data analysis process via query result augmentation and result data feedback |
| CN101639776A (en) * | 2009-09-07 | 2010-02-03 | 陈小青 | Database access and integration method and system thereof |
| CN102203736A (en) * | 2011-05-20 | 2011-09-28 | 华为技术有限公司 | Method and device for calling open application programming interface (openapi) |
| CN102346785A (en) * | 2011-11-15 | 2012-02-08 | 北京创腾科技有限公司 | Method and device for directly self-defining field of database |
-
2015
- 2015-03-30 CN CN201510143045.9A patent/CN104750810A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US564981A (en) * | 1896-08-04 | Fluid-pressure brake | ||
| US20040254924A1 (en) * | 2003-06-12 | 2004-12-16 | International Business Machines Corporation | Iterative data analysis process via query result augmentation and result data feedback |
| CN101639776A (en) * | 2009-09-07 | 2010-02-03 | 陈小青 | Database access and integration method and system thereof |
| CN102203736A (en) * | 2011-05-20 | 2011-09-28 | 华为技术有限公司 | Method and device for calling open application programming interface (openapi) |
| CN102346785A (en) * | 2011-11-15 | 2012-02-08 | 北京创腾科技有限公司 | Method and device for directly self-defining field of database |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106649314A (en) * | 2015-10-29 | 2017-05-10 | 北京国双科技有限公司 | Data query method and device |
| CN106126692A (en) * | 2016-06-29 | 2016-11-16 | 北京奇虎科技有限公司 | The searching method of a kind of sample data and device |
| CN106453603A (en) * | 2016-10-28 | 2017-02-22 | 努比亚技术有限公司 | Interface data information management and control method and management and control system thereof |
| CN106453603B (en) * | 2016-10-28 | 2020-07-24 | 珠海大横琴科技发展有限公司 | Management control method and management control system for interface data information |
| CN109800229A (en) * | 2018-12-29 | 2019-05-24 | 深圳云天励飞技术有限公司 | Data access method and relevant device |
| CN109800229B (en) * | 2018-12-29 | 2021-10-08 | 深圳云天励飞技术有限公司 | Data access method and related equipment |
| CN110413161A (en) * | 2019-06-14 | 2019-11-05 | 深圳爱根斯通科技有限公司 | Arrrangement method, device and electronic equipment |
| CN110413161B (en) * | 2019-06-14 | 2021-08-31 | 深圳爱根斯通科技有限公司 | Component configuration method and device and electronic equipment |
| CN110610069A (en) * | 2019-09-09 | 2019-12-24 | 苏州浪潮智能科技有限公司 | Method and device for calling REST interface in web system |
| CN110825796A (en) * | 2019-10-09 | 2020-02-21 | 上海易点时空网络有限公司 | Data acquisition method, device and system |
| CN111104421A (en) * | 2019-12-31 | 2020-05-05 | 新奥数能科技有限公司 | Data query method and device based on data interface standard configuration |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104750810A (en) | Data querying and processing method based on configuration | |
| US10241839B2 (en) | Method and system for generating a virtual device resource accessible by an application | |
| CN104125208B (en) | Data transmission method and device | |
| WO2002035395A3 (en) | Integrating heterogeneous data and tools | |
| AU2003267038A1 (en) | Content based messaging including the extension of a remote procedure call | |
| WO2003005624A3 (en) | System and method for transforming business process policy data | |
| WO2005055053A3 (en) | Mobile device programming system and method | |
| CN106528880A (en) | Normalizing method and system for data structure format of multi-source power service data | |
| CN101739300A (en) | Method and system for inter-process communication of multimedia terminal | |
| CN104766189A (en) | Logistics information processing system and method | |
| CN101739460A (en) | Grid-based spatial data source unification service system and method | |
| CN104394305A (en) | Compatibility method for supporting external mobile camera and built-in camera of mobile equipment in Android system | |
| CN1996878A (en) | A method for information conversion of the simple object access protocol service management interface | |
| CN103092645A (en) | Geographic spatial information application system and implement method thereof based on microkernel technology | |
| CN105635050A (en) | Data interaction method and system | |
| US20140337655A1 (en) | Integrated interface system for power-system monitoring and control system | |
| CN104965829A (en) | Method, server and system for classifying terminal applications | |
| WO2018225012A3 (en) | System and method for smart interaction between website components | |
| CN106302759A (en) | A kind of Intelligent vehicle-mounted multimedia system and method | |
| US10776313B2 (en) | Converting source objects to target objects | |
| CN102905000B (en) | Address book synchronization method and device | |
| CN106952184B (en) | Automobile service management system, automobile service management method and adaptation method thereof | |
| CA2498539A1 (en) | A system and method for building component applications using metadata defined mapping between message and data domains | |
| Yacchirema et al. | Onem2m based-interworking architecture for heterogeneous devices interoperability in iot | |
| CN102681867A (en) | Video analysis task processing method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20150701 |
|
| WD01 | Invention patent application deemed withdrawn after publication |