Tool for converting SQL queries into portable ODBC
    1.
    发明授权
    Tool for converting SQL queries into portable ODBC 失效
    将SQL查询转换为便携式ODBC的工具

    公开(公告)号:US06877000B2

    公开(公告)日:2005-04-05

    申请号:US09934887

    申请日:2001-08-22

    IPC分类号: G06F7/00 G06F17/30

    摘要: A method, computer program product and system for converting Structured Query Language (SQL) statements into the Open Database Connectivity (ODBC) standard. The source code of a database application may be parsed to identify one or more keywords. These keywords may be used to identify SQL statements as well as variables that are used to process the SQL statements. Upon identifying the SQL statements, the SQL statements may be evaluated. The SQL statements evaluated may then be matched with particular functions in a function library, i.e., a collection of functions stored in data files. These functions may implement particular ODBC calls thereby enabling SQL statements to be converted into the ODBC standard. A function call, i.e., a call to that function, may be substituted for the corresponding SQL statement. The function call may then be implemented resulting in the execution of the ODBC calls.

    摘要翻译: 一种用于将结构化查询语言(SQL)语句转换为开放数据库连接(ODBC)标准的方法,计算机程序产品和系统。 可以解析数据库应用的源代码以识别一个或多个关键字。 这些关键字可用于标识SQL语句以及用于处理SQL语句的变量。 在识别SQL语句时,可能会对SQL语句进行评估。 然后可以将所评估的SQL语句与功能库中的特定功能相匹配,即存储在数据文件中的函数的集合。 这些功能可以实现特定的ODBC调用,从而使SQL语句能够转换为ODBC标准。 函数调用,即对该函数的调用可以替代相应的SQL语句。 然后可以实现函数调用,从而导致ODBC调用的执行。

    Method and system for improved access to non-relational databases
    2.
    发明授权
    Method and system for improved access to non-relational databases 失效
    改进非关系数据库访问的方法和系统

    公开(公告)号:US06502088B1

    公开(公告)日:2002-12-31

    申请号:US09349607

    申请日:1999-07-08

    IPC分类号: G06F1730

    摘要: The method and system of the present invention provides improved access to databases in a computer system. The present invention includes a plurality of data sources, the data sources including at least one non-relational data source; a server coupled to the plurality of data sources, the server capable of providing client access to the plurality of data sources; and a store place data access layer (SPDAL) coupled to the server and the at least one non-relational data source, the SPDAL providing relational features to the at least one non-relational data source. In the preferred embodiment, the relational features provided include a two-phase commit process; a process for performing Structured Query Language (SQL) operations from within a single application; a referential integrity process; and a process for providing indices for non-relational data source files. These features allow the computer system to perform data changes across multiple database sources within a single operation; perform SQL operations from a single application across heterogeneous file systems; provide referential integrity of data in both relational and non-relational databases; and perform ad-hoc queries of data and other queries efficiently in non-relational databases. By adding these features, significant flexibility is added to the computer system.

    摘要翻译: 本发明的方法和系统提供对计算机系统中的数据库的改进访问。 本发明包括多个数据源,数据源包括至少一个非关系数据源; 耦合到所述多个数据源的服务器,所述服务器能够提供客户端对所述多个数据源的访问; 以及耦合到所述服务器和所述至少一个非关系数据源的存储位置数据访问层(SPDAL),所述SPDAL向所述至少一个非关系数据源提供关系特征。 在优选实施例中,提供的关系特征包括两阶段提交过程; 从单个应用程序中执行结构化查询语言(SQL)操作的过程; 引用完整性过程; 以及为非关系数据源文件提供索引的过程。 这些功能允许计算机系统在单个操作中跨多个数据库源执行数据更改; 通过异构文件系统从单个应用程序执行SQL操作; 在关系数据库和非关系数据库中提供数据的参照完整性; 并在非关系数据库中高效地执行数据和其他查询的即席查询。 通过添加这些功能,将显着的灵活性添加到计算机系统中。

    Method and system for characterizing applications for use with databases having structured query language interfaces
    3.
    发明授权
    Method and system for characterizing applications for use with databases having structured query language interfaces 失效
    用于表征具有结构化查询语言接口的数据库的应用程序的方法和系统

    公开(公告)号:US06304871B1

    公开(公告)日:2001-10-16

    申请号:US09216613

    申请日:1998-12-18

    IPC分类号: G06F1730

    摘要: A system and method for allowing a user to characterize an application are disclosed. In one aspect, the method and system allow a user to characterize a database engine. The database engine utilizes a particular interface for communicating with an application. The method and system include determining a query spectrum including plurality of queries corresponding to a plurality of query types. The plurality of query types are chosen such that any possible query can be classified as being of one query type. The plurality of queries is compatible with the particular interface. The method and system include running the query spectrum on the database engine and determining a time taken to run each of the plurality of queries on the database engine. In another aspect, the method and system are for characterizing the application. In this aspect, the method and system include characterizing the database engine using a query spectrum including a first plurality of queries compatible with the particular interface. The first plurality of queries has a plurality of query types. The method and system further include providing a second plurality of queries characteristic of the application. The second plurality of queries have a portion of the plurality of query types and are compatible with the particular interface. The method and system further include calculating a run time taken to run the second plurality of queries on a portion of the plurality of database engines based on the portion of the plurality of query types and characterization of the plurality of database engines.

    摘要翻译: 公开了允许用户表征应用的系统和方法。 在一个方面,该方法和系统允许用户表征数据库引擎。 数据库引擎利用特定的接口与应用程序进行通信。 所述方法和系统包括确定包括与多个查询类型相对应的多个查询的查询频谱。 选择多个查询类型,使得任何可能的查询可以被分类为一种查询类型。 多个查询与特定接口兼容。 该方法和系统包括在数据库引擎上运行查询频谱并确定在数据库引擎上运行多个查询中的每一个所需的时间。 另一方面,该方法和系统用于表征应用。 在这方面,该方法和系统包括使用包括与特定接口兼容的第一多个查询的查询频谱来表征数据库引擎。 第一组查询具有多种查询类型。 所述方法和系统还包括提供应用的特征的第二多个查询。 第二多个查询具有多个查询类型的一部分并且与特定接口兼容。 该方法和系统还包括基于多个查询类型的部分和多个数据库引擎的表征来计算在多个数据库引擎的一部分上运行第二多个查询所花费的运行时间。

    Methods, systems and computer program products for logical access of data sources utilizing standard relational database management systems
    4.
    发明授权
    Methods, systems and computer program products for logical access of data sources utilizing standard relational database management systems 失效
    用于使用标准关系数据库管理系统的数据源的逻辑访问的方法,系统和计算机程序产品

    公开(公告)号:US06457003B1

    公开(公告)日:2002-09-24

    申请号:US09375111

    申请日:1999-08-16

    IPC分类号: G06F1730

    摘要: Methods, systems and computer program products are provided which allow for accessing at least one data source by intercepting a command to a standard relational database management system and determining if the intercepted command accesses the data source utilizing a logical table name. If the intercepted command accesses the data source utilizing the logical table name, then the logical table name is translated to a physical table name. The intercepted command is the provided to the relational database management system utilizing the physical table name translated from the logical table name so as to provide access the data source utilizing the logical table name. Furthermore, if the intercepted command accesses the data source utilizing a logical table name and a logical column name, then the logical table name is translated to the physical table name and the logical column name translated to a physical column name.

    摘要翻译: 提供了方法,系统和计算机程序产品,其允许通过截取对标准关系数据库管理系统的命令来访问至少一个数据源,并且确定截获的命令是否利用逻辑表名访问数据源。 如果拦截的命令使用逻辑表名访问数据源,则将逻辑表名称转换为物理表名称。 截取的命令是使用从逻辑表名称翻译的物理表名提供给关系数据库管理系统,以便利用逻辑表名提供对数据源的访问。 此外,如果拦截的命令使用逻辑表名称和逻辑列名访问数据源,则将逻辑表名称转换为物理表名称,并将逻辑列名称转换为物理列名称。