A master thesis from Aalborg University
'Microsoft SQL Server 2005: Rethinking Code Placement'
Author(s)
Term
4. term
Education
Publication year
2006
Submitted on
2012-02-14
Abstract
'This thesis examines the possibilities introduced by the integration of CLR in Microsoft SQL Server 2005. The focus of the examination is to determine how the CLR integration affects the design of a distributed system concerning the performance and scalability criteria. The goal of the thesis is to define a metric empirically, which is able to determine whether a given functionality achieve the best performance and scalability on the application server or database. In order to define the metric, the parameters affecting performance and scalability are determined. A subset of these parameters is varied in a full factorial experimental design to determine the impact of each parameter. The measurements obtained from the performed experiments are compared statistically. Thereby, determining the differences between code deployed on the application server and the two technologies - T-SQL and SQLCLR. Subsequently, the obtained result is used to define the metric. In order to make the metric easy to use for the developer, it has been implemented into a tool with a simple user interface, where the different parameters can be specified.'
Documents
Colophon: This page is part of the AAU Student Projects portal, which is run by Aalborg University. Here, you can find and download publicly available bachelor's theses and master's projects from across the university dating from 2008 onwards. Student projects from before 2008 are available in printed form at Aalborg University Library.
If you have any questions about AAU Student Projects or the research registration, dissemination and analysis at Aalborg University, please feel free to contact the VBN team. You can also find more information in the AAU Student Projects FAQs.