[go: up one dir, main page]

WO2010145157A1 - Method and device for data query from heterogeneous data sources - Google Patents

Method and device for data query from heterogeneous data sources Download PDF

Info

Publication number
WO2010145157A1
WO2010145157A1 PCT/CN2009/075861 CN2009075861W WO2010145157A1 WO 2010145157 A1 WO2010145157 A1 WO 2010145157A1 CN 2009075861 W CN2009075861 W CN 2009075861W WO 2010145157 A1 WO2010145157 A1 WO 2010145157A1
Authority
WO
WIPO (PCT)
Prior art keywords
query
group
data
source
stored
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.)
Ceased
Application number
PCT/CN2009/075861
Other languages
French (fr)
Chinese (zh)
Inventor
兰恩龙
狄强
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
ZTE Corp
Original Assignee
ZTE Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by ZTE Corp filed Critical ZTE Corp
Publication of WO2010145157A1 publication Critical patent/WO2010145157A1/en
Anticipated expiration legal-status Critical
Ceased legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING OR CALCULATING; COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database

Definitions

  • the second query, the system can only be in the middle or multiple queries, or each of the mediation and mediation.
  • querying the query methods used in different sources is not the same.
  • multiple queries are required, and the queries are more cost-effective and need to be queried in multiple sources. Therefore, in the need to query a large number of existing wood query methods, exist Inefficient. content
  • This provides query methods and devices to solve the problem that the existing wood cannot be queried.
  • Source teaching device including, , and display
  • the query determines the number of queries to be queried, the second number, the number of the second group of numbers, the number of sources, the second group of numbers, the second source
  • the number of information in the query is to be queried.
  • Steps said, close to the number stored in each of the only stored numbers.
  • the display shows the number of times that are shown in the rest or period of the period.
  • the number of the number of the query work in the second group of numbers, the number of the devices, and the number of the number of the query functions
  • Receiving a query querying, determining the number of queries to be queried, second, the number, the second
  • the number of the first group and the number of the second group Specially changed to the system format, showing the number of the format.
  • Step the query information of the source to be queried with the query
  • Step the number of stored and the number of the first number stored, the number of the second stored number, and the number of the processed
  • Step the number of stored, the rest will be stored
  • the number to be stored is stored in the only number stored in the storage.
  • Step the number of the first group and the second group To the special format, the method stores the format number to the same
  • the number of the display format the number of hours or periods, and the number shown in the same period.
  • Step, in the group of numbers, the second group of steps, the method is near
  • the number of the number of the numerators of the number of numerators the number of the digits.
  • the query determines the number of queries to be queried, the second, the number of groups
  • the number of the second source and the second source are replaced by a unified format, and the format number is displayed. With this technique, you can query it once.
  • the number of different types in the source, and the unified query, to overcome the existing wood-based query can only query the number in the source, can not query and query, low efficiency, therefore, using this technology to query the query, improve Up
  • the number in the source can be multi-user geographically the same query, the square user query operation, improve the system availability
  • the query device is arbitrarily inquired, and special, both for the customer and for each, and may be neither the customer nor the end, the devices 11 and 12 are stored together 13 and displayed 14, wherein
  • the same storage 13 is used to divide the number of 12 into the same end. Show 14, in the same period of the cycle, the number will be displayed to the customer.
  • the user can provide the query interface provided by the customer.
  • the query starts with the same query, and the query is generated by the customer's query.
  • the query contains the information about the query and the query mode information, and sends the query to the query device.
  • the query mode information needs the number of queries or / and the information of the sum, and the number of each and each information to be queried. Information can
  • Step 302 Querying the number received in the number 11 to determine whether it is necessary to query the number of the sums, and if yes, executing step 303. Otherwise, executing step 305
  • Step 303, 304, 11 query to determine each of the various queries, and the function is used to query each number
  • a unique file is generated by the number of each of the remaining numbers and the number of each.
  • step 303 the number of steps of the work needs to be queried, ⁇ .
  • each Query message message received each, returned, parsed, parsed generated unique files.
  • the query user of the above query message generates the query, adds public control information, message flow, and (more than the same, or can be 0 255, ten can only be determined), receive and so on.
  • Steps 305, 11 query whether the remainder is, if yes, execute step 306. Otherwise, perform step 3 0.
  • Step query whether the remainder, the rest of the query received before the rest of the query query comparison, if the same, then the query is not otherwise, the query is residing.
  • the non-query operations (row sorting, paging, etc.) that the user needs to go to, do not need to query the remainder. Therefore, in the case that the query is not exhausted, the query can be queried, and 11 is needed directly in the same, but no more than 11 , while improving efficiency, with resources.
  • Steps 306, 11 Query The query needs to be queried, and the remaining ones are satisfied by the respective ones.
  • the rabbit needs to establish a connection for each query, and P (e a oce g ., central processor) is the same resource, this
  • connection and system allocate a certain amount of connection resources in memory, in the system
  • the step will be the need to unify the connected fixed force query Of ,
  • Step 307 Generate a unique file to be stored. Better, better stored, to
  • Steps 308 and 12 convert the special files in the generated unique file into a unified format, and store the format special in the same end of each end.
  • Step 309 showing 14 or the same period in the cycle, will be displayed to the customer.
  • Step 310 customer or cycle in the same.
  • Step 303 of the above process, step 306, can be performed in the same manner as in each process.
  • the query will be queried, and the user will query the next time.
  • the user submits the same query in the same query (the same as 2, that is, within the 2 that needs to be queried), to improve the efficiency of the query, and reduce the query, which will share the same force, more than 2 months.
  • the force component 2 is the same as 4,
  • Step 1 and analyze the configuration information, information, and information required by the system.
  • Step 2 the information obtained by the unified analysis, more, ⁇ , each of the full of more than enough.
  • Step 3 The way in the previous process in the process, no longer here. Step 3.
  • the information obtained by the unified analysis is more
  • Step 4 The special format obtained in the steps 2 and 3 is replaced by a format, and the format is stored in the same middle of each end.
  • Step 5 In the same customer, the displayed will be displayed on the customer interface.
  • Steps 3 and 4 in the above process are not required. You can either perform step 3 or step 4 first.
  • the Ming technology can be used in many ways, and the user can query the physical use of the technology, and the general query (that is, the different queries can be different in the source), and overcome the existing wood-based query can only query the source. In the middle
  • the special source in different sources is changed into a unified format, the customer displays the provider, and the format is stored in the middle of the same end, and is displayed by the customer or the middle of the cycle, and now in the query Or the part of the cycle will be displayed to the customer, without waiting for the query to be displayed again, and the user's speed is improved, the user experience is improved, the secondary query, if the user needs to query the non-query operation, directly In the same way, the query operation is not required, and the efficiency of the non-query operation is improved.

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 present invention discloses a method and device for data query from heterogeneous data sources in order to solve the problem of complexity, time-consuming and inefficiency of the prior art data query from heterogeneous data sources. Said method includes: determining, according to a received data query request, that data sources presently to be queried are a first data source and a second data source, wherein said first data source and said second data source are heterogeneous data sources; initiating a first group of data collection threads to retrieve data from said first data source, and initiating a second group of data collection threads to retrieve data from said second data source; converting the data retrieved from said first and second group of data collection threads into a uniform data format and presenting the converted data. Via adopting the technical solution of the present invention, uniform data query from heterogeneous data sources can be realized, complexity of data query from heterogeneous data sources can be simplified, and efficiency of data query from heterogeneous data sources can be improved.

