It bothered me for a long time there was no data modeling tool to represent, in the conceptual view of a relational database model, many-to-many relationships with just a straight connector between the two tables and nothing more. With no required intersection table, as long as this was a physical level implementation detail.
Our suite may be the only such database tool on the market today that offers this important security level: making sure data and metadata are only “xtracted” from a database, and never altered (including deletions and insertions). Our customers will just drill-down on relational relationships the fastest possible way, looking for data. They will reverse engineer your database metadata and expose comprehensible and flexible data models as diagrams. But they may never, and they should never, alter whatever your connected databases may have.
Instant flexible data models for most relational database management systems. Choose what tables and views to add in each diagram. Expanded, collapsed or minimized shapes. Expandable relationships as surrogate shape items. Chain relationships and custom joins. Table, view and columns aliases. And did I mention the Model Xtractor is all FREE? More to come: web publishing in self-hosted environment, with team collaboration.
I’ll say this, and not just because I advertise this product, but I’ll prove it: Query Xtractor is one of the best tools to learn SQL! Once again: Query Xtractor – from the Data Xtractor suite – is one of the best possible ways to help you learn SQL! And not just plain and simple SQL, but SQL adapted to different real world DBMSs or standalone database engines.
I always admired how most database administrators I worked with love typing both simple and complex queries with absolutely no help from a QBE (Query by Examples) graphical interface. Truth being said, the large majority of database administration tools offer a somehow poor user experience in this regard. And Query Xtractor is intended to improve this area.