Beginner's guide into
➤ SQL
➤ SPL
➤ NoSQL
And, how to choose the best one:
➤ SQL
➤ SPL
➤ NoSQL
And, how to choose the best one:
➊ What is SQL?
SQL is a query language for structured data. Here's a complete guide:
SQL is a query language for structured data. Here's a complete guide:
➋ What is NoSQL?
⬘ NoSQL stands for "Not Only SQL."
⬙ NoSQL is not a database language but, in fact, an umbrella term used for databases that allow unstructured and semi-structured data.
⬘ NoSQL stands for "Not Only SQL."
⬙ NoSQL is not a database language but, in fact, an umbrella term used for databases that allow unstructured and semi-structured data.
➌ What is SPL?
⬘ SPL stands for "Structured Process Language."
⬙ SPL is a database language for structured data. But instead of using relational algebra (which SQL uses) to solve the problems, it uses "discrete datasets."
Read more about it:
swapnakpanda.hashnode.dev
⬘ SPL stands for "Structured Process Language."
⬙ SPL is a database language for structured data. But instead of using relational algebra (which SQL uses) to solve the problems, it uses "discrete datasets."
Read more about it:
swapnakpanda.hashnode.dev
➍ Is SQL the right fit all the time?
Unarguably, structured data is easy to store, read, and process. But are they always efficient?
⬘ It's not guaranteed that data will always remain structured.
⬙ At times, data volume may grow substantially.
Unarguably, structured data is easy to store, read, and process. But are they always efficient?
⬘ It's not guaranteed that data will always remain structured.
⬙ At times, data volume may grow substantially.
⬘ SQL relies on relational algebra, which has been around for fifty years.
⬙ Continuing to apply the theory of that time to solve today's problems (with much bigger datasets) is sometimes tedious and inefficient.
⬙ Continuing to apply the theory of that time to solve today's problems (with much bigger datasets) is sometimes tedious and inefficient.
➎ NoSQL v/s SPL
We have 2 approaches:
➤ Change how data is stored (NoSQL)
Different database.
Different processing language.
➤ Change how data is processed (SPL)
Same database as SQL.
Different processing language.
We have 2 approaches:
➤ Change how data is stored (NoSQL)
Different database.
Different processing language.
➤ Change how data is processed (SPL)
Same database as SQL.
Different processing language.
➏ What is esProc SPL?
⬘ @esProc_SPL is an open-source programming language for data processing that performs computing independently.
⬙ It mainly operates on data stores like relational databases, MongoDB, or files like CSV, Excel, TXT.
Find it here: github.com
⬘ @esProc_SPL is an open-source programming language for data processing that performs computing independently.
⬙ It mainly operates on data stores like relational databases, MongoDB, or files like CSV, Excel, TXT.
Find it here: github.com
That's a wrap.
If you enjoyed reading this thread:
1. Follow me @swapnakpanda for more career-related guides, programming (Python, JavaScript), and database (SQL, NoSQL) content.
2. Like & RT the topmost tweet of this thread to share it with your audience.
If you enjoyed reading this thread:
1. Follow me @swapnakpanda for more career-related guides, programming (Python, JavaScript), and database (SQL, NoSQL) content.
2. Like & RT the topmost tweet of this thread to share it with your audience.
جاري تحميل الاقتراحات...