Database Design

How do we pick out the data we want when we meet a huge amount of data in our daily work? Is it a blind search, or is it a search for a new solution or a trick to get it? When designing a data form, developers tend to follow three commonly used forms, which they consider to be the only way to design. However, since the developer had this mindset at the outset, the design of the data form became entrenched and hindered its innovation. Author Shivprasad from the usual work of the project accumulated some experience, introduced us to 11 of the production of data form ...

In MySQL, using the id field of the auto_increment type as the primary key of a table and using it as a foreign key to other tables to form a "master-slave table structure" is a common usage in database design. However, in the specific generation of id, our order of operations is generally: insert records in the main table, and then get the automatically generated id, based on it to insert the record from the table. There is a difficulty here, is inserted into the main table record, how to get it corresponds to the id. The usual practice is through "select max (id) from table ...

Odaba is an advanced oriented database management system, according to ODMG3 's Odbms concept of an extended version. It provides a variety of enhancements based on natural language analysis, including database cores, database http://www.aliyun.com/zixun/aggregation/6993.html "> Design tools, Documentation, and accelerated development." Odaba provides a powerful c++++ and. NET interface, as well as a Odaba scripting interface (OS ...).

Odaba is an advanced oriented database management system, according to ODMG3 's Odbms concept of an extended version. It provides a variety of enhancements based on natural language analysis, including database cores, database http://www.aliyun.com/zixun/aggregation/6993.html "> Design tools, Documentation, and accelerated development." Odaba provides a powerful c++++ and. NET interface, as well as a Odaba scripting interface (OSI ...

Database Deployment Manager (DDM) is a desktop platform-oriented, multi-platform http://www.aliyun.com/zixun/aggregation/6993.html "> Design tool, It allows database administrators and programmers to create database structures (using object-oriented methods) and deploy to existing databases. The tool can be used to create charts to determine the basic relationships between the defined structures. Database Deploym ...

Odaba is an advanced oriented database management system, which is an extended version of the Odbms concept according to ODMG3. It provides a variety of enhancements based on natural language analysis, including database cores, database http://www.aliyun.com/zixun/aggregation/6993.html "> Design tools, Documentation, and accelerated development." Odaba provides a powerful c++++ and. NET interface, as well as a Odaba scripting interface (...).

Dbwrench is a multi-platform Visual Database design synchronization software. Features include syntax highlighting SQL Query Editor, support for multiple most popular databases, graphic entity diagram (ERD) design, and forward and reverse engineering database capabilities. This software is the ideal choice for heterogeneous database environments. Official web site: Http://www.dbwrench.com/DbWrench 2.1.0 features include support for Oracle database, print and print preview, enhanced JDBC driver ...

MySQL Workbench is an er/database modeling tool designed for MySQL. It is the famous database http://www.aliyun.com/zixun/aggregation/6993.html "> Design tool DBDesigner4 successor. You can design and create new database diagrams, build database documents, and perform complex MySQL migrations (zsh) with MySQL Workbench. MySQL Wor ...