Patent ID: 8788511
Filing Date: 2014-07-22
Classification: G06F

Abstract:
1. A method for manipulating a Siebel database (SDB) with a Structured Query Language (SQL) statement, the method comprising: receiving, by a parser running on a processor of a server system, the SQL statement from a client system coupled to the server system, wherein the SDB comprises a Siebel repository and at least one relational database (RDB) table, the Siebel repository comprising at least one business component (BC) that enables controlling of Siebel data model of the SDB, said at least one RDB table storing actual data of the Siebel data model in relational database format, wherein the Siebel data model described by the Siebel repository is independent from the relational database format of said at least one RDB table, wherein the SQL statement requests modification of a first RDB table of said at least one RDB table by setting a first column of the first RDB table to a first value for records of the first RDB table satisfying a first WHERE clause of the SQL statement; creating a BC list comprising at least one BC of the Siebel repository, said at least one BC being associated with the received SQL statement; selecting a BC of said at least one BC from the created BC list responsive to determining that the BC comprises all fields respectively corresponding to all columns of all RDB tables represented in the received SQL statement; identifying a first group of records of said all RDB tables, the first group of records corresponding to the selected BC; updating the identified first group of records within the RDB tables of the SDB pursuant to the received SQL statement; and communicating the updated first group of records of the SDB to the client system.