Description

查詢方法及裝置 木領域  Inquiry method and device

本 涉及 查詢 木, 尤其涉及 查詢方法及 裝置。 背景 木  This relates to querying wood, especially to query methods and devices. Background

目前, 在各矣 各 需要 各 中戶生 的大量 各 志中的 ( 各 理和已 理的 ) 以及 各 理和 在 理的 查詢及分析, 以有利于軟件提供 、 定 位 障 , 而 步提高 原 , 以及有利于 各 不 提高 各的 能力等。  At present, in each of the large number of comrades in each of the various households (all reasonable and reasonable) and the rational and rational query and analysis, in order to facilitate the software to provide, locate obstacles, and improve the original, And it is advantageous for each ability to improve each.

般情況下, Web 的 矣 , 矣 各 理和 已 理的 (也 ), 將 矣 存儲在商 另 矣 各 理和 在 理的 (也 ), 將 矣 存 儲在 各 理和的內 由于 矣 的 本身存在 d 多少、 各 、 同 快慢等因素) 且 矣 都包含有 多 , 需要 集和制分別 存儲 矣 的 中 滿足余 的 因此, 現有 木不能 統 查詢  Under the circumstance, the Web's embarrassment, the ruling and the rational (also), the 矣 矣 矣 矣 商 商 商 商 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣 矣d How many, each, the same speed and other factors) and there are many 矣, need to set and system separately to store the 满足 满足 因此 因此 因此 因此 因此 因此 因此 因此 因此

, 次查詢, 統只能 中的 介或多 中查詢 , 或者 各 理和中 介或多 各 中 。  , the second query, the system can only be in the middle or multiple queries, or each of the mediation and mediation.

目前, 查詢不同 源中的 用的查詢方式不 因此, 查詢多 源中的 , 需要 多次查詢, 而使得在需要查詢多 源中的 , 查詢 查詢耗費的 同 、 效率較低。 因此, 在需要查詢大量的 , 現有 木的查詢方式, 存在 、 效率低的 。 內容 At present, querying the query methods used in different sources is not the same. In the query of multiple sources, multiple queries are required, and the queries are more cost-effective and need to be queried in multiple sources. Therefore, in the need to query a large number of existing wood query methods, exist Inefficient. content

本 提供 查詢方法及裝置, 以解決現有 木中 不能 統 查詢 而 在需要查詢大量  This provides query methods and devices to solve the problem that the existing wood cannot be queried.

, 、 效率低的 。  , , and inefficient.

源教 裝置, 包括 、 、 展示 , 其中  Source teaching device, including, , and display,

數 , 于接收 查詢 , 查詢 定 出 查詢的待查詢 第 數 第二 , 所述第 數 所述第二 第 組數 所述第 數 源中 , 第二組數 所述第二 源中  Number, in the receiving query, the query determines the number of queries to be queried, the second number, the number of the second group of numbers, the number of sources, the second group of numbers, the second source

, 于將所述第 組數 和所述第二組數 到的數 特換成統 數 格式  And replacing the number of the first group and the number of the second group into a unified format

