Judy Liu

The Difficulty of SQL Stems From Relational Algebra

This article explores how the fundamental difficulty of SQL actually stems from its theoretical foundation, namely relational algebra.

March 27, 2024

· 499 Views · 2 Likes

Actually, You Will Never Be Able to Master Python

To assist with daily work, programming languages need to have strong structured data processing capabilities. Learn which options are best.

March 11, 2024

· 1,184 Views · 1 Like

How Slow Is Database I/O?

Perform a field test to find out the performances of retrieving data from Oracle and MySQL and compare them with the performance of retrieving data from the text file.

February 21, 2024

· 1,773 Views · 1 Like

What You Possibly Don’t Know About Columnar Storage

Columnar storage is a commonly used storage technique. Often, it implies high performance and has become a standard configuration for today’s analytical databases.

February 1, 2024

· 2,855 Views · 4 Likes

How Much Is One Terabyte of Data?

Assuming each record takes up 100 bytes or 0.1 KB, one terabyte of storage can hold up to ten billion records.

January 24, 2024

· 1,419 Views · 2 Likes

Simple SQL Statements Only Exist in Coursebooks and Training Courses

Except for the simplest scenarios, the degree of SQL code complexity increases sharply, even if the task complexity only rises slightly.

January 17, 2024

· 2,579 Views · 3 Likes

SQL Looks Like English Is a Well-Intentioned Error

SQL is a language with very strict syntax, and any non-compliant part of a statement will be rejected by the database. Learn more about its advantages here.

December 29, 2023

· 3,410 Views · 2 Likes

Is SQL a Declarative Language?

When faced with complex tasks, the difficulty increases sharply, and some tasks cannot be implemented using SQL alone because it is not Turing-complete.

December 19, 2023

· 1,816 Views · 2 Likes

Reputation:	229
Pageviews:	15.5K
Articles:	8
Comments:	0

Articles