Baza podataka u kompjutorskoj telefoniji

undergraduate thesis

• Title (english): Database in computer telephony
• Author: Josip Spajić
• Mentor: Dragan Jevtić (mentor)
• Committee member: Dragan Jevtić (predsjednik povjerenstva)
• Committee member: Matija Šulc (član povjerenstva)
• Committee member: Matija Džanko (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2015-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: CTI; kompjutorska telefonija; baza podataka; softphone; VoIP; SIP; Zoiper; SIP2SIP; upravljanje pozivima; MySQL Workbench
• Keywords (english): CTI; Computer telephony; database; softphone; VoIP; SIP; Zoiper; SIP2SIP; call management; MySQL Workbench
• Language: croatian
• URN:NBN: urn:nbn:hr:168:234683
• 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 11:52:51