展示 , 于展示所述 的數 。 步 , 所述 查詢 帶有 查詢的待查詢 源的 信息  Show, show the number mentioned. Step, the query information of the source to be queried with the query

定出待查詢 , 休 將所述查詢 中的 信息所 的數 定力 查詢的待查詢 。  To determine the number of information to be queried, the number of information in the query is to be queried.

步 , 所述第 組數 中的數 所述第 數 源的數 吋 , 所述第二組數 中的數  a number in the number of groups, the number of the number of sources, and the number in the second group

所述第二 源的數 吋 Number of the second source

所述第 組數 所述第 數 源中 , 第二組數 所述第二 源中 , 休 第 組數 和 第二組數 中的各 各自 的數 中  The number of the first number of the plurality of sources, the second number of the second source, the number of each of the first group and the second group

。 步 , 所述第 數 存儲的數 各 理和已 理的數 , 第二 存儲的數 各 理和 在 理的數 . Step, the number of the stored number and the number of the rational number, the number of the second stored number and the number of the rational number

所述第 組數 所述第 數 , 休  The number of the group, the number, the rest

每 介 , 自身 的存儲 Every medium, its own storage

的數 中  Number of

或/和,所述第二組數 所述第二 , 休 每 介 , 向自身 的數 查詢 消息, 返 的數 中 。  Or / and, the second group of numbers, the second, the rest, the number of queries to the number of their own, the number of returns.

步 , 所述 , 近 于將各存儲 到的數 在惟 各存儲 的數 所述惟 中 。  Steps, said, close to the number stored in each of the only stored numbers.

步 , 裝置近  Step, device near

中同 存儲 , 于將所述 的數 存儲至 中同  Store in the same place, store the number in the same

所述 展示 展示所述 , 休 或周期 所述中同 中 , 展示 到的數 。  The display shows the number of times that are shown in the rest or period of the period.

所述 步 于, 在 第 組數 所述第 二組數 , 數器, 數器的 查詢 功的數 的 數量 所述 中任 數  The number of the number of the query work in the second group of numbers, the number of the devices, and the number of the number of the query functions

, 所述 數器的數值 。  , the value of the counter.

查詢方法,  Query method,

接收 查詢 , 查詢 定出 查詢的待查詢 第 數 第二 , 所述第 數 所述第二  Receiving a query, querying, determining the number of queries to be queried, second, the number, the second

第 組數 所述第 數 源中 , 第二組數 所述第二 源中  The number of the plurality of sources, the second group of numbers, the second source

將所述第 組數 和所述第二組數 到的數 特換成統 數 格式, 展示 格式特 的數 。 The number of the first group and the number of the second group Specially changed to the system format, showing the number of the format.

步 , 所述 查詢 帶有 查詢的待查詢 源的 信息  Step, the query information of the source to be queried with the query

定出 查詢的待查詢 , 休 將所述查詢 中的 信息所 的數 定力 查詢的待查詢 。  Determine the query to be queried, and the number of information in the query will be determined by the query.

步 , 所述第 組數 中的數 所述第 數 源的數 吋 , 所述第二組數 中的數  a number in the number of groups, the number of the number of sources, and the number in the second group

所述第 數 源的數 吋 The number of the number of sources

所述第 組數 所述第 數 源中 , 第二組數 所述第二 源中 , 休 第 組數 和 第二組數 中的各 各自 的數 中  The number of the first number of the plurality of sources, the second number of the second source, the number of each of the first group and the second group

 .

步 , 所述第 數 存儲的數 各 理和已 理的數 , 第二 存儲的數 各 理和 在 理的數  Step, the number of stored and the number of the first number stored, the number of the second stored number, and the number of the processed

所述第 組數 所述第 數 , 休  The number of the group, the number, the rest

每 介 , 的存儲 的數 中 Number of storage per medium

或/和,所述第二組數 所述第二 , 休 每 介 , 向自身 的數 查詢 消息, 返 的數 中 。  Or / and, the second group of numbers, the second, the rest, the number of queries to the number of their own, the number of returns.

步 , 的存儲 的數 中 , 休 將各存儲  Step, the number of stored, the rest will be stored

到的數 存儲在惟 各存儲 的數 所述惟 中 。 The number to be stored is stored in the only number stored in the storage.

步 , 將所述第 組數 和所述第二組數 到 特換成統 數 格式 , 所述方法近 將 格式特 的數 存儲至中同 Step, the number of the first group and the second group To the special format, the method stores the format number to the same

所述展示 格式特 的數 , 休 或周期 所述中同 中 , 展示 到的數 。  The number of the display format, the number of hours or periods, and the number shown in the same period.

步 , 在 第 組數 所述第二組數 程 , 所述方法近  Step, in the group of numbers, the second group of steps, the method is near

數器, 數器的 查詢 功的數 的 所述 中的任意 數 , 所述 數器的數值 。  The number of the number of the numerators of the number of numerators, the number of the digits.

本 , 接收到 查詢 , 查詢 定出 查詢的 待查詢 第 數 第二 , 第 組數  Ben, received the query, the query determines the number of queries to be queried, the second, the number of groups

所述第 數 源中 , 第二 所述第二 源中 將 到的數 特換成統 數 格式, 展示 格式 特 的數 。 用本 明技木 , 了 次查詢即可 In the first source, the number of the second source and the second source are replaced by a unified format, and the format number is displayed. With this technique, you can query it once.

