6533b834fe1ef96bd129d5cf

RESEARCH PRODUCT

Database Versioning 2.0, a Transparent SQL Approach Used in Quantitative Management and Decision Making

Carmen NovacMarius CiocaCosmin Cioranu

subject

AutocommitSQLPhysical data modelComputer scienceViewData definition languagecomputer.software_genreDatabase designDatabase testingData modelingDecision Making ;DBMSGeneral Environmental Sciencecomputer.programming_languageDatabase modelData administrationSQLDatabasebusiness.industryComponent-oriented databaseDatabase Logical Version ControlAnalyticsGeneral Earth and Planetary SciencesbusinessRaw datacomputerIntelligent database

description

Abstract Managerial decisions are based on accurate information and in today's time raw data is produced even with a stroke of a key. Regardless of the data creating process one needs to know how the information was extracted and which pool of data was used. One important factor is time therefore we need to structure it in layers of data history in such a way that it can be analyzed, (post)process, in order to be able to retrieve valuable information. The simplest way is to use a Database Management System (DBMS), but even with such a management system we face the issue of making it a self-contained database on each version of data added. Our proposed system, a continuation of previous work, aims toward creating a database versioning system which keeps the natural dependency between data on each internal revision, a basis of security and alteration control mechanism, trend analytics, without sacrificing(within acceptable levels) speed, flexibility and the cost of implementation be kept as minimal as possible.

10.1016/j.procs.2015.07.030http://dx.doi.org/10.1016/j.procs.2015.07.030