Database Jaman Now
1 like213 views
Materi terkait perkembangan database modern, membahas pula posisi database pada dunia developement. Materi ini dipresentasikan di hadapan mahasiswa Sistem Informasi UMK Kudus, Desember 2017.
More Related Content
Similar to Database Jaman Now (20)
More from Hari Setiaji (19)
Recently uploaded (20)
Database Jaman Now
- 1. Database Trend Structure | Development | Opportunities Hari Setiaji, M.Eng. Program Studi Teknik Informatika Universitas Islam Indonesia Universitas Muria Kudus Kudus, 23 Desember 2017Hari Setiaji - Informatika UII 1
- 2. Hello! Hari Setiaji hari.setiaji@uii.ac.id Past Now Project Manager PT.RPI - Project Manager CV.MBI - ITCentrum - Oracle Instructure (DBA 1) Still counting.. Instructure - MOS, Web, DBMS, IT Still counting.. - Lecturer and Researcher Informatics Departments UII - A father of (almost) 2 children. :) See my full profile on Linkedin linkedin.com/in/harisetiaji Hari Setiaji - Informatika UII 2
- 3. How much DBMS in the world ? Sebutkan ? There are 339 (and still counting) DBMS, based on list at http://db-engines.com (Data per-Desember 2017) Hari Setiaji - Informatika UII 3
- 5. 2020 ? Sumber: https://db-engines.com/en/ranking_trend Diakses 20 Desember 2017Hari Setiaji - Informatika UII 5
- 6. Comparation Relational Database Oracle MySQL Ms SQL Server PostgreSQL Non Relational Database MongoDB Lets take top five DBMS from db-ranking List Relational: Bersifat relasional, terstruktur, skema lebih kaku, dalam kecepatan cenderung lambat No Relational Database: anti-relational, disebut NoSQL, bersifat terdistribusi, desain fleksibel, digunakan pada sistem skala besar, cenderung lebih cepat Hari Setiaji - Informatika UII 6
- 7. Lets see the performance! Based on Research International Journal of Scientific and Research Publications, Volume 5, Issue 2, February 2015 by Rajat Aghi et al. Penelitian ini melakukan komparasi terhadap Relational dan Non- Relational dengan menggunakan 3 parameter dataset. DBMS yang dikomparasi yaitu MySQL dan MongoDB a) Small Dataset: 10 rows and 2 columns b) Medium Dataset: 400 rows and 35 columns c) Large Dataset: 2000 rows and 20 columns Hari Setiaji - Informatika UII 7
- 24. Traditional Database Architecture Key-value access Complex queries OLAP transactions Analytics Sumber: http://aws.amazon.com Hari Setiaji - Informatika UII 24
- 29. Oracle for Development Sistem Informasi Pendidikan 1 Year Sistem Informasi Klinik 4 Years Sistem Informasi Rumah Sakit 4 Years Based on my experiences CLIENT WEB APP MOBILE APP ORACLE API Hari Setiaji - Informatika UII 29
- 30. Our Weapons! Oracle Database Express Edition 10g / 11g(Free). SQL Developer OCI Client Oracle ODBC Drivers PHP and friends Coffes and Happines J Hari Setiaji - Informatika UII 30
- 32. Database Job Opportunities Database Administrator Having deep understanding in database management system Solid understanding ofdatabase design principals Ms SQL Server, ORACLE, MySQL Server Database Developer Strong SQL expertise Can write a query to do almost anything within Database Server PL/SQL for Oracle Database Engineer Identifies database requirements by interviewing customers. (Analyst) Recommends solution for Database Operation Part job of Web/Mobile Developer SQL Skill Understanding basic administration of popular DBMS Based on specifications at https://www.jobstreet.co.id Hari Setiaji - Informatika UII 32
- 33. What should I learn? SQL API NOSQL Basic Database Administration Data Engineering Hari Setiaji - Informatika UII 33