源中 不同 型的數 , 而 了統 查詢 , 克服 現有 木中 次查詢只能查詢 介 源中的數 , 不能 統 查詢 而 查詢 、 效率低的 , 因此, 用本 明技木 化了 查詢的 , 提高了  The number of different types in the source, and the unified query, to overcome the existing wood-based query can only query the number in the source, can not query and query, low efficiency, therefore, using this technology to query the query, improve Up

查詢效率。 說明 Query efficiency. Description

1力本 中 查詢裝置的 示意 1力本中

2力本 中數 的示意 3力本 中 于 1所示裝置 查詢 的流程 2 Forces of the number of the three figures in the power of the device shown in Figure 1

4 力本 中數 查詢 的示意 。 休 方式 4 force this number The indication of the inquiry. Hugh way

下面結合說明 本 的描述。 The following description is combined with the description.

1, 力本 中 查詢裝置的 示意 , 本 , Web 統 B/S ( ow e/Seve, 客戶 / 各 ) 模式, 客戶 須安裝, 只需 介 即可方 各 端的  1, the instructions of the query device in this book, this, Web system B / S (ow e / Seve, customer / each) mode, the customer must be installed, only need to refer to each side of the

源中的數 , 集中控制。 同 , 可以 多 用戶 地域同 查詢, 方 用戶 查詢操作, 提高 統可用性 本 中的  The number in the source, centralized control. The same, can be multi-user geographically the same query, the square user query operation, improve the system availability

查詢裝置作力 統 查詢、 以及特 的 , 既 可以 于客戶 , 也可以 于 各 , 近可以是既不 于客戶 也不 于 各 端的 各, 裝置 11、 12 中同 存儲 13以及 展示 14, 其中  The query device is arbitrarily inquired, and special, both for the customer and for each, and may be neither the customer nor the end, the devices 11 and 12 are stored together 13 and displayed 14, wherein

數 11, 于在接收到 查詢 , 需要查詢 的數 (即 查詢的待查詢 ), 相 的多 各 源中 滿足余 的數 。 Number 11, after receiving the query, the number of queries that need to be queried (ie, the query to be queried), the number of the plurality of sources meets the remainder.

2所示, 需要 的數 于存儲 統已赴理數 的數 、 于存儲 統 在外理的數 的 各 理和 2, the number of required data in the storage system has been counted, and the number of storage systems is different.

B B2、. B , 各 理和 各 CP CP2. CP B B2. B, each and every CP CP2. CP

11 1、 2. "分別 B B2、. B"中 滿足余 的數 ,以及 + +2. + 分別 各 CP CP2. CP 中 滿足余 的數 。 11 1, 2. "B B2, . B" respectively satisfies the remainder, and + +2. + Respectively CP CP2. The remainder of the CP is satisfied.

12, 于將 11 到的數 特換成統 數 格式。  12, in the number of 11 to the number of special format.

中同 存儲 13, 于將 12 的數 到 各 端的中同 。 展示 14, 于 或周期 中同 中 , 將 到的數 展示到客戶 。 The same storage 13 is used to divide the number of 12 into the same end. Show 14, in the same period of the cycle, the number will be displayed to the customer.

了更清楚、 描述本 明技木方案, 下面以 查 詢裝置 或/和 各 理和中查詢 的流程力 本 明技木方案 的描述, 流程 3所示。 To better understand and describe the technical solution of the present invention, the following is a description of the technical solution of the query device or/and the query process in the context and the process, and the process is shown in the third step.

3,力本 中 1所示 查詢裝置查詢 源中數 的方法流程, 在 統 化 , 流程 以下步驟 步驟301、 查詢裝置接收客戶 的數 查詢 。 用戶可 客戶 提供的查詢界面, 查詢余 (查詢余  3, Liben 1 shown in the query device query source number process flow, in the integration process, the following steps, step 301, the query device receives the number of customers query. The user can provide the query interface provided by the customer.

、 查詢起始 同、 查詢 同 ), 由客戶 用戶 的查詢 余 生成數 查詢 , 查詢 中 帶有查詢余 信息、 查詢模式信 息, 將 查詢 送至 查詢裝置。 其中, 查詢 模式信息 需要查詢的數 或/和 各 理和的 信息, 以及需要查 詢的數 、 各 的 信息。 信息可以  The query starts with the same query, and the query is generated by the customer's query. The query contains the information about the query and the query mode information, and sends the query to the query device. Among them, the query mode information needs the number of queries or / and the information of the sum, and the number of each and each information to be queried. Information can

查詢所需查詢的數 。  Query the number of queries required.

步驟302、 查詢裝置中的數 11 接收到 的數 查詢 定是否需要查詢 各 理和中的數 , 若是, 則執行步 驟303 否則, 執行步驟305  Step 302: Querying the number received in the number 11 to determine whether it is necessary to query the number of the sums, and if yes, executing step 303. Otherwise, executing step 305

步驟303 304、 11 查詢 定出 各 理和中 查詢的 各 , 功用于查詢各 各 的數  Step 303, 304, 11 query to determine each of the various queries, and the function is used to query each number

, 由 各自 的 各 中 滿足余 的數 , 到的數 生成惟 文件。  , a unique file is generated by the number of each of the remaining numbers and the number of each.

