80 likes | 277 Views
Development of software for controlling measurement network of Environmental Agency of Republic of Slovenia (EARS). Author: Jože Guši Miklavčič Mentor: dr. Robert Leskovar, doc. Problems, objectives, working methods. Problems
E N D
Development of software for controlling measurement network of Environmental Agency of Republic of Slovenia (EARS) Author: Jože Guši Miklavčič Mentor: dr. Robert Leskovar, doc
Problems, objectives, working methods • Problems • dispersed evidence of maintenance, field working revisions, statistics of availability • difficulties in communication between maintenance stuff and users • administration which is not computer supported • Objectives • designing of processes model, data model and model of business functions • relational database implementation and development of users interface • esurient of evidence according to Statute of quality assurance • Working methods • study of literature (Oracle Designer, Application Server) • development of software • testing of solution
Process model Measuring stations maintenance process
Process model Process of recording information about faults
Diagram : MERILNA_MESTA Modified : 25 November 2002 12:40:05 Author : Joze Miklavcic KRAJI (Metatabele) KONCENTRATORJI (Metatabele) MERILNA_MESTA (Metatabele) ID_KRAJA OZNAKA KOORDINATE (Metatabele) ID_MM TEL DATUM_POSTAVITVE TIP_MM DATUM_DO IME NAZIV_MM DATUM_OD AKTIVEN ID_KOORDINATE OBMOCJE NASLOV MM_OSN_ID_MM KONCENTRATORJI SEKTORSKA_STEVILKA VPISAL PRENOS_KONCENTRAT_FK KONCENTRAT_PK MM_OSN_TIP_MM VISINA_MNM DATUM_VPISA DATUM_OD VPISAL IME_KRAJA DATUM_DO DATUM_VPISA KRAJI Y_KOOR POT_PRENOSA KRAJ_PK PRENOS_KRAJ_FK X_KOOR DAT_ZACETEK GEO_DOL DAT_KONEC GEO_SIR MM_DAT_ZACETEK KOORDINATA_MM_OSN_FK POV_P MM_DAT_KONEC PRENOSI (Metatabele) DATUM_VPISA PRENOSI_ID_MM VPISAL MM_PRENOSI_FK_I_1 GEO_D_SIR MM_PRENOSI_FK MM_OSN_PRENOSI_FK_I ID_MM GEO_D_DOL MM_PRENOSI_FK_I KONC_OZNAKA KOORDINATA_PK MM_OSN_PK MM_PAR_MM_OSN_FK PORT KOORDINATA_MM_OSN_FK MM_PRENOSI_FK AKTIVEN MM_OSN_PRENOSI_FK DATOTEKA TELEFON KRAJ_ID_KRAJA PRENOS_KRAJ_FK_I PRENOS_KONCENTRAT_FK_I PRENOSI_PK PRENOS_KRAJ_FK PRENOS_KONCENTRAT_FK MM_PARAMETRI (Metatabele) POSTAJA TIP PARAMETRI (Metatabele) PARAMETER MM_PARAMETRI MM_PAR_PK MM_PAR_UK ID_PARAMETRA PERIODA_MERJENJA IME_TABELE_S_PODATKI ST_DECIMALNIH_MEST DOLZINA_STEVILA MM_PAR_PARAMETER_FK OZNAKA_PARAMETRA OZNAKA_PAR_HTML MERSKA_ENOTA_HTML MERSKA_ENOTA OPIS_PARAMETRA TIP_PARAMETRA Data model
DOGODKI (Metatabele) Diagram : OBRATOVALNI_DOGODKI Modified : 29 November 2002 13:23:14 Author : Joze Miklavcic ELEMENTI (Metatabele) ID_DOGODKA VRSTA_DOGODKA DOGODKI_SEQ_TR ID_ELEMENTA DOGODKI DATUM_VPISA DOGODEK_PK VPISAL OBRATOVALNI_DOGODKI (Metatabele) NEGOTOVOST_B_TIP_REL SP_M_NAZ_OBM NAZIV_ELEMENTA ID_OBR_DOG OBR_DOG_DOGODEK_FK NEGOTOVOST_B_TIP_ABS DATUM_DOGODKA CAS_KONST DATUM_VPISA OBR_DOG_ELEMENT_FK ZG_M_NAZ_OBM VPISAL DOLGOTRAJNA_STABILNOST OPIS_DOGODKA ID_KATEGORIJE MM_POSTAJA NAPRAVA_ID_NAPRAVE MM_TIP ID_ENOTE_MERE MM_PAR_POSTAJA ID_MER_VEL MM_PAR_TIP MM_PAR_PARAMETER ELEMENT_ENOTA_MERE_FK_I ELEMENT_NAPRAVA_FK_I ID_ELEMENTA MERILNA_MESTA (Metatabele) ELEMENT_MER_VEL_FK_I SIFRA_AMP ELEMENT_KAT_UPOR_FK_I ID_DOGODKA OBR_DOG_SEQ_TR ID_MM OBR_DOG_DOGODEK_FK_I TIP_MM OBR_DOG_MM_OSN_FK_I OBR_DOG_MM_OSN_FK NAZIV_MM OBR_DOG_MM_PAR_FK_I OBMOCJE OBR_DOG_ELEMENT_FK_I SEKTORSKA_STEVILKA PRENOSI (Metatabele) OBRATOVALNI_DOGODKI VISINA_MNM OBR_DOG_PK VPISAL OBR_DOG_UK MM_PRENOSI_FK OBR_DOG_MM_PAR_FK DATUM_VPISA ARC_CHECK ID_MM OBR_DOG_ELEMENT_FK POT_PRENOSA KONC_OZNAKA OBR_DOG_MM_OSN_FK DAT_ZACETEK PORT OBR_DOG_MM_PAR_FK DAT_KONEC AKTIVEN OBR_DOG_DOGODEK_FK MM_DAT_ZACETEK DATOTEKA MM_DAT_KONEC TELEFON PRENOSI_ID_MM KRAJ_ID_KRAJA MM_PRENOSI_FK_I_1 PRENOSI MM_OSN_PRENOSI_FK_I PRENOS_KONCENTRAT_FK PRENOSI_PK MM_PRENOSI_FK_I PRENOS_KRAJ_FK MERILNA_MESTA MM_PAR_MM_OSN_FK PRENOS_KONCENTRAT_FK MM_OSN_PK MM_OSN_MM_OSN_PK_UK MM_PARAMETRI (Metatabele) MM_PRENOSI_FK MM_OSN_PRENOSI_FK POSTAJA KONCENTRATORJI (Metatabele) TIP PARAMETER MM_PAR_PK OZNAKA MM_PAR_UK DATUM_POSTAVITVE MM_PAR_PARAMETER_FK IME MM_PAR_MM_OSN_FK AKTIVEN KONCENTRATORJI KONCENTRAT_PK Data model Server model of operational events
User interface Show
Conclusion • systematical approach to defining processes and functions of system, together with users, caused also optimization of some operating processes • data are stored in relational database in accordance to Statute of quality assurance of measurements • user interface is formed like web portal where users have possibility to design their own pages • developed was a stable system that ensures simplified data views and updates. This was confirmed also by testing