Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In with Facebook Sign In with Google Sign In with OpenID

Categories

We have migrated to a new platform! Please note that you will need to reset your password to log in (your credentials are still in-tact though). Please contact lee@programmersheaven.com if you have questions.
Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Tips - Database Management Tool

mitzanumitzanu RomaniaPosts: 1Member

It’s not uncommon to discover databases that have simply evolved over time rather than having been built according to some overall design or “master plan”. And there seem to be no shortage of answers as to why this occurs. Sometimes DBA’s are just far too busy with loads of other tasks. Sometimes developers are under the gun for deliverables so quickly that there’s just not time. Or, this project started just a couple new tables and then ballooned into a monster. Whatever the reason, the situation exists far too often in the real world of information systems. Let’s put this into perspective. Would you build a new house without a foundation? For sure you’re not going to do that.

The database it’s the foundation of the software and a good database design will reflect in the quality of the software. Dbschema it’s a complete database management tool for the most popular relational databases providing the highest performance, scalability and reliability to meet the requirements of today's database applications .It provides a various powerful tools for viewing, editing and document your schema.

Layouts

Just like in the real life, when you`re going to build a house you’ll need a design plan for the house. Dbschema allows you to view all the elements from the database in a graphical environment with the help of the layouts. A layout it’s a diagram that represents the tables of your database and the relationships between them and for a better understanding of the database schema it allows you to create multiple layouts so you can focus only on a specific part of the database schema. The layouts allows you to create Entity Relationship Diagram that will represent all the elements in your database. The tool is intended for reverse engineering and database modification in an easy and powerful way. It helps you to simplify database maintenance. A diagram of your database can help you define operational aspects of your applications logic that you might otherwise overlook. Also, a well-defined data diagram that accurately represents your tasks can be helpful in orienting employees to goals and operations. Directly from the layout you can create, edit or delete any table, column, foreign key, etc… also you can find a set of features that come in handy in the daily work like: Fast Table Search, Data preview of the tables, Foreign key Notation, callouts(Comments), groups of tables, etc…

Relational Data Browse

If you want to view data from multiple tables at the same time without writing complicated sql queries you can use the Relational Data Browse. Data Browse operates in a multi level master detail, this allows you to see the tables data in a cascade mode. Using it you can see data from multiple tables at the same time just like the result of a complicated join query without any limitation in the numbers of tables that you can add. It’s a great functionality that you must try. Directly in the Relational Data Browse you can set different sets of filters such as: sorting, column filters, like, between, equals, is empty, is not empty, etc…

Query Builder

Using the Query Builder you can create very complex queries, in a visual way, without any sql knowledge, this is very useful even for the sql experts because they can build queries fast and it will save time. The Query Builder is a code generator that produces SQL commands that you can use or share. You can use this features to build complex queries and combine different set of filters, different join conditions: INNER JOIN,LEFT OUTER , EXISTS, NOT EXISTS,GROUP BY, of any complexity. If you want to analyze how a query is processed by the database you can use the Explain Plan feature.

Sql Editor Another Build-in tools is the Sql Editor that you can use in writing sql queries manually, the auto-completion feature will constantly help you. Also you’ll find useful the text formatting, syntax highlighting importing and exporting sql scripts, etc… Schema Documentation You can export your schema or parts of it as an image: PNG, GIF or JPG. Or you can export it as HTML 4 and HTML5, this is the ideal documentation because the image is small and moving the mouse over the columns you can read table comments and see the database structure.

Synchronization The Synchronization feature lets you work in a team the changes will be tracked and available for everyone in your team. Another great feature of the synchronization lets you compare different schemas, track changes or easily migrate a database between the production test and development environments or different databases, for example you can migrate your MySql database to Oracle and vice versa.

Usually you can’t work on your project without a database connection. With DbSchema you can. Use the offline mode to design the schema without a database connection and create it or update it later in the database.

Data Generator Why do I need to fill a database with random data? When developing an application, you would be wise to test it. You might test it for correctness and you might test it for load. Manually inserting 3 or 4 rows in each table just isn't good enough. This is an attempt at making the problem smaller. Generating fixtures has never been easier.

Use DbSchema to:

• Connect to any RDBMS using JDBC drivers • Reduce faults in development • Significantly improve your productivity • Visualize database structures and get a better understanding of the existing databases. • Verify your work automatically • Generate very detailed HTML documentations • Keep existing database structures up-to-date • Work in a team with existing database structures • Create databases faster • Create Groovy Scripts

Sign In or Register to comment.