发明名称 Processor implemented systems and methods for using the catalog part of an SQL identifier to expose/access heterogeneous data
摘要 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.
申请公布号 US8645386(B2) 申请公布日期 2014.02.04
申请号 US201113035630 申请日期 2011.02.25
申请人 HESS ROBERT BRIAN;BEESLEY JAMES MICHAEL;JEFFREYS DAVID KERR;SAS INSTITUTE INC. 发明人 HESS ROBERT BRIAN;BEESLEY JAMES MICHAEL;JEFFREYS DAVID KERR
分类号 G06F7/00 主分类号 G06F7/00
代理机构 代理人
主权项
地址