prikaz prve stranice dokumenta Baza podataka u kompjutorskoj telefoniji
No public access
undergraduate thesis
Baza podataka u kompjutorskoj telefoniji
Zagreb: University of Zagreb, Faculty of Electrical Engineering and Computing, 2015. urn:nbn:hr:168:234683
Spajić, Josip
University of Zagreb
Faculty of Electrical Engineering and Computing

Institutional repository: FER Repository

Cite this document

Spajić, J. (2015). Baza podataka u kompjutorskoj telefoniji (Undergraduate thesis). Zagreb: University of Zagreb, Faculty of Electrical Engineering and Computing. Retrieved from https://urn.nsk.hr/urn:nbn:hr:168:234683

Spajić, Josip. "Baza podataka u kompjutorskoj telefoniji." Undergraduate thesis, University of Zagreb, Faculty of Electrical Engineering and Computing, 2015. https://urn.nsk.hr/urn:nbn:hr:168:234683

Spajić, Josip. "Baza podataka u kompjutorskoj telefoniji." Undergraduate thesis, University of Zagreb, Faculty of Electrical Engineering and Computing, 2015. https://urn.nsk.hr/urn:nbn:hr:168:234683

Spajić, J. (2015). 'Baza podataka u kompjutorskoj telefoniji', Undergraduate thesis, University of Zagreb, Faculty of Electrical Engineering and Computing, accessed 03 November 2024, https://urn.nsk.hr/urn:nbn:hr:168:234683

Spajić J. Baza podataka u kompjutorskoj telefoniji [Undergraduate thesis]. Zagreb: University of Zagreb, Faculty of Electrical Engineering and Computing; 2015 [cited 2024 November 03] Available at: https://urn.nsk.hr/urn:nbn:hr:168:234683

J. Spajić, "Baza podataka u kompjutorskoj telefoniji", Undergraduate thesis, University of Zagreb, Faculty of Electrical Engineering and Computing, Zagreb, 2015. Available at: https://urn.nsk.hr/urn:nbn:hr:168:234683

Metadata
TitleBaza podataka u kompjutorskoj telefoniji
Title (english)Database in computer telephony
AuthorJosip Spajić
MentorDragan Jevtić (mentor)
Committee memberDragan Jevtić (predsjednik povjerenstva)
Committee memberMatija Šulc (član povjerenstva)
Committee memberMatija Džanko (član povjerenstva)
GranterUniversity of Zagreb
Faculty of Electrical Engineering and Computing
Zagreb
Defense date and country2015-09-07, Croatia
Scientific / art field,
discipline and subdiscipline		TECHNICAL SCIENCES
Computing
Scientific / art field,
discipline and subdiscipline		TECHNICAL SCIENCES
Electrical Engineering
Abstract
Kompjutorska telefonija, nekada jednostavno nazivana CTI, je primjena računala u upravljanju telefonskim pozivima. Pojam se često koristi za kompjuterizirane usluge koje koriste call centri kao što su potpore korisnicima ili telefonska prodaja. Također se koristi i za upotrebu osobnih računala za obavljanje poziva, što je bio fokus ovog rada. Korišten je Zoiper softphone instaliran na dva različita laptopa, te SIP2SIP sip provider na kojem su registrirana tri različita korisnička računa koja su služili za uspostavu poziva s jednog računala na drugo. Podatci o pozivima dobavljani su izravno s web stranice sip providera, gdje se zasebno za svaki korisnički račun spremaju podatci o dolaznim i odlaznim pozivima. Podatci se dobavljaju u tri koraka: skidanje izvornog koda web stranice za svakog korisnika, parsiranje izvornog koda, spremanje zapisa u bazu podataka. Svaki korak obavlja po jedna skripta. Sve skripte napisane su u Pythonu 2.7 za 64 bitnu verziju Windowsa. Svi pozivi se brišu nakon tri tjedna sa web stranice sip providera, te ih je zbog toga nužno spremiti u bazu podataka. Baza je sql baza, a SUBP je MySQL Workbench 6.3.
Abstract (english)
Computer telephony, sometimes simply referred to as CTI, is the use of computers in telephone call management. The term is often used in describing computerized services of call centers, such as user support or telephone sales. It is also sometimes used to describe the ability to use your personal computer to initiate and manage phone calls, which was the main focus of this paper. Zoiper softphone was installed on two different laptops. Using the SIP2SIP sip provider, three accounts were created which were used along with the softphone to initiate calls from one computer to the other. Call information was fetched directly from the sip provider web site, where it was stored separately for each accounts incoming and outgoing calls. The data was acquired in three steps: downloading the website source code, parsing the source code, saving parsed call logs in the database. Each step is performed by a different script. All the scripts were written using python 2.7 for Windows 7 64-bit version. Calls are stored up to three weeks on the sip provider web page, so it is necesary to save them in the database. We used a sql database created with MySQL Workbench 6.3 DBMS.
Keywords
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:168:234683
Study programmeTitle: 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 resourceText
File originBorn digital
Access conditionsClosed access
Terms of useLicence In copyright icon
Public note
Created on2018-02-06 11:52:51