步驟 303 中, 功的數 程數量 需要查詢的 各 數 量 致, 吋 。 各 消息和制 相 的 各  In step 303, the number of steps of the work needs to be queried, 吋 . Each message and system

中 , 休 方式 下 向 的 各 查詢消息 消息 , 接收到 的 各 返 的 , 拼裝 解析, 解析 的 生成惟 文件。 上述查詢消息的消息 用戶 的查詢余 生成, 在 消息 中添 公共控制信息, 消息流水 、 和 (多 于同 介 , 或 可 0 255的 , 十 可唯 定出 各 )、 接收 和 等。 In the middle of each Query message messages, received each, returned, parsed, parsed generated unique files. The query user of the above query message generates the query, adds public control information, message flow, and (more than the same, or can be 0 255, ten can only be determined), receive and so on.

步驟305、 11 查詢余 是否 , 若是, 則執行步 驟306 否則, 執行步驟3 0  Steps 305, 11 query whether the remainder is, if yes, execute step 306. Otherwise, perform step 3 0.

步驟 , 查詢余 是否 , 休 將 前接收到的查詢余 前 次 查詢 的查詢余 比較, 若相同, 則 查詢余 不 否則, 查詢余 化。 用戶需要 到的 非查 詢操作 ( 行排序、 分頁等操作), 不需要 查詢余 , 因此, 在 查詢余 不吏的情況下, 可 查詢 , 以 11 直接 中同 中 需要的 , 而不需要 11 多 中 , 而提高 效率, 同 資源。  Step, query whether the remainder, the rest of the query received before the rest of the query query comparison, if the same, then the query is not otherwise, the query is residing. The non-query operations (row sorting, paging, etc.) that the user needs to go to, do not need to query the remainder. Therefore, in the case that the query is not exhausted, the query can be queried, and 11 is needed directly in the same, but no more than 11 , while improving efficiency, with resources.

步驟306、 11 查詢 定出 查詢需要查詢的 , 多 , 由 各自 的 中 滿足余 的 。  Steps 306, 11 Query The query needs to be queried, and the remaining ones are satisfied by the respective ones.

較佳 , 兔每次查詢都需要建立 連接, 而 P ( e a oce g ., 中央 理器) 同 同 資源, 本  Preferably, the rabbit needs to establish a connection for each query, and P (e a oce g ., central processor) is the same resource, this

, 在 行 統 化 , 連接 和制 現在內存中分配 定 量 的 連接資源, 在 統 可 用情況  , in the line of integration, connection and system, allocate a certain amount of connection resources in memory, in the system

連接 , 以提高 統性能。  Connect to improve performance.

步驟 將 統 化 連接的 定力 查詢需要 的 , 的 , 各 The step will be the need to unify the connected fixed force query Of ,

吋 。 的存儲 , 由存儲 用戶 的查詢余 的  Inches . Storage, by the storage user's query

中 滿足余 的 。 存儲 的方式 下 存儲 查詢余 中的查詢 同 定出需要查詢的 分布在 中的 哪些 再 定出的 , 以 滿足余 的 。 在 , 可 需要查詢的 的最大余 ( 1000余), 因此, 用本 明技木 只需要 即可 到所需的 , 因此, 本 明技木 用性比較強。  Satisfied with the rest. Store the query in the storage mode to determine which of the distributions that need to be queried are re-determined to satisfy the remainder. In , the maximum amount of inquiry (more than 1000) can be required. Therefore, it is only necessary to use the technology of the present invention. Therefore, the technique is more flexible.

步驟307、 各 將 存儲 到的 生成惟 文件。 較佳 , 了更好 存儲 到的 , 以  Step 307: Generate a unique file to be stored. Better, better stored, to

的 的完整性, 本 , 各存儲 將 到的滿足余 的 存儲至惟 再由相 的 惟 中 Integrity, this, the storage will be satisfied to the rest of the storage to the only

的 生成惟 文件。  Generate a unique file.

步驟308、 12將生成的惟 文件中的 特換成統 格式, 將格式特 的 存儲至 各 端的中同 。  Steps 308 and 12 convert the special files in the generated unique file into a unified format, and store the format special in the same end of each end.

步驟309、 展示 14 或周期 中同 中 , 將 到的 展示在客戶 。  Step 309, showing 14 or the same period in the cycle, will be displayed to the customer.

步驟310、 客戶 或周期 中同 中 。  Step 310, customer or cycle in the same.

較佳 , 了更好 監測所有的 是否都已 完成 , 以 順利地完成 查詢, 上述流程的步驟303 步驟306 近可 以下操作 在 各 程 的很 同內,  Preferably, it is better to monitor whether all of the completions have been completed to successfully complete the inquiry. Step 303 of the above process, step 306, can be performed in the same manner as in each process.

, 的 功的 的 致, 其中 介 , 的 相 ,  , the result of the work , the middle , the phase ,

的 , 即可 查詢 。 較佳 , 了防止由于其他特殊原因而 其中 介或多 的 同 , 而 次 查詢 同太 的 , 本 預先 定 介 同 , 在 程 的 段 同 ( 同等于 的 同 ) , 的 近沒有 , 則 , you can query. Preferably, the prevention of the same or more of the same due to other special reasons, and the second query is the same as the pre-determined, the same paragraph in the process (the same as the same), the near is not, then

