CN109145025A - A kind of data query method, apparatus and service server that multi-data source is integrated - Google Patents
A kind of data query method, apparatus and service server that multi-data source is integrated Download PDFInfo
- Publication number
- CN109145025A CN109145025A CN201811073189.1A CN201811073189A CN109145025A CN 109145025 A CN109145025 A CN 109145025A CN 201811073189 A CN201811073189 A CN 201811073189A CN 109145025 A CN109145025 A CN 109145025A
- Authority
- CN
- China
- Prior art keywords
- data
- interface
- data source
- preconfigured
- mapping relations
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A kind of data query method, apparatus and service server that multi-data source is integrated is disclosed, this method comprises: receiving data inquiry request, the data inquiry request carries the data attribute of data to be checked；According to the mapping relations between preconfigured data attribute and data source property, target data source attribute is determined, wherein the data source property includes dataSource link, field name；According to the mapping relations between preconfigured data source property and atom interface, the target atoms interface of the target data source attribute mapping is determined；According to the mapping relations between preconfigured atom interface and bottom data, data are extracted from the bottom data that it is mapped by the target atoms interface, obtain the data to be checked.
Description
Technical field
The data query that this specification embodiment is related to technical field of data processing more particularly to a kind of multi-data source integrates
Method, apparatus and service server.
Background technique
In internationalization air control system, air control system can support multiple service lines, i.e. tenant upwards, and can be directed to a variety of
Event, such as payment events, registered events etc. carry out risk management.It is carried out in business side, such as operation personnel and tactful personnel
Daily operation, or for event carry out risk it is qualitative during, data query requirements can be related to, and in a data query
In the process, it may be necessary to dock multiple data sources or multiple data-query interfaces, and for different events, business side pair
The demand of query result is also different, for example, business side is generally concerned with transaction related information for payment events, for note
For volume event, business Fang Ze is generally concerned with user related information.
In the prior art, when business side increases a kind of data query requirements newly, the R&D personnel waiting is needed to be counted
According to the encapsulation of query interface, and since for different tenants, business otherness is inevitable, thus the R&D personnel
It also needs to handle the otherness under different tenants, later, implements publication process, realize the technical support to the data query requirements.
It can be seen that in the prior art, expending technical support cost, influencing the working efficiency of entire technical research team.
Summary of the invention
In view of the above technical problems, this specification embodiment provides a kind of integrated data query method of multi-data source, dress
It sets and service server, technical solution is as follows:
It is described according to this specification embodiment in a first aspect, provide a kind of multi-data source integrated data query method
Method includes:
Data inquiry request is received, the data inquiry request carries the data attribute of data to be checked；
According to the mapping relations between preconfigured data attribute and data source property, the data to be checked are determined
The target data source attribute of data attribute mapping, wherein the data source property includes dataSource link, field name；
According to the mapping relations between preconfigured data source property and atom interface, the target data source category is determined
Property mapping target atoms interface；
According to the mapping relations between preconfigured atom interface and bottom data, by the target atoms interface from
Data are extracted in its bottom data mapped, obtain the data to be checked.
According to the second aspect of this specification embodiment, a kind of data query device that multi-data source is integrated is provided, it is described
Device includes:
Receiving module, inquiry request, the data inquiry request carry the data of data to be checked for receiving data
Attribute；
First determining module, for according to the mapping relations between preconfigured data attribute and data source property, really
The target data source data of the data attribute mapping of the fixed data to be checked, wherein the data source property includes data source
Name, field name；
Second determining module, for according to the mapping relations between preconfigured data source property and atom interface, really
The target atoms interface of the fixed target data source attribute mapping；
Data extraction module, for passing through according to the mapping relations between preconfigured atom interface and bottom data
The target atoms interface extracts data from the bottom data that it is mapped, and obtains the data to be checked.
According to the third aspect of this specification embodiment, a kind of service server is provided, including memory, processor and deposit
Store up the computer program that can be run on a memory and on a processor, wherein the processor is realized when executing described program
A kind of integrated data query method of multi-data source that this specification embodiment provides.
Technical solution provided by this specification embodiment, by receiving data inquiry request, which is taken
Data attribute with data to be checked, according to the mapping relations between preconfigured data attribute and data source property, really
The target data source attribute of the data attribute mapping of the fixed data to be checked, connects according to preconfigured data source property with atom
Mapping relations between mouthful determine the target atoms interface of target data source attribute mapping, finally according to preconfigured original
Mapping relations between sub-interface and bottom data extract data from the bottom data that it is mapped by target atoms interface,
Data to be checked are obtained, may be implemented when business side increases a kind of query demand newly, efficiency data query, and saving technique are improved
Support cost, the working efficiency for the R&D team that develops skill.
It should be understood that above general description and following detailed description be only it is exemplary and explanatory, not
This specification embodiment can be limited.
In addition, any embodiment in this specification embodiment does not need to reach above-mentioned whole effects.
Detailed description of the invention
In order to illustrate more clearly of this specification embodiment or technical solution in the prior art, below will to embodiment or
Attached drawing needed to be used in the description of the prior art is briefly described, it should be apparent that, the accompanying drawings in the following description is only
The some embodiments recorded in this specification embodiment for those of ordinary skill in the art can also be attached according to these
Figure obtains other attached drawings.
Fig. 1 is that one kind of the business framework for the data query method for realizing that the multi-data source that this specification provides is integrated is shown
Example；
Fig. 2 is the implementation for the data query method that a kind of multi-data source that one exemplary embodiment of this specification provides integrates
Example flow chart；
Fig. 3 is the implementation for the data query device that a kind of multi-data source that one exemplary embodiment of this specification provides integrates
Example block diagram；
Fig. 4 shows one kind provided by this specification embodiment, and more specifically service server hardware configuration is illustrated
Figure.
Specific embodiment
In order to make those skilled in the art more fully understand the technical solution in this specification embodiment, below in conjunction with this
Attached drawing in specification embodiment is described in detail the technical solution in this specification embodiment, it is clear that described
Embodiment is only a part of the embodiment of this specification, instead of all the embodiments.The embodiment of base in this manual,
Those of ordinary skill in the art's every other embodiment obtained, all should belong to the range of protection.
In order to solve when business side increases a kind of data query requirements newly, the R&D personnel to be needed to arrange in the prior art
Phase carries out the encapsulation of data-query interfaces, and handles the otherness under different tenants, implements entire publication process, Cai Nengshi later
The technical support of data query requirements now newly-increased to this causes to expend technical support cost, influences entire technical research team
Working efficiency the problem of, this specification provides a kind of multi-data source integrated data query method.
Firstly, from business support layer face, to business framework needed for realizing the integrated data query method of the multi-data source
It is illustrated.As shown in Figure 1, being the business framework for the data query method for realizing that the multi-data source that this specification provides is integrated
A kind of example.
Business framework exemplified by Fig. 1 have two layers it is abstract, respectively data source level of abstraction and show level of abstraction, it is as follows,
The incidence relation between two level of abstractions and two level of abstractions is described respectively:
(1) data source level of abstraction:
For encapsulating atom interface comprising bottom data layer and atom interface layer.Wherein, bottom data layer provides a variety of
Data, such as event data, analysis data etc.；Atom interface layer is then located at the upper layer of bottom data layer, is packaged with multiple originals
Sub-interface, it will be appreciated by persons skilled in the art that atom interface is the minimum envelope for carrying out data query for network request
Unit is filled, for example, the membership information inquiry encapsulation for international payment domain is a kind of atom interface, namely passes through the atom interface
Available membership information；Transaction Information inquiry encapsulation for international payment domain is also a kind of atom interface, namely by being somebody's turn to do
The available Transaction Information of atom interface.
Based on foregoing description, it can be understood as data source level of abstraction includes reflecting between atom interface and bottom data one by one
Relationship is penetrated, namely the bottom data of the atom interface mappings can be extracted by a certain atom interface.
(2) show level of abstraction:
For encapsulation of data source comprising data active layer and query configuration layer.Wherein, data active layer provides multiple data
Source, such as event information data source, user information data source, trading information data source etc., these data sources are drawn based on business
Point；Query configuration layer is then located at the upper layer of data active layer, this layer is the configuration layer provided to business side, passes through query configuration
Layer, business can be pre-configured with the mapping relations between data attribute and data source property, wherein the mapping relations can be one
An at least data source property, data source category mentioned here can be mapped to more mapping relations namely a data attribute
Property may include dataSource link, field name.For example, by taking this data attribute of the IP address information of user as an example, mapping
Data source property may include ipCountry, ipState, ipCity these three fields in event information data source.
(3) incidence relation between data source level of abstraction and exhibiting abstraction layer:
As shown in Figure 1, data source level of abstraction with show between level of abstraction by data active layer it is associated with atom interface layer,
Wherein, data active layer is located at the upper layer of atom interface layer, and seen from the above description, multiple data sources provided by data active layer are
Based on delineation of activities, for example, order information data source can provide the letter such as the name of product of purchase and the chained address of product
Breath, so that different data sources can correspond to multiple atom interfaces, therefore, the configuration mode between data active layer and atom interface layer
In, the mapping relations that can be pre-configured between data source property and atom interface, further, due to having between different tenants
Business otherness, for example, for the link address information of the product of purchase, in AliExpress (global speed is sold logical) tenant
Under, it can be obtained by the atom interface in electric business domain, and in the case where Lazada (reaches) tenant to praise, then it can pass through event information
Atom interface obtains, and is based on this, then can in advance under tenant's dimension, for different tenants configure different data source property with
Mapping relations between atom interface.
By this kind of processing mode, the business otherness of different tenants can be shielded, to ensure one in service logic
Cause property realizes the decoupling that the technical support of lower layer and upper-layer service are realized, is conducive to the long term maintenance of later period system code；Together
When, when business side increases a kind of query demand newly, data source property is pre-defined by business side, without technical research
Personnel participate in, so that manpower and material resources are liberated, the working efficiency for the R&D team that develops skill.
It is as follows, on the basis of business framework shown in Fig. 1, the multi-data source that following embodiments provide this specification is shown
Integrated data query method is illustrated:
Fig. 2 is referred to, the data query side integrated for a kind of multi-data source that one exemplary embodiment of this specification provides
The embodiment flow chart of method, this method may comprise steps of:
Step 202: receiving data inquiry request, the data inquiry request carries the data attribute of data to be checked.
In this specification embodiment, by taking the IP address of a certain user is inquired by business side as an example, business side, which can pass through, is
Platform of uniting initiates data inquiry request, which carries the data attribute of data to be checked, such as IP address.
Step 204: according to the mapping relations between preconfigured data attribute and data source property, determining number to be checked
According to data attribute mapping target data source attribute, wherein data source property includes dataSource link, field name.
In this specification embodiment, system platform then can according to preconfigured data attribute and data source property it
Between mapping relations, obtain data attribute mapped data source property involved in step 202, for convenience, will
The data source property is known as target data source attribute.
Using data attribute as IP address for example, dataSource link included by target data source attribute can for event believe
Data source is ceased, field name may include these three field names of ipCountry, ipState, ipCity.
It should be noted that in the example above only by taking a dataSource link as an example, in practical applications, the phase based on Fig. 1
Closing the mapping relations described it is found that between data attribute and data source property can be one-to-many mapping relations, thus, at this
In step, accessed target data source attribute may include more than two dataSource links, and each dataSource link can correspond to again
At least one field name.
Step 206: according to the mapping relations between preconfigured data source property and atom interface, determining target data
The target atoms interface of source attribute mapping.
Step 208: according to the mapping relations between preconfigured atom interface and bottom data, being connect by target atoms
Mouth extracts data from the bottom data that it is mapped, and obtains data to be checked.
It is as follows, step 206 and step 208 are illustrated:
In this specification embodiment, involved by the target data source attribute that can successively determine in traversal step 204
Each data source, for the data source currently traversed, can according to preconfigured data source property and atom interface it
Between mapping relations, determine the data source property mapping atom interface the atom interface is known as target for convenience
Atom interface.
It should be noted that based on the associated description in above-mentioned Fig. 1 it is found that due to having business difference between different tenants
Property, so as to from the dimension of tenant, be configured in advance for different tenants between different data source property and atom interface
Mapping relations, then, in this specification embodiment, mentioned in step 202 to data inquiry request can also carry
Tenant's information of data tenant to be checked, in step 206, then can determine to be directed to and be somebody's turn to do according to tenant's information
Mapping relations between the preconfigured data source property of the tenant that tenant's information is identified and atom interface, then, according to this
Mapping relations determine target atoms interface.
Further, then it can pass through target according to the mapping relations between preconfigured atom interface and bottom data
Atom interface extracts data from the bottom data that it is mapped.
It is subsequent, continue to traverse next data source, until having traversed each data source involved by target data source attribute.
Seen from the above description, one data source of every traversal, then can extract one piece of data, in this specification embodiment
In, these data can be spliced according to preconfigured data format, using the data obtained after splicing as to be checked
Data.
For example, preconfigured data format is as follows:
{ eventDataSource:ipCity }
{ eventDataSource:ipState }
{ eventDataSource:ipCountry }； 
The practical significance of the data format is, by the ipCity, ipState extracted from event information data source:
These three fields of ipCountry are spliced with space.
Technical solution provided by this specification embodiment, by receiving data inquiry request, which is taken
Data attribute with data to be checked, according to the mapping relations between preconfigured data attribute and data source property, really
The target data source attribute of the data attribute mapping of the fixed data to be checked, connects according to preconfigured data source property with atom
Mapping relations between mouthful determine the target atoms interface of target data source attribute mapping, finally according to preconfigured original
Mapping relations between sub-interface and bottom data extract data from the bottom data that it is mapped by target atoms interface,
Data to be checked are obtained, may be implemented when business side increases a kind of query demand newly, efficiency data query, and saving technique are improved
Support cost, the working efficiency for the R&D team that develops skill.
Corresponding to above method embodiment, this specification embodiment also provides a kind of data query dress that multi-data source is integrated
It sets, refers to Fig. 3, for the reality for the data query device that a kind of multi-data source that one exemplary embodiment of this specification provides integrates
A block diagram is applied, the apparatus may include: receiving module 31, the first determining module 32, the second determining module 33 and data are extracted
Module 34.
Wherein, receiving module 31, inquiry request, the data inquiry request carry data to be checked for receiving data
Data attribute；
First determining module 32, for according to the mapping relations between preconfigured data attribute and data source property,
Determine the target data source data of the data attribute mapping of the data to be checked, wherein the data source property includes data
Parent name, field name；
Second determining module 33, for according to the mapping relations between preconfigured data source property and atom interface,
Determine the target atoms interface of the target data source attribute mapping；
Data extraction module 34, for leading to according to the mapping relations between preconfigured atom interface and bottom data
It crosses the target atoms interface and extracts data from the bottom data that it is mapped, obtain the data to be checked.
In one embodiment, there are mapping relations between the data attribute and at least one data source property；
There are mapping relations between the data source property and at least one atom interface.
In one embodiment, under tenant's dimension, different data source property and atom interface are configured for different tenants
Between mapping relations.
In one embodiment, the data inquiry request also carries tenant's letter of the data tenant to be checked
Breath；
Second determining module includes (not showing that in Fig. 3):
Relationship determines submodule, for determining pre- for the data tenant to be checked according to tenant's information
Mapping relations between the data source property first configured and atom interface；
Target determines submodule, for being directed to the preconfigured data source of data tenant to be checked according to described
Mapping relations between attribute and atom interface determine the target atoms interface of the target data source attribute mapping.
In one embodiment, the data extraction module includes (not showing that in Fig. 3):
Extracting sub-module, for passing through institute according to the mapping relations between preconfigured atom interface and bottom data
It states target atoms interface and extracts data from the bottom data that it is mapped；
Splicing submodule will splice for splicing the data extracted according to preconfigured data format
The data obtained afterwards are as the data to be checked.
It is understood that receiving module 31, the first determining module 32, the second determining module 33 and data extract mould
Module of the block 34 as four kinds of functional independences can both be configured in a device simultaneously as shown in Figure 3, can also individually be configured
In a device, therefore structure shown in Fig. 3 should not be construed as the restriction to this specification example scheme.
In addition, the function of modules and the realization process of effect are specifically detailed in the above method corresponding step in above-mentioned apparatus
Rapid realization process, details are not described herein.
This specification embodiment also provides a kind of computer equipment, includes at least memory, processor and is stored in
On reservoir and the computer program that can run on a processor, wherein processor realizes one kind above-mentioned when executing described program
The integrated data query method of multi-data source, this method include at least: receiving data inquiry request, the data inquiry request is taken
Data attribute with data to be checked；According to the mapping relations between preconfigured data attribute and data source property, really
Set the goal data source property, wherein the data source property includes dataSource link, field name；According to preconfigured data source
Mapping relations between attribute and atom interface determine the target atoms interface of the target data source attribute mapping；According to pre-
Mapping relations between the atom interface first configured and bottom data, the bottom number mapped by the target atoms interface from it
According to middle extraction data, the data to be checked are obtained.
Fig. 4 shows one kind provided by this specification embodiment, and more specifically service server hardware configuration is illustrated
Figure, which may include: processor 410, memory 420, input/output interface 430, communication interface 440 and bus 450.
Wherein processor 410, memory 420, input/output interface 430 and communication interface 440 pass through between the realization of bus 450
Communication connection inside equipment.
Processor 410 can use general CPU (Central Processing Unit, central processing unit), micro process
Device, application specific integrated circuit (Application Specific Integrated Circuit, ASIC) or one or
The modes such as multiple integrated circuits are realized, for executing relative program, to realize technical solution provided by this specification embodiment.
Memory 420 can use ROM (Read Only Memory, read-only memory), RAM (RandomAccess
Memory, random access memory), static storage device, the forms such as dynamic memory realize.Memory 420 can store
Operating system and other applications are realizing technical solution provided by this specification embodiment by software or firmware
When, relevant program code is stored in memory 420, and execution is called by processor 410.
Input/output interface 430 is for connecting input/output module, to realize information input and output.Input and output/
Module can be used as component Configuration (not shown) in a device, can also be external in equipment to provide corresponding function.Wherein
Input equipment may include keyboard, mouse, touch screen, microphone, various kinds of sensors etc., output equipment may include display,
Loudspeaker, vibrator, indicator light etc..
Communication interface 440 is used for connection communication module (not shown), to realize the communication of this equipment and other equipment
Interaction.Wherein communication module can be realized by wired mode (such as USB, cable etc.) and be communicated, can also be wirelessly
(such as mobile network, WIFI, bluetooth etc.) realizes communication.
Bus 450 includes an access, in various components (such as the processor 410, memory 420, input/output of equipment
Interface 430 and communication interface 440) between transmit information.
It should be noted that although above equipment illustrates only processor 410, memory 420, input/output interface
430, communication interface 440 and bus 450, but in the specific implementation process, which can also include realizing to operate normally
Necessary other assemblies.In addition, it will be appreciated by those skilled in the art that, it can also be only comprising realizing in above equipment
Component necessary to this specification example scheme, without including all components shown in figure.
This specification embodiment also provides a kind of computer readable storage medium, is stored thereon with computer program, the journey
It realizes that a kind of integrated data query method of multi-data source above-mentioned, this method include at least when sequence is executed by processor: receiving
Data inquiry request, the data inquiry request carry the data attribute of data to be checked；According to preconfigured data category
Mapping relations between property and data source property, determine target data source attribute, wherein the data source property includes data source
Name, field name；According to the mapping relations between preconfigured data source property and atom interface, the target data source is determined
The target atoms interface of attribute mapping；According to the mapping relations between preconfigured atom interface and bottom data, pass through institute
It states target atoms interface and extracts data from the bottom data that it is mapped, obtain the data to be checked.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by any method
Or technology come realize information store.Information can be computer readable instructions, data structure, the module of program or other data.
The example of the storage medium of computer includes, but are not limited to phase change memory (PRAM), static random access memory (SRAM), moves
State random access memory (DRAM), other kinds of random access memory (RAM), read-only memory (ROM), electric erasable
Programmable read only memory (EEPROM), flash memory or other memory techniques, read-only disc read only memory (CD-ROM) (CD-ROM),
Digital versatile disc (DVD) or other optical storage, magnetic cassettes, tape magnetic disk storage or other magnetic storage devices
Or any other non-transmission medium, can be used for storage can be accessed by a computing device information.As defined in this article, it calculates
Machine readable medium does not include temporary computer readable media (transitorymedia), such as the data-signal and carrier wave of modulation.
As seen through the above description of the embodiments, those skilled in the art can be understood that this specification
Embodiment can be realized by means of software and necessary general hardware platform.Based on this understanding, this specification is implemented
Substantially the part that contributes to existing technology can be embodied in the form of software products the technical solution of example in other words,
The computer software product can store in storage medium, such as ROM/RAM, magnetic disk, CD, including some instructions are to make
It is each to obtain computer equipment (can be personal computer, server or the network equipment etc.) execution this specification embodiment
Method described in certain parts of a embodiment or embodiment.
System, device, module or the unit that above-described embodiment illustrates can specifically realize by computer chip or entity,
Or it is realized by the product with certain function.A kind of typically to realize that equipment is computer, the concrete form of computer can
To be personal computer, laptop computer, cellular phone, camera phone, smart phone, personal digital assistant, media play
In device, navigation equipment, E-mail receiver/send equipment, game console, tablet computer, wearable device or these equipment
The combination of any several equipment.
All the embodiments in this specification are described in a progressive manner, same and similar portion between each embodiment
Dividing may refer to each other, and each embodiment focuses on the differences from other embodiments.Especially for device reality
For applying example, since it is substantially similar to the method embodiment, so describing fairly simple, related place is referring to embodiment of the method
Part explanation.The apparatus embodiments described above are merely exemplary, wherein described be used as separate part description
Module may or may not be physically separated, can be each module when implementing this specification example scheme
Function realize in the same or multiple software and or hardware.Can also select according to the actual needs part therein or
Person's whole module achieves the purpose of the solution of this embodiment.Those of ordinary skill in the art are not the case where making the creative labor
Under, it can it understands and implements.
The above is only the specific embodiment of this specification embodiment, it is noted that for the general of the art
For logical technical staff, under the premise of not departing from this specification embodiment principle, several improvements and modifications can also be made, this
A little improvements and modifications also should be regarded as the protection scope of this specification embodiment.
Claims (11)
1. a kind of integrated data query method of multi-data source, which comprises
Data inquiry request is received, the data inquiry request carries the data attribute of data to be checked；
According to the mapping relations between preconfigured data attribute and data source property, the data of the data to be checked are determined
The target data source attribute of attribute mapping, wherein the data source property includes dataSource link, field name；
According to the mapping relations between preconfigured data source property and atom interface, determine that the target data source attribute reflects
The target atoms interface penetrated；
According to the mapping relations between preconfigured atom interface and bottom data, reflected by the target atoms interface from it
Data are extracted in the bottom data penetrated, obtain the data to be checked.
2. according to the method described in claim 1, between the data attribute and at least one data source property there is mapping to close
System；
There are mapping relations between the data source property and at least one atom interface.
3. according to the method described in claim 1, being configured with different data source properties for different tenants under tenant's dimension
With the mapping relations between atom interface.
4. according to the method described in claim 3, the data inquiry request also carries the data tenant to be checked
Tenant's information；
The mapping relations according between preconfigured data source property and atom interface determine the target data source category
Property mapping target atoms interface, comprising:
According to tenant's information, determines and be directed to the preconfigured data source property of the data tenant to be checked and atom
Mapping relations between interface；
Reflecting between the preconfigured data source property of the data tenant to be checked and atom interface is directed to according to described
Relationship is penetrated, determines the target atoms interface of the target data source attribute mapping.
5. according to the method described in claim 1, the mapping according between preconfigured atom interface and bottom data
Relationship extracts data from the bottom data that it is mapped by the target atoms interface, obtains the data to be checked, wrap
It includes:
According to the mapping relations between preconfigured atom interface and bottom data, reflected by the target atoms interface from it
Data are extracted in the bottom data penetrated；
The data extracted are spliced according to preconfigured data format, using the data obtained after splicing as described in
Data to be checked.
6. a kind of integrated data query device of multi-data source, described device include:
Receiving module, inquiry request, the data inquiry request carry the data attribute of data to be checked for receiving data；
First determining module, for determining institute according to the mapping relations between preconfigured data attribute and data source property
State the target data source data of the data attribute mapping of data to be checked, wherein the data source property includes dataSource link, word
Section name；
Second determining module, for determining institute according to the mapping relations between preconfigured data source property and atom interface
State the target atoms interface of target data source attribute mapping；
Data extraction module, for according to the mapping relations between preconfigured atom interface and bottom data, by described
Target atoms interface extracts data from the bottom data that it is mapped, and obtains the data to be checked.
7. device according to claim 6 between the data attribute and at least one data source property there is mapping to close
System；
There are mapping relations between the data source property and at least one atom interface.
8. device according to claim 6, under tenant's dimension, for different tenants configure different data source property with
Mapping relations between atom interface.
9. device according to claim 8, the data inquiry request also carries the data tenant to be checked
Tenant's information；
Second determining module includes:
Relationship determines submodule, for determining and matching in advance for the data tenant to be checked according to tenant's information
Mapping relations between the data source property set and atom interface；
Target determines submodule, for being directed to the preconfigured data source property of data tenant to be checked according to described
With the mapping relations between atom interface, the target atoms interface of the target data source attribute mapping is determined.
10. device according to claim 6, the data extraction module include:
Extracting sub-module, for passing through the mesh according to the mapping relations between preconfigured atom interface and bottom data
Mark atom interface extracts data from the bottom data that it is mapped；
Splice submodule, for splicing the data extracted according to preconfigured data format, will be obtained after splicing
The data arrived are as the data to be checked.
11. a kind of service server including memory, processor and stores the meter that can be run on a memory and on a processor
Calculation machine program, wherein the processor realizes method as claimed in claims 1-5 when executing described program.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811073189.1A CN109145025B (en) | 2018-09-14 | 2018-09-14 | Multi-data-source integrated data query method and device and service server |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811073189.1A CN109145025B (en) | 2018-09-14 | 2018-09-14 | Multi-data-source integrated data query method and device and service server |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109145025A true CN109145025A (en) | 2019-01-04 |
| CN109145025B CN109145025B (en) | 2021-09-24 |
Family
ID=64825389
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811073189.1A Active CN109145025B (en) | 2018-09-14 | 2018-09-14 | Multi-data-source integrated data query method and device and service server |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109145025B (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110704422A (en) * | 2019-08-14 | 2020-01-17 | 招联消费金融有限公司 | Data query method, device, system, computer equipment and storage medium |
| CN110765275A (en) * | 2019-10-14 | 2020-02-07 | 平安医疗健康管理股份有限公司 | Search method, search device, computer equipment and storage medium |
| CN110955712A (en) * | 2019-11-26 | 2020-04-03 | 北京天元创新科技有限公司 | Development API processing method and device based on multiple data sources |
| CN111104421A (en) * | 2019-12-31 | 2020-05-05 | 新奥数能科技有限公司 | Data query method and device based on data interface standard configuration |
| CN111143461A (en) * | 2019-12-31 | 2020-05-12 | 中国银行股份有限公司 | Mapping relation processing system and method and electronic equipment |
| CN111198968A (en) * | 2019-12-11 | 2020-05-26 | 中国建设银行股份有限公司 | Data query method and device |
| CN111240733A (en) * | 2020-01-21 | 2020-06-05 | 深圳市优必选科技股份有限公司 | Data acquisition method and device based on multiple third-party interfaces |
| CN111443970A (en) * | 2020-03-24 | 2020-07-24 | 山东浪潮通软信息科技有限公司 | Method, device and equipment for assembling multi-source data and readable medium |
| CN111459991A (en) * | 2020-04-15 | 2020-07-28 | 中国银行股份有限公司 | Information query method and device |
| CN111930770A (en) * | 2020-07-15 | 2020-11-13 | 北京金山云网络技术有限公司 | Data query method and device and electronic equipment |
| WO2020228801A1 (en) * | 2019-05-15 | 2020-11-19 | 华为技术有限公司 | Multi-language fusion query method and multi-model database system |
| CN111984657A (en) * | 2020-09-04 | 2020-11-24 | 河北幸福消费金融股份有限公司 | Data collection method and device, storage medium and computer equipment |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1672150A (en) * | 2002-06-21 | 2005-09-21 | 住商信息系统株式会社 | Views for software atomization |
| CN101546325A (en) * | 2008-12-23 | 2009-09-30 | 重庆邮电大学 | Grid heterogeneous data integrating method based on SOA |
| CN102081661A (en) * | 2011-01-19 | 2011-06-01 | 吉林大学 | Data integration method and system of heterogeneous relational database based on XML (Extensive Makeup Language) |
| CN102682117A (en) * | 2012-05-15 | 2012-09-19 | 浪潮电子信息产业股份有限公司 | Method for quickly copying cluster data in database |
| CN105183735A (en) * | 2014-06-18 | 2015-12-23 | 阿里巴巴集团控股有限公司 | Data query method and query device |
| CN106874461A (en) * | 2017-02-14 | 2017-06-20 | 北京慧正通软科技有限公司 | A kind of workflow engine supports multi-data source configuration security access system and method |
| CN107329809A (en) * | 2017-07-05 | 2017-11-07 | 国网信息通信产业集团有限公司 | A kind of distributed transaction processing method and system towards multi-data source |
| CN107818127A (en) * | 2017-09-09 | 2018-03-20 | 国网浙江省电力公司 | A kind of querying method and system for multi-source data |
| CN108228617A (en) * | 2016-12-14 | 2018-06-29 | 北京国双科技有限公司 | Ensure the method and device of database manipulation atomicity |
-
2018
- 2018-09-14 CN CN201811073189.1A patent/CN109145025B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1672150A (en) * | 2002-06-21 | 2005-09-21 | 住商信息系统株式会社 | Views for software atomization |
| CN101546325A (en) * | 2008-12-23 | 2009-09-30 | 重庆邮电大学 | Grid heterogeneous data integrating method based on SOA |
| CN102081661A (en) * | 2011-01-19 | 2011-06-01 | 吉林大学 | Data integration method and system of heterogeneous relational database based on XML (Extensive Makeup Language) |
| CN102682117A (en) * | 2012-05-15 | 2012-09-19 | 浪潮电子信息产业股份有限公司 | Method for quickly copying cluster data in database |
| CN105183735A (en) * | 2014-06-18 | 2015-12-23 | 阿里巴巴集团控股有限公司 | Data query method and query device |
| CN108228617A (en) * | 2016-12-14 | 2018-06-29 | 北京国双科技有限公司 | Ensure the method and device of database manipulation atomicity |
| CN106874461A (en) * | 2017-02-14 | 2017-06-20 | 北京慧正通软科技有限公司 | A kind of workflow engine supports multi-data source configuration security access system and method |
| CN107329809A (en) * | 2017-07-05 | 2017-11-07 | 国网信息通信产业集团有限公司 | A kind of distributed transaction processing method and system towards multi-data source |
| CN107818127A (en) * | 2017-09-09 | 2018-03-20 | 国网浙江省电力公司 | A kind of querying method and system for multi-source data |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2020228801A1 (en) * | 2019-05-15 | 2020-11-19 | 华为技术有限公司 | Multi-language fusion query method and multi-model database system |
| US11907216B2 (en) | 2019-05-15 | 2024-02-20 | Huawei Technologies Co., Ltd. | Multi-language fusion query method and multi-model database system |
| CN110704422A (en) * | 2019-08-14 | 2020-01-17 | 招联消费金融有限公司 | Data query method, device, system, computer equipment and storage medium |
| CN110704422B (en) * | 2019-08-14 | 2023-08-15 | 招联消费金融有限公司 | Data query method, device, system, computer equipment and storage medium |
| CN110765275A (en) * | 2019-10-14 | 2020-02-07 | 平安医疗健康管理股份有限公司 | Search method, search device, computer equipment and storage medium |
| CN110765275B (en) * | 2019-10-14 | 2023-02-07 | 深圳平安医疗健康科技服务有限公司 | Search method, search device, computer equipment and storage medium |
| CN110955712A (en) * | 2019-11-26 | 2020-04-03 | 北京天元创新科技有限公司 | Development API processing method and device based on multiple data sources |
| CN111198968A (en) * | 2019-12-11 | 2020-05-26 | 中国建设银行股份有限公司 | Data query method and device |
| CN111143461A (en) * | 2019-12-31 | 2020-05-12 | 中国银行股份有限公司 | Mapping relation processing system and method and electronic equipment |
| CN111104421A (en) * | 2019-12-31 | 2020-05-05 | 新奥数能科技有限公司 | Data query method and device based on data interface standard configuration |
| CN111143461B (en) * | 2019-12-31 | 2024-04-19 | 中国银行股份有限公司 | Mapping relation processing system, method and electronic equipment |
| CN111240733A (en) * | 2020-01-21 | 2020-06-05 | 深圳市优必选科技股份有限公司 | Data acquisition method and device based on multiple third-party interfaces |
| CN111443970A (en) * | 2020-03-24 | 2020-07-24 | 山东浪潮通软信息科技有限公司 | Method, device and equipment for assembling multi-source data and readable medium |
| CN111443970B (en) * | 2020-03-24 | 2023-11-03 | 浪潮通用软件有限公司 | Method, device, equipment and readable medium for assembling multi-source data |
| CN111459991A (en) * | 2020-04-15 | 2020-07-28 | 中国银行股份有限公司 | Information query method and device |
| CN111459991B (en) * | 2020-04-15 | 2023-04-07 | 中国银行股份有限公司 | Information query method and device |
| CN111930770A (en) * | 2020-07-15 | 2020-11-13 | 北京金山云网络技术有限公司 | Data query method and device and electronic equipment |
| CN111984657A (en) * | 2020-09-04 | 2020-11-24 | 河北幸福消费金融股份有限公司 | Data collection method and device, storage medium and computer equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109145025B (en) | 2021-09-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109145025A (en) | A kind of data query method, apparatus and service server that multi-data source is integrated | |
| US10595161B2 (en) | Associating multiple user devices with a single user | |
| US20200076811A1 (en) | Data security across data residency restriction boundaries | |
| CN108449418A (en) | A kind of mixed cloud platform management system and method | |
| US20200099535A1 (en) | Deterministic verification of digital identity documents | |
| US20160357621A1 (en) | Data processing | |
| US11481243B1 (en) | Service access across Kubernetes clusters | |
| US10044837B2 (en) | Generation and distribution of named, definable, serialized tokens | |
| CN110196889A (en) | Data processing method, device, electronic equipment and storage medium | |
| JP2019511785A (en) | Pre-formed instructions for mobile cloud services | |
| US10949600B2 (en) | Semiconductor package floating metal checks | |
| CN109284990A (en) | A kind of amount balance system and method | |
| CN110008111A (en) | A kind of service test method and device | |
| US20180246906A1 (en) | Generating a ranked list of best fitting place names | |
| US10956649B2 (en) | Semiconductor package metal shadowing checks | |
| CN111241107A (en) | Service processing method, device, medium and electronic equipment | |
| US20210174296A1 (en) | Delivery director | |
| US10546096B2 (en) | Semiconductor package via stack checking | |
| US9949073B2 (en) | Wireless service provider management of geo-fenced spaces | |
| US10168999B2 (en) | Software object definition and integration | |
| US10656975B2 (en) | Hybrid cloud with dynamic bridging between systems of record and systems of engagement | |
| US11647377B2 (en) | Mobile device roaming optimization and operation | |
| CN109788015A (en) | Application service invocation system, method and device | |
| US9129318B2 (en) | System and method for allocating suppliers using geographical information system and supplier capability | |
| US10896144B2 (en) | Automated configuring of computer system settings for peripheral device(s) |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20201010 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20201010 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman Islands Applicant after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Applicant before: Alibaba Group Holding Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |