The PASS Data Architecture Virtual Chapter focuses on data architecture concerns as they impact users, developers and DBAs on the Microsoft SQL Server platform.

 


May 6, 2014 Presentation 12:00 CST

 

Glenda Gable: What the point of a Data Warehouse?

Presentation Summary:





A data warehouse environment is used differently than a transactional environment, so architecture and indexing strategies should also be different. In this presentation, we review what the ultimate goal of an index really is, what the point of a data warehouse is, and how they relate to each other. You will also learn common practices for indexing the different types of warehouse tables, specifically dimension tables, fact tables, and staging tables. We will review cases when it is useful to have summary level fact tables, in addition to detail level fact tables. Then, lastly, we will look at the benefits, and gotchas, of using columnstore indexes.







Speaker Bio:



 

Glenda Gable has worked with databases in some form or another for 13 years, and loves working with data. She has worked in the healthcare, state park, construction licensing, and not-for-profit industries. She currently works for LHC Group in Lafayette, LA in the Business Intelligence department, handling the servers and software maintenance to report development and all the ETL transactions in between. Her main focus is on planning and optimizing the full ETL process, and learning more about database administration. Glenda is becoming more involved in the SQL community, she is co-founder of the Acadiana SQL User Group in Lafayette and speaks at local events.







Gotowebinar

 

https://attendee.gotowebinar.com/register/8508402863945182210

 

 

Data Architecture underpins just about everything we do in IT. Without a clear understanding of how data is structured, there is no reliable way to derive meaning from it. Data Architecture drives the design and governance of data systems, and thus should be of interest to any data professional. Data Architecture provides the blue-prints that we all share, whether we be DBAs, data integration developers, database developers, data warehousing professionals, data presentation developers or client-side application developers persisting data for later retrieval.

The PASS Data Architecture Virtual Chapter will focus on data architecture concerns as they impact users, developers and DBAs on the Microsoft SQL Server platform. We want to make data architecture accessible to all data practitioners, and drive the point home that Data Architecture is a set of practices and a body of knowledge that overlaps almost all database professionals to some degree.

Email us at davc@sqlpass.org or twitter is @DArchVC