Using Databases in Decisions Systems for Businesses

摘要

The paper presents the usage of databases that store business data into a warehouse star model that permits to create queries using SQL language and business intelligence tools. This kind of model allow to the decision maker to create complex reports and graphs based on the columns from the dimension tables and measures from fact tables, that can be the base for creating alternatives and scenarious acording to the economical indicators. Building alternatives and scenarious is an elaborate task and must have a background in existing data structured in databases that have a special structure of dimensions and fact tables. This data warehouse star model allow complex analyses such as rollup, drill down, slice and dice through the dimensions and fact tables by using special tools such as online analythical processes and complex queries based on views and snapshots. To create simulation envolves changing strategic economical indicators and keeping restrains on others so they reflect reality and the business environment. The business environments require analyses on large amount of data, big data and necessitate advanced tools to query through numerous criterias and also to create different realistic scenarious that allow choosing one option, so the business manager can use the right tool to gain economic advantage.