JudyMore foreign-key joins (JOIN Simplification and Acceleration Series 7)Let’s continue our discussion of foreign-key-based JOINs using the example in the previous article.Jul 12Jul 12
JudyForeign-key pre-join(JOIN Simplification and Acceleration Series 6)Let’s move on to look at how to increase JOIN query performance by making use of certain features of JOINs. As this involves lots of…Jun 17Jun 17
JudyFinal association query solution (JOIN Simplification and Acceleration Series 5)By rethinking and redefining the equi-joins, we are able to simplify the join syntax. A direct and obvious effect is that queries become…May 27May 27
JudyDimension alignment (JOIN Simplification and Acceleration Series 4)In the previous essay, we talked about the alignment of two sub tables to the primary table. Below is the SQL query for doing it:May 21May 21
JudySimplifying JOIN syntax (JOIN Simplification and Acceleration Series 3)As all joins involve the primary key, we can devise ways of simplifying JOIN code according to this characteristic. There are three join…May 13May 13
JudyTypes of equi-joins (JOIN Simplification and Acceleration Series 2)Let’s look at three types of equi-joins:May 8May 8
JudyJOINs in SQL(JOIN Simplification and Acceleration Series 1)JOINs are long-standing SQL headaches. As the number of tables to be joined increases, coding becomes error prone. The complicated…Apr 22Apr 22
JudyWhat is the difference between BI and AI?There is an I in both BI and AI, and the corresponding English word is “Intelligence”, which appears to have the same meaning.Apr 15Apr 15
JudyWhat You Possibly Don’t Know About Columnar StorageThe columnar storage is a commonly used storage technique. Often it implies high performance, and has basically become a standard…Apr 7Apr 7
JudyThe difficulty of SQL stems from relational algebraIn the field of structured data computing, SQL is still the most widely used working language, not only adopted by all relational…Mar 15Mar 15