Change search
ReferencesLink to record
Permanent link

Direct link
Design and Implementation of an Efficient, Reliable and Safe Work-Package Database System at CERN
Norwegian University of Science and Technology, Faculty of Information Technology, Mathematics and Electrical Engineering, Department of Telematics.
2010 (English)MasteroppgaveStudent thesis
Abstract [en]
The Activity Coordination Tool (ACT) is a web application designed to automate the planning and coordination of work packages. In the CMS experiment at CERN it is important that work packages in the underground facilities are properly planned in order to not jeopardize time schedules, equipments, budgets and safety. The subject of this thesis is the development of the database schema used by the ACT application. The schema has been developed from scratch in order to best fit the needs of CMS and to cover all aspects of the planning and coordination process not found in other CERN databases. Models and diagrams of the database schema are based on a step by step description of the work package process. This step by step description was used to organize the data, to make the data and data relationships consistency, and to make the database structure flexible for extensions in the future. These models would eventually be used to implement the schema in the CMS online database. Another database at CERN has many similarities with the ACT database. These two databases will eventually merge due to common interest, and the ACT database schema needed therefore to resemble some tables in this database in order to facilitate the merging. Some problems with network traversal and security needs to be solved before these two databases can be merged. The architecture and usage of the database schema can affect the database performance but it doesnÂ’t contribute to the reliability of the databases system. The hardware and software components making up the database system itself are usually the main contributors to this. The CMS online network work hard to keep the performance and reliability of their database system as good as possible. Everything from disks to network connections is redundant. In addition to component redundancy are features provided by Oracle used to improve performance. The amount of server redundancy does however seem a bit exaggerated, and the performance could be slightly improved if other Oracle features were used.
Place, publisher, year, edition, pages
Institutt for telematikk , 2010. , 133 p.
Keyword [no]
ntnudaim:5771, MSTCNNS Master of Telematics - Communication Networks and Networked Services (2 year), Nett og tjenestekvalitet
URN: urn:nbn:no:ntnu:diva-12175Local ID: ntnudaim:5771OAI: diva2:401951
Available from: 2011-03-04 Created: 2011-03-04

Open Access in DiVA

fulltext(3176 kB)890 downloads
File information
File name FULLTEXT01.pdfFile size 3176 kBChecksum SHA-512
Type fulltextMimetype application/pdf
cover(91 kB)21 downloads
File information
File name COVER01.pdfFile size 91 kBChecksum SHA-512
Type coverMimetype application/pdf

By organisation
Department of Telematics

Search outside of DiVA

GoogleGoogle Scholar
Total: 890 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: 28 hits
ReferencesLink to record
Permanent link

Direct link