Invention Grant
US08645386B2 Processor implemented systems and methods for using the catalog part of an SQL identifier to expose/access heterogeneous data
有权
处理器实现的系统和方法,用于使用SQL标识符的目录部分来公开/访问异构数据
- Patent Title: Processor implemented systems and methods for using the catalog part of an SQL identifier to expose/access heterogeneous data
- Patent Title (中): 处理器实现的系统和方法,用于使用SQL标识符的目录部分来公开/访问异构数据
-
Application No.: US13035630Application Date: 2011-02-25
-
Publication No.: US08645386B2Publication Date: 2014-02-04
- Inventor: Robert Brian Hess , James Michael Beesley , David Kerr Jeffreys
- Applicant: Robert Brian Hess , James Michael Beesley , David Kerr Jeffreys
- Applicant Address: US NC Cary
- Assignee: SAS Institute Inc.
- Current Assignee: SAS Institute Inc.
- Current Assignee Address: US NC Cary
- Agency: Kilpatrick Townsend & Stockton LLP
- Main IPC: G06F7/00
- IPC: G06F7/00

Abstract:
Systems and methods are provided for providing data from a plurality of databases stored on a plurality of disparate servers. A query is received for data from a plurality of databases stored on a plurality of disparate servers. An address for a first server is resolved that stores a first database identified by the catalog field in the query using a logical name-to-connection metadata map. A first sub-query is transmitted to the first server based on the received query, and a first sub-query response is received from the first server. The resolving, transmitting, and receiving are repeated for a second server. The first sub-query response and the second sub-query response are combined to generate a query response according to the received query, and the query response is transmitted.
Public/Granted literature
Information query