Analisa kinerja store procedure dan create view sakila database pada online dan offline

Saputra, Edwin Wiyanto (2014) Analisa kinerja store procedure dan create view sakila database pada online dan offline. Bachelor thesis, Universitas Pelita Harapan.

[img] Text (Title)
Title.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (37MB)
[img] Text (Abstract)
Abstract.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (68kB)
[img] Text (ToC)
ToC.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (883kB)
[img] Text (Chapter1)
Chapter1.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (80kB)
[img] Text (Chapter2)
Chapter2.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (384kB)
[img] Text (Chapter3)
Chapter3.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (570kB)
[img] Text (Chapter4)
Chapter4.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (835kB)
[img] Text (Chapter5)
Chapter5.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (72kB)
[img] Text (Bibliography)
Bibliography.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (70kB)
[img] Text (Appendices)
Appendices.pdf
Restricted to Repository staff only
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (945kB)
[img] Text (Publication Agreement)
Publication Agreement.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (362kB)

Abstract

In this test, the testing will be done in online and offline. In online testing will be done with 4 different ISPs, which are Bolt, Hypernet, Fastnet and Hypernet. Each ISP have different speed and there is also an ISP that have download and upload that fast enough, but still unstable. In the online test will be used MySQL in phpMyAdmin. In offline testing will be used MySQL Workbench. Data collecting in the use of online databases in phpMyAdmin is done by using a stopwatch, everything is accurate and precise, without any changes. The data collecting for using offline database in MySQL Workbench is displayed directly on the MySQL Workbench application itself. Online and offline testing are done by creating store procedure and different create view. Each tests in the store procedure and create view are done 30 times From the results of this study, can be demonstrated that ISP plays a significant role in running the database in phpMyAdmin, a stable ISP also very affecting the performance of the database in phpMyAdmin. The use of store procedure that is simple and complex also affecting the performance of the database

Item Type: Thesis (Bachelor)
Creators:
CreatorsNIMEmail
Saputra, Edwin WiyantoUNSPECIFIEDUNSPECIFIED
Contributors:
ContributionContributorsNIDN/NIDKEmail
Thesis advisorYugopuspito, PujiantoUNSPECIFIEDUNSPECIFIED
Thesis advisorPanduwinata, FransUNSPECIFIEDUNSPECIFIED
Additional Information: SK 82-09 SAP a
Subjects: Q Science > QA Mathematics > QA75 Electronic computers. Computer science
Divisions: University Subject > Current > Faculty/School - UPH Karawaci > School of Information Science and Technology > Informatics
Current > Faculty/School - UPH Karawaci > School of Information Science and Technology > Informatics
Depositing User: Mr Samuel Noya
Date Deposited: 04 Oct 2018 05:43
Last Modified: 18 Oct 2021 04:07
URI: http://repository.uph.edu/id/eprint/606

Actions (login required)

View Item View Item