查詢, 將 查詢 到的 展示, 以 用戶 行下 次 查詢。 較佳 , 用戶提交的查詢余 中查詢 的 同 較大的情況 ( 同 2 , 也即需要查詢 的 2 內的 ), 提高 查詢的效率, 縮 查詢 本 , 將 同 分力多 , 比 將2介月分力 2 同 , 4所示, Query, the query will be queried, and the user will query the next time. Preferably, the user submits the same query in the same query (the same as 2, that is, within the 2 that needs to be queried), to improve the efficiency of the query, and reduce the query, which will share the same force, more than 2 months. The force component 2 is the same as 4,

11 都 查詢  11 are inquiries

, 其中 介 第 吋同 的 , 另 介 查詢 第二 同 的 。  , which is the same as the first one, and the second is the same.

本 , 統 化流程 以下步驟  Ben, the integration process The following steps

步驟1、 、 解析 統所需的配置信息, 信息、 各 信息。  Step 1, and analyze the configuration information, information, and information required by the system.

步驟2、 統解析得到的 信息, 多 , 吋 , 各自 的 中 滿 足余 的 。  Step 2, the information obtained by the unified analysis, more, 吋, each of the full of more than enough.

步驟 多 的方式, 以及各  More steps, and

中 的方式 前 流程中的方式 致, 在此不再 。 步驟3、 統解析得到的 各 信息, 多  The way in the previous process in the process, no longer here. Step 3. The information obtained by the unified analysis is more

, 各 吋 , 各自 的 各  , each, each

中 滿足余 的 。 Satisfied with the rest.

步驟 多 的方式, 以及各  More steps, and

各 中 的方式 前述流程中的方式 致, 在此不再贅述。 步驟4、 將步驟2、 步驟3中 到的 特換成統 的 格式, 將格式特 的 存儲至 各 端的中同 中。 The manner in each of the foregoing processes is not repeated here. Step 4: The special format obtained in the steps 2 and 3 is replaced by a format, and the format is stored in the same middle of each end.

步驟5、客戶 中同 中 , 將 到的 展示至客 戶 界面上。  Step 5: In the same customer, the displayed will be displayed on the customer interface.

上述流程中的步驟3、 步驟4在 上沒有 要求, 既可以先執行步 驟3也可以先執行步驟4, 近可以同 執行。  Steps 3 and 4 in the above process are not required. You can either perform step 3 or step 4 first.

本 明技木 可 于多 , 手札用戶統 查詢物理 用本 明技木方案, 方面, 了統 查詢 (即 次查詢可 源中 不同矣型的 ), 而克服現有 木中 次查詢只能查詢 介 源中的 (即不能 統 查詢 The Ming technology can be used in many ways, and the user can query the physical use of the technology, and the general query (that is, the different queries can be different in the source), and overcome the existing wood-based query can only query the source. In the middle

) 而 查詢 、 效率低的 , 因此, 用本 明技木方案 化了 查詢的 , 提高了  ) and the query is inefficient, therefore, the query has been improved with the technology of the present invention.

查詢效率 另 方面, 將 不同 源中的 特換成統 格式, 客戶 統 展示 提供方 , 且近將格式特 的 存儲至 各 端的中同 中, 由客戶 或周期的 中同 中 展 示, 而 現在 查詢 中 或周期的將已 到的部分 展 示至客戶 , 而不需要等 查詢 再展示 到的 , 而提高 了用戶 的速度, 提高用戶感受 再 方面, 次 查詢 , 若用戶需要 查詢得到的 非查詢操作 , 直接 中 同 中 , 而不需要再 行 次查詢操作, 而提高了非查詢 操作 , 的效率。 In terms of query efficiency, the special source in different sources is changed into a unified format, the customer displays the provider, and the format is stored in the middle of the same end, and is displayed by the customer or the middle of the cycle, and now in the query Or the part of the cycle will be displayed to the customer, without waiting for the query to be displayed again, and the user's speed is improved, the user experience is improved, the secondary query, if the user needs to query the non-query operation, directly In the same way, the query operation is not required, and the efficiency of the non-query operation is improved.

然, 本領域的 木 可以 本 行各 和 而不 本 的精神和 固。 , 倘若本 的 修 和 于本  However, the wood in this field can be both spiritual and solid. If the repair of this book is in this

要求及其等同 木的 固 則本 也 包含 和 。  The requirements and their equivalents to the wood also include and .

Claims

