Data modeling in SqlDBM

Data modeling is the process of documenting a complex software system design as an easily understood diagram, using text and symbols to represent the way data needs to flow. The diagram can be used as a blueprint for the construction of new software or for re-engineering a legacy application.

Data modelers often use multiple models to view the same data and ensure that all processes, entities, relationships and data flows have been identified. There are several different approaches to data modeling, including:

Conceptual Data Modeling — identifies the highest-level relationships between different entities.

Enterprise Data Modeling — similar to conceptual data modeling, but addresses the unique requirements of a specific business.

Logical Data Modeling — illustrates the specific entities, attributes and relationships involved in a business function. Serves as the basis for the creation of the physical data model.

Physical Data Modeling — represents an application and database-specific implementation of a logical data model.

What is SqlDBM?

SqlDBM Develop Database and Data Warehouse without writing a single line of code. SqlDBM (www.sqldbm.com) offers you an easy, convenient way to design your database for Snowflake, Redshift , MS SQL Server, PostgreSQL & MySQL absolutely anywhere on any browser, working away without need for any extra database engine or database modelling tools or apps. Use SqlDBM to design and manage both large and small databases and data models on the fly. All while incorporating any needed database rules and objects such as database keys, schemas, indexes, column constraints and relationships.

SqlDBM’s core functionality is to create to create or modify your existing Database or Data Warehouse without writing a single line of code.

SqlDBM — Develop Database and Data Warehouse without writing a single line of code.
SqlDBM’s features

Along with that SqlDBM offers the following features for its users:

Different Database / Data Warehouse Types Support

  • SqlDBM is compatible with MS SQL Server, MySQL, PostgreSQL, Snowflake and Amazon Redshift
  • You can convert projects between MS SQL Server, MySQL, PostgreSQL, Snowflake and Amazon Redshift

SqlDBM enables you to visualize database design online for MS SQL Server, MySQL, PostgreSQL, Snowflake and Amazon Redshift. While creating a project in SqlDBM, you can select a type of your project in either MS SQL Server, MySQL, PostgreSQL, Snowflake or Amazon Redshift. You can even convert your project from MySQL to SQL Server, PostgreSQL, Snowflake or Amazon Redshift and vice versa.

Friendly UI for Modeling

  • Create tables quickly in a very intuitive way
  • InLine editing of tables on the diagram
  • Define relationships between tables easily
  • Copy or Move columns across tables
  • Zoom In/out diagrams

SqlDBM’s user interface is specifically designed as an independent platform that is ridiculously easy to use. Any proprietary commercial softwares are unnecessary for its use — all you need is a browser. But this does not mean that SqlDBM suffers reduced utility compared to the commercial-database alternatives. The interface is richly functional and includes many abilities such as drag-and-drop elements (for example when moving a column to another table), in-and-out zoom, and modification of all database objects. Here it is, at your fingertips, a rich, on-the-spot design tool that can be used anywhere and on any browser.

Forward and Reverse Engeenering

  • Generate SQL Code
  • Import Existing DB/DW

Use SqlDBM to create a physical model or ERD of your DB/DW, then create your actual database using the model, including all database objects — tables and their attendant columns and relationships, indexes and constraints. Alternatively, simply click to generate the necessary SQL statements that will create your database, and save these statements to create your database at a later point. No database credentials are required for this.

Do you already have an existing database but no ER diagram or physical model? With SqlDBM, you can use the reverse engineering feature to import an existing database into SqlDBM. No database credentials are required for this as well.

Collaborate and Share Projects

  • Team collaboration allows to work remotely with your team and stakeholders on the same project.
  • Easily share projects and versions of each project with other users
  • Use shared projects for presentations, documentation or database design reviews

Team Collaboration: work remotely with your team and stakeholders on the same project. Keep a geographically dispersed team collaborating and always in sync.

Quickly create and share projects with other users. Share feature allows user to create universal link, anybody with has this link can view the project and create their own copy.

Compare Revisions

  • Identify differences between your SqlDBM revisions within seconds.
  • Eliminate mistakes migrating DB/DW changes from Dev, to QA, to Prod
  • Compare tables and DDL scripts

Compare Revisions feature allows SqlDBM users to compare changes in tables and DDL scripts and easily identify difference between revisions in your project. It also detects column discrepancies such as data type, nullability, constraints and defaults.

Alter Script

  • Generate Alter Script to modify objects in existing DB/DW
  • Select between SqlDBM revisions to apply Alter Script

SqlDBM provides the Alter Script feature that helps to incorporate the changes to the already existing database/data warehouse design. This is vital to ensure that your database can be easily kept up-to-date with your ever-evolving data model

Diagram Export

  • Export the entire diagram in PNG format
  • Export individual subject areas of your interest

With SqlDBM Diagram Export Feature — users can easily and conveniently export their schema diagram in PNG format any time for sharing, presentations, printing or including it into Business Requirement Document.

Project Conversion

  • Redshift to Snowflake DDL Conversion
  • Easy and quick DB Type Migration

Project Conversion feature enables SqlDBM users to seamlessly convert one DB/DW type to another in a matter of a few clicks. Save hours of work from recreating DDL scripts while migrating from Redshift to Snowflake.

Revisions

  • SqlDBM automatically creates a new version of your project upon every ‘Save’
  • You can roll back to any version at any time
  • All versions are saved in the cloud, giving you the flexibility to open any version anywhere
  • You can create custom labels for any version

When working on your SqlDBM project, every time you click ‘Save’, a new version of your project is automatically created. Made some inadvertent changes and need to revert to a previous version of your project? Easy — just navigate to the list of versions, numbered by timestamp, and roll back to whichever version you want

All versions are stored in the cloud for security and quick and easy retrieval. And you can create your own custom labels or descriptors for any version or revision, say “New Sales Structure, created 12–25–2017, to be rolled out Q1 2018”.

View Modes

  • Customize your project view using modes such as: Table Names only, Keys only, Description Only etc
  • Use the different view modes for different purposes, for example one view for presentation purposes and another for design reviews
  • Add a helpful description for each view mode for better conceptual modelling and identification

View Modes allow you to zero in and limit what you are currently viewing to only objects of interest. For example, you may want to simplify and view only the tables in your database, without any visual ‘clutter’ of columns, indexes, keys and so on. To do this, simply click View Modes and select the ‘Table’ view mode, also accessible via the keyboard shortcut Ctrl+1. Other available view modes are PK/AK (to view only Primary and Alternate keys), Columns (to view all columns in all tables) and Notes (to view all notes previously created).



This isn’t all what SqlDBM has to offer, check out SqlDBM at https://sqldbm.com and let us know how we can improve SqlDBM to resolve your current issues related to database designing/modeling. Help us get the next update to SqlDBM in the best possible shape. Your feedback is important to securing a solid update release, and we greatly appreciate your assistance.

SqlDBM — Develop Database and Data Warehouse without writing a single line of code.

Related 

Load More