Archive

Posts Tagged ‘SQL’

An overview of the Business Intelligence world

Business Intelligence (BI) is a field of computer-science the goal of which is to build decision support systems.

According to Wikipedia, BI involves the means, the tools and the methods used to collect, consolidate and produce the data model, and to finally display it. It is designed:

  • to help a company taking decisions;
  • to cover its whole activity for people in charge of the strategy.

Simply put, BI is the art of transforming raw data into valuable information.

This article begins with an introduction to BI, then describes the main actors of the BI market, and what their products are designed for.

Read more…

Recursion in SQL

We are used to easily writing recursive calls and loops in procedural languages, but this doesn’t hold true in SQL. Indeed, it depends on the DBMS used.

This article will focus on the ability to write recursive queries using Common Table Expressions (CTE). CTE are an addition from the SQL 1999 standard and are not yet available in all DBMS. As of today, CTE are at least compatible with:

  • Microsoft SQL Server 2000 / 2005 / 2008
  • IBM DB2
  • Oracle 9.2
  • PostgreSQL

Read more…

Categories: HowTo Tags: , , , , , ,
Follow

Get every new post delivered to your Inbox.