SQL – the cornerstone of enterprise IT

Businesspeople Running Towards Finish Line — Image by © Royalty-Free/Corbis

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.
Oglasi
Ovaj unos je objavljen u Nekategorizirano. Bookmarkirajte stalnu vezu.

Komentiraj

Popunite niže tražene podatke ili kliknite na neku od ikona za prijavu:

WordPress.com Logo

Ovaj komentar pišete koristeći vaš WordPress.com račun. Odjava /  Izmijeni )

Google photo

Ovaj komentar pišete koristeći vaš Google račun. Odjava /  Izmijeni )

Twitter picture

Ovaj komentar pišete koristeći vaš Twitter račun. Odjava /  Izmijeni )

Facebook slika

Ovaj komentar pišete koristeći vaš Facebook račun. Odjava /  Izmijeni )

Spajanje na %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.