要求 Claim 1、 查詢裝置, 其特 在于, 、 、 展示 , 其中  1. Query device, which is characterized by, , and display, wherein 數 , 于接收 查詢 , 查詢  Number, in receiving query, query 查詢的待查詢 第 數 第二 , 所述第 數 所述第二 第 組數 所述第 數 源中 , 第二組數 所述第二 源中  The second number of the number of the second group of the number of the source, the second group of the second source , 于將所述第 組數 和所述第二組數 到的數 特換成統 數 格式  And replacing the number of the first group and the number of the second group into a unified format 展示 , 于展示所述 的數 。  Show, show the number mentioned. 2、 要求1所述的裝置, 其特 在于, 所述 查詢 帶有 查詢的待查詢 源的 信息 2. The apparatus of claim 1, wherein the querying information of the source to be queried with the query 定出待查詢 , 休 將所述查詢 中的 Set to be queried, Hugh will be in the query 3、 要求1所述的裝置, 其特 在于, 所述第 組數 3. The apparatus of claim 1, wherein the number of the groups is 中的數 所述第 數 源的數 吋 , 所述第二組數 中的數 所述第二 源的數 吋 所述第 組數 所述第 數 源中 , 第二組數 所述第二 源中 , 休 第 組數 和 第二組數 中的各 各自 的數 中 a number of the number of the first source, a number of the second group, a number of the second source, a number of the first number of the first source, and a second group of the second source In the number of each of the Hugh group and the second group  . 4、 要求3所述的裝置, 其特 在于, 所述第 數 存儲的數 各 理和已 理的數 , 第二 存儲的數 各 理和 在 理的數  4. The apparatus of claim 3, wherein the number of stored and processed numbers of the first number, the number of the second stored numbers, and the number of processed 所述第 組數 所述第 數 , 休 每 介 , 自身 的存儲 的數 中 The number of the first group, the rest Each, the number of its own storage 或/和,所述第二組數 所述第二 , 休 每 介 , 向自身 的數 查詢 消息, 返 的數 中 。  Or / and, the second group of numbers, the second, the rest, the number of queries to the number of their own, the number of returns. 5、 要求4所述的裝置, 其特 在于, 所述 , 近 于將各存儲 到的數 存儲在惟 各存儲 的數  5. The apparatus of claim 4, wherein the means for storing each stored number is stored in a unique number 所述惟 中 。  Said only. 6、 要求1至5任 項所述的裝置, 其特 在于, 近  6. The device of any of claims 1 to 5, characterized in that 中同 存儲 , 于將所述 的數 存儲至 中同  Store in the same place, store the number in the same 所述 展示 展示所述 , 休 或周期 所述中同 中 , 展示 到的數 。  The display shows the number of times that are shown in the rest or period of the period. 7、 要求1至5任 項所述的裝置, 其特 在于, 所述  7. The apparatus of any one of claims 1 to 5, characterized in that 步 于, 在 第 組數 所述第二組數  Step by, in the number of groups, the second group number , 數器, 數器的 查詢 功的數  , number of devices, number of detectors 的 數量 所述 中任 數 , 所述 數器的數值 。  The number of the number, the value of the number. 8、 查詢方法, 其特 在于,  8, the query method, its special feature is that 接收 查詢 , 查詢 定出 查詢的待查詢 第 數 第二 , 所述第 數 所述第二  Receiving a query, querying, determining the number of queries to be queried, second, the number, the second 第 組數 所述第 數 源中 , 第二組數 所述第二 源中  The number of the plurality of sources, the second group of numbers, the second source 將所述第 組數 和所述第二組數 到的數 特換成統 數 格式, 展示 格式特 的數 。 The number of the first group and the number of the second group are replaced by a system format, and the format number is displayed. 9、 要求8所述的方法, 其特 在于, 所述 查詢 帶有 查詢的待查詢 源的 信息 9. The method of claim 8, wherein the querying the information of the source to be queried with the query 定出 查詢的待查詢 , 休 將所述查詢 中的 信息所 的數 定力 查詢的待查詢 。 Determine the query to be queried, and the number of information in the query will be determined by the query. 10、 要求 8 所述的方法, 其特 在于, 所述第 組數 中的數 所述第 數 源的數 吋 , 所述第二組 數 中的數 所述第 數 源的數 吋  10. The method of claim 8, wherein the number of the number of the first group is the number of the number of sources, and the number of the second group is the number of the number of sources. 所述第 組數 所述第 數 源中 , 第二組數 所述第二 源中 , 休 第 組數 和 第二組數 中的各 各自 的數 中  The number of the first number of the plurality of sources, the second number of the second source, the number of each of the first group and the second group  . 11、 要求10所述的方法, 其特 在于, 所述第 數 存儲的 數 各 理和已 理的數 , 第二 存儲的數 各 理和 在 理的數  11. The method of claim 10, wherein the number of stored and processed numbers, the second stored number, and the number of processed 所述第 組數 所述第 數 , 休  The number of the group, the number, the rest 每 介 , 的存儲 的數 中 Number of storage per medium 或/和,所述第二組數 所述第二 , 休 每 介 , 向自身 的數 查詢 消息, 返 的數 中 。  Or / and, the second group of numbers, the second, the rest, the number of queries to the number of their own, the number of returns. 12、 要求 要求11所述的方法, 其特 在于,  12. The method of claim 11 is characterized in that 的存儲 的數 中 , 休 將各存儲 到的數 存儲在惟 各存儲 的數 所述惟 中 。 Among the stored numbers, Hume stores each stored number in the only number stored in the storage. 13、 要求8至12任 項所述的方法, 其特 在于, 將 第 組數 和所述第二組數 到 特換成統 數 格 式 , 所述方法近 將 格式特 的數 存儲至中同 13. The method of claim 8 to 12, characterized in that The number of groups and the number of the second group are converted into a system of numbers, and the method stores the number of the format to the same  Seven 所述展示 格式特 的數 , 休 或周期 所述中同 中 , 展示 到的數 。  The number of the display format, the number of hours or periods, and the number shown in the same period. 14、 要求8至12任 項所述的方法, 其特 在于, 在 第 組數 所述第二組數 程 , 所述方法近  14. The method of any of clauses 8 to 12, characterized in that, in the group of numbers, the second group of steps, the method is near 數器, 數器的 查詢 功的數 的 所述 中的任意 數 , 所述 的數值 。  The number of the number of the numerators of the number of numerators, the value of the number.
PCT/CN2009/075861 2009-10-27 2009-12-22 Method and device for data query from heterogeneous data sources Ceased WO2010145157A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN200910210129.4 2009-10-27
CN200910210129A CN101694665B (en) 2009-10-27 2009-10-27 Method and device for data query of heterogeneous data source

