CN101694665B - Method and device for data query of heterogeneous data source - Google Patents
Method and device for data query of heterogeneous data source Download PDFInfo
- Publication number
- CN101694665B CN101694665B CN200910210129A CN200910210129A CN101694665B CN 101694665 B CN101694665 B CN 101694665B CN 200910210129 A CN200910210129 A CN 200910210129A CN 200910210129 A CN200910210129 A CN 200910210129A CN 101694665 B CN101694665 B CN 101694665B
- Authority
- CN
- China
- Prior art keywords
- data
- acquisition thread
- data acquisition
- source
- group
- 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.)
- Active
Links
Images
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
- G06F16/258—Data format conversion from or to a database
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)
- Information Transfer Between Computers (AREA)
Abstract
The invention disclose a method and a device for data query of a heterogeneous data source, which aim at solving the problem in the prior art that querying data of a heterogeneous data source is complicate, takes long time, and has low efficiency. The method includes that to-be-queried data sources of a query are determined to be a first data source and a second data source according to a received data query request, the first data source and the second data source are heterogeneous data sources; a first group of data acquisition threads are started to obtain data from the first data source, a second group of data acquisition threads are started to obtain data from the second data source; the data obtained by the first group of data acquisition threads and the second group of data acquisition threads are converted into data in a uniform data format, the data going through format conversion are displayed. The technical scheme of the method and the device can be adopted to realize querying data of the heterogeneous sources uniformly, thereby simplifying complexity of data query of the heterogeneous data sources and improving efficiency of data query of the heterogeneous data sources.
Description
Technical field
The present invention relates to communication technical field, relate in particular to a kind of data query of heterogeneous data source method and device.
Background technology
At present; In all kinds of service operation maintenance processes; Often need inquire about and analyze the real time data that the historical data in a large number of services daily record that produces in the business processing process (data that service processor is treated) and service processor are being handled; Helping software supplier investigation, fault location problem, thereby further improve the quality of products, and help service provider and improve constantly professional O&M ability etc.
Generally speaking, the data of the Web page comprise two types of data, and one type of data is the treated data of service processor (being also referred to as historical data), with such data storage in business database; Another kind of data are the data (being also referred to as real time data) that service processor is being handled, with such data storage in the internal memory of service processor; Because the data source of these two types of data itself there are differences (such as factors such as busy spare time of data volume what, server, Network Transmission speeds) and every type of data all include a plurality of data sources, needs to adopt two sets of data collection mechanisms from the database of storing these two types of data, to obtain the data that satisfy condition respectively; Therefore; Prior art can not realize unified inquiry isomeric data source data; One query, system can only the one or more database nodes from business database in data query, perhaps from service processor, obtain data in one or more service processing node.
At present; The inquiry mode of the The data in the inquiry different pieces of information source is different, therefore, and when inquiring about the data in a plurality of isomeries source; Need repeatedly inquire about; Thereby make that when needs are inquired about the data in a plurality of isomeries source the inquiry complexity is higher, the data query consumed time is long, efficient is lower.Therefore, when needs are inquired about a large amount of isomery source datas, adopt the inquiry mode of prior art, have length consuming time, inefficient problem.
Summary of the invention
The embodiment of the invention provides a kind of data query of heterogeneous data source method and device, can not realize unified inquiry isomeric data source data in the prior art and causes when needs are inquired about a large amount of isomeric data source data length consuming time, inefficient problem to solve.
A kind of data query of heterogeneous data source device comprises data acquisition module, data processing module, data display module, wherein:
Data acquisition module is used to receive the data query request, and is first data source and second data source according to the data source to be checked that this time inquiry is determined in this data query request, and said first data source and said second data source are heterogeneous data source; Start first group of data acquisition thread and from said first data source, obtain data; Start second group of data acquisition thread and from said second data source, obtain data; Data acquisition thread in said first group of data acquisition thread is corresponding one by one with the back end of said first data source, and the data acquisition thread in said second group of data acquisition thread is corresponding one by one with the back end of said second data source;
Data processing module is used for that said first group of data acquisition thread got access to data-switching with said second group of data acquisition thread and becomes the uniform data form;
The data display module is used to show said data processing module processing data afterwards.
A kind of data query of heterogeneous data source method comprises:
Receive the data query request, and be first data source and second data source according to the data source to be checked that this time inquiry is determined in this data query request, said first data source and said second data source are heterogeneous data source; Start first group of data acquisition thread and from said first data source, obtain data; Start second group of data acquisition thread and from said second data source, obtain data; Data acquisition thread in said first group of data acquisition thread is corresponding one by one with the back end of said first data source, and the data acquisition thread in said second group of data acquisition thread is corresponding one by one with the back end of said second data source;
Said first group of data acquisition thread got access to data-switching with said second group of data acquisition thread become the uniform data form, and show through the data after the format conversion.
In the embodiment of the invention; After receiving the data query request; When the data source to be checked of determining this time inquiry according to query requests is first data source and second data source; Start first group of data acquisition thread and from said first data source, obtain data, start the second data acquisition thread and from said second data source, obtain data; And the data-switching that gets access to become the uniform data form, and show through the data after the Data Format Transform.Adopt technical scheme of the present invention; Realized from heterogeneous data source, to obtain data of different types through one query; Thereby realized unified inquiry isomeric data source data; Overcome in the prior art one query and can only inquire about the data in the data source, can not realize unified inquiry isomeric data source data and cause data query of heterogeneous data source length consuming time, inefficient problem, therefore; Adopt technical scheme of the present invention to simplify the complexity of data query of heterogeneous data source, improved data query of heterogeneous data source efficient.
Description of drawings
Fig. 1 is the structural representation of data query of heterogeneous data source device in the embodiment of the invention;
Fig. 2 is the synoptic diagram of data collecting module collected isomeric data source data in the embodiment of the invention;
Fig. 3 is for carrying out the process flow diagram of data query in the embodiment of the invention to heterogeneous data source based on device shown in Figure 1;
Fig. 4 is for being applied in the synoptic diagram in the application scenarios of short message enquiry with technical scheme of the present invention in the embodiment of the invention.
Embodiment
Below in conjunction with Figure of description the embodiment of the invention is carried out detailed description.
Referring to Fig. 1; Be the structural representation of data query of heterogeneous data source device in the embodiment of the invention, in the embodiment of the invention, the Web system adopts B/S (Browser/Server; Client end/server end) pattern; Client need not be installed, need only one browser can make things convenient for the data in the heterogeneous data source of querying server end, realize centralized control.Simultaneously, can realize that a plurality of user's cross-regions inquire about simultaneously, make things convenient for the user to carry out query manipulation, improve system availability; The processing layer that isomery source data inquiry unit in the embodiment of the invention is inquired about, gathered and change as the heterogeneous data source uniform data; Both can be positioned at client; Also can be positioned at server end; Can also be neither to be positioned at the autonomous device that client is not positioned at server end yet, this device comprises data acquisition module 11, data processing module 12, intermediate data storage module 13 and data display module 14, wherein:
As shown in Figure 2, need the data source of inquiry to comprise: be used for the storage system reduced data database, be used for the service processor of the data that storage system handling; Database comprise database node DB1, DB2 ..., DBn, service processor comprises service processing node CP1, CP2..., CPm; Data acquisition module 11 log-on data collecting threads 1,2..., n respectively from database node DB1, DB2 ..., obtain the data that satisfy condition among the DBn, and log-on data collecting thread n+1, n+2..., n+m obtain the data that satisfy condition respectively from service processing node CP1, CP2..., CPm.
Data processing module 12 is used for the data-switching that data acquisition module 11 collects is become the uniform data form.
Intermediate data storage module 13 is used for the intermediate database of the data storage after handling through data processing module 12 to server end.
Data display module 14, what be used for timing or cycle obtains data from intermediate database, and the data display that gets access to is arrived client.
For clearer, detailed description technical scheme of the present invention, below with the data query of heterogeneous data source device from database or/and the service processor flow process of data query be that example is carried out detailed description to technical scheme of the present invention, this flow process is as shown in Figure 3.
Referring to Fig. 3, for adopting the method flow of data in the data query device inquiry heterogeneous data source as shown in Figure 1 in the embodiment of the invention, after system carried out initialization, this flow process may further comprise the steps:
Step 301, data query of heterogeneous data source device receive the data query request that client is sent.
The query interface that the user can provide through client; Input inquiry condition (querying condition comprises Termination ID number, inquiry zero-time, poll-final time); By the querying condition generation data query request of client according to user's input; (this pattern information comprises that the database of needs inquiry is or/and the identification information of service processor to carry querying condition information, query pattern information in this query requests; And need the database node of inquiry, the identification information of service processing node), and this data query request is sent to the data query of heterogeneous data source device.
Step 303～304, data acquisition module 11 are determined the service processing node of needs inquiry according to query requests; And startup is used to inquire about the data acquisition thread of each service processing node data; From obtaining the data that satisfy condition the corresponding service processing node separately, temporary file is handled and generated to the data that get access to by the data acquisition thread.
In this step, the data acquisition number of threads of startup is consistent with the service processing node quantity that needs inquiry, and corresponding one by one.Each data acquisition thread adopts message mechanism from the corresponding service processing node, to obtain data; Concrete implementation is following: the data acquisition thread sends query messages and registration message audiomonitor to the corresponding service processing node; After the data acquisition thread receives the data that its corresponding service processing node returns; These data are carried out assembly unit and parsing, generate temporary file according to the data after resolving.The message header of above-mentioned query messages is the querying condition generation according to user's input; And in this message header, add common control information; (a plurality of modules belong to same office like message serial number, transmit leg office number and module No.; Office number or module No. can be set to 0～255 numeral, can uniquely determine service processing node according to office number+module No.), take over party office number and module No. etc.
Step 305, data acquisition module 11 judge whether querying condition changes, if then execution in step 306; Otherwise, execution in step 310.
In this step, judge that whether querying condition changes, and is specially: the querying condition of input compares during with current querying condition that receives and the inquiry of last secondary data, if identical, judges that then querying condition is constant; Otherwise, judge that this querying condition changes.The user need to the data that get access to carry out non-query manipulation (as data are sorted, operation such as paging), need not change querying condition, therefore; Keeping under the constant situation of querying condition; Can send query requests, directly from intermediate database, obtain the data that need, from database node, not obtain data and do not need data acquisition module 11 to start a plurality of data acquisition threads with trigger data acquisition module 11; Obtain efficient thereby improve data, save Internet resources.
Step 306, data acquisition module 11 are determined the database node of this time inquiry needs inquiry according to query requests, and start a plurality of data acquisition threads, from each self-corresponding database node, obtain the data that satisfy condition by the data acquisition thread.
Preferably, connect for avoiding each inquiry all need set up database node, thereby save CPU (Central Processing Unit.; Central processing unit) processing time and Internet resources are in the embodiment of the invention, when carrying out system initialization; Adopt connection pool mechanism to be implemented in the database node connection resource that distributes some in the internal memory; In system's operational process, can be according to actual operating position dynamic expansion connection pool, to improve system performance.
In this step, the database node that connects during with system initialization is confirmed as the database node of this time inquiry needs inquiry, starts the data acquisition thread the same with database node quantity, and each data acquisition thread is corresponding one by one with database node.Call its corresponding storing process after the data acquisition thread starts, by storing process according to obtaining the data that satisfy condition in the querying condition of the user's input database node corresponding with this data acquisition thread.The mode that storing process obtains data is following: storing process is determined in which table of DATA DISTRIBUTION in database node of needs inquiry according to the query time section in the querying condition; Again the table of determining is scanned one by one, to obtain the data that satisfy condition.In practical application, can set the maximum bar number (being defaulted as 1000) of the data that need inquiry, therefore, adopt technical scheme of the present invention only need scan several tables and can get access to required data, therefore, technical scheme practicality of the present invention is more intense.
Step 307, each data acquisition thread generate temporary file with the data that its storing process gets access to.
Preferably; For the data that better storing process got access to gather; Integrality with the data that guarantee to obtain; In the embodiment of the invention, the data storage that satisfies condition that each storing process will get access to is obtained data and is generated temporary file according to the data of obtaining by the corresponding data acquisition thread again to temporary table from this temporary table.
Step 308, data processing module 12 become the uniform data form with the data-switching in the temporary file that generates, and in the intermediate database with the data storage after the format conversion to server end.
Step 309, data display module 14 regularly or the cycle from intermediate database, obtain data, and with the data display that gets access in client.
Step 310, client regularly or the cycle from intermediate database, obtain data.
Preferably, whether all accomplished data acquisition, to guarantee accomplishing this secondary data inquiry smoothly in order better to monitor all data acquisition threads; In the step 303 of above-mentioned flow process and the step 306; Also can comprise following operation: in the very short time after starting each data acquisition thread, the enabling counting device, the initial value of this counter is consistent with the total quantity of the data acquisition thread of startup; After one of them data acquisition thread end data collection; The numerical value of counter subtracts one accordingly, when the numerical value of counter is zero, can confirm this secondary data poll-final.
Preferably; In order to prevent owing to other cause specifics cause the execution time of wherein one or more data acquisition threads long; Thereby cause oversize problem of data query time one time, the embodiment of the invention preestablishes a time threshold, after a period of time after the log-on data collecting thread (time threshold that this section period equals to set); The numerical value of counter also is not kept to zero; Then finish the inquiry of this secondary data, the data display that this time inquiry is got access to is so that the user carries out data query next time.
Preferably; (like time span is 2 months to the bigger situation of data time span of Query Database node in the querying condition of submitting to the user; Also promptly need the data in 2 months of data query node), be the efficient that improves data query, shorten query time; In the embodiment of the invention; To be divided into a plurality of stages the time; Such as being divided into 2 time periods with 2 months, as shown in Figure 4, data acquisition module 11 all starts 2 these database nodes of data collecting thread parallel query to each database node; The data of one of them this database node very first time section of data acquisition thread inquiry, the data of another data acquisition thread this second time period of database node of inquiry.
In the embodiment of the invention, the system initialization flow process may further comprise the steps:
Step 1, loading, the required configuration information (like database nodal information, service processing node information) of resolution system.
Step 2, according to the database node information that system analysis obtains, start a plurality of data acquisition threads, the data acquisition thread is corresponding one by one with database node, from each self-corresponding database node, obtains the data that satisfy condition.
In this step, start the mode of a plurality of data acquisition threads, and each data acquisition thread from database node, to obtain the mode of data consistent with mode in the aforementioned flow process, repeat no more at this.
Step 3, according to the service processing node information that obtains of system analysis, start a plurality of data acquisition threads, the data acquisition thread is corresponding one by one with service processing node, from obtaining the data that satisfy condition the corresponding service processing node separately.
In this step, start the mode of a plurality of data acquisition threads, and each data acquisition thread from service processing node, to obtain the mode of data consistent with mode in the aforementioned flow process, repeat no more at this.
Step 4, the data-switching that gets access in step 2, the step 3 is become uniform data format, and in the intermediate database with the data storage after the format conversion to server end.
Step 6, client are obtained data from intermediate database, and with the data display that gets access to client end interface.
Step 3 in the above-mentioned flow process, step 4 are not strict with on sequential, both can first execution in step 3 also can first execution in step 4, can also carry out simultaneously.
Technical scheme of the present invention can be applicable to several scenes, handles the ticket of storing in ticket and the service processor of handling like what store in the unified inquiry of the cellphone subscriber physical database.
Adopt technical scheme of the present invention; On the one hand; Realized unified inquiry isomeric data source data (being that one query can be obtained data of different types from heterogeneous data source); Thereby overcome one query in the prior art can only inquire about one in the data source data (promptly can not realize unified inquiry isomeric data source data) and cause data query of heterogeneous data source length consuming time, inefficient problem; Therefore, adopt technical scheme of the present invention to simplify the complexity of data query of heterogeneous data source, improved data query of heterogeneous data source efficient; On the other hand; To become the uniform data form from the data-switching the different data sources; For the unified displaying of client data are provided convenience, and in the intermediate database with the data storage after the format conversion to server end, also show by the data of from intermediate database, obtaining in client timing or cycle; Thereby be implemented in this time query script regularly or the partial data that will get access in cycle is showed to client; Do not show the data that get access to behind this time poll-final again and need not wait, thereby improved the speed that the user obtains data, improve user's impression; Again on the one hand, after a data query finishes, in the time of need carrying out non-query manipulation to the data that this secondary data inquiry obtains as if the user; Directly from intermediate database, obtain data; And do not need to carry out again one query operation, thereby when having improved non-query manipulation, obtain the efficient of data.
Obviously, those skilled in the art can carry out various changes and modification to the present invention and not break away from the spirit and scope of the present invention.Like this, belong within the scope of claim of the present invention and equivalent technologies thereof if of the present invention these are revised with modification, then the present invention also is intended to comprise these changes and modification interior.
Claims (14)
1. a data query of heterogeneous data source device is characterized in that, comprises data acquisition module, data processing module, data display module, wherein:
Data acquisition module is used to receive the data query request, and is first data source and second data source according to the data source to be checked that this time inquiry is determined in this data query request, and said first data source and said second data source are heterogeneous data source; Start first group of data acquisition thread and from said first data source, obtain data; Start second group of data acquisition thread and from said second data source, obtain data; Data acquisition thread in said first group of data acquisition thread is corresponding one by one with the back end of said first data source, and the data acquisition thread in said second group of data acquisition thread is corresponding one by one with the back end of said second data source;
Data processing module is used for that said first group of data acquisition thread got access to data-switching with said second group of data acquisition thread and becomes the uniform data form;
The data display module is used to show said data processing module processing data afterwards.
2. device as claimed in claim 1 is characterized in that, said data query request carries the identification information that the data source of required inquiry is inquired about in this time;
Data acquisition module is determined data source to be checked, is specially: the data source to be checked of the pairing data source of the identification information in the said query requests being confirmed as this time inquiry.
3. device as claimed in claim 1 is characterized in that,
Said first group of data acquisition thread obtains data from said first data source; Second group of data acquisition thread obtains data from said second data source, be specially: each the data acquisition thread in first group of data acquisition thread and the second group of data acquisition thread obtains data from each self-corresponding back end.
4. device as claimed in claim 3 is characterized in that, the data of said first data source storage are the treated data of service processor, and the data of second data source storage are the data that service processor is being handled;
Said first group of data acquisition thread obtains data from said first data source, is specially: to each data acquisition thread, the data acquisition thread obtains data through calling its corresponding storing process from the corresponding back end of this data acquisition thread;
Or/and; Said second group of data acquisition thread obtains data from said second data source; Be specially: to each data acquisition thread, the data acquisition thread sends query messages to its corresponding back end, and from the data that this back end returns, obtains data.
5. device as claimed in claim 4 is characterized in that, the data storage that said acquisition module gets access to each storing process is in temporary table; The data acquisition thread that each storing process is corresponding obtains data from said temporary table.
6. like each described device of claim 1～5, it is characterized in that, also comprise:
The intermediate data storage module is used for said data processing module is handled data storage afterwards to intermediate database;
The said data of said data display modules exhibit are specially: regularly or the cycle from said intermediate database, obtain data, and show the data that get access to.
7. like each described device of claim 1～5; It is characterized in that; Said data acquisition module is further used for; When starting first group of data acquisition thread and said second group of data acquisition thread, enabling counting device, the initial value of this counter are set to the total quantity that the data acquisition thread that is started is inquired about in this time; After arbitrary data acquisition thread end data was gathered in the said data acquisition thread, the numerical value of said counter subtracted one.
8. a data query of heterogeneous data source method is characterized in that, comprises step:
Receive the data query request, and be first data source and second data source according to the data source to be checked that this time inquiry is determined in this data query request, said first data source and said second data source are heterogeneous data source; Start first group of data acquisition thread and from said first data source, obtain data; Start second group of data acquisition thread and from said second data source, obtain data; Data acquisition thread in said first group of data acquisition thread is corresponding one by one with the back end of said first data source, and the data acquisition thread in said second group of data acquisition thread is corresponding one by one with the back end of said second data source;
Said first group of data acquisition thread got access to data-switching with said second group of data acquisition thread become the uniform data form, and show through the data after the format conversion.
9. method as claimed in claim 8 is characterized in that, said data query request carries the identification information that the data source of required inquiry is inquired about in this time;
Determine the data source to be checked of this time inquiry, be specially: the data source to be checked of the pairing data source of the identification information in the said query requests being confirmed as this time inquiry.
10. method as claimed in claim 8; It is characterized in that; Said first group of data acquisition thread obtains data from said first data source; Second group of data acquisition thread obtains data from said second data source, be specially: each the data acquisition thread in first group of data acquisition thread and the second group of data acquisition thread obtains data from each self-corresponding back end.
11. method as claimed in claim 10 is characterized in that, the data of said first data source storage are the treated data of service processor, and the data of second data source storage are the data that service processor is being handled;
Said first group of data acquisition thread obtains data from said first data source; Be specially: to each data acquisition thread, the data acquisition thread obtains data through calling the corresponding storing process of this data acquisition thread from the corresponding back end of this data acquisition thread;
Or/and; Said second group of data acquisition thread obtains data from said second data source; Be specially: to each data acquisition thread, the data acquisition thread sends query messages to its corresponding back end, and from the data that this back end returns, obtains data.
12. like claim method as claimed in claim 11; It is characterized in that; The data acquisition thread obtains data through calling the corresponding storing process of this data acquisition thread from the corresponding back end of this data acquisition thread, be specially: the data storage that each storing process is got access to is in temporary table; The data acquisition thread that each storing process is corresponding obtains data from said temporary table.
13. like each described method of claim 8～12; It is characterized in that; Said first group of data acquisition thread and said second group of data acquisition thread are got access to data-switching become after the uniform data form, also comprise with through the data storage after the Data Format Transform to intermediate database;
Said displaying is specially through the data after the format conversion: regularly or the cycle from said intermediate database, obtain data, and show the data that get access to.
14. like each described method of claim 8～12; It is characterized in that; Also comprise: after starting first group of data acquisition thread and said second group of data acquisition thread; Also comprise the enabling counting device, the initial value of this counter is set to the sum that the data acquisition thread that is started is inquired about in this time; After any data acquisition thread end data in the said data acquisition thread was gathered, the numerical value of said counter subtracted one.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910210129A CN101694665B (en) | 2009-10-27 | 2009-10-27 | Method and device for data query of heterogeneous data source |
| PCT/CN2009/075861 WO2010145157A1 (en) | 2009-10-27 | 2009-12-22 | Method and device for data query from heterogeneous data sources |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910210129A CN101694665B (en) | 2009-10-27 | 2009-10-27 | Method and device for data query of heterogeneous data source |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101694665A CN101694665A (en) | 2010-04-14 |
| CN101694665B true CN101694665B (en) | 2012-10-03 |
Family
ID=42093638
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200910210129A Active CN101694665B (en) | 2009-10-27 | 2009-10-27 | Method and device for data query of heterogeneous data source |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN101694665B (en) |
| WO (1) | WO2010145157A1 (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107657042A (en) * | 2017-09-30 | 2018-02-02 | 上海数据交易中心有限公司 | Data query method and device, storage medium, the terminal of multi-data source |
Families Citing this family (25)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101895428B (en) * | 2010-07-27 | 2014-07-02 | 中兴通讯股份有限公司 | Acquisition system and acquisition point distribution method |
| US9952893B2 (en) | 2010-11-03 | 2018-04-24 | Microsoft Technology Licensing, Llc | Spreadsheet model for distributed computations |
| CN102571715B (en) * | 2010-12-27 | 2015-07-29 | 腾讯科技（深圳）有限公司 | Multidimensional data query method and system |
| CN102542009B (en) * | 2011-12-14 | 2018-03-13 | 中兴通讯股份有限公司 | Data query method and device |
| CN102722572B (en) * | 2012-06-05 | 2015-04-08 | 太仓云联信息科技有限公司 | Alarm processing method based on heterogeneous database |
| CN103916368B (en) * | 2012-12-31 | 2017-11-21 | 中国移动通信集团公司 | A kind of method and device for realizing data processing between different data sources |
| CN104462121B (en) * | 2013-09-18 | 2019-04-30 | 腾讯科技（深圳）有限公司 | Data processing method, apparatus and system |
| CN105320673A (en) * | 2014-06-30 | 2016-02-10 | 苏宁云商集团股份有限公司 | Method and device for transmitting data among multiple data sources |
| CN105808585B (en) * | 2014-12-29 | 2020-01-24 | 大唐软件技术股份有限公司 | Method and device for processing streaming data |
| CN104933173B (en) * | 2015-06-30 | 2019-01-15 | 北京京东尚科信息技术有限公司 | It is a kind of for the data processing method of isomery multi-data source, device and server |
| CN104991824B (en) * | 2015-08-03 | 2019-09-13 | 上海斐讯数据通信技术有限公司 | A kind of method and system in switching at runtime application data source |
| CN106933873A (en) * | 2015-12-30 | 2017-07-07 | 中国移动通信集团上海有限公司 | A kind of cross-platform data querying method and equipment |
| CN105912624B (en) * | 2016-04-07 | 2019-05-24 | 北京中安智达科技有限公司 | The querying method of the heterogeneous database of distributed deployment |
| CN106529195A (en) * | 2016-12-02 | 2017-03-22 | 郑州云海信息技术有限公司 | Data acquisition and analysis method and device |
| CN106850748B (en) * | 2016-12-26 | 2020-12-22 | 曙光信息产业(北京)有限公司 | Subscription and publishing system of cloud desktop |
| CN106970943A (en) * | 2017-02-21 | 2017-07-21 | 南京中新赛克科技有限责任公司 | Fusion query method based on heterogeneous data source and distributed file system |
| CN108959291B (en) * | 2017-05-19 | 2023-03-24 | 腾讯科技（深圳）有限公司 | Query method and related device |
| CN107220363B (en) * | 2017-06-07 | 2020-09-22 | 中国科学院信息工程研究所 | Cross-region query method and system supporting global complex retrieval |
| CN109359794A (en) * | 2018-08-14 | 2019-02-19 | 阿里巴巴集团控股有限公司 | Business access method, device, electronic equipment and computer readable storage medium |
| CN109413180B (en) * | 2018-10-26 | 2021-08-06 | 厦门科灿信息技术有限公司 | Data acquisition method, system and equipment and storage medium |
| CN109684379A (en) * | 2018-12-17 | 2019-04-26 | 浩云科技股份有限公司 | A kind of analysis method and system of multivariate data |
| CN110659327A (en) * | 2019-08-16 | 2020-01-07 | 平安科技（深圳）有限公司 | Method and related device for realizing interactive query of data between heterogeneous databases |
| CN110851495A (en) * | 2019-10-24 | 2020-02-28 | 长城计算机软件与系统有限公司 | Heterogeneous source data processing method and device, storage medium and electronic equipment |
| CN112069215B (en) * | 2020-09-17 | 2024-09-03 | 国能龙源电气有限公司 | Data query method and device based on integrated data |
| CN112487090A (en) * | 2020-11-30 | 2021-03-12 | 乐刷科技有限公司 | Data synchronization method, data display platform and computer readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6732360B1 (en) * | 1998-12-07 | 2004-05-04 | Korea Telecom | System and method for providing connection between client and heterogeneous database management systems |
| CN1499402A (en) * | 2002-10-31 | 2004-05-26 | �Ҵ���˾ | Distribution inquixy and expression of information from isomeric data source and its system and method |
| CN101030224A (en) * | 2006-03-03 | 2007-09-05 | 国际商业机器公司 | System and method for building a unified query that spans heterogeneous environments |
| CN101163265A (en) * | 2007-11-20 | 2008-04-16 | 中兴通讯股份有限公司 | Distributed database based on multimedia message log inquiring method and system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101286269A (en) * | 2008-05-26 | 2008-10-15 | 北京捷讯畅达科技发展有限公司 | Traffic flow forecasting system combining dynamic real time traffic data |
-
2009
- 2009-10-27 CN CN200910210129A patent/CN101694665B/en active Active
- 2009-12-22 WO PCT/CN2009/075861 patent/WO2010145157A1/en active Application Filing
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6732360B1 (en) * | 1998-12-07 | 2004-05-04 | Korea Telecom | System and method for providing connection between client and heterogeneous database management systems |
| CN1499402A (en) * | 2002-10-31 | 2004-05-26 | �Ҵ���˾ | Distribution inquixy and expression of information from isomeric data source and its system and method |
| CN101030224A (en) * | 2006-03-03 | 2007-09-05 | 国际商业机器公司 | System and method for building a unified query that spans heterogeneous environments |
| CN101163265A (en) * | 2007-11-20 | 2008-04-16 | 中兴通讯股份有限公司 | Distributed database based on multimedia message log inquiring method and system |
Non-Patent Citations (2)
| Title |
|---|
| 储应梅等.定性查询引擎在Web化学数据库集成检索中的应用.《计算机与应用化学》.2005,第22卷(第8期),660-664. * |
| 袁小龙等.基于XML的半结构化化学信息提取系统的重构与优化.《第九届全国计算(机)化学学术会议论文集》.2007,208-209. * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107657042A (en) * | 2017-09-30 | 2018-02-02 | 上海数据交易中心有限公司 | Data query method and device, storage medium, the terminal of multi-data source |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2010145157A1 (en) | 2010-12-23 |
| CN101694665A (en) | 2010-04-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101694665B (en) | Method and device for data query of heterogeneous data source | |
| CN102650953B (en) | Concurrently-optimized BPMN (Business Process Modeling Notation) combined service execution engine and method | |
| CN111263409B (en) | Method, system and related equipment for providing metadata information of network function service | |
| CN104601702B (en) | Cluster remote procedure calling (PRC) method and system | |
| CN111083181B (en) | Equipment scheduling method, gateway and system for large-scale access to Internet of things | |
| EP4236422A2 (en) | Devices and methods for discovering collectable data and analytics data in a network | |
| CN110581893B (en) | Data transmission method and device, routing equipment, server and storage medium | |
| CN101383839A (en) | Data distribution system based on data server and implementation method | |
| CN101953188B (en) | Method and apparatus for processing multi-channel request subscription under service management platform | |
| CN113905015B (en) | Identification analysis method and identification analysis system | |
| CN101808051A (en) | Application integration gateway and control method thereof | |
| CN110851248A (en) | Asynchronous task data processing method and device and computer readable storage medium | |
| CN105511946A (en) | Intelligent home appliance equipment active degree statistic method and device and internet gateway | |
| CN116662376B (en) | Data query method, device, electronic equipment and storage medium | |
| CN101938383B (en) | On-line monitoring method and system of user account with multiple services as well as monitoring service system | |
| CN102487382B (en) | Resource providing method, apparatus thereof and system thereof | |
| CN102090039A (en) | A method of performing data mediation, and an associated computer program product, data mediation device and information system | |
| CN104852964A (en) | Multifunctional server scheduling method | |
| CN101753561B (en) | Business cluster processing method and cluster system | |
| CN117041284A (en) | External interface management method, system, equipment and medium based on interface cloud | |
| US20120136983A1 (en) | Method and System for use in Network Management of Communications Network | |
| CN110839061A (en) | Data distribution method, device and storage medium | |
| CN104462235A (en) | Internet of Things general event service mechanism based on Restful Web Service | |
| CN112019452B (en) | Method, system and related device for processing service requirement | |
| CN117135580A (en) | 5G message universal access system and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |