Within the specific field of action of the Tax Agency Open Sistemas develops a project of analysis, comparison and selection of OLAP engines based on a study of this institution casuistry, which is the low time of response in a data query from the users and a massive quantity of information looked up.
-
Identified Demand / Problem
- Identify an optimum solution of OLAP motor
- High requirements on capacity and space and limitation on database design
- Final response time under 1 second
-
Description
- High sizes for standard databases
- Lack of specific tools
-
How the problem was solved
- Consultory and analysis of problem at a business and technical level
- Identification and selection of tool
- Analysis of optimum data model and valuation Mondrian / SyBaseIQ
-
Business outcome
- Optimum tool selection
- Implantation process
