Automatgenerering av transaktionshanteringsprocedurer

In a database environment, when you create or alter tables you often want to have a basic interface for standard operations such as insert, delete and update. This thesis report covers an analysis of what programs there are on the market for generating such interfaces and compares them against the d...

Full description

Bibliographic Details
Main Author: Våleman, Adrian
Format: Bachelor Thesis
Language:Swedish
Published: Linköpings universitet, Databas och informationsteknik 2013
Subjects:
DML
Online Access:http://urn.kb.se/resolve?urn=urn:nbn:se:liu:diva-93842
Description
Summary:In a database environment, when you create or alter tables you often want to have a basic interface for standard operations such as insert, delete and update. This thesis report covers an analysis of what programs there are on the market for generating such interfaces and compares them against the demands of a real company. The analysis showed that none of the programs were completely meeting the requirements and therefore an own implementation of an interface generating program was created. The result is a PL/SQL program capable of generating files, storing them in a version handling system and executing the files into the database.