Acadiana SQL - Meeting - March 2014

Our second meeting is upon us - we hope to see you there! Please make sure to invite your friends as well, the more the merrier.

Topic: Data Warehouse Indexes

Date: Tuesday, March 25, 2014

Location: Dupre Logistics

Speaker: Glenda Gable, LHC Group

Agenda:

  • 5:30 - 5:45 pm: Networking and Refreshments
  • 5:45 - 6:00 pm: Announcements
  • 6:00 - 7:00 pm: Main Presentation

Presentation Summary: A datawarehouse 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 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.

Address: 201 energy parkway STE 500 Lafayette, LA 70508


View Larger Map

Contact Us

You can contact us in any of the following ways:

Twitter: @acadianaSQL

Email: info@acadianasql.org

SQL