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)
X. Zhang, B. Pielech, und E. Rundesnteiner. Proceedings of the 4th international workshop on Web information and data management, Seite 15--22. New York, NY, USA, ACM, (2002)
X. Zhang, K. Liu, L. Zou, X. Du, und S. Wang. Proceedings of the 12th international conference on Web-age information management, Seite 578--589. Berlin, Heidelberg, Springer-Verlag, (2011)
K. Schmidt, S. Bächle, und T. Härder. Database Systems for Advanced Applications, Volume 5667 von Lecture Notes in Computer Science, Springer, Berlin / Heidelberg, (2009)
Q. Chen, A. Therber, M. Hsu, H. Zeller, B. Zhang, und R. Wu. Proceedings of the 2009 International Database Engineering & Applications Symposium, Seite 43--53. New York, NY, USA, ACM, (2009)