LATEST INTELLIGENCE
SINGLESTORE : SIMPLIFYING DATA ARCHITECTURES WITH A UNIFIED DATABASE
iIntroduction
General-Purpose Databases – Most organizations work with databases that can be classified as generalpurpose databases . These products can support many different types of use cases , such as transactional data-entry applications , data warehouses , websites , and portals . To accomplish this , database administrators optimize them for that specific use case . For example , they are optimized to process many complex queries or process a large transactional workload . But they cannot be optimized to support multiple use cases concurrently .
Therefore , many data architectures , such as the classic data warehouse architecture , consist of several databases , each designed to support a different use case . Evidently , this leads to complex data architectures . A popular example is that one database is developed to support the transactional workload and another to support the reporting and analytical workload , and data is periodically copied from one to the other . Both databases can be developed with the same database product , but are optimized differently .
Drawbacks of Copying Data – In numerous environments that deploy general-purpose databases , data is copied between databases . Copying data has the following drawbacks :
• Copying data increases the data latency experienced by data consumers
• Extracting data from a transactional database can interfere with the transactional workload
• Duplicating data complicates complying with data privacy regulations such as GDPR
• Data stored in copied databases must also be secured as in the original databases , complicating data security
• Processes that copy data can fail resulting in incorrect data and a degraded data quality level p
PRESENTED BY
www . intelligentcio . com INTELLIGENTCIO NORTH AMERICA 19