Posts Tagged ‘database’
Relational Databases
When building a dynamic website a relational database such as MySQL, Oracle, MSSQL etc. is an important part of the project. Tabular data works well within a relational database as it requires a well-defined structure.
At its most basic a database is simply a collection of rows and columns.Relational databases are a basic requirement of any dynamic website weather a blog, wiki, cms, ecommerce, etc. Relations are created between tables using links between common data in organised in separate tables.
Databases are a highly optimised method for storing and retrieving data. Many high level languages (such as PHP) allow direct access to databases for querying and manipulating data. This enables data to be used efficiently with minimal server load.
