| When it comes to computer software | | | | robust as it reduces the lines of code |
| development, there are numerous programming | | | | programmed. This considerably reduces the work |
| concepts and methods that come to the fore, | | | | load of the programmers and ensures minimum |
| including Object SQL Mapping. | | | | errors. |
| Object-SQL Mapping, also called as | | | | - When a bulk of data is deleted, object SQL |
| Object-relational mapping is a programming | | | | mapping tools do not perform well. |
| method that links object oriented language | | | | Some computer software development experts |
| concepts to SQL databases, thus creating a | | | | support the use of object oriented database |
| virtual object database. The programming objects | | | | management system (OODBMS). The |
| represent real-world objects in the development | | | | OODBMS is created for working with |
| of software. For example, if an address book | | | | object-oriented values. Some programmers |
| contains lists of people along with their phone | | | | support Object oriented databases because it |
| numbers, a persons name, list of addresses and | | | | would eliminate the need for converting data to |
| phone numbers would be represented by a | | | | an SQL form. But, the major disadvantage of |
| person object with instance variables and fields | | | | Object oriented DBMS is losing the capability to |
| (slots) to hold data. But, when it is time to save | | | | create SQL queries. An Object-SQL mapping |
| the data to a permanent storage, the | | | | system fares in this aspect and thats why most |
| programmers will choose a persistent object | | | | programmers choose this method, even though |
| store, into which any object could be placed and | | | | commercial object oriented DBMS are capable to |
| retrieved later. Object SQL mapping is used to | | | | process SQL queries in a limited way. |
| implement this approach. | | | | There are many commercial and free packages |
| Advantages and Disadvantages of Object SQL | | | | that perform object-relational mapping. But, most |
| Mapping: | | | | custom software development services find it |
| - In the custom software programming field, the | | | | easy to create their own object relational mapping |
| object SQL mapping makes the software more | | | | tools. |