|
OLAP vendors hope to
have their OLAP solution running on OLTP architecture. Why? Simply
because OLAP currently requires separate data modeling and has
limitation to support Real Time OLAP, as data is updated in OLTP
and the time gap between the data updated to OLAP cannot be avoided.
The OLAP data modeling often takes 60 - 70% of the entire Data
Warehouse and BI project. Changes in OLTP design sometimes cause
redesign of the OLAP data model, which is extremely time consuming.
The maintenance effort of OLAP is heavy, and high skill set is
required to be built up within the organization.
Speedminer is the first DW/BI solution
that runs directly on OLTP, Speedminer is not exactly an OLAP
product, however, it provides all functionalities of OLAP and
much more. Best of all, it takes much lesser time to implement,
and maintain.
|
|
DOSM is probably the
organization that performs most analysis in the nation. DOSM stores
most data in the country that includes Trade, Economics, Finance,
Population, Agriculture and many other Censuses. In order to convert
the raw data to the final analysis requested by many government
agencies, reporting and analysis becomes the key task in DOSM.
With the constantly changing reporting requirements, needs of
drill down to identify trends and patterns, alert on exceptional
data and complex cleansing of raw data within a limited time for
the various agencies that require these final reports and analysis,
caused DOSM to look into OLAP and Business Intelligence for solution
of their requirements and needs mentioned.
DOSM has tried out various OLAP tools, but as
the IT Director, Madam Roszaini Omar has mentioned "the other
OLAP solutions require more than 40 days in redesigning and rebuilding
whenever we have new requirement, if we do not go through this
lengthy change, the query will run extremely slow".
A user of the OLAP once mentioned "They
claimed that they have an Ad-Hoc query tool, but whatever we want
to query, we must pre-aggregate first for decent performance,
how can we consider that as Ad-Hoc?"
DOSM iniatiated Speedminer DW & BPM in August
2005 in Trade Department. The project was very successful, and
the Agriculture Census by the Small Medium Enterprise etc.
With Speedminer's intuitive reporting capabailities,
reports to government agencies are now delivered earlier than
before. As Speedminer is a total web based solution with zero
foot print, DOSM has allowed many government agencies such as
Central Provisional Bank, Inland Revenue Authority, Employee Provisional
Fund and others to directly access Speedminer DW & BPM reports
and analysis via Web browser.
DOSM used to backup historical data in
the tape, but with Speedminer DW & BPM, they are all made
available online. Through the powerful ETL and cleansing module,
Speedminer DW & BPM helps DOSM to track invalid patterns in
information quickly based on historical data and the business
rule entered. For example, inconsistencies in the patterns that
point to fraud error and manipulation can be detected easily for
further actions. Many forwarders who intentionally enter wrong
information to get tax advantage are discovered using Speedminer.
|
