IDEAS home Printed from https://ideas.repec.org/a/ath/journl/v45y2017i1p61-72.html
   My bibliography  Save this article

Applications For Businesses That Uses Relational Databases:

Author

Listed:
  • Danut-Octavian SIMION

    (Athenaeum University, Bucharest, Romania)

  • Emilia VASILE

    (Athenaeum University, Bucharest, Romania)

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.

Suggested Citation

  • Danut-Octavian SIMION & Emilia VASILE, 2017. "Applications For Businesses That Uses Relational Databases:," Internal Auditing and Risk Management, Athenaeum University of Bucharest, vol. 45(1), pages 61-72, March.
    • Handle: RePEc:ath:journl:v:45:y:2017:i:1:p:61-72
    as

    Download full text from publisher

    File URL: http://aimr.univath.ro/download/1107_aimr45_61_72.pdf
    Download Restriction: no
    File URL: http://aimr.univath.ro/en/article/APPLICATIONS-FOR-BUSINESSES-THAT-USES-RELATIONAL-DATABASES~1107.html
    Download Restriction: no
    ---><---

    More about this item

    Keywords

    Database storage; business intelligence tools; business production model; data warehouse star model; SQL queries and reports; rollup and drill down objects;
    All these keywords.

    JEL classification:

    • C23 - Mathematical and Quantitative Methods - - Single Equation Models; Single Variables - - - Models with Panel Data; Spatio-temporal Models
    • C26 - Mathematical and Quantitative Methods - - Single Equation Models; Single Variables - - - Instrumental Variables (IV) Estimation
    • C38 - Mathematical and Quantitative Methods - - Multiple or Simultaneous Equation Models; Multiple Variables - - - Classification Methdos; Cluster Analysis; Principal Components; Factor Analysis
    • C55 - Mathematical and Quantitative Methods - - Econometric Modeling - - - Large Data Sets: Modeling and Analysis
    • C81 - Mathematical and Quantitative Methods - - Data Collection and Data Estimation Methodology; Computer Programs - - - Methodology for Collecting, Estimating, and Organizing Microeconomic Data; Data Access
    • C87 - Mathematical and Quantitative Methods - - Data Collection and Data Estimation Methodology; Computer Programs - - - Econometric Software

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:ath:journl:v:45:y:2017:i:1:p:61-72. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    We have no bibliographic references for this item. You can help adding them by using this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Cosmin Catalin Olteanu and Emilia Vasile (email available below). General contact details of provider: https://edirc.repec.org/data/feathro.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.