ePrints.FRI - University of Ljubljana, Faculty of Computer and Information Science

SQL server 2008 based application development

Anton Šivic (2010) SQL server 2008 based application development. EngD thesis.

[img] PDF
Download (4Mb)


    In my thesis i tried to present some functionality from SQL Server 2008 platform and some new functionality and extensions that were introduced in Microsoft.NET framework version 3.0, 3.5 sp1 and 4.0. Things most interesting to me were SQL Server Integration Services, SQL Server Reporting Services and SQL Server Analysis Services. I think SQL Server Integration Services are interesting because you can create custom work flow diagrams and event handlers with which you can capture a lot of your business logic without any addtional programming. I decided to also use SQL Server Reporting Services because of it's great reporting system. With the use of SQL Server Reporting Services we get a great reporting system without a need to have IIS intalled and at the same time we can still implement a lot of security features. With this security features and settings we can assure that in our business environment only those who have suficient privileges can see the reports. The reports we do with SQL Server Reporting Services are as good as they were made inside applications that were specially designed for that purpose. With SQL Server Analysis Services we can analize our database data and the do different optimizations. This makes our work a bit easier because we do not need any aditional tools for analysing data. With SQL Server Analysis Services we can do different pivot tables. Additionally I decided to include a chapter about Entity Framework and with that in mind also about LINQ technology. I find this technology very interesting because it makes it possible to work with database table and other database objct as regular objects.

    Item Type: Thesis (EngD thesis)
    Keywords: Reports, data integration, analysing data, database, object model.
    Number of Pages: 40
    Language of Content: Slovenian
    Mentor / Comentors:
    Name and SurnameIDFunction
    doc. dr. Rok Rupnik279Mentor
    Link to COBISS: http://www.cobiss.si/scripts/cobiss?command=search&base=50070&select=(ID=00007812948)
    Institution: University of Ljubljana
    Department: Faculty of Computer and Information Science
    Item ID: 1139
    Date Deposited: 08 Jul 2010 09:01
    Last Modified: 13 Aug 2011 00:37
    URI: http://eprints.fri.uni-lj.si/id/eprint/1139

    Actions (login required)

    View Item