|
|
MS SQL Application Development Framework
Hanes, Marek ; Kopecký, Michal (advisor) ; Hoksza, David (referee)
Title: MS SQL Application Development Framework Author: Bc. Marek Hanes Department: Department of Software Engineering Supervisor: RNDr. Michal Kopecký, Ph.D. Supervisor's e-mail address: kopecky@ksi.mff.cuni.cz Abstract: The thesis deals with a database application development and tries to find ways to optimize the most common problems encountered. The goal of this thesis is to design and develop a modular framework that simplifies the database application development and prevents inexperienced users from using unsafe SQL statements and/or expressions. The example of such a statement can be the insert statement without explicit column list, unsafe XPath expression, etc. The framework provides among others manipulation with history tables allowing versioning of data and reverting unwanted data changes asynchronous and parallel SQL execution support, error management and logging support, monitoring of schema changes as well as procedure and function debugging Together with means of data manipulation, the framework provides the simple way of publishing stored procedure as web service as well. The framework is accompanied by well-written programmers and users guide to allow its further development. Keywords: application development, framework, modular design, safe statements, constraints 1
|
|
|
Semantic annotation of domain dependent data
Fišer, Dominik ; Vojtáš, Peter (advisor) ; Kopecký, Michal (referee)
One of the problems of semantic web is automated getting annotated data - web pages. Therefore this work is engaged in manual annotation of web pages and try to simplify this process for users using proposed methods. First part contains analysis of annotated data, users and vocabularies used for annotation. Afterwards are proposed methods which simplify annotation creation for users, the possibility of usage similar annotations or possibility highlight interesting parts of web page suitable for annotation. The work includes proposal of annotation tool user interface also that verifies proposed methods in practice. On the basis of this proposal was created a prototype implementation of the annotation tool Semantic Annotator as an extension for Google Chrome browser, which was also used for experiment verifying user-friendliness especially.
|
|
|
Information filtering in XML documents
Pilátová, Michaela ; Pokorný, Jaroslav (advisor) ; Kopecký, Michal (referee)
With a growing amount of information available on the Internet and by other technologies, there is a growing need to distribute data to individua/ users as fast as possible - and only to those who are interested. Publish-subscribe systems allow users to specify their interes/s using profi/es created with an appropriate query language, thus order receiving required information from all available sources contributing to the syslem. The XML language nowadays belongs to the most important standards used for data exchange. This thesis deals with publish-subscribe systems working with data in XML data forma!. Methods of effective filtration of XML data and general techniques used in publish-subscribe systems for delivery of pertinent data to users are discussed there. Also, a prototype of a simple publish-subscribe syslem working with XML - Xm/Part - is implemented. A couple of techniques connected to information delivery is implemented and tested using this syslem on real data. Powered by TCPDF (www.tcpdf.org)
|
|
|
Data Generator for Microsoft SQL Server
Drozen, Jan ; Hoksza, David (advisor) ; Kopecký, Michal (referee)
Testing of newly programmed components is an integral part of software development. Data Generator for Microsoft SQL Server is a tool for simple populating database tables with testing data which allows efficient database component testing for programmers, administrators and other database developers. Generated data can be structured using the parameters which are set in a simple user interface. Generated data correspond with database schema and constraints defined on columns. In following text we are going to describe the architecture and implementation details together with the necessary theoretical knowledge.
|
|
|
Template system for generating text documents
Vávro, Petr ; Kopecký, Michal (advisor) ; Kulič, Luboš (referee)
This thesis aims on design and implementation of a three-tier system for generating text documents from templates and supplied data. The system is going to be a part of the information system Munis developed by Triada. The thesis significantly extends the possibilities, provided by the component Aspose. Words by Aspose, Templates may contain expressions evaluated at time of data insertion, master-detail constructs of arbitrary level as well as conditionally shown text blocks.
|
|
|
Querying RDF graphs stored in a relational database using SPARQL and R2RML
Chaloupka, Miloš ; Nečaský, Martin (advisor) ; Kopecký, Michal (referee)
The RDF framework is becoming a popular framework for presenting data. It makes the data easily accessible and queryable. But the most common way how to store structured data is to use a relational database systems. The relational databases benefit from their long theoretical and practical history, however the relational database does not offer any convenient way how to publish the data. It is essential to create a mapping between these two worlds, to publish the data stored in a relational database in the RDF format. In the presented work we study the SPARQL algebra and create a transformation algorithm that enable us to create a virtual SPARQL endpoint over the relational data. We apply the acquired knowledge in implementation of a tool which uses the algorithm to proof the concept. Powered by TCPDF (www.tcpdf.org)
|
|
|
Tool for NDL
Myazina, Elena ; Richta, Karel (advisor) ; Kopecký, Michal (referee)
Title: Tool for NDL Author: Elena Myazina Department: Department of Software Engineering Supervisor: Doc. Ing. Karel Richta, CSc. Supervisor's Supervisor's e-mail address: richta@ksi.ms.mff.cuni.cz Abstrakt: -Current research networks allow end users to build their own application-specific connections (lightpaths) and Optical Private Networks (OPNs). This requires a clear communication between the requesting application and the network. The Network Description Language (NDL) is a vocabulary designed to describe optical networks based on the Resource Description Framework (RDF). These descriptions aid applications in querying the capabilities of the network and allow them to clearly express requests to the network. This work deals with the analysis of the current draft language NDL systems and optical components. He compares its potential and shortcomings of the proposal seeks. It also proposes a graphical representation corresponding to that language, which implements the graphical tool. The developed tool will allow the subsequent dialogs (voice) applications. Key words: NDL, RDF, optical mapping technology.
|
|
|
Virtualisation of Surveillance Systems
Koňas, Jakub ; Kopecký, Michal (advisor) ; Žemlička, Michal (referee)
Title: Virtualisation of Surveillance Systems Author: Jakub Koňas Department: Department of Software Engineering Supervisor: RNDr. Michal Kopecký, Ph. D. Supervisor's e-mail address: Michal.Kopecky@mff.cuni.cz Abstract: This thesis studies the procedures in the field of security, building and lifesafety management focused at rising necessity of securing buildings in geografically large areas. The opening chapters of the thesis explain the principles of facility management relevant to security and present current progress in the field. It creates new comprehensive source of information based on the experience of security specialist that Czech languge lacks. The following chapters define new terms in the field of security - large area (LA) and securing the LA (SLA) - and specify the essential qualities of SLA systems. Subsequent part of the thesis discusses possible architecture of the SLA system and proposes own solution based on ideas of service architecture and OPC. The thesis contains partial implementation of the crutial element of the framework - the virtual device. The final chapters demonstrates needed qualities of the framework using its sample application. Keywords: surveillance system, security, large area, virtual device, framework
|
|
|
Products Catalogue Configuration Framework
Dzurenko, Miroslav ; Nečaský, Martin (advisor) ; Kopecký, Michal (referee)
Market segmentation is growing as customers become more and more demanding for individual products and exclusive services. Companies are introducing new applications and products across many industries , that can be tailored easily to specific customers and markets. To be successful, the organisations have to offer a high level of customisation and customer-centric processes. However, traditional companies in financial, telecommunication and insurance industry struggle with the technological challenges associated with becoming customer focused enterprises. The aim of this thesis is to define the products catalogue framework, that will provide products bundling and customisation capabilities with user-friendly GUI. Therefore, the most of the work can be designed by business users without additional intensive development efforts. Moreover, the viability of the framework was evaluated on the solution based on IBM technologies. Powered by TCPDF (www.tcpdf.org)
|
|
| |
guest ::
RSS feed.