MIS 447 Resources

• Download the Database Files
  • AdventureWorks2012
  • AdventureWorksDW2012
  • AdventureWorksLT2012
• Tools
  • Gradiance
  • ERDPlus

SQL Server 2014 Resources

• Implementing a Data Warehouse with SQL Server Jump Start

SQL Server 2014 vs. SAP Hana

• Can Microsoft's SQL Server 2014 Compete with SAP HANA? (May 2014)
• SQL Server Database Features - Microsoft Documentation
• Microsoft’s SQL Server 2014 Adds In-Memory, Updates Columnar - Mar 2014

But the interesting bit about in-memory transaction processing is that it enables such speedy queries against production databases that have live rather than summary data that in many cases putting in-memory databases underneath ERP, CRM, and other back-end systems obviates the need for data warehouses to do separate queries. This, in fact, is precisely what application software maker SAP has found out as it has deployed its own HANA in-memory database underneath its own ERP and CRM systems as well as the data warehouse it uses to steer its business.

• Microsoft Turbocharges Transactions With ‘Hekaton’ In-Memory
• Inside SAP’s Own HANA Accelerated Systems
• SAP Hana vs Microsoft SQL Server, the war is on...
• Solving Big Data with SAP HANA and Hadoop - Aug 2012

Data Warehousing and Python

Frameworks / Tools

• Cubes
  • Talk at PyCon 2014
• Bubbles - Python ETL Framework
  • Blog article on Bubbles
• pygrametl - Python ETL Framework

Talks

• How to Build a SQL-based Data Warehouse for 100+ Billion Rows in Python Presentation Video Slides
• Python for BI - Talk at PyData 2012

Related Courses

• CS 345: Topcis in Data Warehousing @ Stanford: Autumn 2004
• U Chicago Course on Data Warehousing (Winter 2013)