May 6, 2014
Presentation 12:00 CST
Glenda Gable: What the point of a Data Warehouse?
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.
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
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 firstname.lastname@example.org or twitter is @DArchVC