Data Management: Efficient Storage and Indexing

Related lectures (32)

Introduces the Entity-Relationship model for designing databases with a focus on conceptual and relational aspects.

Explores learning models over relational databases, emphasizing prediction quality and the importance of structure-aware learning.

Explores the importance of metadata in organizing media libraries and the challenges in retrieving specific works or artists efficiently.

Covers the modeling of hydrological systems, focusing on the retention of floods and the example of the Routing System.

Covers the architecture of a typical DBMS and SQL interfaces like SQL Developer and DataGrip.

Covers database management systems principles, design, implementation, and storage options like flat CSV files.

Concludes the exploration of relational databases and introduces database management systems.

Covers relational databases and database management systems basics for upcoming lessons.

Covers query processing with relational operations, including query optimization and different join algorithms.

Explores file organization, indexing methods, and database storage design, including record formats, page formats, and index classification.

Covers Spark Data Frames, distributed collections of data organized into named columns, and the benefits of using them over RDDs.

Page 2 of 2