Home arrow MySQL arrow Plan a Good Database

Plan a Good Database

Organize a collection of data somehow for later usage and you will get a database. In the last couple of years, with the spread of the Internet, databases have become something you will come across everywhere on the World Wide Web. Most websites have a strong database behind them. With this phase of the web's evolution, if you work in software development, eventually you will need to create and plan a database from scratch. This article is here to teach you and show you what traits a solid plan should have.

TABLE OF CONTENTS:
  1. Plan a Good Database
  2. Data Model
  3. Relationship Types
  4. Relational Model
By: Gabor Bernat
Rating: starstarstarstarstar / 9
June 02, 2010

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

To start, we need to separate the concept of data and information. While in the everyday usage these two merge, in the world of databases these are two very separate things. Data is the representation of facts/concepts of stuff that is adequate for human or automatic (by a machine) processing. The information is the meaning that we allocate to the data. For example, a ten percent salary decrease is a piece of data. For the employee, this is a bad thing (information), while for the boss it can be a good thing (also information).

The significance of a given piece of data depends on the current user. Therefore, we can work up and organize a structure for the data. You should leave the determination of the information out of the database, because this it is not always possible at this level. The application that uses the database should handle this (like the Windows/Mac/Linux application or the website).

A database management system is software that organizes and keeps your data together. This should work fast if you have an enormous quantity of data. There are two products from which you can choose currently on the market. There is the free version, MySQL; and the professional and expensive one, available from Oracle.

Actually, in 2009 Oracle bought MySQL, which has therefore become a slimmer version of Oracle's database. You can achieve most of the same tasks in both interfaces. However, you will have to work a lot harder (in the sense of extra code to write) if you take the MySQL path. MySQL is currently up to the fifth main version. 

My advice is to travel the Oracle path if you do it for a large company and can afford the extra cash. Otherwise, go for MySQL if you do it for your personal use or the $200+ price tag creates an impediment.



 
 
>>> More MySQL Articles          >>> More By Gabor Bernat
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

MYSQL ARTICLES

- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: