Słowa kluczowe: przetwarzanie analityczne, bazy rezydujące w pamięci, Power-Pivot, OLAP Summary. For several years, the analysts have admitted, that demand for the computing power of analytic applications grows exponentially. For this reason, the new technologies of resource usage are still looking for. The result of these quests are the column-based… (More)
The idea of column-based indexes, introduced in Microsoft SQL Serv-er 2012, is one of the solutions, improving the efficiency of the analytical data processing. In order to verify the opinion, the column-oriented data processing gives more efficient results than classic, row-oriented, data processing method, a series of tests were executed and the results… (More)
The fundamental concepts of relational data versioning possibilities and the proposals of full and incremental versioning methods are contained in this paper. Additionally, applied method influence to the database size and the time of database state restoring are presented in this article. relacyjnych baz danych.
Słowa kluczowe: temporalna baza danych, model zdarzeń, model stanu, baza danych SZPITAL. Summary. The fundamental concepts of temporal data models and the possibilities and reasons of title conversion are contained in this paper. Additionally the model influence to the time of executing sample queries is presented in this article. All tests were made on… (More)