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, и S. Levialdi. Proceedings of the IFIP TC2/WG 2.6 Second Working Conference on Visual Database Systems II, стр. 153--168. Amsterdam, The Netherlands, The Netherlands, North-Holland Publishing Co., (1992)
M. Sampaio, J. Quesado, и S. Barros. Advances in Databases and Information Systems, том 186 из Advances in Intelligent Systems and Computing, Springer Berlin Heidelberg, (2013)
E. Bakke, D. Karger, и R. Miller. Proceedings of the SIGCHI Conference on Human Factors in Computing Systems, стр. 2541--2550. New York, NY, USA, ACM, (2011)
X. Zhang, B. Pielech, и E. Rundesnteiner. Proceedings of the 4th international workshop on Web information and data management, стр. 15--22. New York, NY, USA, ACM, (2002)
X. Zhang, K. Liu, L. Zou, X. Du, и S. Wang. Proceedings of the 12th international conference on Web-age information management, стр. 578--589. Berlin, Heidelberg, Springer-Verlag, (2011)
K. Schmidt, S. Bächle, и T. Härder. Database Systems for Advanced Applications, том 5667 из Lecture Notes in Computer Science, Springer, Berlin / Heidelberg, (2009)
Q. Chen, A. Therber, M. Hsu, H. Zeller, B. Zhang, и R. Wu. Proceedings of the 2009 International Database Engineering & Applications Symposium, стр. 43--53. New York, NY, USA, ACM, (2009)