database Archives

[Modern Data Warehouse] Serverless databases – what are they and when should you use them?

Key points: Provisioned capacity for PaaS database – does it always meet current trends in programming? What is a serverless database and how does it differ from the database with provisioned capacity? What are the pros and cons of serverless databases? Scenarios for using serverless databases Cloud databases have been available in the market already for some time and it […]

5 main differences between ETL and ELT

Do ETL and ELT sound familiar to you? The below article is dedicated to the topic of differences between them. ETL (Extract-Transform-Load) and ELT (Extract-Load-Transform) are two approaches to the data transfer process to: data warehouses (storing data from multiple sources, already processed and prepared for analysis or reporting) data repositories (Data Lake, used to […]

Analytics data data sources data warehouse database ELT ETL