Presto: SQL over big data, NoSQL and relational DBMS
What about using SQL to retrieve data from NoSQL databases? Or to make joins between tables stored in relational databases[…]
Read more
Author: Database Tips
Using Sequences in database systems
A Sequence is a database object capable to generate numbers (i.e. it is a number generator). One of the main[…]
Read more
SQL Count(*), Count(cte), Count(column), Count(pk), … x Inner and Outer Joins
In SQL, The Count function counts the number of values in a set. Such function accepts a parameter, that specifies[…]
Read more
How to delete millions of rows from a table
To delete a great number of rows from a table may become a pain in the neck. A never ending[…]
Read more
SQL: 3 ways to find gaps and missing values
It is really common to have columns that stores sequences of numbers in database systems (specially in relational databases). Users[…]
Read more
SQL: from [Not] In to [Not] Exists in 3 steps
For many people, using noncorrelated subqueries (using In/Not In) seems to be more natural than using Exists/Not Exists and correlated[…]
Read more
Redo logs, archivelog mode and Connect internal only
When in production, you should run Oracle in Archivelog mode, multiplex redo log files and make regular backups of your[…]
Read more
SQL Inner and (Left/Right/Full) Outer Joins
Joins are one of the most common operators in SQL queries. In this post, we present inner and outer joins[…]
Read more
Autonomous Transactions
Transaction management is a key functionality of database management systems (DBMS). Its main properties include Atomicity, Consistency, Isolation and Durability[…]
Read more
Database Tuning and Buffer Cache Hit ratio
In this post, we continue our series on performance tuning. We present the concepts of logical reads and physical reads,[…]
Read more