SQLServerCentral.com Articles tagged relational

Relational Databases and Solid State Memory: An Opportunity Squandered?

Fri, 10 Feb 2012 07:00:00 UT

The relational model was devised long before computer hardware was able to deliver an RDBMS that could deliver a fully normalized database with no performance deficit. Now, with reliable SSDs falling in price, we can reap the benefits, instead of getting distracted by NOSQL with its doubtful compromise of 'eventual consistency'.

Stairway to T-SQL DML Level 3: Implementing a Relational Model in SQL Server

Wed, 09 Nov 2011 07:00:00 UT

This level of the stairway details the creation of a relational database, as well as filling in some of the history of the relational database model.

Going Beyond the Relational Model with Data

Thu, 13 Oct 2011 06:00:00 UT

SQL is a powerful tool for querying data, and for aggregating it. However, you can't easily use it to draw inferences, to make predictions, or to tease out subtle correlations. To provide ever more sophisticated inferences to businesses, the race is on to combine the power of the relational model with advanced statistical packages. Both IBM and PostGres are ready with solutions. And SQL Server? Hmm...