Press "Enter" to skip to content

Posts published in “Content”

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…

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…

Entity and Referential Integrity in Relational Databases

Data integrity is the overall completeness, accuracy and consistency of data (Techopedia, n.d.). In order to achieve data integrity, it is important to analyse Entity and Referential integrity constraints. Entity Integrity Focuses on Primary keys. Each table should have a primary key and each record must be unique and not…

The Relational Database Model

Relational databases first made an appearance in the mid 1970s, between the years 1974 and 1977 with the creation of Ingres and System R which led to the creation of MS SQL Server, Sybase, Wang’s PACE and Britton-Lee to name a few (Quickbase, n.d.). It was only until the 1980s…

A Brief Talk on Databases

Databases have been around since ancient times, when elaborate database systems were deployed by governments, hospitals and organisations to keep track of vast amounts of information; but only until around the 1960s did computerised databases start to take shape and become cost effective for private organisations to start using (Quickbase,…

Mitigating Risks with Software Development Outsourcing

In the Oxford Dictionary the term “outsourcing” is simply defined as obtaining goods or services by contract from an outside supplier (OxfordDictionaries.com, n.d.).   When it comes to software development, the same is true, with many companies opting to use economically cheaper labour to extend or swap out their workforce…

Cloud Computing – The Refute

Cloud is great, but when you know what you are doing, think about alternatives (Blippex, 2013).   What is Cloud? “The cloud” is a term given to pay as you go – or pay monthly – off premises computing services that provide either hosting or storage to it’s user base.…

Auditing Organisational Information Systems – Security

Auditing an organisation’s information systems is a vital part of operating a business at any decent scale. Particularly from a security standpoint (Mohamed ElBorno, n.d.). Information systems have many different facets and each organisation operates slightly differently, so while auditing can be handled the same on general shared traits, more…

Biometric Technology

What is Biometric Technology? Biometric verification is any means by which a person can be uniquely identified by evaluating one or more distinguishing biological traits (Margaret Rouse, n.d.)   Such recognition usually falls into one of the main categories such as: Facial recognition Hand geometry Earlobe geometry Signature comparison Voice…

Copyright Compensation in the Internet Age

The original conception of copyright in 1710 (Craig Joyce, n.d.) was that it usually covers only the expression of a particular idea and not the idea itself, but this was a very long time ago, before the challenges of a digital society. Since then, copyright has had to encompass a…