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 PDF

Info

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
Application number
CN201811073189.1A
Other languages
Chinese (zh)
Other versions
CN109145025B (en
Inventor
刘冠雄
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Advanced New Technologies Co Ltd
Advantageous New Technologies Co Ltd
Original Assignee
Alibaba Group Holding Ltd
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 Alibaba Group Holding Ltd filed Critical Alibaba Group Holding Ltd
Priority to CN201811073189.1A priority Critical patent/CN109145025B/en
Publication of CN109145025A publication Critical patent/CN109145025A/en
Application granted granted Critical
Publication of CN109145025B publication Critical patent/CN109145025B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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

A kind of data query method, apparatus and service server that multi-data source is integrated
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 };&nbsp
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.
CN201811073189.1A 2018-09-14 2018-09-14 Multi-data-source integrated data query method and device and service server Active CN109145025B (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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

Patent Citations (9)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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