|
|
Data quality in the business information database environment
Cabalka, Martin ; Chlapek, Dušan (advisor) ; Kučera, Jan (referee)
This master thesis is concerned with the choice of suitable data quality dimensions for a particular database of economy information and proposes and implements metrics for its assessment. The aim of this paper is to define the term data quality in the context of economy information database and possible ways to measure it. Based on dimensions suitable to observe, a list of metrics was created and subsequently implemented in SQL query language, alternatively in a procedural extension Transact SQL. These metrics were also tested with the use of real data and the results were provided with a commentary. The main asset of this work is its complex processing of the data quality topic, from theoretical term definition to particular implementation of individual metrics. Finally, this study offers a variety of both theoretical and practical directions fort this issue to be further researched.
|
|
|
Comparison of in-memory database systems
Cabalka, Martin ; Chlapek, Dušan (advisor) ; Palovská, Helena (referee)
The aim of this thesis is to analyze basic technological principles of in-memory database systems, followed by a market research and selection of the products, which will be submitted to the qualitative comparison in a number of proposed criteria. Afterwards, there will be also explored the possibility of a performance measuring through the implementation of TPC-C benchmark, created at University of economics in Prague. In the introduction are outlined the circumstances and advantages, which support one of actual trends in database systems -- in-memory database systems. In the third chapter are described the most usual models of present database systems. This is followed by a next chapter, where are described technological principles of in-memory database systems. In chapter five are compared advantages and disadvantages of disc and in-memory systems and subsequently, the most common myths about in-memory databases are disproved. In a next part the in-memory database market is analyzed and criterions for choosing compared products are defined. Those products are subsequently compared, according to criterions defined in a chapter nine. In the last part is analyzed a possibility of a performance comparison of chosen products through the selected implementation of TPC-C benchmark. The most important outcome of this thesis is a complex analyze of in-memory database systems. Both from theoretical point of view, as well as from practical testing of chosen systems from proposed criterions.
|
guest ::
RSS feed.