Apr 6, 2017 ... Say you want info about your friends' quizzes. • Need to store info in a shared database. • Can't be on your device. • Need data to be...
SIXTH EDITION. Ramez Elmasri. Department of Computer Science and Engineering. The University of Texas at Arlington. Shamkant B. Navathe. College of ..... Sun, Rajshekhar Sunderraman, Aravindan Veerasamy, and Emilia E. Villareal. □ Fourth edition. Mai
SQL Fundamentals 3 Preface Purpose SQL Fundamentals describes basic Teradata SQL concepts, including data handling, SQL data definition, control, and manipulation
Download Geofisika (BMKG) melakukan pengelolaan data Meteorologi Klimatologi dan Geofisika ... saat ini sedang membangun sistem pengelolaan database MKG dengan ... format dan sistem database yang berbeda-‐beda, sehingga data tersebut sulit untu
Download Part 1 describes the basic introductory concepts necessary for a good understanding of database models, systems, and languages. Chapters 1 and 2 introduce databases, typical users, and DBMS concepts, terminology, and architecture. Part
Download AJAX (Asynchronous JavaScript and XML) technology is mainstream ... The Deficit of JavaScript Language: JavaScript is a widely client-side scripting language, ...
Download Rancangan ini diawali dengan pengumpulan data dan informasi dari perusahaan konstruksi. PT. Hutama Karya ... Kata Kunci : material, manajemen material, sistem database. 1 Alumni Prodi ... gudang. Biasanya bagian ini mempunyai alat-alat
Download Abstract- SQLite is advance database system useful for storing data. It is simple to use operate and supported by multiplatform. Basically it is more applied in android based application systems. Because of its flexibility and platform
Download dan Sdr. Khamami Heru Santoso berdasarkan Surat Keputusan Kepala Pusdiklat .... Sistem berbasis TIK diimplementasikan, baik dalam rangka information value ...... 1, MS-Windows 95. (untuk komputer stand-alone atau untuk komputer client
Foreword his document describes the OECD Economic Outlook database – 102th edition - Volume 2017/2. Section 1 describes the content of the database and gives some
Progettare un database - prof. Enzo Mardegan - http://digilander.libero.it/enzomrd 1 PROGETTARE UN DATABASE CON ACCESS Una delle funzioni più comuni per un
Download Structure. 1.0 Objectives. 1.1 Introduction. 1.2 Data Processing Vs. Data Management Systems. 1.3 File Oriented Approach. 1.4 Database Oriented Approach to Data Management. 1.5 Characteristics of Database. 1.6 Advantages and Disadvanta
Download Menurut Gottschalk dan Saether dalam jurnal (2010, 41), database adalah ..... semua dokumen tentang konsep tertentu, meskipun istilah yang ia gunakan untuk.
Download Abstract- SQLite is advance database system useful for storing data. It is simple to use operate and supported by multiplatform. Basically it is more applied in android based application systems. Because of its flexibility and platform
Download Rancangan ini diawali dengan pengumpulan data dan informasi dari perusahaan konstruksi. PT. Hutama Karya ... Kata Kunci : material, manajemen material, sistem database. 1 Alumni Prodi ... gudang. Biasanya bagian ini mempunyai alat-alat
makalah ini dapat bermanfaat bagi kita semua, khususnya dibidang pendidikan komputer. Makassar ... Program untuk Kasir di koperasi, penjualan untuk toko
Alchemy Database White Paper Version 7 - 1 - The Alchemy® Database An Open and Extensible Architecture for Efficient Management of Unstructured Data
Konsep Basis Data. • Base : Kumpulan / Gudang. • Data : Fakta tentang objek, orang, dan lain-lain yang dinyatakan dengan nilai (angka, simbol, dll). • Hirarki Data : Bit. Byte. Field. Record. File/Table. Basis Data
Download Garut yang dalam hal keamanan database nya belum terjamin. Metodologi ... PDAM Tirta Intan dalam mengolah data tentang informasi kepegawaian sudah.
Download Sistem berbasis TIK diimplementasikan, baik dalam rangka information value ...... (untuk- DBMS yang berbasis grafis). DBMS seperti MS-. Access dapat menunjukkan hal itu. b. Menggunakan bahasa database (data manipulation language). ....
Download 24 Okt 2007 ... Data) termasuk di dalamnya program aplikasi yang dibuat dan ... Data Base Management System (DBMS)/Sistem Manajemen Basis Data ...
Download Part 1 describes the basic introductory concepts necessary for a good understanding of database models, systems, and languages. Chapters 1 and 2 introduce databases, typical users, and DBMS concepts, terminology, and architecture. Part
Download Sistem berbasis TIK diimplementasikan, baik dalam rangka information value ...... (untuk- DBMS yang berbasis grafis). DBMS seperti MS-. Access dapat menunjukkan hal itu. b. Menggunakan bahasa database (data manipulation language). ....
Download Geofisika (BMKG) melakukan pengelolaan data Meteorologi Klimatologi dan Geofisika ... saat ini sedang membangun sistem pengelolaan database MKG dengan ... format dan sistem database yang berbeda-‐beda, sehingga data tersebut sulit untu
Firebase Realtime Database Landon Cox April 6, 2017
Databases so far • SQLite (store quiz progress locally) • User starts app • Check database to see where user was
• Say you want info about your friends’ quizzes • • • •
Need to store info in a shared database Can’t be on your device Need data to be stored on server Want to be notified when data changes
Relational databases • Data is organized into tables • • • •
Tables have named, typed columns Data is stored as rows in a table Can place constraints on columns (e.g., uniqueness) Structure + constraints define the schema
• Read/write the data base with SQL • Structured Query Language (SQL) • SQL is declarative • It describes what result you want, not how to compute it
• Example databases: mysql, postgresql, sqlite
SQLite • SQLite is the primary database for Android apps
• Classes for managing your app’s SQLite database • Contract class w/ inner BaseColumns class • DbHelper class that extends SQLiteOpenHelper • Cursor for iterating through answers to queries
Define the contract/schema • Contract class • Place to put all constants related to your database
• BaseColumns inner class • Table names • Column names
• One BaseColumns class for each table in the db
_id
quiz_title
num_correct
num_wrong
last_question
finished_quiz
timestamp
0
Duke Basketball
0
0
0
0
1488460945
Firebase features • Authentication • Integrate with identity providers or email • Google, Twitter, Facebook, others
• Storage • Remote storage for the user • Can store large files
• Messaging • Send/receive notifications • Requires app server https://github.com/firebase/FirebaseUI-Android/
Firebase features • Authentication • Integrate with identity providers or email • Google, Twitter, Facebook, others
• Storage • Remote storage for the user • Can store large files
• Messaging • Send/receive notifications • Requires app server https://github.com/firebase/FirebaseUI-Android/
Tables vs JSON trees • SQL databases are stored as tables • Use SQL language to access data _id
quiz_title
num_correct
num_wrong
last_question
finished_quiz
timestamp
0
Duke Basketball
0
0
0
0
1488460945
• Firebase databases are stored as a tree • Access via keys (Strings) that map to values (Objects) • Objects are stored in JSON format • We’ve seen JSON before …
JSON • Javascript Object Notation • Similar to XML, but more restricted • Solved the need to exchange client/server data on web • Designed to ease marshalling/unmarshalling
• Example javascript (marshalling) var myObj = { "name":"John", "age":31, "city":"New York" }; var myJSON = JSON.stringify(myObj); window.location = "demo_json.php?x=" + myJSON;
h"ps://www.w3schools.com/js/js_json_intro.asp
JSON • Javascript Object Notation • Similar to XML, but more restricted • Solved the need to exchange client/server data on web • Designed to ease marshalling/unmarshalling
• Example javascript (marshalling)
Fields: string name + value
var myObj = { "name":"John", "age":31, "city":"New York" }; var myJSON = JSON.stringify(myObj); window.location = "demo_json.php?x=" + myJSON;
h"ps://www.w3schools.com/js/js_json_intro.asp
JSON • Javascript Object Notation • Similar to XML, but more restricted • Solved the need to exchange client/server data on web • Designed to ease marshalling/unmarshalling
• Example javascript (marshalling)
Convert js object to string via stringify
var myObj = { "name":"John", "age":31, "city":"New York" }; var myJSON = JSON.stringify(myObj); window.location = "demo_json.php?x=" + myJSON;
h"ps://www.w3schools.com/js/js_json_intro.asp
JSON • Javascript Object Notation • Similar to XML, but more restricted • Solved the need to exchange client/server data on web • Designed to ease marshalling/unmarshalling
• Example javascript (marshalling)
Once a string, can print
var myObj = { "name":"John", "age":31, "city":"New York" }; var myJSON = JSON.stringify(myObj); window.location = "demo_json.php?x=" + myJSON;
h"ps://www.w3schools.com/js/js_json_intro.asp
JSON • Javascript Object Notation • Similar to XML, but more restricted • Solved the need to exchange client/server data on web • Designed to ease marshalling/unmarshalling
• Example javascript (marshalling)
Once a string, can also save to database!
var myObj = { "name":"John", "age":31, "city":"New York" }; var myJSON = JSON.stringify(myObj); window.location = "demo_json.php?x=" + myJSON;
h"ps://www.w3schools.com/js/js_json_intro.asp
JSON • Javascript Object Notation • Similar to XML, but more restricted • Solved the need to exchange client/server data on web • Designed to ease marshalling/unmarshalling
• Example javascript (marshalling)
Once a string, can also save to database!
var myObj = { "name":"John", "age":31, "city":"New York" }; var myJSON = JSON.stringify(myObj); window.location = "demo_json.php?x=" + myJSON;
h"ps://www.w3schools.com/js/js_json_intro.asp
JSON • Javascript Object Notation • Similar to XML, but more restricted • Solved the need to exchange client/server data on web • Designed to ease marshalling/unmarshalling
• Example javascript (unmarshalling) var myJSON = ’{ "name":"John", "age":31, "city":"New York" }’; var myObj = JSON.parse(myJSON); document.getElementById(“demo”).innerHTML = myObj.name;
h"ps://www.w3schools.com/js/js_json_intro.asp
JSON • Javascript Object Notation • Similar to XML, but more restricted • Solved the need to exchange client/server data on web • Designed to ease marshalling/unmarshalling
• Example javascript (unmarshalling) Note that this is a string var myJSON = ’{ "name":"John", "age":31, "city":"New York" }’; var myObj = JSON.parse(myJSON); document.getElementById(“demo”).innerHTML = myObj.name;
h"ps://www.w3schools.com/js/js_json_intro.asp
JSON • Javascript Object Notation • Similar to XML, but more restricted • Solved the need to exchange client/server data on web • Designed to ease marshalling/unmarshalling
• Example javascript (unmarshalling) Convert string to object via parse
var myJSON = ’{ "name":"John", "age":31, "city":"New York" }’; var myObj = JSON.parse(myJSON); document.getElementById(“demo”).innerHTML = myObj.name;
h"ps://www.w3schools.com/js/js_json_intro.asp
JSON • Javascript Object Notation • Similar to XML, but more restricted • Solved the need to exchange client/server data on web • Designed to ease marshalling/unmarshalling
• Example javascript (unmarshalling) Can now access named object fields
var myJSON = ’{ "name":"John", "age":31, "city":"New York" }’; var myObj = JSON.parse(myJSON); document.getElementById(“demo”).innerHTML = myObj.name;
h"ps://www.w3schools.com/js/js_json_intro.asp
JSON • Javascript Object Notation • Similar to XML, but more restricted • Solved the need to exchange client/server data on web • Designed to ease marshalling/unmarshalling Awesome! But we’re building apps in
• Example javascript (unmarshalling) java, not javascript …
var myJSON = ’{ "name":"John", "age":31, "city":"New York" }’; var myObj = JSON.parse(myJSON); document.getElementById(“demo”).innerHTML = myObj.name;
h"ps://www.w3schools.com/js/js_json_intro.asp
Firebase database • Map String paths to objects • “/users/$uid/” for uid “alovelace” might map to { }
Firebase database • Map String paths to objects • “/users/$uid/” for uid “alovelace” might map to { }
Keys can be defined by you, or by database via “push” "users": { "alovelace": { "name": "Ada Lovelace", "contacts": { "ghopper": true }, }, "ghopper": { ... }, "eclarke": { ... } }
Firebase database • Map String paths to objects • “/users/$uid/” for uid “alovelace” might map to { }