|
|
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.
|
|
|
Shlukování textových dokumentů a jejich částí
Zápotocký, Radoslav ; Kopecký, Michal (advisor) ; Skopal, Tomáš (referee)
This thesis analyses use of vector-space model and data clustering approaches on parts of single document - on chapters, paragraphs and sentences - to allow simple navigation between similar parts. A simulation application (SimDIS), written in C# programming language is also part of this thesis. The application implements the described model and provides tools for visualization of vectors and clusters.
|
|
|
Visualisation of Text Retrieval Algorithms
Remiš, Daniel ; Kopecký, Michal (advisor) ; Lokoč, Jakub (referee)
The work deals with design and implementation of the program, which is used to clarify the operation of algorithms for searching through text using a graphical view of their structures. The work also includes some analyzis of already existing, interesting visualization tools designed to address other areas.
|
|
| |
|
|
Fuzzy database based on an E-R schema
Plachý, Milan ; Pokorný, Jaroslav (advisor) ; Kopecký, Michal (referee)
This text is especialy intended to those who are interested into fuzzy logic and its application in relational databases. It is mainly focused on concept of fuzzyfied relational database and implementation of such database. This text consists of two parts: theoretical aspects of fuzzyfication and implementation part. Selected extension is based on fuzzy E-R model so the requirements of the real world can be better met. This paper also describes existing solutions on different level of fuzzyfication. Part of the work is design and implementation of a simple software for querying over fuzzyfied relational database. This work shoud also serve as a guide for design and implementation of fuzzy database.
|
|
|
Transformace z OCL do SQL
Sobotka, Petr ; Richta, Karel (advisor) ; Kopecký, Michal (referee)
The aim of this Master Thesis named Transformation from OCL into SQL is to explore possibilities of enhancing Enterprise Architect by the ability of generating SQL code that implements OCL constraints of a Platform Independent Model, and to create a working prototype that demonstrates this capability. The thesis contains a brief introduction to the problem of Model Driven Architecture, why it would be useful to implement the specified constraints directly in the database, a description of the interaction with Enterprise Architect along with analysing how to get the needed data, the way OCL can be mapped onto SQL, and finally it describes the implementation of the OCLtoSQL plugin from its analysis and chosen architecture to its documentation.
|
|
|
Index Suitable for Similar Search in High-dimensional Spaces
Krejčová, Martina ; Kopecký, Michal (advisor) ; Skopal, Tomáš (referee)
In this paper, we focus on indexing and searching in high-dimensional data. To achieve the target we implemented the Metric Index, a model of the similarity search based on the metric spaces, that employs many of known principles of partitioning and filtering. The metric space is a general model of similarity, which enables the usage of implemented index for various data. With this index, stored data could be searched effectively. The internal structure of data is hidden, we just require an implementation of the function for feature extraction, which produces a vector representing data, and the metric function applicable to the given data. The Metric Index was implemented as a data cartridge, the mechanism for extending the capabilities of the Oracle server. This data cartridge enables indexing of large unstructured data in the Oracle server known as LOBs.
|
|
|
Workgroup Planning Application
Nguyen Cong, Thang ; Kopecký, Michal (advisor) ; Žemlička, Michal (referee)
This thesis describes design and implementation of a tool that supports workgroup planning. The system allows its users to manipulate their tasks, as well as supports collaboration of more users. The user interface of the application is based on lightweight web client. The application is modular, so that the enhancing of the application in the future will be as simple as possible.
|
|
|
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.
|
guest ::
RSS feed.