| | SLO | ENG | Cookies and privacy

Bigger font | Smaller font

Show document Help

Title:Razvoj sistema za spremljanje porabe protimikrobnih zdravil
Authors:ID Bajec, Tom (Author)
ID Kljajić Borštnar, Mirjana (Mentor) More about this mentor... New window
Files:.pdf MAG_Bajec_Tom_2017.pdf (7,32 MB)
MD5: C26FDC474ACB72292C9B926598CDED69
 
Language:Slovenian
Work type:Master's thesis/paper
Organization:FOV - Faculty of Organizational Sciences in Kranj
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, prototip
Place of publishing:Maribor
Year of publishing:2017
PID:20.500.12556/DKUM-64876 New window
COBISS.SI-ID:7899155 New window
NUK URN:URN:SI:UM:DK:3D3FCUAJ
Publication date in DKUM:27.02.2017
Views:1731
Downloads:147
Metadata:XML DC-XML DC-RDF
Categories:FOV
:
BAJEC, Tom, 2017, Razvoj sistema za spremljanje porabe protimikrobnih zdravil [online]. Master’s thesis. Maribor. [Accessed 13 April 2025]. Retrieved from: https://dk.um.si/IzpisGradiva.php?lang=eng&id=64876
Copy citation
  
Average score:
0.5
1
1.5
2
2.5
3
3.5
4
4.5
5
(0 votes)
Your score:Voting is allowed only for logged in users.
Share:Bookmark and Share


Hover the mouse pointer over a document title to show the abstract or click on the title to get all document metadata.

Secondary language

Language:English
Title:Development of system for antimicrobial drug consumption monitoring
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.
Keywords:data warehouse, business intelligence, information system Anbico, prototype


Comments

Leave comment

You must log in to leave a comment.

Comments (0)
0 - 0 / 0
 
There are no comments!

Back
Logos of partners University of Maribor University of Ljubljana University of Primorska University of Nova Gorica