Navigate your options for public cloud database services
Your choice of a cloud database, data warehouse or data lake depends on the structure of your data and your analysis needs. Follow these guidelines to know which to choose.
With all the cloud database services available, it can be difficult to know which to choose. First, it's important to understand the differences between specific services, such as data warehouses and data lakes, and whether they work best for structured or unstructured data sets.
Data warehouses and databases store structured data, while a data lake is specifically designed for unstructured data. Data in structured systems is organized according to a schema, known as a schema-on-write process, while unstructured data is stored raw and only subject to a schema structure when read for analysis , a process known as schema-on-read. This means that structured stores only handle data that fits the defined schemas, while an unstructured store handles other data types.