Lectures related to Storage Technologies Overview

Data Wrangling with Hadoop

Covers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.

Optimizing Recursive Queries

Explores optimizing recursive queries in database systems using Datalog and semirings, discussing the challenges and solutions in data analytics.

Cost-based Query Optimization

Explores cost-based query optimization in database systems, covering cost estimation, selectivity estimation, and join cardinality.

Compilation: Code Generation and Performance Optimization

Explores code generation, performance optimization, and compilation trade-offs in DBMS.

Storage and Data Transmission: Accessing Information

Covers the importance of metadata for accessing information and structuring data for storage and transmission.

Persistent Storage: Understanding Magnetic Disks and Their Performance

Covers persistence in computer science, focusing on magnetic disks and their performance characteristics, including seek time, rotational latency, and disk scheduling algorithms.

Relational Algebra and SQL: Foundations of Database Management

Introduces the relational model and relational algebra, focusing on SQL and its operations for effective database management.

Query Operators: Joins and Query Processing Techniques

Discusses advanced query operators, focusing on join techniques and their processing methods in relational databases.

Database Management Systems: Fundamentals

Introduces the fundamentals of database management systems, covering relational model, storage options, data integrity, queries, and data manipulation languages.

Memory Hierarchies: Introduction and Technological Constraints

Introduces memory storage technologies, hierarchies, and their impact on performance.

System-R Optimizer: Query Optimization and Cost Estimation

Explores the System-R Optimizer, query optimization, cost estimation, join orderings, and cardinality challenges in database systems.

Digitisation Processes

Delves into the challenges and processes of document digitisation, including the Google Books project, copyright issues, and the optimization of source selection.

Smart Borders: General Issues and Concepts

Explores the definition, goals, and implications of smart borders, including data privacy concerns and the impact on migrants' rights.

Views: SQL Queries Simplification

Explores how views simplify query writing and are key in data warehouses.

Relational Model: Basics

Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.

Optimization Heuristics: Example of INGRES Database System

Explores heuristic-based optimization using the INGRES database system example.

Query Optimization: Heuristics and Cost-Based Approach

Explores query optimization principles, challenges in cardinality estimation, and the impact of errors on plan selection.

Devices and Disk Management

Explores the interaction between operating systems and devices, covering device drivers, IO basics, hardware structure, buses, disk performance, and RAID levels.

Big Data Best Practices and Guidelines

Covers best practices and guidelines for big data, including data lakes, architecture, challenges, and technologies like Hadoop and Hive.

Query Fusion, Nested Queries MOOC: Geographical Information Systems 1

Covers query fusion, nested queries, and SQL operators in a geographical context.

Storage Technologies Overview

Chat with Graph Search