Digital transformation comes from gaining actionable insights on data. When trying to get business intelligence, and make actionable decisions that drive business value, SQL is still king.
Good Old SQL
SQL is declarative language which expresses the desired result of computation without describing the steps to achieve it (also abbreviated with “describe what, not how”). When the database gets a SQL query, it looks through the query and the affected tables and builds itself a query plan – set of imperative commands to execute. Reasonable assumption is that a query plan is, in most cases, better than our coding logic for fetching data, and it executes in an area that is closest to the one where data resides.
How Modern SQL Databases Come up with Algorithms that You Would Have Never Dreamed Of by Lukas Eder is an excellent explanation why using SQL:
SQL in non-relational sources:
- Amazon Athena is an interactive query service that makes it easy to analyze data directly in Amazon Simple Storage Service (Amazon S3) using standard SQL.
- The Apache Hive data warehouse software uses SQL for reading, writing, and managing large datasets residing in distributed storage stored in Hadoop’s HDFS and compatible file systems such as Amazon S3 filesystem and Alluxio.