prikaz prve stranice dokumenta Razvoj okoline za učinkovito stvaranje složenog sustava SQL upita
  Download
PDF 6 MB
master's thesis
Razvoj okoline za učinkovito stvaranje složenog sustava SQL upita
2021. urn:nbn:hr:200:658634
Radić, Svetozar
Josip Juraj Strossmayer University of Osijek
Faculty of Electrical Engineering, Computer Science and Information Technology Osijek
Department of Software Engineering
Chair of Programming Languages and Systems

Cite this document

Radić, S. (2021). Razvoj okoline za učinkovito stvaranje složenog sustava SQL upita (Master's thesis). Osijek: Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek. Retrieved from https://urn.nsk.hr/urn:nbn:hr:200:658634

Radić, Svetozar. "Razvoj okoline za učinkovito stvaranje složenog sustava SQL upita." Master's thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, 2021. https://urn.nsk.hr/urn:nbn:hr:200:658634

Radić, Svetozar. "Razvoj okoline za učinkovito stvaranje složenog sustava SQL upita." Master's thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, 2021. https://urn.nsk.hr/urn:nbn:hr:200:658634

Radić, S. (2021). 'Razvoj okoline za učinkovito stvaranje složenog sustava SQL upita', Master's thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, accessed 23 January 2025, https://urn.nsk.hr/urn:nbn:hr:200:658634

Radić S. Razvoj okoline za učinkovito stvaranje složenog sustava SQL upita [Master's thesis]. Osijek: Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek; 2021 [cited 2025 January 23] Available at: https://urn.nsk.hr/urn:nbn:hr:200:658634

S. Radić, "Razvoj okoline za učinkovito stvaranje složenog sustava SQL upita", Master's thesis, Josip Juraj Strossmayer University of Osijek, Faculty of Electrical Engineering, Computer Science and Information Technology Osijek, Osijek, 2021. Available at: https://urn.nsk.hr/urn:nbn:hr:200:658634

Please login to the repository to save this object to your list.
Metadata
TitleRazvoj okoline za učinkovito stvaranje složenog sustava SQL upita
Title (english)Development of environment for effective creation of a complex SQL query system
AuthorSvetozar Radić
MentorGoran Martinović (mentor)
Committee memberGoran Martinović (predsjednik povjerenstva)
Committee memberIvica Lukić (član povjerenstva)
Committee memberKrešimir Nenadić (član povjerenstva)
GranterJosip Juraj Strossmayer University of Osijek
Faculty of Electrical Engineering, Computer Science and Information Technology Osijek
(Department of Software Engineering)
(Chair of Programming Languages and Systems)
Osijek
Defense date and country2021-03-19, Croatia
Scientific / art field,
discipline and subdiscipline		TECHNICAL SCIENCES
Computing
Program Engineering
Abstract
U ovom radu razvijena je okolina za učinkovito stvaranje složenih SQL upita. Okolina rješava problem dugotrajnog pisanja SQL upita prilikom pripreme podataka za marketinške promidžbe unutar Salesforce Marketing Clouda. Korisnik pomoću korisničkog sučelja jednostavnom metodom „drag and drop“ prolazi kroz potrebne korake pri stvaranju SQL upita. Na početku je potrebno definirati izvorišna podatkovna proširenja te filtre. Sljedeći korak je odabir ciljnog podatkovnog proširenja u koje će se upisati podaci dobiveni pokretanjem SQL upita. Na kraju se dobiveni podaci prikazuju krajnjem korisniku u obliku tablice. Analizom rada okoline utvrđeno je učinkovitost okoline, te smanjenje vremena stvaranja složenih SQL upita kao i nestanak potrebe za pisanjem SQL upita što pridonosi poboljšanju kvalitete marketinških promidžbi.
Abstract (english)
This paper elaborates on developing an environment for efficiently creating complex SQL queries. The problem of resolving the lengthy writing of SQL queries when preparing data for marketing campaigns within the Salesforce Marketing Cloud. Using a simple drag-and-drop user interface, the user goes through the necessary steps in creating an SQL query. Initially, it is necessary to define the source data extension and the filters. The next step is to select the target data extension in which the dana, obtained by running the SQL query, will be saved. Finally, the obtained data is displayed to the end user in the form of a table. Application performance analysis determined the effectiveness of the application in reducing the time of creating complex SQL queries as well as the disappearance of the need to write SQL queries, which contributed to improving the quality of marketing campaigns.
Keywords
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:200:658634
Study programmeTitle: Graduate University Study Programme in Computer Engineering
Study programme type: university
Study level: graduate
Academic / professional title: magistar/magistra inženjer/inženjerka računarstva (magistar/magistra inženjer/inženjerka računarstva)
Type of resourceText
File originBorn digital
Access conditionsOpen access
Terms of useLicence In copyright icon
Created on2021-04-06 08:09:17