Oracle Retail Data Model

Using Oracle Retail Data Model RDTECH created the solution "Analytical System of the Trading Company" and tested it in Kopeyka Trading House.

Oracle Retail Data Model (data model of the company of retail) is based on world industrial experience that allows to consider industry specifics and to use the best practices of business of retail chain stores. Except model of the data warehouse Oracle Retail Data Model includes four ready OLAP cubes, means of data analysis in the form of a set of the preconfigured forms of BI reports and ten Oracle Data mining models which are the powerful tool for creation of forecasts and detection of the hidden patterns in data bulks. Use of a ready data model allows to minimize a design stage of a system and at once to pass to setup of model under business requirements of the Customer.

During the project in TD "Kopek" the following delivered before developers RDTECH, the purposes was reached:

• increase in level of knowledge of business users for acceptance of reasoned decisions;
• increase in efficiency of operational management due to acceleration of formation of the analytical reporting and increase in its quality;
• solution of the problem of data inconsistency in the different systems;
• decrease in technological and personnel hazards at operation and development of Information systems;

unloading of a transaction ERP system.

In addition to the achieved goals, it is possible to refer approbation of model to project deliverables: degree of compliance of Oracle Retail Data Model to real tasks of retail chain stores Kopek made 85%. In the mode of real loading the solution showed the high performance and applicability. The conclusion was drawn that in total with other products of Oracle the model is a key component for creation of the corporate data warehouse.