Database Reference
In-Depth Information
10
Creating and
Managing SQL Scripts
In This Chapter
Design concepts
●
Working with SQL scripts
●
Indexing and performance considerations
●
SQL solutions to common analytics problems
●
Analytics systems must procure data from various sources, often in formats that are not necessarily
suited for analytics. These data feeds have to be integrated and manipulated to make the output suit-
able for analytics consumption. In this chapter we go over key concepts and tools to guide you in
building an analytics system that is scalable and maintainable.
Design Concepts
Building a successful analytics system requires careful design that stems from experience and lessons
learned from prior mistakes. Luckily the industry has now a couple of decades of experience in build-
ing these systems. This had led to established best practices to help you avoid the mistakes of the
past. In this section we summarize these best practices and give you a foundation to start off on the
right foot.
The concepts in this section become important as your system complexity and data vol-
umes grow. When you start your design, you have to assess the scope of your system
and decide the level of design sophistication that is necessary to meet your needs.
Note
195
Search WWH ::
Custom Search