© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2021
D. SarkaAdvanced Analytics with Transact-SQLhttps://doi.org/10.1007/978-1-4842-7173-5_5

5. Time-Oriented Data

Dejan Sarka1  
(1)
Ljubjana, Slovenia
 

Understanding what kind of temporal data can appear in a database is very important. Some queries that deal with temporal data are hard to optimize. Data preparation of time series data has many of its own rules.

Queries that deal with time-oriented data are frequent in analytical systems. Besides a simple comparison of data in different periods, much more complex problems and analyses can arise. This chapter and the next chapter deal with time-oriented data. In this chapter, you learn about the following.
  • Application ...

Get Advanced Analytics with Transact-SQL: Exploring Hidden Patterns and Rules in Your Data now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.