公开(公告)号：US20070192336A1

公开(公告)日：2007-08-16

申请号：US10001095

申请日：2001-11-15

申请人： Arjun Iyer ,  Chandrakant Bhavsar

发明人： Arjun Iyer ,  Chandrakant Bhavsar

IPC分类号： G06F7/00

CPC分类号： G06F17/30463 ,  G06F17/30557 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99953

摘要： A Structured Query Language (SQL) adapter business service that converts data from a data set to a common representation format used for all data sets with which the SQL adapter business service interacts. Hence the SQL adapter business service can communicate with various internal and external systems independently of the native format in which those systems maintain and store data. The SQL adapter business service optimizes operations to update data in the data sets by combining operations when possible and by using result sets from executing previous SQL statements to construct subsequent SQL statements. SQL adapter business service takes advantage of parent/child relationships between tables to construct SQL statements in an order such that the SQL statements process only a minimum amount of data, thereby making retrieval of data as efficient as possible.

摘要翻译： 结构化查询语言（SQL）适配器业务服务，将数据从数据集转换为用于与SQL适配器业务服务交互的所有数据集的公共表示格式。 因此，SQL适配器业务服务可以独立于这些系统维护和存储数据的本机格式与各种内部和外部系统进行通信。 SQL适配器业务服务优化操作，以在可能时组合操作并通过使用执行先前SQL语句的结果集来构建后续SQL语句来更新数据集中的数据。 SQL适配器业务服务利用表之间的父/子关系来构造SQL语句，以使SQL语句仅处理最小量的数据，从而使数据检索尽可能高效。

公开(公告)号：US20070192304A1

公开(公告)日：2007-08-16

申请号：US10751236

申请日：2004-01-02

申请人： Arjun Iyer ,  Chandrakant Bhavsar

发明人： Arjun Iyer ,  Chandrakant Bhavsar

IPC分类号： G06F17/30

CPC分类号： G06F17/30463 ,  G06F17/30557 ,  Y10S707/99932 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99953

摘要： A Structured Query Language (SQL) adapter business service that converts data from a data set to a common representation format used for all data sets with which the SQL adapter business service interacts. Hence the SQL adapter business service can communicate with various internal and external systems independently of the native format in which those systems maintain and store data. The SQL adapter business service optimizes operations to update data in the data sets by combining operations when possible and by using result sets from executing previous SQL statements to construct subsequent SQL statements. SQL adapter business service takes advantage of parent/child relationships between tables to construct SQL statements in an order such that the SQL statements process only a minimum amount of data, thereby making retrieval of data as efficient as possible.

摘要翻译： 结构化查询语言（SQL）适配器业务服务，将数据从数据集转换为用于与SQL适配器业务服务交互的所有数据集的公共表示格式。 因此，SQL适配器业务服务可以独立于这些系统维护和存储数据的本机格式与各种内部和外部系统进行通信。 SQL适配器业务服务优化操作，以在可能时组合操作并通过使用执行先前SQL语句的结果集来构建后续SQL语句来更新数据集中的数据。 SQL适配器业务服务利用表之间的父/子关系来构造SQL语句，以使SQL语句仅处理最小量的数据，从而使数据检索尽可能高效。

公开(公告)号：US20070244689A1

公开(公告)日：2007-10-18

申请号：US10176898

申请日：2002-06-20

申请人： Jon Degenhardt ,  Peter Thorson ,  Arjun Iyer

发明人： Jon Degenhardt ,  Peter Thorson ,  Arjun Iyer

IPC分类号： G06F17/20

CPC分类号： G06F17/2223

摘要： An embodiment of the present invention describes a method and system for using related data from external systems employing incompatible character sets to affect a business process. For one embodiment, a first external system uses a first character set. A first data set is received from the first external system, the first data set using the first character set. The first data set a subset of a second data set. A second external system uses a second character set. A third data set, which is also a subset of the second data set, is received from the second external system, the third data set using the second character set. The first data set and the third data set are converted to use a third character set, the third character set a superset of the first character set and the second character set. The first data set and the third data set are then used to effect one or more business processes. For one embodiment, the third character set is Unicode.

摘要翻译： 本发明的一个实施例描述了一种使用来自使用不兼容字符集的外部系统的相关数据来影响业务过程的方法和系统。 对于一个实施例，第一外部系统使用第一字符集。 从第一外部系统接收第一数据集，第一数据集使用第一字符集。 第一数据集合设置第二数据集的子集。 第二个外部系统使用第二个字符集。 第三数据集，其也是第二数据集的子集，从第二外部系统接收第三数据集，第三数据集使用第二字符集。 将第一数据集和第三数据集转换为使用第三字符集，第三字符集是第一字符集和第二字符集的超集。 然后，第一数据集和第三数据集用于实现一个或多个业务流程。 对于一个实施例，第三个字符集是Unicode。