SchemaBank is a web-based data modeling

Data modeling

Data modeling in software engineering is the process of creating a data model for an information system by applying formal data modeling techniques.- Overview :...

 and database design

Database design

Database design is the process of producing a detailed data model of a database. This logical data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a Data Definition Language, which can then be used to create a database...

 tool, delivering to users over the internet

Internet

The Internet is a global system of interconnected computer networks that use the standard Internet protocol suite to serve billions of users worldwide...

 using the software as a service

Software as a Service

Software as a service , sometimes referred to as "on-demand software," is a software delivery model in which software and its associated data are hosted centrally and are typically accessed by users using a thin client, normally using a web browser over the Internet.SaaS has become a common...

 (SaaS

Saas

SAAS is an abbreviation for* Social Accountability Accreditation Services* Software as a service * Student Awards Agency for Scotland* Seattle Academy of Arts and Sciences* South Australian Ambulance Service...

) model. It supports visual creation of Entity-relationship diagram and conversion of such diagrams into Data Definition Language

Data Definition Language

A data definition language or data description language is a syntax similar to a computer programming language for defining data structures, especially database schemas.-History:...

 (e.g. SQL

SQL

SQL is a programming language designed for managing data in relational database management systems ....

 statements).

Visual creation of Entity Relationship Diagrams

SchemaBank allows users to draw physical entity relationship diagrams (ERD) for the following databases:

• MySQL
  MySQL
  MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...
  
  
• PostgreSQL
  PostgreSQL
  PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...
  
  

SQL statement generation

SQL statements can be generated automatically for all supported database systems.

Reverse engineering

Database schema dump can be imported into SchemaBank and be shown as ERD diagrams.

Version management

Version Control is provided at the project level. Different copies of database design can be committed into the version repository. Users can also create different branches within the version repository.

Reports can be generated to show the difference between any two versions stored inside the version repository. SQL Alter statements can also be generated to migrate the physical database system from one version to another.

Different project sharing modes

Database projects can be shared for either public access or named-user access. Named-user access requires the project owner to add an invitee's email address into the project's access control list

Access control list

An access control list , with respect to a computer file system, is a list of permissions attached to an object. An ACL specifies which users or system processes are granted access to objects, as well as what operations are allowed on given objects. Each entry in a typical ACL specifies a subject...

.

However, projects under their free plan can be shared only for public access.

See also

• Relational Model
  Relational model
  The relational model for database management is a database model based on first-order predicate logic, first formulated and proposed in 1969 by Edgar F...
  
  
• Computer-aided software engineering
  Computer-aided software engineering
  Computer-aided software engineering is the scientific application of a set of tools and methods to a software system which is meant to result in high-quality, defect-free, and maintainable software products...
  
  
• History of software configuration management
  History of software configuration management
  The history of software configuration management in computing can be traced back as early as the 1950s, when CM , originally for hardware development and production control, was being applied to software development. The first software configuration management was most likely done manually...