sql
4 notes tagged sql in the Data topic. Data engineering: pipelines, warehouses, time series and storage choices.
- Database design circular
A comprehensive guide to understanding circular references in database design, including types, challenges, real-world applications, and solutions for managing them…
- SQL saragable queries and their impact on database performance
Structured Query Language (SQL) is widely used for managing data in relational database management systems (RDBMS). In the context of SQL, the optimization of database…
- Materialized view pattern
Materialized view is the cache of views. It pre-computes, stores, and optimizes data access when created, and automatically refreshes to ensure real-time data…