Azure

Azure SQL options – The Arrival of the modern data warehouse – part 2

Recently I wrote about the arrival of the modern data warehouse, per Microsoft Azure design concepts. In this I walked you through an introduction of what this really means, from a high level perspective. This included a walk down memory lane as it pertains to the birth and evolution of the concept we call data warehousing. [caption id="attachment_280" align="aligncenter" width="750"] Azure Modern Data Warehouse Architecture[/caption] With this you were able to then establish a great overview of what is coming with this new approach and paradigm in regards to design and architecture. Its always important to understand where you have been. In doing this, giving correct amount of priority to understanding the past, your able to better anticipate the future. You will then better understand where you are going, in relation to Microsoft's modern data warehouse architecture and design. (more…)

By brandon, ago
Datawarehouse

The arrival of the modern data warehouse – part i

One of the cornerstone technologies for enabling enterprise grade insights is the data warehouse. This has had many names adopted through the years, since the inception of the phrase itself by no other than Bill Inmon. (resource: Find out more on our resource page) Having coined said phrase back in the 1970's, with the goal in crafting a standard in which a companies data could be stored, accessed and used in order to provide a single source of truth in which describes and tell the story of said company. Thus the great data warehouse religious wars began that pitted two strong willed and minded camps. Those whom would embrace the original author of the concept itself found themselves flying and fighting for the Inmon camp. With this there was yet one more knight in which to battle until victory was claimed. If therefore you where not part of the Inmon camp then you found yourself digging in and amazed at the fact in which anyone would design for a company the construct that a data warehouse represents - no others than that of Ralph Kimball's approach to the design of the coveted single semantic layer. This, as time progressed onward, would then in turn be called an enterprise data warehouse. Inferring with its name the single and solely accepted version of a companies truth, and that Kimball on a tone of 7/8-1 would be used in designing a companies prized semantic layer.

(pictured above is an example of the Ralph Kimball data warehouse architecure)

(more…)

By Amy George, ago