THOUGHT FOR THE DAY

Progress

“Without a struggle,there can be no progress.”- Frederick Douglass

TOPIC OF THE DAY

Online analytical processing

Online analytical processing, or OLAP, is an approach to swiftly answer multi-dimensional analytical queries.[1] OLAP is part of the broader category of business intelligence, which also encompasses relational reporting and data mining.[2] The typical applications of OLAP are in business reporting for sales, marketing, management reporting, business process management (BPM)[3], budgeting and forecasting, financial reporting and similar areas, with new applications coming up, such as agriculture [4]. The term OLAP was created as a slight modification of the traditional database term OLTP (Online Transaction Processing).[5]

Databases configured for OLAP use a multidimensional data model, allowing for complex analytical and ad-hoc queries with a rapid execution time. They borrow aspects of navigational databases and hierarchical databases that are faster than relational databases.[6]

The output of an OLAP query is typically displayed in a matrix (or pivot) format. The dimensions form the rows and columns of the matrix; the measures form the values.

Read on...

LATEST ARRIVALS

The Checklist Manifesto - Atul Gawande