Chapter 6: Implementing Logical Data Structures

I hope you enjoyed learning about the implementation details of storage structures. In this chapter, we will be covering the implementation details of logical data structures. You will learn to implement advanced data loading concepts like slowly changing dimensions, storage based solutions for optimizing query performance and techniques to read external data without having to copy them over to local storage.

We will cover the following topics in this chapter:

• Building a temporal data solution
• Building a slowly changing dimension
• Building a logical folder structure
• Implementing file and folder structures for efficient querying and data pruning
• Building external tables