PRO+ Premium Content/Storage
Access your Pro+ Content below.
Lines blur between structured and unstructured data storage
This article is part of the Storage issue of November 2020, Vol. 18, No. 4
Once upon a time, organizations stored structured data in relational -- or sometimes NoSQL -- databases, and unstructured data in object storage systems like Amazon S3 or Google Cloud Storage. This distinction between structured and unstructured data storage has become less pronounced, however, and is having a significant impact on how organizations store, query and manage structured data. The reason for this shift is the advent of platforms like Presto. A free and open source query engine, Presto and its ilk enable the use of low-cost object stores to persist data while still making it accessible through structured data access tools like SQL. Let's consider a basic data warehouse populated with data from several online transaction processing systems, such as sales, inventory and fulfillment management systems. The basic data warehouse Data is extracted from these systems at regular intervals. It is then transformed and restructured for use in the data warehouse. The transformed data may be written directly to the data warehouse...
Features in this issue
-
Enterprise backup as a service explained
Enterprise BaaS is a software as a service that delivers backup and recovery services that connect systems to the cloud. Learn how BaaS works, pros and cons, and best practices.
-
The state of data center convergence: Past, present and future
Discover if CI, HCI, dHCI or composable technology is right for your environment and workloads, and how the converged data center continues to evolve.
News in this issue
-
Post-acquisition strategy and why storage mergers go bad
NetApp-SolidFire and HPE-SimpliVity cuts illustrate some of the pitfalls awaiting large vendors when they spend hundreds of millions and even billions of dollars on acquisitions.
-
Optimal architectures for intelligent storage systems
Explore the best, most optimal architectures for intelligent storage and how these systems improve storage performance/utilization to help get more bang out of your data set buck.
Columns in this issue
-
With release of vSphere 7, VMware takes NVMe-oF mainstream
VMware's support of NVMe-oF means organizations might be able to significantly improve the performance of their application environments without changing any data center hardware.
-
Lines blur between structured and unstructured data storage
Open source tools like Presto persist low-cost unstructured object data stores while still making information accessible through structured data access tools such as SQL.