Analiza korištenja pametnih kuća

undergraduate thesis

• Title (english): Analyis of Smart House Usage
• Author: Ivan Bošnjak
• Mentor: Boris Vrdoljak (mentor)
• Committee member: Boris Vrdoljak (predsjednik povjerenstva)
• Committee member: Ljiljana Brkić (član povjerenstva)
• Committee member: Marko Banek (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2015-07-13, Croatia
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Computing
• Scientific / art field, discipline and subdiscipline: TECHNICAL SCIENCES; Electrical Engineering

Abstract

Tema ovog završnog rada je izgradnja baze podataka u koju se pohranjuju podaci o korištenju pametne kuće i web-aplikacije pomoću koje se ti podaci pregledavaju i analiziraju. Prvi korak je bio napraviti ER model i relacijski model baze podataka, a potom ju implementirati i napuniti podacima. To je učinjeno pomoću WampServera koji se sastoji od Apache web servera, MySQL baze podataka i PHP programskog jezika. Potom je korištenjem programskih jezika Java, PHP i HTML kreirana web-aplikacija sa... More funkcionalnošću pretraživanja podataka iz baze SQL upitima i računanja vremena i trajanja korisnikovih kretnji u pametnoj kući. Rezultat završnog rada omogućuje jednostavno upravljanje pametnom kućom i otvoren je za poboljšanja i nadogradnje koja bi dodatno unaprijedila kvalitetu usluga pametne kuće. Less

Abstract (english)

Subject of this project is creation of database used for logging data of Smart Home usage and creation of web-application used for overview and analysis of this data. First step was making ER and relationship model of database, then implementing it and storing data. We did that using WampServer which consists of Apache web server, MySQL database and PHP programming language. After that, by using Java, PHP and HTML programming languages we created web-application with search functions that... More use SQL queries and calculating time and duration of users habits in Smart Home. Result of this project enables easy Smart Home management and is opened for enhancements and upgrades that could further improve the quality of Smart Home usage. Less

• Keywords: pametna kuća; baza podataka; web-aplikacija; MySQL; Java; PHP; HTML; CSS
• Keywords (english): smart home; database; web-application; MySQL; Java; PHP; HTML; CSS
• Language: croatian
• URN:NBN: urn:nbn:hr:168:050510
• Study programme: Title: Computing; Study programme type: university; Study level: undergraduate; Academic / professional title: sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka računarstva (sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka računarstva)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2018-02-06 07:59:39