公开(公告)号：US06546365B1

公开(公告)日：2003-04-08

申请号：US09497915

申请日：2000-02-04

申请人： Kimberly Lynn Gajda ,  Michael Joseph Johnson

发明人： Kimberly Lynn Gajda ,  Michael Joseph Johnson

IPC分类号： G06F1720

CPC分类号： G06F9/454

摘要： An apparatus and method to construct programs for use in multiple-language environments. A subroutine is described to provide for reference to a translation table but maintain the self-documenting feature of direct coding. Also disclosed is an extractor program, which is capable of automatically creating a translation table based upon default values to be used for messages. Finally, the disclosed invention also provides a superior method of handling errors in translation table files by providing for a default message.

摘要翻译： 一种用于构建在多语言环境中使用的程序的装置和方法。 描述了一个子程序来提供对转换表的参考，但是保持直接编码的自我记录特征。 还公开了一种提取程序，其能够基于要用于消息的默认值自动创建转换表。 最后，所公开的发明还提供了通过提供默认消息来处理翻译表文件中的错误的优良方法。

公开(公告)号：US06304871B1

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

申请号：US09216613

申请日：1998-12-18

申请人： Kimberly Lynn Gajda ,  Michael Joseph Johnson ,  Robert Tod Thorpe

发明人： Kimberly Lynn Gajda ,  Michael Joseph Johnson ,  Robert Tod Thorpe

IPC分类号： G06F1730

CPC分类号： G06F17/30306 ,  G06F11/3419 ,  G06F11/3428 ,  G06F11/3447 ,  Y10S707/99934 ,  Y10S707/99935 ,  Y10S707/99943

摘要： 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.

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

公开(公告)号：US08589949B2

公开(公告)日：2013-11-19

申请号：US11308768

申请日：2006-05-01

申请人： Ana Claudia Biazetti ,  Adam Barrett Darney ,  Edward Joseph Dobner ,  Metin Feridun ,  Kimberly Lynn Gajda ,  Thomas Gschwind ,  Michael Moser ,  Brian David Pate ,  Mack Edward Phelps

发明人： Ana Claudia Biazetti ,  Adam Barrett Darney ,  Edward Joseph Dobner ,  Metin Feridun ,  Kimberly Lynn Gajda ,  Thomas Gschwind ,  Michael Moser ,  Brian David Pate ,  Mack Edward Phelps

IPC分类号： G06F9/54

CPC分类号： G06Q10/00 ,  G06F9/541 ,  G06F9/542

摘要： An invention is disclosed for improved computer system management by allowing complex computer-monitored events to be handled in different formats for correlation, analysis and action. Specifically, a method and system are disclosed for processing multiple heterogeneous event types in a complex event processing (CEP) engine.

摘要翻译： 公开了一种通过允许以不同格式处理复杂的计算机监视事件进行相关性，分析和动作来改进计算机系统管理的发明。 具体地，公开了一种在复杂事件处理（CEP）引擎中处理多个异类事件类型的方法和系统。

公开(公告)号：US06877000B2

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

申请号：US09934887

申请日：2001-08-22

申请人： Kimberly Lynn Gajda ,  Bradley Allan Hess ,  Robert Tod Thorpe

发明人： Kimberly Lynn Gajda ,  Bradley Allan Hess ,  Robert Tod Thorpe

IPC分类号： G06F7/00 ,  G06F17/30

CPC分类号： G06F17/3041 ,  G06F17/30427 ,  Y10S707/99933 ,  Y10S707/99934

摘要： 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调用的执行。

公开(公告)号：US06502088B1

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

申请号：US09349607

申请日：1999-07-08

申请人： Kimberly Lynn Gajda ,  Bradley Allan Hess ,  Julie Anne Hill Kemp ,  Jerry Jay Lewis ,  Robert Tod Thorpe

发明人： Kimberly Lynn Gajda ,  Bradley Allan Hess ,  Julie Anne Hill Kemp ,  Jerry Jay Lewis ,  Robert Tod Thorpe

IPC分类号： G06F1730

CPC分类号： G06F17/3056 ,  Y10S707/99931 ,  Y10S707/99932 ,  Y10S707/99934

摘要： 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操作; 在关系数据库和非关系数据库中提供数据的参照完整性; 并在非关系数据库中高效地执行数据和其他查询的即席查询。 通过添加这些功能，将显着的灵活性添加到计算机系统中。

公开(公告)号：US06457003B1

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

申请号：US09375111

申请日：1999-08-16

申请人： Kimberly Lynn Gajda ,  Robert Tod Thorpe

发明人： Kimberly Lynn Gajda ,  Robert Tod Thorpe

IPC分类号： G06F1730

CPC分类号： G06F17/30557 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99934

摘要： 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.

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