Automatgenerering av transaktionshanteringsprocedurer

• Main Author: Våleman, Adrian
• Format: Bachelor Thesis
• Language: Swedish
• Published: Linköpings universitet, Databas och informationsteknik 2013
• Subjects: Databas; Oracle; DML; Tableinterfaces; transaktioner; procedurer; CRUD; auto; automat; generera; generering
• Online Access: http://urn.kb.se/resolve?urn=urn:nbn:se:liu:diva-93842

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.