iBATIS is based on the idea that there is value in relational databases and SQL, and that it is a good idea to embrace the industrywide investment in SQL. In some cases we have seen that an application was rewritten in a different language, but the SQL and database remained largely unchanged.
It is for such reasons that iBATIS does not attemp to hide SQL or avoid SQL. It is a persistence layer framework that instead embraces SQL by making it easier to work with and easier to integrate into modern object-oriented software.
Hybrid solutions have proven effective in the IT industry. iBatis is one such hybrid solution for the persistence layer of your application. Over time, various methods have been developed to enable applications to execute SQL against a database. iBATIS is a unique solution that borrows concepts from several other approaches.
#1 iBATIS takes the best attributes and ideas from the most popular means of accessing a relational database, and finds synergey among them. At the heart of iBATIS is SQL. By definition, all relational databases support SQL as primary means of interacting with the database. SQL is a simple, nonprocedural language for working with the database, and is really two languages in one.
The first is Data Definition Language(DDL), which includes statements like CREATE, DROP, and ALTER. THESE STATEMENTS ARE USED TO DEFINE THE STRUCTURE AND DESIGN OF THE DATABASE, INCLUDING The tables , columns, indexes, constraints, procedures, and foreign key relationships. DDL is not something that iBATIS supports directly. Although many people have successfully executed DDL using iBATIS, DDL is usually owned and controlled by a database administration group and is often beyond the reach of developers.
The second part of SQL is the Data Manipulation Language(DML). It includes statements such as SELECT, INSERT,UPDATE, and DELETE. DML is used to manipulate the data directly. Originally SQL was designed to be a language simple enough for end users to use. It was designed so that there should be no need for a rich user interface or even an application at all. SQL alone is no longer an effective interface for end users. but it is an extremely powerful tool for developers. SQL is the only complete means of accessing the database; everything else is a subset of the complete set of capabilities of SQL. For this reason, iBATIS fully embraces SQL as the primary means of accessing the relationship. At the same time, iBATIS provides many of the benefits of the other approaches, including stored procedures and object/relational mapping tools.