CN106933873A - A kind of cross-platform data querying method and equipment - Google Patents
A kind of cross-platform data querying method and equipment Download PDFInfo
- Publication number
- CN106933873A CN106933873A CN201511025982.0A CN201511025982A CN106933873A CN 106933873 A CN106933873 A CN 106933873A CN 201511025982 A CN201511025982 A CN 201511025982A CN 106933873 A CN106933873 A CN 106933873A
- Authority
- CN
- China
- Prior art keywords
- data
- platform
- data platform
- checked
- target
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present embodiments relate to and Data Mining, more particularly to a kind of cross-platform data querying method and equipment, for reducing volume of transmitted data, improve efficiency data query.In the embodiment of the present invention, inquiry request is received, inquiry request includes the querying condition for N number of data platform；Determine target data platform from N number of data platform；For each data platform in N number of data platform in addition to target data platform, the corresponding Data Migration order of the data platform is sent to the data platform, so that the data is activation to be checked of the querying condition for meeting the data platform that the data platform will be determined is to target data platform；Inquiry request is sent to target data platform, the corresponding total data to be checked of inquiry request that target data platform is returned are received.The data to be checked of the querying condition due to target data platform without will meet target data platform again are transmitted, therefore reduce volume of transmitted data, improve efficiency data query.
Description
Technical field
The present embodiments relate to Data Mining, more particularly to a kind of cross-platform data querying method and set
It is standby.
Background technology
At present, developing rapidly with the communication technology, user data also increases therewith, is typically different type
User data is deposited in different platforms.Such as, in telecommunication technology field, the personal information of user, than
Such as the phone number of user, the information Store such as the consumption of user, and flow service condition is in the farsighted money in day
In news (Teradata) data platform；The information of the terminal of user, such as terminal standard, terminal screen are big
It is small, and user's changes terminal the information Store such as frequency in the data of the inscriptions on bones or tortoise shells (Oracle) data platform
In storehouse；And the most-often used APP of the corresponding application category information of user, such as user, and most frequentation is asked
The information such as the Type of website are then stored in the database of enterprise-level Distributed Calculation (Hadoop) data platform.
In specific implementation, it usually needs cross-platform to carry out inquiry operation to data, for example, such as inquire about
Go out the eligible A of personal information of user, the eligible B of information of the frequency of user's changes terminal, and use
The user of the eligible C of information at the most-often used application program in family (Application, abbreviation APP).
Settling mode of the prior art is, first by Teradata data platforms, in Oracle data platforms, with
And all data stored in Hadoop big data platforms are all directed into target data platform, in target
Each data is associated (Join) in data platform, the number of association is carried out from target data platform afterwards
Inquire that " the eligible A of personal information of user, the information of the frequency of user's changes terminal meets bar in
Part B, and the eligible C of information of the most-often used APP of user user ".
In such scheme, all data platforms, i.e. Teradata data platforms, Oracle data platforms, with
And during Hadoop data platforms are required to send data to target data platform, the data volume of migration is larger,
Cause Data Migration relatively costly, therefore cause efficiency data query relatively low, and the process consume it is substantial amounts of
System resource.
In sum, a kind of cross-platform data querying method and equipment are needed badly, for reducing volume of transmitted data,
Efficiency data query is improved, and then saves system resource.
The content of the invention
The embodiment of the present invention provides a kind of cross-platform data querying method and equipment, for reducing data transfer
Amount, improves efficiency data query, and then save system resource.
The embodiment of the present invention provides a kind of cross-platform data querying method, including：
Inquiry request is received, wherein, the inquiry request includes the querying condition for N number of data platform；
Wherein, N is the integer more than 1；
Determine target data platform from N number of data platform；
For each data platform in N number of data platform in addition to the target data platform, to this
Data platform sends the corresponding Data Migration order of the data platform, so that the symbol that the data platform will be determined
The data is activation to be checked of querying condition of the data platform is closed to the target data platform；
The inquiry request is sent to the target data platform, the institute that the target data platform is returned is received
State the corresponding total data to be checked of inquiry request.
Alternatively, it is described to determine target data platform from N number of data platform, specifically include：
For each data platform in N number of data platform, according to the querying condition of the data platform,
Obtain the quantity of the data to be checked of the querying condition that the data platform is met in the data platform；
By the corresponding data platform of quantity of the maximum data to be checked of the quantity intermediate value of N number of data to be checked
It is defined as target data platform.
Alternatively, described each data platform in N number of data platform, according to the data platform
Querying condition, obtain the number of the data to be checked of the querying condition that the data platform is met in the data platform
Amount, specifically includes：
For each data platform in N number of data platform, perform：
According to the inquiry request, the corresponding query task of the data platform is generated；
The query task is sent to the data platform；Wherein, the query task includes the data platform
Querying condition；The query task is used to make the data platform determine that the data are put down according to the query task
The quantity of the data to be checked of the querying condition of the data platform is met in platform；
Receive the data platform returned after the data platform execution query task corresponding to be checked
The quantity of data.
Alternatively, the quantity of the corresponding data to be checked of each data platform includes in N number of data platform
The field quantity of the corresponding data to be checked of the data platform and the bar number of data to be checked；
The corresponding data of quantity of the maximum data to be checked of the quantity intermediate value by N number of data to be checked
Platform is defined as target data platform, specifically includes：
For each data platform in N number of data platform, determine that the data platform is corresponding to be checked
The product of the bar number of the field quantity and data to be checked of data is ask, the corresponding product of the data platform is obtained
Value；
The maximum corresponding data platform of product value of N number of product value intermediate value is defined as target data platform.
Alternatively, the data memory format of the target data platform is also included in the Data Migration order；
Described each data platform in N number of data platform in addition to the target data platform,
Data Migration order is sent to the data platform, so that the data platform meets the data platform by what is determined
Querying condition data is activation to be checked give the target data platform, specifically include：
Performed for each data platform in N number of data platform in addition to the target data platform：
Data Migration order is sent to the data platform；
Wherein, the Data Migration order meets the inquiry of the data platform for determining the data platform
The data to be checked of condition, and it is determined that the data memory format and the data platform of the target data platform
Data memory format it is inconsistent when, the data memory format of the data to be checked of the data platform is converted to
The data memory format of the target data platform, and the data is activation to be checked that will enter after row format conversion
To target data platform.
Alternatively, the corresponding total data to be checked of the inquiry request are the target data platforms for reception
To each data to be checked and the target data platform in store data be associated after, according to institute
Determined in stating data of the inquiry request after being associated.
Alternatively, the every number in N number of data platform in addition to the target data platform
According to platform, the corresponding Data Migration order of the data platform is sent to the data platform, so that the data platform
The data is activation to be checked of the querying condition for meeting the data platform that will be determined is put down to the target data
Platform, specifically includes：
For each data platform in N number of data platform in addition to the target data platform, hold
OK：
The corresponding Data Migration order of the data platform is sent to the data platform；
Wherein, the Data Migration order is used for the data platform that meets for making the data platform to determine
The data to be checked of querying condition are replicated, and the data to be checked for replicating are loaded by not landing data
Method is loaded onto the target data platform, so that the target data platform is receiving the inquiry request
And after the corresponding total data to be checked of the inquiry request for returning, by the data platform by not landing number
The data to be checked loaded according to loading method are deleted from the target data platform.
The embodiment of the present invention provides a kind of cross-platform data query facility, including：
Receiving unit, for receiving inquiry request, wherein, the inquiry request is included for N number of data
The querying condition of platform；The inquiry request for receiving the target data platform return is corresponding total to be checked
Data；Wherein, N is the integer more than 1；
Processing unit, for determining target data platform from N number of data platform；
Transmitting element, for for each in N number of data platform in addition to the target data platform
Data platform, the corresponding Data Migration order of the data platform is sent to the data platform, so that the data are flat
The data is activation to be checked of the querying condition for meeting the data platform that platform will be determined gives the target data
Platform；The inquiry request is sent to the target data platform.
Alternatively, the processing unit, specifically for：
For each data platform in N number of data platform, according to the querying condition of the data platform,
Obtain the quantity of the data to be checked of the querying condition that the data platform is met in the data platform；
By the corresponding data platform of quantity of the maximum data to be checked of the quantity intermediate value of N number of data to be checked
It is defined as target data platform.
Alternatively, the processing unit, in described each data platform in N number of data platform,
According to the querying condition of the data platform, querying condition that the data platform is met in the data platform is obtained
During the quantity of data to be checked, specifically for：
For each data platform in N number of data platform, perform：
According to the inquiry request, the corresponding query task of the data platform is generated；
The query task is sent to the data platform；Wherein, the query task includes the data platform
Querying condition；The query task is used to make the data platform determine that the data are put down according to the query task
The quantity of the data to be checked of the querying condition of the data platform is met in platform；
Receive the data platform returned after the data platform execution query task corresponding to be checked
The quantity of data.
Alternatively, the quantity of the corresponding data to be checked of each data platform includes in N number of data platform
The field quantity of the corresponding data to be checked of the data platform and the bar number of data to be checked；
The processing unit, specifically for：
For each data platform in N number of data platform, determine that the data platform is corresponding to be checked
The product of the bar number of the field quantity and data to be checked of data is ask, the corresponding product of the data platform is obtained
Value；
The maximum corresponding data platform of product value of N number of product value intermediate value is defined as target data platform.
Alternatively, the data memory format of the target data platform is also included in the Data Migration order；
The processing unit, specifically for：
Performed for each data platform in N number of data platform in addition to the target data platform：
Data Migration order is sent to the data platform；
Wherein, the Data Migration order meets the inquiry of the data platform for determining the data platform
The data to be checked of condition, and it is determined that the data memory format and the data platform of the target data platform
Data memory format it is inconsistent when, the data memory format of the data to be checked of the data platform is converted to
The data memory format of the target data platform, and the data is activation to be checked that will enter after row format conversion
To target data platform.
Alternatively, the corresponding total data to be checked of the inquiry request are the target data platforms for reception
To each data to be checked and the target data platform in store data be associated after, according to institute
Determined in stating data of the inquiry request after being associated.
Alternatively, the processing unit, specifically for：
For each data platform in N number of data platform in addition to the target data platform, hold
OK：
The corresponding Data Migration order of the data platform is sent to the data platform；
Wherein, the Data Migration order is used for the data platform that meets for making the data platform to determine
The data to be checked of querying condition are replicated, and the data to be checked for replicating are loaded by not landing data
Equipment is loaded onto the target data platform, so that the target data platform is receiving the inquiry request
And after the corresponding total data to be checked of the inquiry request for returning, by the data platform by not landing number
The data to be checked loaded according to loading equipemtn are deleted from the target data platform.
In the embodiment of the present invention, inquiry request is received, wherein, the inquiry request is included for N number of number
According to the querying condition of platform；Wherein, N is the integer more than 1；Determine mesh from N number of data platform
Mark data platform；Put down for each data in N number of data platform in addition to the target data platform
Platform, the corresponding Data Migration order of the data platform is sent to the data platform, so that the data platform will be true
That makes meets the data is activation to be checked of the querying condition of the data platform to the target data platform；To
The target data platform sends the inquiry request, receives the inquiry that the target data platform is returned
The corresponding total data to be checked of request.Due to determining target data platform from N number of data platform, because
This, the data to be checked on each data platform can be sent to target data and put down by other data platforms
Platform, and target data platform is without again by the inquiry bar for meeting target data platform in the target data platform
The data to be checked of part are transmitted, it is seen then that reduce volume of transmitted data, and then improve data query effect
Rate, saves system resource.
Brief description of the drawings
Technical scheme in order to illustrate more clearly the embodiments of the present invention, institute in being described to embodiment below
The accompanying drawing for needing to use is briefly introduced, it should be apparent that, drawings in the following description are only of the invention
Some embodiments, for one of ordinary skill in the art, on the premise of not paying creative work,
Other accompanying drawings can also be obtained according to these accompanying drawings.
Fig. 1 is a kind of system architecture schematic diagram that the embodiment of the present invention is applicable；
Fig. 2 is a kind of cross-platform data querying method schematic flow sheet provided in an embodiment of the present invention；
Fig. 3 is a kind of structural representation of cross-platform data query facility provided in an embodiment of the present invention.
Specific embodiment
In order that the purpose of the present invention, technical scheme and beneficial effect become more apparent, below in conjunction with accompanying drawing
And embodiment, the present invention will be described in further detail.It should be appreciated that specific implementation described herein
Example is only used to explain the present invention, is not intended to limit the present invention.
Fig. 1 illustrates a kind of applicable system architecture schematic diagram of the embodiment of the present invention, as shown in figure 1,
The applicable system architecture of the embodiment of the present invention includes cross-platform data query facility 101, and multiple data are put down
Platform, illustrates multiple data platforms, respectively data platform 102, data platform 103 in Fig. 1
With data platform 104.Different types of data, and each data platform can be stored in different data platforms
There is corresponding data memory format during middle data storage.Data are stored in the database of data platform.
For concreteness, such as data platform 102 can be Teradata data platforms, data platform 103
Can be Oracle data platforms, data platform 103 can be Hadoop big data platforms.
Teradata data platforms are used to store the personal information of user, such as the phone number of user, user
Length of surfing the Net, the age of user etc.；Also store the consumption of user, such as the bill expense of user, user
The accrediting amount etc.；Also store the flow service condition of user, such as the average data flow that user is used
WLAN data flow value that value, user are used etc..Oracle data platforms are used to store the end of user
Frequency of the information at end, such as terminal standard, terminal screen size, and user's changes terminal etc..Hadoop
Data platform is used to store the corresponding application category information of user, such as the most-often used APP of user, and most
The information such as the Type of website that frequentation is asked.
The inquiry request that cross-platform data query facility 101 is received is:Inquire length of surfing the Net more than 5 years, often
Month flow usage amount is 800,000,000 (M), and average each year more preferable terminal, and most video is asked in frequentation
The user of class website.Can be seen that, more than 5 years, monthly flow usage amount is 800 to length of surfing the Net in the inquiry request
The data storage of the user of million (M) is in Teradata data platforms；Average each year more preferable terminal
The data storage of user is in Oracle data platforms；Most frequentation asks that the user data of video class website is stored in
Hadoop big data platforms.
Cross-platform data query facility 101 is from Teradata data platforms, Oracle data platforms and Hadoop
A data platform is determined in data platform as target data platform, such as by Teradata data platforms
Used as target data platform, now Oracle data platforms and Hadoop big datas platform are another source data
Platform.Cross-platform data query facility 101 sends Data Migration order to two source data platforms, so that
Oracle data platforms equal the data is activation of the user of average each year more preferable terminal to target data
Platform, so that most frequentation is asked that the user data of video class website is sent to target data by Hadoop data platforms
Platform；Between the data that target data platform will be received, and target data platform data in itself are carried out
Association.Cross-platform data query facility 101 sends inquiry request, target data platform to target data platform
The user data that inquiry request will be met returns to cross-platform data query facility 101.
It can be seen that, in said process, due to determining target data platform from N number of data platform, therefore,
Data to be checked on each data platform can be sent to target data platform by other data platforms,
And target data platform is without again by the querying condition for meeting target data platform in the target data platform
Data to be checked be transmitted, it is seen then that reduce volume of transmitted data, and then improve efficiency data query,
Save system resource.
Fig. 2 illustrates a kind of cross-platform data querying method flow provided in an embodiment of the present invention and illustrates
Figure.
Based on system architecture and the above shown in Fig. 1, as shown in Fig. 2 provided in an embodiment of the present invention
A kind of cross-platform data querying method, can be realized by cross-platform data query facility, and the method includes following step
Suddenly：
Step 201, cross-platform data query facility receives inquiry request, wherein, inquiry request includes pin
To the querying condition of N number of data platform；Wherein, N is the integer more than 1；
Step 202, cross-platform data query facility determines target data platform from N number of data platform；
Step 203, cross-platform data query facility in N number of data platform in addition to target data platform
Each data platform, send the corresponding Data Migration order of the data platform to the data platform so that should
The data is activation to be checked of the querying condition for meeting the data platform that data platform will be determined is to number of targets
According to platform；
Step 204, cross-platform data query facility sends inquiry request to target data platform, receives target
The corresponding total data to be checked of inquiry request that data platform is returned.
Due to determining target data platform from N number of data platform, therefore, other data platforms can be by
Data to be checked on each data platform are sent to target data platform, and target data platform without again
The data to be checked of the querying condition for meeting target data platform in the target data platform are transmitted,
It can be seen that, volume of transmitted data is reduced, and then efficiency data query is improve, save system resource.
Alternatively, in above-mentioned steps 201, user can be asked by self-service configuration interface input inquiry, from
The formula configuration interface of helping includes the querying condition chosen or insert for user, and these querying conditions can come from
In different platforms.Such as, self-service configuration interface included length of surfing the Net more than several years, and user can insert
More than 5 years, more than 3 years, or insert 2 years to 6 years etc. contents.
In above-mentioned steps 202, cross-platform data query facility can be by any one in N number of data platform
Data platform is defined as target data platform.Or cross-platform data query facility can equal N number of data
The most strong data platform of disposal ability in platform, or by the minimum number of the load burden in N number of data platform
It is defined as target data platform according to platform.
The embodiment of the present invention provides a kind of implementation method alternatively, described true from N number of data platform
Set the goal data platform, specifically includes：
For each data platform in N number of data platform, according to the querying condition of the data platform,
Obtain the quantity of the data to be checked of the querying condition that the data platform is met in the data platform；Treated N number of
The corresponding data platform of quantity for inquiring about the data to be checked of the quantity intermediate value maximum of data is defined as number of targets
According to platform.
For example, N is 3, N number of data platform be respectively the first data platform, the second data platform and
3rd data platform.Inquiry request includes three querying conditions of data platform, is respectively that the first data are put down
The querying condition A of platform, the querying condition B, the querying condition C of the 3rd data platform of the second data platform.
The quantity that the data to be checked of querying condition A are met in first data platform is 5；It is full in second data platform
The quantity of the data to be checked of sufficient querying condition B is 10；Meet querying condition C's in 3rd data platform
The quantity of data to be checked is 20；Then the 3rd data platform of selection is used as target data platform.Now, it is only necessary to
The quantity for wanting the first data platform to meet the data to be checked of querying condition A is that 5 data are transferred to target
Data platform, the quantity that the second data platform will meet the data to be checked of querying condition B is 10 data
Target data platform is transferred to, without the data that the 3rd data platform transmitted data amount is 20 during being somebody's turn to do,
Volume of transmitted data is only 15, it is seen then that in this way, maximized reduce volume of transmitted data, further improved
Efficiency data query, saves system resource.
Alternatively, according to the querying condition of the data platform, to obtain and meet the data platform in the data platform
The mode of quantity of data to be checked of querying condition have various, such as each data is gone according to inquiry request
Inquiry meets the quantity of the data of the querying condition in inquiry request in platform, for another example sends inquiry request
Each data platform is given, so that each data platform reports the quantity of the data for meeting inquiry request.
The embodiment of the present invention provides a kind of alternatively implementation method, described in N number of data platform
Each data platform, according to the querying condition of the data platform, obtains and meet in the data platform data and put down
The quantity of the data to be checked of the querying condition of platform, specifically includes：
For each data platform in N number of data platform, perform：
According to the inquiry request, the corresponding query task of the data platform is generated；
The query task is sent to the data platform；Wherein, the query task includes the data platform
Querying condition；The query task is used to make the data platform determine that the data are put down according to the query task
The quantity of the data to be checked of the querying condition of the data platform is met in platform；
Receive the data platform returned after the data platform execution query task corresponding to be checked
The quantity of data.
For example, N is 3, N number of data platform be respectively the first data platform, the second data platform and
3rd data platform.Inquiry request includes three querying conditions of data platform, is respectively that the first data are put down
The querying condition A of platform, the querying condition B, the querying condition C of the 3rd data platform of the second data platform.
Cross-platform data query facility generates the query task A of the first data platform according to inquiry request, generation the
The query task B, the query task C of the 3rd data platform of two data platforms.Query task A includes looking into
Inquiry condition A；Query task B includes that querying condition B, query task C include querying condition C.Across
Query task A is sent to the first data platform by platform data query facility, and query task B is sent to
Second data platform, the 3rd data platform is sent to by query task C.First data platform is appointed according to inquiry
Business A finds the quantity of the data for meeting querying condition A, and the quantity is returned into cross-platform data inquiry
Equipment；Second data platform finds the quantity of the user data for meeting querying condition B according to query task B,
And the quantity is returned into cross-platform data query facility；3rd data platform finds symbol according to query task C
The quantity of the user data of querying condition C is closed, and the quantity is returned into cross-platform data query facility.
It can be seen that, the inquiry request that cross-platform data query facility will be received is split, and is analyzed, raw
Into the query task of each data platform response.
Meet alternatively in the embodiment of the present invention, in data platform the data platform querying condition it is to be checked
The quantity of data can be the total number of data, or be the size for taking up room of data, such as the data are accounted for
Use space 5M；Or the quantity of all fields for data occupancy.
The embodiment of the present invention provides a kind of alternatively implementation method, and each data is put down in N number of data platform
The field quantity of the quantity of the corresponding data to be checked of platform including the corresponding data to be checked of the data platform and
The bar number of data to be checked；
The corresponding data of quantity of the maximum data to be checked of the quantity intermediate value by N number of data to be checked
Platform is defined as target data platform, specifically includes：
For each data platform in N number of data platform, determine that the data platform is corresponding to be checked
The product of the bar number of the field quantity and data to be checked of data is ask, the corresponding product of the data platform is obtained
Value；The maximum corresponding data platform of product value of N number of product value intermediate value is defined as target data platform.
For example, N number of data platform be respectively Teradata data platforms, Oracle data platforms and
Hadoop data platforms, 500,000 are had from the data for meeting querying condition of Teradata data platforms inquiry
Bar, 7 fields are included per data, and 7 fields are respectively the phone number field of user, user
Length of surfing the Net field, the age field of user, the bill expense field of user, the accrediting amount field of user, use
The average data flow value field that family is used and the WLAN data flow value field that user is used.This
When, Teradata data platforms are treated to the data platform that cross-platform data query facility 101 is returned is corresponding
The field quantity for inquiring about data is 7, and the bar number of data to be checked is 500,000.
100,000 are had from the data for meeting querying condition of Oracle data platforms inquiry, per data bag
3 fields are included, 3 fields are respectively terminal standard field, terminal screen size field, and user
The frequency field of changes terminal.Now, Oracle data platforms are returned to cross-platform data query facility 101
The field quantity of the corresponding data to be checked of the data platform be 3, the bar number of data to be checked is 100,000.
200,000 are had from the data for meeting querying condition of Hadoop data platforms inquiry, per data bag
2 fields are included, 2 fields are respectively the most-often used APP fields of user, and most frequentation is asked
Type of website field.Now, Hadoop data platforms are to being somebody's turn to do that cross-platform data query facility 101 is returned
The field quantity of the corresponding data to be checked of data platform is 2, and the bar number of data to be checked is 200,000.
For each data platform in N number of data platform, determine that the data platform is corresponding to be checked
The product of the bar number of the field quantity and data to be checked of data is ask, the corresponding product of the data platform is obtained
Value, with reference to the example, then the product value of Teradata data platforms is multiplied by 7 for 500,000, equal to 350；Oracle
The product value of data platform is multiplied by 3 for 100,000, equal to 30；The product value of Hadoop data platforms is 20
Ten thousand are multiplied by 2, equal to 40.Product value it is maximum be 350, therefore by the maximum product of N number of product value intermediate value
Be worth corresponding data platform and be defined as target data platform, will Teradata data platforms be defined as number of targets
According to platform.
It can be seen that, in this way, maximized reduce volume of transmitted data, efficiency data query is further increased,
Save system resource.
Alternatively, in above-mentioned steps 203, the target data platform is also included in the Data Migration order
Data memory format；
Described each data platform in N number of data platform in addition to the target data platform,
Data Migration order is sent to the data platform, so that the data platform meets the data platform by what is determined
Querying condition data is activation to be checked give the target data platform, specifically include：
Performed for each data platform in N number of data platform in addition to the target data platform：
Data Migration order is sent to the data platform；
Wherein, the Data Migration order meets the inquiry of the data platform for determining the data platform
The data to be checked of condition, and it is determined that the data memory format and the data platform of the target data platform
Data memory format it is inconsistent when, the data memory format of the data to be checked of the data platform is converted to
The data memory format of the target data platform, and the data is activation to be checked that will enter after row format conversion
To target data platform.
For example, N number of data platform is respectively the first data platform, the second data platform and the 3rd data
Platform, N is three, and now the 3rd data platform is target data platform.The data storage of the 3rd data platform
Form is that perpendicular table, i.e. a data only take up a row, but can take a line or multirow；And the first data are flat
The data memory format of platform and the second data platform is horizontal table, i.e. a data and only takes up a line, but can
Take one or more columns per page.Now need to meet the to be checked of querying condition by what is determined in the first data platform
The storage format of data is changed to perpendicular table from horizontal table, and by the data is activation to be checked of perpendicular sheet form to number of targets
According to platform；The storage format of the data to be checked of querying condition that is determined in the second data platform meet is from horizontal stroke
Table is changed to perpendicular table, and by the data is activation to be checked of perpendicular sheet form to target data platform.
Another alternatively implementation method is in the embodiment of the present invention, the first data platform and the second data platform
Horizontal table is directly sent to target data platform, target data platform puts down the first data platform and the second data
The horizontal tableau format that platform sends is converted to perpendicular table.
The embodiment of the present invention provides a kind of alternatively implementation method, described for being removed in N number of data platform
Each data platform outside the target data platform, sends the data platform corresponding to the data platform
Data Migration order, so that the querying condition for meeting the data platform that will determine of the data platform is to be checked
Data is activation is ask to the target data platform, is specifically included：
For each data platform in N number of data platform in addition to the target data platform, hold
OK：
The corresponding Data Migration order of the data platform is sent to the data platform；
Wherein, the Data Migration order is used for the data platform that meets for making the data platform to determine
The data to be checked of querying condition are replicated, and the data to be checked for replicating are loaded by not landing data
Method is loaded onto the target data platform, so that the target data platform is receiving the inquiry request
And after the corresponding total data to be checked of the inquiry request for returning, by the data platform by not landing number
The data to be checked loaded according to loading method are deleted from the target data platform.
Specifically, when each data platform in N number of data platform in addition to the target data platform will
When respective data is activation to be checked is to target data platform, the mode of shearing is not used, but use and replicate
Mode replicate another data, now, when in N number of data platform in addition to the target data platform
Still be stored with respective data to be checked in each data platform.
Alternatively, the corresponding total data to be checked of the inquiry request are the target data platforms for reception
To each data to be checked and the target data platform in store data be associated after, according to institute
Determined in stating data of the inquiry request after being associated.
For example, N number of data platform is respectively the first data platform, the second data platform and the 3rd data
Platform, N is three, and now the 3rd data platform is target data platform.The inquiry bar that inquiry request includes
Part is the querying condition A of the first data platform, the querying condition B of the second data platform, the 3rd data platform
Querying condition C.That meet querying condition A in the first data platform is data A to be checked, the second data
That meet querying condition B in platform is data B to be checked.First data platform carries out data A to be checked
Replicate, and the data A to be checked for replicating is sent to target data platform, the second data platform will be to be checked
Data B is replicated, and the data B to be checked for replicating is sent into target data platform, now, the
Also be stored with data A to be checked in one data platform, and be also stored with data B to be checked in the second data platform.
In data A to be checked, data B to be checked and the target data platform that target data platform will be received
Data are associated (Join), and for example, data A to be checked includes that user X's meets inquiry bar
The data of part A, also include the data for meeting querying condition B of user X, mesh in data B to be checked
Also the related data of user X is included in mark data platform.Now, by data A to be checked, data to be checked
The data of the user X in B and target data platform are associated.Target data platform receives inquiry please
After asking, that is, determine while meet the data of querying condition A, querying condition B and querying condition C, then
Target data platform determines the corresponding total data to be checked of inquiry request in the data after being associated,
Total data to be checked are while meet the data of querying condition A, querying condition B and querying condition C,
Total data to be checked are simultaneously returned to cross-platform data query facility by target data platform, so that cross-platform number
Total data to be checked are returned into user according to query facility.
Alternatively, afterwards target data platform by data A to be checked and data B to be checked from number of targets
Deleted according in platform, can so avoid taking the space of target data platform.
Alternatively, can be put down by each data when transmitting data in the embodiment of the present invention between each data platform
The standard interface of platform, such as ODBC interfaces, JDBC interfaces are transmitted, and Teradata data are flat
TPT interfaces of platform etc..
The procedure that the embodiment of the present invention is provided all is automatically performed, and without manual intervention, alleviates tool
Workload in body implementation process, improves operating efficiency.And, it is to avoid the transport number between data platform
According to when numerous and diverse approval process, further improve efficiency data query.
It can be seen from the above：In the embodiment of the present invention, inquiry request is received, wherein, the inquiry
Request includes the querying condition for N number of data platform；Wherein, N is the integer more than 1；From described
Determine target data platform in N number of data platform；For in N number of data platform remove the target data
Each data platform outside platform, sends the corresponding Data Migration of the data platform and orders to the data platform
Order, so that the data is activation to be checked of the querying condition for meeting the data platform that the data platform will be determined
To the target data platform；The inquiry request is sent to the target data platform, the target is received
The corresponding total data to be checked of the inquiry request that data platform is returned.Due to from N number of data platform
Middle determination target data platform, therefore, other data platforms can will be to be checked on each data platform
Data are sent to target data platform, and target data platform without again by the symbol in the target data platform
The data to be checked for closing the querying condition of target data platform are transmitted, it is seen then that reduce volume of transmitted data,
And then efficiency data query is improve, save system resource.
The structure that Fig. 3 illustrates a kind of cross-platform data query facility provided in an embodiment of the present invention is shown
It is intended to.
Based on same idea, the embodiment of the present invention provides a kind of cross-platform data query facility, as shown in figure 3,
Cross-platform data query facility 300 includes receiving unit 301, processing unit 302 and transmitting element 303：
Receiving unit, for receiving inquiry request, wherein, the inquiry request is included for N number of data
The querying condition of platform；The inquiry request for receiving the target data platform return is corresponding total to be checked
Data；Wherein, N is the integer more than 1；
Processing unit, for determining target data platform from N number of data platform；
Transmitting element, for for each in N number of data platform in addition to the target data platform
Data platform, the corresponding Data Migration order of the data platform is sent to the data platform, so that the data are flat
The data is activation to be checked of the querying condition for meeting the data platform that platform will be determined gives the target data
Platform；The inquiry request is sent to the target data platform.
Alternatively, the processing unit, specifically for：
For each data platform in N number of data platform, according to the querying condition of the data platform,
Obtain the quantity of the data to be checked of the querying condition that the data platform is met in the data platform；
By the corresponding data platform of quantity of the maximum data to be checked of the quantity intermediate value of N number of data to be checked
It is defined as target data platform.
Alternatively, the processing unit, in described each data platform in N number of data platform,
According to the querying condition of the data platform, querying condition that the data platform is met in the data platform is obtained
During the quantity of data to be checked, specifically for：
For each data platform in N number of data platform, perform：
According to the inquiry request, the corresponding query task of the data platform is generated；
The query task is sent to the data platform；Wherein, the query task includes the data platform
Querying condition；The query task is used to make the data platform determine that the data are put down according to the query task
The quantity of the data to be checked of the querying condition of the data platform is met in platform；
Receive the data platform returned after the data platform execution query task corresponding to be checked
The quantity of data.
Alternatively, the quantity of the corresponding data to be checked of each data platform includes in N number of data platform
The field quantity of the corresponding data to be checked of the data platform and the bar number of data to be checked；
The processing unit, specifically for：
For each data platform in N number of data platform, determine that the data platform is corresponding to be checked
The product of the bar number of the field quantity and data to be checked of data is ask, the corresponding product of the data platform is obtained
Value；
The maximum corresponding data platform of product value of N number of product value intermediate value is defined as target data platform.
Alternatively, the data memory format of the target data platform is also included in the Data Migration order；
The processing unit, specifically for：
Performed for each data platform in N number of data platform in addition to the target data platform：
Data Migration order is sent to the data platform；
Wherein, the Data Migration order meets the inquiry of the data platform for determining the data platform
The data to be checked of condition, and it is determined that the data memory format and the data platform of the target data platform
Data memory format it is inconsistent when, the data memory format of the data to be checked of the data platform is converted to
The data memory format of the target data platform, and the data is activation to be checked that will enter after row format conversion
To target data platform.
Alternatively, the corresponding total data to be checked of the inquiry request are the target data platforms for reception
To each data to be checked and the target data platform in store data be associated after, according to institute
Determined in stating data of the inquiry request after being associated.
Alternatively, the processing unit, specifically for：
For each data platform in N number of data platform in addition to the target data platform, hold
OK：
The corresponding Data Migration order of the data platform is sent to the data platform；
Wherein, the Data Migration order is used for the data platform that meets for making the data platform to determine
The data to be checked of querying condition are replicated, and the data to be checked for replicating are loaded by not landing data
Equipment is loaded onto the target data platform, so that the target data platform is receiving the inquiry request
And after the corresponding total data to be checked of the inquiry request for returning, by the data platform by not landing number
The data to be checked loaded according to loading equipemtn are deleted from the target data platform.
It can be seen from the above：In the embodiment of the present invention, inquiry request is received, wherein, the inquiry
Request includes the querying condition for N number of data platform；Wherein, N is the integer more than 1；From described
Determine target data platform in N number of data platform；For in N number of data platform remove the target data
Each data platform outside platform, sends the corresponding Data Migration of the data platform and orders to the data platform
Order, so that the data is activation to be checked of the querying condition for meeting the data platform that the data platform will be determined
To the target data platform；The inquiry request is sent to the target data platform, the target is received
The corresponding total data to be checked of the inquiry request that data platform is returned.Due to from N number of data platform
Middle determination target data platform, therefore, other data platforms can will be to be checked on each data platform
Data are sent to target data platform, and target data platform without again by the symbol in the target data platform
The data to be checked for closing the querying condition of target data platform are transmitted, it is seen then that reduce volume of transmitted data,
And then efficiency data query is improve, save system resource.
It should be understood by those skilled in the art that, embodiments of the invention can be provided as method or computer journey
Sequence product.Therefore, the present invention can use complete hardware embodiment, complete software embodiment or combine software
With the form of the embodiment of hardware aspect.And, the present invention can be used and wherein include meter at one or more
Calculation machine usable program code computer-usable storage medium (including but not limited to magnetic disk storage,
CD-ROM, optical memory etc.) on implement computer program product form.
The present invention is produced with reference to method according to embodiments of the present invention, equipment (system) and computer program
The flow chart and/or block diagram of product is described.It should be understood that can by computer program instructions realize flow chart and
/ or block diagram in each flow and/or the flow in square frame and flow chart and/or block diagram and/
Or the combination of square frame.These computer program instructions to all-purpose computer, special-purpose computer, insertion can be provided
The processor of formula processor or other programmable data processing devices is producing a machine so that by calculating
The instruction of the computing device of machine or other programmable data processing devices is produced for realizing in flow chart one
The equipment of the function of being specified in individual flow or multiple one square frame of flow and/or block diagram or multiple square frames.
These computer program instructions may be alternatively stored in can guide computer or the treatment of other programmable datas to set
In the standby computer-readable memory for working in a specific way so that storage is in the computer-readable memory
Instruction produce include the manufacture of commander equipment, the commander equipment realization in one flow of flow chart or multiple
The function of being specified in one square frame of flow and/or block diagram or multiple square frames.
These computer program instructions can be also loaded into computer or other programmable data processing devices, made
Obtain and series of operation steps is performed on computer or other programmable devices to produce computer implemented place
Reason, so as to the instruction performed on computer or other programmable devices is provided for realizing in flow chart one
The step of function of being specified in flow or multiple one square frame of flow and/or block diagram or multiple square frames.
, but those skilled in the art once know base although preferred embodiments of the present invention have been described
This creative concept, then can make other change and modification to these embodiments.So, appended right will
Ask and be intended to be construed to include preferred embodiment and fall into having altered and changing for the scope of the invention.
Obviously, those skilled in the art can carry out various changes and modification without deviating from this hair to the present invention
Bright spirit and scope.So, if it is of the invention these modification and modification belong to the claims in the present invention and
Within the scope of its equivalent technologies, then the present invention is also intended to comprising these changes and modification.
Claims (14)
1. a kind of cross-platform data querying method, it is characterised in that including：
Inquiry request is received, wherein, the inquiry request includes the querying condition for N number of data platform；
Wherein, N is the integer more than 1；
Determine target data platform from N number of data platform；
For each data platform in N number of data platform in addition to the target data platform, to this
Data platform sends the corresponding Data Migration order of the data platform, so that the symbol that the data platform will be determined
The data is activation to be checked of querying condition of the data platform is closed to the target data platform；
The inquiry request is sent to the target data platform, the institute that the target data platform is returned is received
State the corresponding total data to be checked of inquiry request.
2. the method for claim 1, it is characterised in that described from N number of data platform
Determine target data platform, specifically include：
For each data platform in N number of data platform, according to the querying condition of the data platform,
Obtain the quantity of the data to be checked of the querying condition that the data platform is met in the data platform；
By the corresponding data platform of quantity of the maximum data to be checked of the quantity intermediate value of N number of data to be checked
It is defined as target data platform.
3. method as claimed in claim 2, it is characterised in that described for N number of data platform
In each data platform, according to the querying condition of the data platform, to obtain and meet the number in the data platform
According to the quantity of the data to be checked of the querying condition of platform, specifically include：
For each data platform in N number of data platform, perform：
According to the inquiry request, the corresponding query task of the data platform is generated；
The query task is sent to the data platform；Wherein, the query task includes the data platform
Querying condition；The query task is used to make the data platform determine that the data are put down according to the query task
The quantity of the data to be checked of the querying condition of the data platform is met in platform；
Receive the data platform returned after the data platform execution query task corresponding to be checked
The quantity of data.
4. method as claimed in claim 2, it is characterised in that per number in N number of data platform
Quantity according to the corresponding data to be checked of platform includes the Field Count of the corresponding data to be checked of the data platform
The bar number of amount and data to be checked；
The corresponding data of quantity of the maximum data to be checked of the quantity intermediate value by N number of data to be checked
Platform is defined as target data platform, specifically includes：
For each data platform in N number of data platform, determine that the data platform is corresponding to be checked
The product of the bar number of the field quantity and data to be checked of data is ask, the corresponding product of the data platform is obtained
Value；
The maximum corresponding data platform of product value of N number of product value intermediate value is defined as target data platform.
5. the method for claim 1, it is characterised in that also include in the Data Migration order
The data memory format of the target data platform；
Described each data platform in N number of data platform in addition to the target data platform,
Data Migration order is sent to the data platform, so that the data platform meets the data platform by what is determined
Querying condition data is activation to be checked give the target data platform, specifically include：
Performed for each data platform in N number of data platform in addition to the target data platform：
Data Migration order is sent to the data platform；
Wherein, the Data Migration order meets the inquiry of the data platform for determining the data platform
The data to be checked of condition, and it is determined that the data memory format and the data platform of the target data platform
Data memory format it is inconsistent when, the data memory format of the data to be checked of the data platform is converted to
The data memory format of the target data platform, and the data is activation to be checked that will enter after row format conversion
To target data platform.
6. the method as described in claim 1 to 5 any claim, it is characterised in that the inquiry
The corresponding total data to be checked of request are that the target data platform is directed to each data to be checked for receiving
And after the data stored in the target data platform are associated, according to the inquiry request from being closed
Determined in data after connection.
7. the method for claim 1, it is characterised in that described for N number of data platform
In each data platform in addition to the target data platform, send the data platform pair to the data platform
The Data Migration order answered, so that the querying condition for meeting the data platform that will determine of the data platform
Data is activation to be checked gives the target data platform, specifically includes：
For each data platform in N number of data platform in addition to the target data platform, hold
OK：
The corresponding Data Migration order of the data platform is sent to the data platform；
Wherein, the Data Migration order is used for the data platform that meets for making the data platform to determine
The data to be checked of querying condition are replicated, and the data to be checked for replicating are loaded by not landing data
Method is loaded onto the target data platform, so that the target data platform is receiving the inquiry request
And after the corresponding total data to be checked of the inquiry request for returning, by the data platform by not landing number
The data to be checked loaded according to loading method are deleted from the target data platform.
8. a kind of cross-platform data query facility, it is characterised in that including：
Receiving unit, for receiving inquiry request, wherein, the inquiry request is included for N number of data
The querying condition of platform；The inquiry request for receiving the target data platform return is corresponding total to be checked
Data；Wherein, N is the integer more than 1；
Processing unit, for determining target data platform from N number of data platform；
Transmitting element, for for each in N number of data platform in addition to the target data platform
Data platform, the corresponding Data Migration order of the data platform is sent to the data platform, so that the data are flat
The data is activation to be checked of the querying condition for meeting the data platform that platform will be determined gives the target data
Platform；The inquiry request is sent to the target data platform.
9. equipment as claimed in claim 8, it is characterised in that the processing unit, specifically for：
For each data platform in N number of data platform, according to the querying condition of the data platform,
Obtain the quantity of the data to be checked of the querying condition that the data platform is met in the data platform；
By the corresponding data platform of quantity of the maximum data to be checked of the quantity intermediate value of N number of data to be checked
It is defined as target data platform.
10. equipment as claimed in claim 9, it is characterised in that the processing unit, is directed to described
Each data platform in N number of data platform, according to the querying condition of the data platform, obtains the number
According to the data to be checked of the querying condition that the data platform is met in platform quantity when, specifically for：
For each data platform in N number of data platform, perform：
According to the inquiry request, the corresponding query task of the data platform is generated；
The query task is sent to the data platform；Wherein, the query task includes the data platform
Querying condition；The query task is used to make the data platform determine that the data are put down according to the query task
The quantity of the data to be checked of the querying condition of the data platform is met in platform；
Receive the data platform returned after the data platform execution query task corresponding to be checked
The quantity of data.
11. equipment as claimed in claim 9, it is characterised in that per number in N number of data platform
Quantity according to the corresponding data to be checked of platform includes the Field Count of the corresponding data to be checked of the data platform
The bar number of amount and data to be checked；
The processing unit, specifically for：
For each data platform in N number of data platform, determine that the data platform is corresponding to be checked
The product of the bar number of the field quantity and data to be checked of data is ask, the corresponding product of the data platform is obtained
Value；
The maximum corresponding data platform of product value of N number of product value intermediate value is defined as target data platform.
12. equipment as claimed in claim 8, it is characterised in that also include in the Data Migration order
The data memory format of the target data platform；
The processing unit, specifically for：
Performed for each data platform in N number of data platform in addition to the target data platform：
Data Migration order is sent to the data platform；
Wherein, the Data Migration order meets the inquiry of the data platform for determining the data platform
The data to be checked of condition, and it is determined that the data memory format and the data platform of the target data platform
Data memory format it is inconsistent when, the data memory format of the data to be checked of the data platform is converted to
The data memory format of the target data platform, and the data is activation to be checked that will enter after row format conversion
To target data platform.
13. equipment as described in claim 8 to 12 any claim, it is characterised in that described to look into
It is that the target data platform is directed to each number to be checked for receiving to ask the corresponding total data to be checked of request
According to and the target data platform in after the data that store are associated, according to the inquiry request from carrying out
Determined in data after association.
14. equipment as claimed in claim 8, it is characterised in that the processing unit, specifically for：
For each data platform in N number of data platform in addition to the target data platform, hold
OK：
The corresponding Data Migration order of the data platform is sent to the data platform；
Wherein, the Data Migration order is used for the data platform that meets for making the data platform to determine
The data to be checked of querying condition are replicated, and the data to be checked for replicating are loaded by not landing data
Equipment is loaded onto the target data platform, so that the target data platform is receiving the inquiry request
And after the corresponding total data to be checked of the inquiry request for returning, by the data platform by not landing number
The data to be checked loaded according to loading equipemtn are deleted from the target data platform.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511025982.0A CN106933873A (en) | 2015-12-30 | 2015-12-30 | A kind of cross-platform data querying method and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201511025982.0A CN106933873A (en) | 2015-12-30 | 2015-12-30 | A kind of cross-platform data querying method and equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106933873A true CN106933873A (en) | 2017-07-07 |
Family
ID=59441354
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201511025982.0A Pending CN106933873A (en) | 2015-12-30 | 2015-12-30 | A kind of cross-platform data querying method and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106933873A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110059103A (en) * | 2019-04-28 | 2019-07-26 | 南京大学 | A kind of cross-platform unified big data SQL query method |
| CN110457540A (en) * | 2019-06-28 | 2019-11-15 | 卓尔智联(武汉)研究院有限公司 | Querying method, service platform, terminal device and the storage medium of data |
| CN111858609A (en) * | 2020-07-27 | 2020-10-30 | 北京金山云网络技术有限公司 | Fuzzy query method and device for block chain |
| CN112507017A (en) * | 2020-12-03 | 2021-03-16 | 建信金融科技有限责任公司 | Data table conversion method and device |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5588150A (en) * | 1994-09-29 | 1996-12-24 | International Business Machines Corporation | Push down optimization in a distributed, multi-database system |
| US6792425B2 (en) * | 2000-11-30 | 2004-09-14 | Hitachi, Ltd. | Secure multi database system including a client, multi database server, and database server |
| US6931396B1 (en) * | 1999-06-29 | 2005-08-16 | Gene Logic Inc. | Biological data processing |
| CN101694665A (en) * | 2009-10-27 | 2010-04-14 | 中兴通讯股份有限公司 | Method and device for data query of heterogeneous data source |
| CN102147794A (en) * | 2010-02-05 | 2011-08-10 | 新奥特（北京）视频技术有限公司 | Multi-database caption display method and device based on SQL (structured query language) sentence |
| CN102902777A (en) * | 2012-09-28 | 2013-01-30 | 用友软件股份有限公司 | Cross data source inquiry device and cross data source inquiry method |
| CN104166738A (en) * | 2014-09-04 | 2014-11-26 | 北京国双科技有限公司 | Database query processing method and device |
| CN104572676A (en) * | 2013-10-16 | 2015-04-29 | 中国银联股份有限公司 | Cross-database paging querying method for multi-database table |
| CN104794247A (en) * | 2015-05-14 | 2015-07-22 | 东南大学 | Integrated query method for multi-structure database |
-
2015
- 2015-12-30 CN CN201511025982.0A patent/CN106933873A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5588150A (en) * | 1994-09-29 | 1996-12-24 | International Business Machines Corporation | Push down optimization in a distributed, multi-database system |
| US6931396B1 (en) * | 1999-06-29 | 2005-08-16 | Gene Logic Inc. | Biological data processing |
| US6792425B2 (en) * | 2000-11-30 | 2004-09-14 | Hitachi, Ltd. | Secure multi database system including a client, multi database server, and database server |
| CN101694665A (en) * | 2009-10-27 | 2010-04-14 | 中兴通讯股份有限公司 | Method and device for data query of heterogeneous data source |
| CN102147794A (en) * | 2010-02-05 | 2011-08-10 | 新奥特（北京）视频技术有限公司 | Multi-database caption display method and device based on SQL (structured query language) sentence |
| CN102902777A (en) * | 2012-09-28 | 2013-01-30 | 用友软件股份有限公司 | Cross data source inquiry device and cross data source inquiry method |
| CN104572676A (en) * | 2013-10-16 | 2015-04-29 | 中国银联股份有限公司 | Cross-database paging querying method for multi-database table |
| CN104166738A (en) * | 2014-09-04 | 2014-11-26 | 北京国双科技有限公司 | Database query processing method and device |
| CN104794247A (en) * | 2015-05-14 | 2015-07-22 | 东南大学 | Integrated query method for multi-structure database |
Non-Patent Citations (4)
| Title |
|---|
| HONGJUN LU: "Multidatabase query optimization: issues and solutions", 《PROCEEDINGS RIDE-IMS `93: THIRD INTERNATIONAL WORKSHOP ON RESEARCH ISSUES IN DATA ENGINEERING: INTEROPERABILITY IN MULTIDATABASE SYSTEMS, VIENNA, AUSTRIA》 * |
| 刘雨洋: "海量多数据库集成系统的查询处理研究", 《万方学位数据库》 * |
| 张立明: "多数据库查询核心技术研究", 《万方学位数据库》 * |
| 赵曜: "多数据库系统下统一查询平台的研究与应用", 《万方学位数据库》 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110059103A (en) * | 2019-04-28 | 2019-07-26 | 南京大学 | A kind of cross-platform unified big data SQL query method |
| CN110457540A (en) * | 2019-06-28 | 2019-11-15 | 卓尔智联(武汉)研究院有限公司 | Querying method, service platform, terminal device and the storage medium of data |
| CN110457540B (en) * | 2019-06-28 | 2020-07-14 | 卓尔智联(武汉)研究院有限公司 | Data query method, service platform, terminal device and storage medium |
| CN111858609A (en) * | 2020-07-27 | 2020-10-30 | 北京金山云网络技术有限公司 | Fuzzy query method and device for block chain |
| CN112507017A (en) * | 2020-12-03 | 2021-03-16 | 建信金融科技有限责任公司 | Data table conversion method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11146502B2 (en) | Method and apparatus for allocating resource | |
| CN110134516B (en) | Financial data processing method, apparatus, device and computer readable storage medium | |
| US20230144062A1 (en) | Method for computational-power sharing and related device | |
| CN106802932B (en) | Routing method and device of database and database system | |
| CN107943841A (en) | Stream data processing method, system and computer-readable recording medium | |
| CN105719009A (en) | Method and device for processing distribution tasks | |
| CN107730228A (en) | Account settle accounts calculation method, equipment and storage medium | |
| CN105472045A (en) | Database migration method and database migration device | |
| CN109408205A (en) | Method for scheduling task and device based on hadoop cluster | |
| CN104166738A (en) | Database query processing method and device | |
| CN107329991A (en) | A kind of list access to web page and methods of exhibiting and its system | |
| CN105488125A (en) | Page access method and apparatus | |
| CN106933873A (en) | A kind of cross-platform data querying method and equipment | |
| CN107341235A (en) | Report form inquiring method, device, medium and electronic equipment | |
| US20190370293A1 (en) | Method and apparatus for processing information | |
| CN103678591A (en) | Device and method for automatically executing multi-service receipt statistical treatment | |
| CN109582476B (en) | Data processing method, device and system | |
| CN107347093A (en) | Collocation method and device for distributed server system | |
| CN113515717B (en) | Navigation page updating method and device, electronic equipment and storage medium | |
| CN111382336B (en) | Data acquisition method and system | |
| CN106469175A (en) | Data processing method and device | |
| CN108228355A (en) | Task processing method and device, method for scheduling task and device | |
| CN110413421A (en) | Business data processing method and device, transaction data processing method and device | |
| CN101394405A (en) | Method and apparatus for data request processing | |
| CN106250248A (en) | A kind of to returning the method and apparatus that data carry out type conversion |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170707 |
|
| RJ01 | Rejection of invention patent application after publication |