High performance Data Warehouse rule #7
tronghuy2807One of the most important choices in building your data warehouse is schema design. This choice sets the table for everything that follows. How much time is your staff going to spend…
High performance data warehousing rule #10
Deliver value. Yup, that's the summary, deliver value. Seems simple, right? Hardly. In many organizations, data teams fulfill requests for technical challenges and deliver them to "the business". That's it. That's all they…
High performance data warehouse Rule 11: Your workloads will drive your data design technique (modeling)
Yup, workloads drive modeling. Not the industry, not your platform, not your beliefs nor religions. There continues to be a lot of chatter about data design (schema modeling) lately as it's…
Database Optimization Techniques 👇
Each "Technique" optimizes database performance in distinct ways 𝟭. 𝗥𝗲𝗮𝗱 𝗥𝗲𝗽𝗹𝗶𝗰𝗮𝘀 𝗳𝗼𝗿 𝗥𝗲𝗽𝗼𝗿𝘁𝗶𝗻𝗴:- Used to offload read traffic from the main database instance- Beneficial for heavy read queries like reporting…
What is a staging area?
1. Introduction 2. What is a staging area 3. The advantages of having a staging area 5. Conclusion 6. Further reading 1. Introduction Working with data pipelines, you might have…