Siebel Systems, Inc.

Oracle International Corporation

Arjun Chandrasekar Iyer

Chandrakant Ramkrishna Bhavsar

Jon Degenhardt

Peter Thorson

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 adapter business service

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. A second external system uses a second character set. A second data set is received from the second external system, the second data set using the second character set. The first data set and the second 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 second data set, as converted and integrated, are then used to effect one or more business processes. For one embodiment, the third character set is Unicode.

Growing community of inventors

Belmont, CA, United States of America

Arjun Chandrasekar Iyer