Why No SQL will never kill SQL Denis

Why No. SQL will never kill SQL Denis Reznik

About Me • • Denis Reznik Kyiv, Ukraine Data Architect at Intapp Microsoft Data Platform MVP Co-Founder of Ukrainian Data Community Kyiv (PASS Chapter) PASS Regional Mentor, Central and Eastern Europe Co-author of “SQL Server MVP Deep Dives vol. 2”

SQL and No. SQL History

RDBMS Ingress System R CODASYL IMS 1960 s SQL 1970 s E. F. Codd’s Paper 1980 s RDMS Commercial Success 1990 s 2000 s 2011 2012 2019 Nowadays

Relational Model Users Key Tuple (Row) Id Name 1 John Smith 3 Microsoft 01/10/2005 SE, Pike st. 5 2 James Woods 3 Microsoft 23/05/2010 SE, Pike st. 5 Companies Attribute (Column) Id Name Company. Id Company Registered. On Relation Address (Table) 1 Intapp Kyiv, Klovsky desc. 7 a 2 Oracle MI, Ocean dr. 13 3 Microsoft SE, Pike st. 5 CAddress Normalization 1 NF 2 NF 3 NF 4 NF 5 NF

Result Set SQL SELECT * FROM Users ORDER BY Name Id Name Opened. On 2 Jack S. 12 -07 -2015 1 John D. 01 -02 -2015 1 James R. 01 -02 -2015 2 Jack S. 12 -07 -2015 4 John D. NULL 3 Peter P. 03 -01 -2016 4 James R. NULL Sessions SELECT u. Name AS Speaker, s. Title AS Session FROM Sessions s INNER JOIN Users u ON s. User_Id = u. Id WHERE s. Id = 5 Users Id User_Id Title Created. On 1 5 Big Data 07/03/2014 2 256 No. SQL 09/09/2015 5 2 SQL 12/08/2015 Id Name Phone 1 Bill +380678455732 Speaker Session 2 John NULL John SQL 3 Mike +380501233427

Mongo. DB Cassandra Neo 4 j Redis Elastic. Search RDBMS Ingress System R CODASYL IMS 1960 s Object Databases Google Big. Table Paper SQL 1970 s E. F. Codd’s Paper Amazon Dynamo Paper 1980 s RDMS Commercial Success 1990 s 2000 s 2011 #nosql (Johan Oskarsson) 2012 2019 Nowadays

Agenda • • SQL history No. SQL history Current trends How No. SQL developer see SQL How SQL developer see No. SQL The world without SQL Why No. SQL will never kill SQL

No. SQL Characteristics due to Martin Fowler • Non-Relational • Open-Source • Cluster-Friendly • 21 st Century Web • Schema-Less Source: https: //www. youtube. com/watch? v=q. I_g 07 C_Q 5 I

Schema-Less

RDBMS Ingress System R CODASYL IMS 1960 s Object Databases E. F. Codd’s Paper Mongo. DB 4. 0 (ACID Transactions) Google Big. Table Paper SQL 1970 s Mongo. DB Cassandra Neo 4 j Redis Elastic. Search Amazon Dynamo Paper Mongo. DB enable journaling by default 1980 s RDMS Commercial Success 1990 s 2000 s 2011 2012 #nosql (Johan Oskarsson) Martin Fowler said that No. SQL will not kill SQL 2019 (? ) Nowadays

No. SQL Databases

No. SQL Databases • Key-Value • Redis • Column-Family • Cassandra • Graph • Neo 4 j • Time Series • Influx • Search • Elastic Search • Document • Mongo. DB

No. SQL

Cost and Open-Source

Relational Databases • SQL Server • Standard ~ $3717 per core • Enterprise - $14256 per core • Oracle Database • Standard - $17500 • Enterprise - $47500 • My. SQL (annual subscription) • Standard - $2000 (1 -4 sockets) - $4000 (5+ sockets) • Enterprise - $5000 (1 -4 sockets) - $10000 (5+ sockets) • Postgre. SQL • Free for commercial use • Enterprise. DB (? ) - ?

No. SQL Databases • Redis • Enterprise Edition • Cassandra • Data. Stax Enterprise Cassandra • Neo 4 j • Enterprise Edition • Influx • Enterprise Edition • Elastic Search • Elastic Cloud Enterprise • Mongo. DB • Enterprise Edition

Cloud and Cost

Hype

Black PR

Legacy

CPU – Cooperative Multitasking Queries CPUs 0 1 2 Time Quantum Length for each Scheduler is 4 ms 3

Select Data Buffer Pool Access Methods Buffer Manager Data Cache Database File

Modify Data Access Methods Buffer Manager Buffer Pool Data Cache Background Processes Log Manager Log Buffer Transaction Log Database File ?

1 PAGEIOLATCH_* Waits A. . C 1 A. . Z Non-Clustered Index (Name) C. . Q X. . Z … Schedulers Runnable Queue SELECT * FROM Users WHERE Name LIKE 'P%' 1 0 PAGEIOLATCH_SH Suspended Queue 1 1 PAGEIOLATCH_SH Buffer Pool 1 2 ? 3 Database File

CX_PACKET 2 s 1 s CXPACKET Wait Thread 0 CXPACKET Wait Thread 1 CXPACKET Wait Thread 2 Thread 3 CXPACKET Wait Thread 4

The Main Argument

Thank You! Denis Reznik Twitter: @denisreznik Email: denisreznik@gmail. com Blog: http: //reznik. uneta. com. ua Facebook: https: //www. facebook. com/denis. reznik. 5 Linked. In: http: //ua. linkedin. com/pub/denis-reznik/3/502/234