Ein weit verbreitetes Missverständnis steht hinter dem Mythos, dass dynamische SQL langsam ist. Für bedingte WHERE-Klauseln kann eben dieser Mythos zu Performanceproblemen fürhen.
Ibator will introspect a database table (or many tables) and will generate iBATIS artifacts that can be used to access the table(s). This lessens the initial nuisance of setting up objects and configuration files to interact with database tables. Ibator seeks to make a major impact on the large percentage of database operations that are simple CRUD (Create, Retrieve, Update, Delete). You will still need to hand code SQL and objects for join queries, or stored procedures.
The Doctrine Project is the home to several PHP libraries primarily focused on database storage and object mapping. The core projects are a Object Relational Mapper (ORM) and the Database Abstraction Layer (DBAL) it is built upon.
DIVA - is a viewer of database physical structure, it can show you any section of DB in several usable forms (2D, 2.5D, 3D). In this way user can easily understand dependency between tables.
C. Batini, T. Catarci, M. Costabile, und S. Levialdi. Proceedings of the IFIP TC2/WG 2.6 Second Working Conference on Visual Database Systems II, Seite 153--168. Amsterdam, The Netherlands, The Netherlands, North-Holland Publishing Co., (1992)
M. Trzaska, und K. Subieta. AVI '06: Proceedings of the working conference on Advanced visual interfaces, Seite 500--503. New York, NY, USA, ACM, (2006)
M. Sampaio, J. Quesado, und S. Barros. Advances in Databases and Information Systems, Volume 186 von Advances in Intelligent Systems and Computing, Springer Berlin Heidelberg, (2013)
E. Bakke, D. Karger, und R. Miller. Proceedings of the SIGCHI Conference on Human Factors in Computing Systems, Seite 2541--2550. New York, NY, USA, ACM, (2011)