Revidering av rockdatabas
Svenskt Rockarkiv is an organization located in Hultsfred, Sweden. Its goal is to collect and document the history of Swedish rock music. The archive contains several types of documentation, such as audio recordings, photographs, posters, video recordings and books representing Swedish rock music history. In order to store information about the audio recordings in the archive, Svenskt Rockarkiv uses a SQL Server 2000 database and a client application written in Microsoft.NET C# and Windows Forms. The purpose of this degree project is to audit the database and windows client, since the organization has needs of new functionality. There are also some bugs in the system that needs to be corrected. The result of the audit states that the database needs to be extended with additional tables and some structural changes to handle the new demands of the system. The poorly designed architecture of the windows client causes performance issues, and these issues are believed to increase with the size of the database. Based on the audit a suggestion of changes to the system is presented, with emphasis on overall performance, usability and preparations for future development. Structural changes to the database are presented as well as a new distributed client-server solution. By using the .NET Remoting technique the business logic is placed in a separate physical layer increasing performance and scalability, and making the system easy to extend with future functionality. Finally the outcome of the system development is presented with a database model and an implementation of the new client.