magistrsko delo Organizacija in management informacijskih sistemov
Tom Bajec (Author), Mirjana Kljajić Borštnar (Mentor)

Abstract

Za magistrsko nalogo smo izdelali podatkovno skladišče ter avtomatski poročilni sistem. S tem smo rešili težave pri odzivnosti aplikacije in pridobivanju rezultatov, saj hranimo več milijonov zapisov. Izdelali in opisali smo ustrezen podatkovni model, podatkovno OLTP in OLAP-bazo ter ELT-proces. Napisali smo podatkovne poizvedbe in skripte v SQL-T jeziku. Izdelali smo poročila, ki temeljijo na klasifikaciji WHO ATC/DDD. V nalogi smo podrobno opisali, kaj WHO ATC/DDD klasifikacija je in kako se izračunava. Opisali smo, na kakšen način oziroma katero metodo smo uporabili pri izgradnji sistema. Podatkovno skladišče smo uporabili kot vir podatkov. Prikazali smo tudi način uporabe podatkovnega rudarjenja. Prototipni informacijski sistem, ki omogoča izračunavanje po WHO ATC/DDD klasifikaciji smo poimenovali Anbico. Uporabljali smo orodja, ki nam jih nudita programska paketa MS SQL 2012 in Visual studio 2013.

Keywords

podatkovno skladišče;avtomatski poročilni sistem;informacijski sistem Anbico;

Data

Language: Slovenian
Year of publishing:
Typology: 2.09 - Master's Thesis
Organization: UM FOV - Faculty of Organizational Sciences
Publisher: [T. Bajec]
UDC: 004
COBISS: 7899155 Link will open in a new window
Views: 1015
Downloads: 102
Average score: 0 (0 votes)
Metadata: JSON JSON-RDF JSON-LD TURTLE N-TRIPLES XML RDFA MICRODATA DC-XML DC-RDF RDF

Other data

Secondary language: English
Secondary title: Development of system for antimicrobial drug consumption monitoring
Secondary abstract: In our master's thesis we were solving problem with unresponsiveness of applications obtaining results from datasets with more millions of records. We developed data warehouse and created automatic reports - business intelligence system. We described an appropriate data model, OLTP, OLAP database and ELT – process. We wrote scripts and database queries in T-SQL language and developed reports, based on the classification of the WHO ATC / DDD. The data warehouse was used as a data source. We demonstrated how to use data mining and described in detail what the WHO ATC / DDD classification actually is and how it is calculated. We described how and what methods were used in the construction of the system. Prototype Information System, which enables the calculation of the WHO ATC / DDD classification, was named Anbico. We used the tools from Microsoft, MS SQL 2012 and Visual Studio 2013.
Secondary keywords: data warehouse;business intelligence;information system Anbico;prototype;
URN: URN:SI:UM:
Type (COBISS): Master's thesis/paper
Thesis comment: Univ. v Mariboru, Fak. za organizacijske vede
Pages: 78 f.
ID: 9247209
Recommended works:
, magistrsko delo Organizacija in management informacijskih sistemov
, magistrsko delo
, diplomsko delo univerzitetnega študija Organizacijska informatika
, diplomsko delo visokošolskega strokovnega študija Informatika v organizaciji in managementu
, diplomsko delo