A database is an organized collection of any kind of information (data). It is used to store, modify, delete and retrieve data.
Where is A Database Stored?
An electronic database may be stored on any secondary storage device - magnetic tape, magnetic/optical disc, external servers etc.
How is Database Organized?
The data is broken down into records, and the records are broken down into fields. The records are organized into tables, and these tables contain the relations between the records. (and how the data should be managed - metadata).
Types of Database
Flat databases are based on a sequence principle, they were mostly used in the early systems.
They have a tree-like structure, where a category breaks down into subcategories and so on.
Network databases include multiple linking between the records and is widely used nowadays in eCommerce.
Database Driven Websites
If you need a website where the information is changed often (you have dynamic web pages), you’d need a database driven website. Changes will only need to be done in a database, and your website will automatically reflect them to the user.
That is applicable for:
Advantages of a Database-Driven Website
Additional facts about database-driven websites:
Database-driven websites cost more, especially if you need a custom database design. Databases need back up (which usually is packed in a database service). And be prepared that the capacity of your database server will need to grow, which will lead to additional investment.
<iframe width="560" height="315" src="https://www.youtube.com/embed/Ls_LzOZ7x0c" frameborder="0" allowfullscreen></iframe>
If you’ve been investigating this subject for a while and you have some great resources which could help other people to make head or tail of it, please feel free to share it in a comment section.
Dynamic web pages, content management system, blog.