Does Altibase support Business Intelligence (BI) solutions?

Post by: Altibase

Date: 2021-03-10

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 exceeds the maximum possible storage capacity of RAM today.

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

Yield Management System – Samsung Electronics : TIBCO Spotfire is integrated with Altibase as a business intelligence tool for this task.
Business Intelligence System – Dongwon F&B : Collect and analyze data from the ERP system.

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
Grouping Set	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.

List

메인으로