WO2010145157A1 - Method and device for data query from heterogeneous data sources - Google Patents
Method and device for data query from heterogeneous data sources Download PDFInfo
- 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
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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
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
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
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)
| 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)
| 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)
| 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 |
-
2009
- 2009-10-27 CN CN200910210129A patent/CN101694665B/en active Active
- 2009-12-22 WO PCT/CN2009/075861 patent/WO2010145157A1/en not_active Ceased
Patent Citations (3)
| 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)
| 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 |