Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /homepages/8/d158560430/htdocs/ericjlawson/wp-content/plugins/jetpack/_inc/lib/class.media-summary.php on line 77

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in /homepages/8/d158560430/htdocs/ericjlawson/wp-content/plugins/jetpack/_inc/lib/class.media-summary.php on line 87
SQL Relay 2013R2 – Cardiff | Data Architecture
Warning: count(): Parameter must be an array or an object that implements Countable in /homepages/8/d158560430/htdocs/ericjlawson/wp-includes/post-template.php on line 284

SQL Relay 2013R2 – Cardiff

I was very pleased to be able to deliver my Star Schema Primer presentation to members of the SQL Server community at the Cardiff leg of the excellent SQL Server Relay 2013R2 event last Wednesday (13.11.2013). There was an excellent turn out and the sun was shining. Go Wales. Thanks very much to the organisers. The effort these volunteers make to put these events on should not be underestimated.

The tagline of the presentation was “the core principles of the Star Schema database, used for decision support solutions and as the bedrock for Analysis Services cubes and the new Tabular model”.

It covers the evolution of the relational database model and the major players, what a normalised data model looks like and how a star schema database deliberately moves away from that OLTP optimsed design, to deliver the basis for high performance decision support solutions.

I cover the basic features of the star schema database, dimension and fact table examples and considerations for best use of these database designs.

If you are starting out in this field then I hope this presentation provides some context and useful tips. I extensively used Wikipedia for my research and have provided loads of links. So whenever you want to find out when Larry Ellison spotted an opportunity waiting to be exploited, which RDBMS system spawned many others and who is Jimmy Treybig, this primer brings many of these trivial pursuit answers for data professional together in one place.

Click to view the Apple Keynote presentation in your browser.

PS. if you spot any errors, or think I have done someone or some company a disfavour by omission, please let me know.


Tags: , , , , ,

Comments are closed.