SQL-Based Object-Oriented Development with DBPowder

Although few decade years have passed since the object/relational (O/R) mapping problem was recognized, it still remains to be a hard problem. A relational model is suitable for persistence of the data, while an object model is suitable for processing of the data. The schema optimized for the relational model is not itself suitable for the object model. The opposite is also true.In this paper, we propose a method of SQL-based object-oriented development, called DBPowderSQL. In our approach, cardinalities between tables are automatically detected based on the configurations of key columns. The mapping between the relational model and the object model is derived based on the cardinality. In addition, programmers can customize the derived object model with support of inheritance, polymorphism, and composition.We developed a prototype system and evaluated it.