Top-down vs Bottom-up Database Design

There are essentially two different approaches one can take when designing databases; these, from a high level analytic point of view, narrow down to what are typically called “Top-down” and “Bottom-up” philosophies or methods. While these methodologies can appear profoundly unique, they share the shared objective of joining a system Read more…

By Andrew Odendaal, ago

A bit on SQL Standards

SQL (Structured Query Language) for relational databases was maintained and standardised by the American National Standards Institute (ANSI) and the International Organisation for Standardisation (ISO) which is affiliated with the International Electrotechnical Commission (IEC). When a new SQL standard is published by these organisations it is outlined on the ISO Read more…

By Andrew Odendaal, ago

Relational Database Proprietary Extensions

Standard Query Language – or SQL for short – is a language designed for relational databases that allows end users such as developers and database administrators (DBAs) to manipulate data. Whether that be INSERT-ing, UPDATE-ing, DELETE-ing, SELECT-ing or otherwise ALTER-ing almost any amount of data; SQL provides an effective way Read more…

By Andrew Odendaal, ago