Publications (1)

Publication Number Publication Date
WO2010145157A1 true WO2010145157A1 (en) 2010-12-23

Family

ID=42093638

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2009/075861 Ceased WO2010145157A1 (en) 2009-10-27 2009-12-22 Method and device for data query from heterogeneous data sources

Country Status (2)

Country Link
CN (1) CN101694665B (en)
WO (1) WO2010145157A1 (en)

Families Citing this family (28)

* Cited by examiner, † Cited by third party
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
CN107657042B (en) * 2017-09-30 2020-06-09 上海数据交易中心有限公司 Data query method and device for multiple data sources, storage medium and terminal
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, device, storage medium and electronic device
CN112069215B (en) * 2020-09-17 2024-09-03 国能龙源电气有限公司 A 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
CN115934811A (en) * 2021-09-24 2023-04-07 青岛海尔科技有限公司 Home appliance database integration system
CN114969119A (en) * 2022-05-31 2022-08-30 平安科技(深圳)有限公司 Data query method, device, server and storage medium

Citations (3)

* Cited by examiner, † Cited by third party
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
CN101163265A (en) * 2007-11-20 2008-04-16 中兴通讯股份有限公司 Distributed database based on multimedia message log inquiring method and system
CN101286269A (en) * 2008-05-26 2008-10-15 北京捷讯畅达科技发展有限公司 Traffic flow forecasting system combining dynamic real time traffic data

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7702617B2 (en) * 2002-10-31 2010-04-20 International Business Machines Corporation System and method for distributed querying and presentation of information from heterogeneous data sources
US7702625B2 (en) * 2006-03-03 2010-04-20 International Business Machines Corporation Building a unified query that spans heterogeneous environments

Patent Citations (3)

* Cited by examiner, † Cited by third party
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
CN101163265A (en) * 2007-11-20 2008-04-16 中兴通讯股份有限公司 Distributed database based on multimedia message log inquiring method and system
CN101286269A (en) * 2008-05-26 2008-10-15 北京捷讯畅达科技发展有限公司 Traffic flow forecasting system combining dynamic real time traffic data

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
"Abstract Proceedings of the 9th National Conference on Computing (Computer) Chemistry", 2007, article X.L. YUAN ET AL.: "Modeling and Transformation of ChemDB Portal, an XML-Based Chemistry Search Engine", pages: 208 - 209 *
C.M. CHU ET AL.: "Directed Query Engine Applications in the Integrated Retrieval of Chemical Web Databases", COMPUTERS AND APPLIED CHEMISTRY, vol. 22, no. 8, 28 August 2005 (2005-08-28), pages 660, 664 *

Also Published As

Publication number Publication date
CN101694665A (en) 2010-04-14
CN101694665B (en) 2012-10-03

Similar Documents

Publication Publication Date Title
WO2010145157A1 (en) Method and device for data query from heterogeneous data sources
CN104660483B (en) Group communication method, server and system
CN101815095B (en) A kind of SAN stored resource unified management and distribution method
JP6338817B2 (en) Data management system and method using database middleware
BRPI0604362B1 (en) SYSTEM AND METHOD OF PROCESSING SERVICE REQUIREMENTS FOR A TELECOMMUNICATIONS ARCHITECTURE
CN109152061B (en) Channel deployment method, device, server and storage medium
TW200931285A (en) Method, system and apparatus for combining distributed computational data
CN101876984A (en) Data management system and data relation query method and device thereof
CN109726244A (en) Data lead-in method and device
JP2004158009A (en) Method and system for delivering network performance data
CN112667465A (en) Multi-cluster operation monitoring method, device and system and readable storage medium
CN114647656A (en) Method, device and equipment for updating data and storage medium
CN113420099A (en) Buried point data access control method and device, computer equipment and storage medium
US20110296239A1 (en) System for handling storage system requests
CN103258389B (en) The method of self-aided terminal upload file, system and self-aided terminal
CN105205605B (en) Interactive service system of city intelligent portal terminal and electric power marketing terminal
WO2008032992A1 (en) Method for downloading multimedia contents to electronic picture frame
CN108038182A (en) A kind of method and apparatus of the relation data library storage data based on Flume
CN106980697A (en) A kind of catalogue distribution querying method and device
US20030225733A1 (en) Method, system and program product for centrally managing computer backups
CN104679821A (en) Data access processing method and data access processing device
CN107092607B (en) A method and device for storing bills
CN117149866A (en) Method and device for exporting multi-source heterogeneous data, readable storage medium and terminal
CN113269557B (en) Transaction log acquisition system and working method thereof
CN102769639B (en) Method of data synchronization and system

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 09846071

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 09846071

Country of ref document: EP

Kind code of ref document: A1