Does Altibase support Business Intelligence (BI) solutions?

Yes. Altibase can be used for Data Marts in BI solutions for analytical purposes. Altibase is not ideal for data warehouses because the size of data warehouses often exceed the maximum possible storage capacity of RAM today.

Altibase has competed with other in-memory databases. Following case studies include related stories.

BI Solution

Altibase can store and process fact and dimension tables of Data Marts in real time so that  users can query critical business information when they need it.[i]

2_Does Altibase support business intelligence (BI) solutions-01

Altibase OLAP Functions

Category

Function

Description

Aggregation

AVG

Average value of the group

COUNT

Count of the group

MAX

Maximum value of the group

MIN

Minimum value of the group

STDDEV

Standard deviation of the group

SUM

Sum of the group

VARIANCE

Variance of the group

Ranking

RANK

Ranking of the group

DENSE_RANK

Ranking of the result set according to group

ROW_NUMBER

Unique serial number according to query result set

Windows

FIRST_VALUE

The value of the first row

LAST_VALUE

The value of the last row

NTH_VALUE

The value of the offset row

FIRST_VALUE_IGNORE_NULLS

Non-null value, the value of the first row

LAST_VALUE_IGNORE_NULLS

Non-null value, the value of the last row

NTH_VALUE_IGNORE_NULLS

Non-null value, the value of the offset row

Grouping Set

ROLLUP

Extended group by function

CUBE

Multi dimensional analytics function

 


[i] A fact table is the central table in a star schema of a Data Mart and a dimension table is a collection of reference information about a measurable event.

Comments are closed.