APPLICATIONS FOR BUSINESSES THAT USES RELATIONAL DATABASES
-
Authors:
• Lecturer PhD.,Dănuţ-Octavian SIMION, email: danut.simion@univath.ro, Afiliation: Athenaeum University, Bucharest, Romania
• Univ.Prof. PhD.,Emilia VASILE, email: rector@univath.ro, Afiliation: Athenaeum University, Bucharest, RomaniaPages:
• 61|72 -
Keywords: Database storage, business intelligence tools, business production model, data warehouse star model, SQL queries and reports, rollup and drill down objects
-
Abstract:
The paper presents a database production model designed as a warehouse star that contain dimensions like deposits, raw materials, stocks, products, producer, locations, time and a fact table with foreign keys and measures. This model optimize the activity of a business based on a production activity in the way that it can store large amount of data in a historical way that can be the base for future scenarios with key values changed by the decision maker. The decision maker analyses a large spectrum of reports and choose what indicators to observe and what measures to display and so it’s easy to decide based on large amount of data and trends. Database applications for business improve the efficiency in managing large quantity of data in the sense for storage, updates, queries, interaction with the users and also getting answers through reports. The schema specific to a database is very flexible and permits adding or removing columns and also adding and removing entities. This feature is very useful when the relational database schema is transformed in a data warehouse shaped as a star with dimensions and a fact table. This model permits advanced queries and the usage of rollup and drill down objects specific to the business intelligence tools that offer quick responses to the complex answers. To a production business the choice of a database application designed and implemented as data warehouse star model, bennefits from all the advantage of storage and also a superior and complex tool for building queries.
