Enabling siebel database manipulation by use of a direct SQL statement

A computer program product comprising:

• a computer readable hardware storage device having a computer readable program code embodied therein, said computer readable program code containing instructions which, upon being executed by a processor of a server system of a computer system, perform a method for manipulating a Siebel database (SDB) with a Structured Query Language (SQL) statement, said 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.

A computer system comprising a server system, a processor of the server system, a memory coupled to the processor, and a computer hardware readable storage device coupled to the processor, said storage device containing program code configured to be executed by the processor via the memory to implement a method for manipulating a Siebel database (SDB) with a Structured Query Language (SQL) statement, said manipulating comprising:

• receiving, by a parser running on the processor of the 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.