What Kind of OLAP Do We Really Need?
The narrow-sensed OLAP OLAP is part and parcel of a BI application. As the name suggests, the word is an acronym for online analytical processing.… Read More »What Kind of OLAP Do We Really Need?
Home
HANLijun
Relational Algebra Is the Root of SQL Problems
There is no doubt that SQL is the most widely-used working language for processing structured data. Not only is the language adopted by all relational… Read More »Relational Algebra Is the Root of SQL Problems
SQL: A Supposed English-like Language
SQL is envisioned as an English-like language. Simple SQL statements read like English sentences. SQL writes a statement in an English way with English prepositions… Read More »SQL: A Supposed English-like Language
What You Possibly Don’t Know About Columnar Storage
Columnar storage is a familiar data storage technique that is used by many data warehousing products because of its high effectiveness in many computing scenarios.… Read More »What You Possibly Don’t Know About Columnar Storage
Closed Computational System Leads to Bloated Databases
Not a few big organizations find their databases (or data warehouses) crammed with a huge number of old data tables, sometimes tens of thousands of… Read More »Closed Computational System Leads to Bloated Databases
An Open Computational System Brings Slim Databases
As stated in the last article, database obesity due to numerous intermediate tables and stored procedures is rooted in the closed computational system. If there… Read More »An Open Computational System Brings Slim Databases
A View on the Difficulty of Stored Procedure Migration
The difficulty to migrate a stored procedure to other databases is always a subject of criticism. This is seldom forgotten every time when the shortcomings… Read More »A View on the Difficulty of Stored Procedure Migration
Stored Procedures: A Seemingly Nice Tool with Hidden Problems
The stored procedure is as widely used in database computing as the controversy around the technique is long-standing. By analyzing its two recognized merits, we… Read More »Stored Procedures: A Seemingly Nice Tool with Hidden Problems
Invest More beyond Tools to Improve Reporting Performance
As a type of front-end data service intended for end-users, reports in applications have received a lot of concerns about their performances. It’s all users’… Read More »Invest More beyond Tools to Improve Reporting Performance
Overpromising and Underperforming: Understanding and Evaluating Self-service BI Tools
From the OLAP concept in earlier years to the agile BI over the last few years, BI vendors never stop advertising the self-service capability, claiming… Read More »Overpromising and Underperforming: Understanding and Evaluating Self-service BI Tools