\nText \/ Binary Formats \u2192 Custom Formats \u2192 Columnar Formats \u2192 In Memory Columnar & High Performance Formats<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n In the beginning, analysts stored most of the data in the Hadoop Distributed File System (HDFS) as text files or in binary formats like SequenceFile or RCFile. While some formats like text and JSON are readable to the bare eye, they consume a lot of storage space and are not performance friendly for large volumes of data.<\/span><\/p>\nSubsequently, engineers developed many open-source data serialization formats like Apache Avro and Google Protobuf to serialize structured data. They provide rich data structures and a compact, fast binary data. These formats continue to be used frequently for storing data.<\/span><\/p>\nThen engineers developed columnar formats like Apache ORC, Apache Parquet, Delta, and Apache Hudi that support better data compression and schema evolution handling. The columnar formats like ORC, Delta, and Hudi can also support ACID transactions to handle data updates and change streams.\u00a0<\/span><\/p>\nThe columnar data formats and storage systems are already the most used across enterprises. The trend for the future will be to use in-memory columnar formats like Apache Arrow or high-performance formats like Apache Iceberg or Apache CarbonData that provide efficient data compression and encoding schemes with enhanced performance to handle complex data in bulk. Internally, these formats still use ORC or Parquet to store the data making them compatible with the existing data stored.<\/span><\/p>\nData Storage Evolution<\/span><\/h3>\n\n\n\nHDFS \u2192 Hive \u2192 NoSQL \/ NewSQL \u2192 Cloud Data Warehouses + Blob Storage<\/b><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n HDFS was the initial distributed file-based storage system that allowed engineers to store large amounts of data on top of community hardware infrastructure. For example, engineers run the MapReduce programs on top of the files stored in HDFS.\u00a0<\/span><\/p>\nApache Hive and HBase frameworks followed this development, providing a table-like view of the underlying data and allowing developers to run SQL-like queries on the underlying data.\u00a0<\/span><\/p>\nSoon after, several NoSQL databases were developed with different characteristics like wide-column, key-value store, document store, graph database, etc., to support specific use cases. Some popular NoSQL databases include Apache Cassandra, MongoDB, Apache CouchDB, Neo4J, Memcached in open source and Amazon DynamoDB, Azure CosmosDB, and Google Cloud BigTable, among commercial versions.\u00a0<\/span><\/p>\nDuring this period, engineers introduced an integration of traditional RDBMS with NoSQL as NewSQL that seeks to provide the scalability of NoSQL systems for online transaction processing (OLTP) workloads while maintaining the ACID guarantees. Some NewSQL databases include Amazon Aurora, Google Cloud Spanner, CockroachDB, and Yugabyte DB, among others.\u00a0<\/span><\/p>\nMost of the cloud storage is HDFS-compliant, and together with the serverless nature of this storage, enterprises are increasingly using them as the blob storage systems. Therefore, the trend for the near future will be to use cloud blob storage like Amazon S3, Azure Blob Storage\/ ADLS, and Google Cloud Storage as the landing zone for ingesting data. The data will then be processed and aggregated data will be persisted in Cloud data warehouses such as Amazon Redshift, Azure Synapse SQL Data warehouse, Google Cloud BigQuery, Snowflake, or Databricks DeltaLake.\u00a0<\/span><\/p>\nEngineers will continue to use the NoSQL databases for specific data use cases as applicable.<\/span><\/p>\nThis concludes the second part of this blog series. We\u2019ll continue to explore the evolution of the data and analytics space in subsequent blog posts in this series in the coming months.\u00a0<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"Data analytics is a dynamic, rapidly shifting space. See how this evolution has impacted the way we develop applications and store data.<\/p>\n","protected":false},"author":26,"featured_media":69498,"parent":0,"menu_order":164,"template":"","insight":[41],"insight-subcats":[1924,1925],"insight-industry":[1783],"insight-services":[1916],"insight-partners":[],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.globallogic.com\/wp-json\/wp\/v2\/insightsection\/69496"}],"collection":[{"href":"https:\/\/www.globallogic.com\/wp-json\/wp\/v2\/insightsection"}],"about":[{"href":"https:\/\/www.globallogic.com\/wp-json\/wp\/v2\/types\/insightsection"}],"author":[{"embeddable":true,"href":"https:\/\/www.globallogic.com\/wp-json\/wp\/v2\/users\/26"}],"version-history":[{"count":1,"href":"https:\/\/www.globallogic.com\/wp-json\/wp\/v2\/insightsection\/69496\/revisions"}],"predecessor-version":[{"id":111326,"href":"https:\/\/www.globallogic.com\/wp-json\/wp\/v2\/insightsection\/69496\/revisions\/111326"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.globallogic.com\/wp-json\/wp\/v2\/media\/69498"}],"wp:attachment":[{"href":"https:\/\/www.globallogic.com\/wp-json\/wp\/v2\/media?parent=69496"}],"wp:term":[{"taxonomy":"insight","embeddable":true,"href":"https:\/\/www.globallogic.com\/wp-json\/wp\/v2\/insight?post=69496"},{"taxonomy":"insight-subcats","embeddable":true,"href":"https:\/\/www.globallogic.com\/wp-json\/wp\/v2\/insight-subcats?post=69496"},{"taxonomy":"insight-industry","embeddable":true,"href":"https:\/\/www.globallogic.com\/wp-json\/wp\/v2\/insight-industry?post=69496"},{"taxonomy":"insight-services","embeddable":true,"href":"https:\/\/www.globallogic.com\/wp-json\/wp\/v2\/insight-services?post=69496"},{"taxonomy":"insight-partners","embeddable":true,"href":"https:\/\/www.globallogic.com\/wp-json\/wp\/v2\/insight-partners?post=69496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} | |