1 option
SN Video Coding and Web Development. Performance Optimization for OLAP Workloads in SQL Server / Springer.
- Format:
- Video
- Series:
- Academic Video Online
- Language:
- English
- Subjects (All):
- SQL server.
- Database management.
- Querying (Computer science).
- OLAP technology.
- Multidimensional databases.
- Genre:
- Instructional films.
- Physical Description:
- 1 online resource (63 minutes)
- Place of Publication:
- London, England : Springer Nature, 2021.
- Language Note:
- In English.
- System Details:
- video file
- Summary:
- This video helps you to design databases and processes that can manage millions or billions (or more) rows of data for analytics and reporting. Analytic workloads follow different architectural and query patterns than standard transactional systems, and the associated data stores grow differently over time as compared to online transaction-processing systems. This video covers the purpose, usage, and effects of growth on analytic data stores with a focus on storing the data directly in SQL Server. Topics covered in this video include design issues such as compression and advanced indexing techniques for online analytical processing (OLAP) data. Also covered are performance optimization and efficient query patterns. Watching this video helps you learn to better retrieve data with the ultimate goal of answering organizational questions using your analytics data store.
- Notes:
- Title from resource description page (viewed April 16, 2021).
- OCLC:
- 1251432825
- Publisher Number:
- ASP5115450/marc
The Penn Libraries is committed to describing library materials using current, accurate, and responsible language. If you discover outdated or inaccurate language, please fill out this feedback form to report it and suggest alternative language.