prikaz prve stranice dokumenta Prelazak s arhitekture više instanci baza podataka na sustanarsku (multitenant) arhitekturu koristeći MS SQL Server 2016
No public access
master's thesis
Prelazak s arhitekture više instanci baza podataka na sustanarsku (multitenant) arhitekturu koristeći MS SQL Server 2016
Zagreb: University of Zagreb, Faculty of Electrical Engineering and Computing, 2017. urn:nbn:hr:168:794660
Basioli, Josip
University of Zagreb
Faculty of Electrical Engineering and Computing

Institutional repository: FER Repository

Cite this document

Basioli, J. (2017). Prelazak s arhitekture više instanci baza podataka na sustanarsku (multitenant) arhitekturu koristeći MS SQL Server 2016 (Master's thesis). Zagreb: University of Zagreb, Faculty of Electrical Engineering and Computing. Retrieved from https://urn.nsk.hr/urn:nbn:hr:168:794660

Basioli, Josip. "Prelazak s arhitekture više instanci baza podataka na sustanarsku (multitenant) arhitekturu koristeći MS SQL Server 2016." Master's thesis, University of Zagreb, Faculty of Electrical Engineering and Computing, 2017. https://urn.nsk.hr/urn:nbn:hr:168:794660

Basioli, Josip. "Prelazak s arhitekture više instanci baza podataka na sustanarsku (multitenant) arhitekturu koristeći MS SQL Server 2016." Master's thesis, University of Zagreb, Faculty of Electrical Engineering and Computing, 2017. https://urn.nsk.hr/urn:nbn:hr:168:794660

Basioli, J. (2017). 'Prelazak s arhitekture više instanci baza podataka na sustanarsku (multitenant) arhitekturu koristeći MS SQL Server 2016', Master's thesis, University of Zagreb, Faculty of Electrical Engineering and Computing, accessed 01 June 2024, https://urn.nsk.hr/urn:nbn:hr:168:794660

Basioli J. Prelazak s arhitekture više instanci baza podataka na sustanarsku (multitenant) arhitekturu koristeći MS SQL Server 2016 [Master's thesis]. Zagreb: University of Zagreb, Faculty of Electrical Engineering and Computing; 2017 [cited 2024 June 01] Available at: https://urn.nsk.hr/urn:nbn:hr:168:794660

J. Basioli, "Prelazak s arhitekture više instanci baza podataka na sustanarsku (multitenant) arhitekturu koristeći MS SQL Server 2016", Master's thesis, University of Zagreb, Faculty of Electrical Engineering and Computing, Zagreb, 2017. Available at: https://urn.nsk.hr/urn:nbn:hr:168:794660

Metadata
TitlePrelazak s arhitekture više instanci baza podataka na sustanarsku (multitenant) arhitekturu koristeći MS SQL Server 2016
Title (english)Migration from Multi-instance to Multitenant Database Architecture using SQL Server 2016
AuthorJosip Basioli
MentorIgor Mekterović (mentor)
Committee memberIgor Mekterović (predsjednik povjerenstva)
Committee memberLjiljana Brkić (član povjerenstva)
Committee memberBoris Vrdoljak (član povjerenstva)
GranterUniversity of Zagreb
Faculty of Electrical Engineering and Computing
Zagreb
Defense date and country2017-02-23, Croatia
Scientific / art field,
discipline and subdiscipline		TECHNICAL SCIENCES
Computing
Abstract
U radu je opisana povijest sustanarstva i značajke koje danas pružaju različiti SUBP-i. Detaljno su opisana tri pristupa sustanarstvu: razdvojena-baza razdvojena-shema, dijeljena-baza razdvojena-shema, dijeljena-baza dijeljena-shema. Opisan je jedan od vodećih sustanarskih sustava. Radi se o platformi za razvoj aplikacija koja koristi modificirani SUBP preko kojeg postiže konkurentno sustanarstvo. Izrađena je aplikacija koja potvrđuje koncept korištenjem pristupa dijeljene-baze dijeljene-sheme te kao jednostanarska aplikacija. Provedena je migracija dijela baza podataka 20 klijenata iz stvarne aplikacije. Migracija je provedena korištenjem dva pristupa: dijeljena-baza razdvojena-shema i dijeljena-baza dijeljena-shema. Uspoređene su performanse i druga svojstva migriranih, sustanarskih baza s početnim, jednostanarskim bazama. Na kraju su navedene smjernice kao pomoć pri odabiru pristupa i odluci o migraciji jednostanarske aplikacije na sustanarsku.
Abstract (english)
Paper describes multitenancy history and features that modern DBMSs can offer. Detailed descriptions are given for three multitenancy approaches: separated-database separated-schema, shared-database, separated-schema, shared-datebase, shared-schema. One of the leading multitenancy systems is described. Application development platform which uses modified DBMS to achieve concurrent multitenancy. Proof of concept application is developed as singletenant application and as multitenant using shared-datebase shared-schema approach. Migration of 20 real client database subsets is performed. Migration applied two approaches: shared-database, separated-schema and shared-datebase, shared-schema. Performances and other paramteres were compared among singletenant and multitenant migrated databases. In the end, guidelines are presented as tips for deciding wether to migrate and which approach to choose
Keywords
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:168:794660
Study programmeTitle: Computing
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 conditionsClosed access
Terms of useLicence In copyright icon
Public note
Created on2019-03-13 18:54:40