Change search
ReferencesLink to record
Permanent link

Direct link
Experimental Database Export/Import for InPUT
Mid Sweden University, Faculty of Science, Technology and Media, Department of Information and Communication systems.
2013 (English)Independent thesis Basic level (degree of Bachelor), 180 HE creditsStudent thesis
Abstract [en]

The Intelligent Parameter Utilization Tool (InPUT) is a format and API for thecross-language description of experiments, which makes it possible to defineexperiments and their contexts at an abstract level in the form of XML- andarchive-based descriptors. By using experimental descriptors, programs can bereconfigured without having to be recoded and recompiled and the experimentalresults of third-parties can be reproduced independently of the programminglanguage and algorithm implementation. Previously, InPUT has supported theexport and import of experimental descriptors to/from XML documents, archivefiles and LaTex tables. The overall aim of this project was to develop an SQLdatabase design that allows for the export, import, querying, updating anddeletion of experimental descriptors, implementing the design as an extensionof the Java implementation of InPUT (InPUTj) and to verify the generalapplicability of the created implementation by modeling real-world use cases.The use cases covered everything from simple database transactions involvingsimple descriptors to complex database transactions involving complexdescriptors. In addition, it was investigated whether queries and updates ofdescriptors are executed more rapidly if the descriptors are stored in databasesin accordance with the created SQL schema and the queries and updates arehandled by the DBMS PostgreSQL or, if the descriptors are stored directly infiles and the queries and updates are handled by the default XML-processingengine of InPUTj (JDOM). The results of the test case indicate that the formerusually allows for a faster execution of queries while the latter usually allowsfor a faster execution of updates. Using database-stored descriptors instead offile-based descriptors offers many advantages, such as making it significantlyeasier and less costly to manage, analyze and exchange large amounts of experi-mental data. However, database-stored descriptors complement file-baseddescriptors rather than replace them. The goals of the project were achieved,and the different types of database transactions involving descriptors can nowbe handled via a simple API provided by a Java facade class.

Place, publisher, year, edition, pages
2013. , 45 p.
Keyword [en]
Databases, DBMS, Experiments, InPUT, Java, PostgreSQL, SQL, XML, XPath
National Category
Computer Engineering
URN: urn:nbn:se:miun:diva-21089OAI: diva2:689315
Subject / course
Computer Engineering DT1
Educational program
Internetbased Study Programme in Computer and Electrical Engineering THOLG 180 higher education credits
Available from: 2014-01-21 Created: 2014-01-20 Last updated: 2014-01-21Bibliographically approved

Open Access in DiVA

Experimental Database Export-Import for InPUT.pdf(3273 kB)82 downloads
File information
File name FULLTEXT01.pdfFile size 3273 kBChecksum SHA-512
Type fulltextMimetype application/pdf

Search in DiVA

By author/editor
Karlsson, Stefan
By organisation
Department of Information and Communication systems
Computer Engineering

Search outside of DiVA

GoogleGoogle Scholar
Total: 82 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

Total: 110 hits
ReferencesLink to record
Permanent link

Direct link