6533b834fe1ef96bd129d5cf
RESEARCH PRODUCT
Database Versioning 2.0, a Transparent SQL Approach Used in Quantitative Management and Decision Making
Carmen NovacMarius CiocaCosmin Cioranusubject
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 databasedescription
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.
year | journal | country | edition | language |
---|---|---|---|---|
2015-01-01 | Procedia Computer Science |