RDBMS1.Relational data base managem

RDBMS
1.Relational data base management system
2.Relational databases introduced by E. F. Codd
Relational Database
1.data stored in tables
2.relationships among data stored in tables
3.data can be accessed and viewed indifferent ways

SQL and SQLite
1. Structured Query Language
programming language to manage data in a RDBMS
2. SQLite implements most, but not all of SQL
http://www.sqlite.org/

1. SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
2. SQLite is the most widely deployed SQL database engine in the world.
3. The source code for SQLite is in the public domain.
4. Databases created with applications are accessible by name to all classes in application, but no outside application

SQL and Database
1. SQL is the language used to manipulate and manage information in a relational database management system (RDBMS)
2. SQL Commands (DDL):
CREATE TABLE - creates a new database table
ALTER TABLE - alters a database table
DROP TABLE - deletes a database table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index

SQL Commands
1. SELECT - get data from a database table
2. UPDATE - change data in a database table
3. DELETE - remove data from a database table
4. INSERT INTO - insert new data in a database table

Buatlah database
1. create subclass of SQLiteOpenHelper
2. Write the statement to manage all the tables
3. To use SQLiteOpenHelper, create a subclass that overrides the onCreate(), onUpgrade() and onOpen() callback methods. You may also want to implement onDowngrade(), but it's not required.
4. Write the statement to manage all the tables
5. Instantiate the subclass of SQLiteOpenHelper
6. Put data into database

Inserting Data
1. ContentValues: object with key/value pairs that are used when inserting/updating databases
2. Each ContentValue object corresponds to one row in a table
3. _id being added and incremented automatically

Cursors
1. When you execute a query on a database in Android, you get a Cursor back
http://developer.android.com/reference/android/database/Cursor.html
2. "Cursor provided random [access] read-write access to the result of a query"
3. Commonly used in other database implementations / models

Cursor
1. find out number of rows in result with getCount()
2. iterate over rows moveToFirst(), moveToNext(0)
3. determine column names with getColumnNames()
4. get values for current row
5. To use all the data …
6. wrap the Cursor in a SimpleCursorAdapter
7. pass the Adapter to a ListView or other view to handle lots of data
8. NOTE: result must contain and integer column named _ID that is unique for the result set used as id for row in ListView

Delete Information from Database
To delete rows from a table, you need to provide selection criteria that identify the rows. The database API provides a mechanism for creating selection criteria that protects against SQL injection. The mechanism divides the selection specification into a selection clause and selection arguments. The clause defines the columns to look at, and also allows you to combine column tests. The arguments are values to test against that are bound into the clause. Because the result isn't handled the same as a regular SQL statement, it is immune to SQL injection.

Update a database
1. When you need to modify a subset of your database values, use the update() method.
2. Updating the table combines the content values syntax of insert() with the where syntax of delete().

Results (Indonesian) 1:

RDBMS1.Relational data base management system2.Relational databases introduced by E. F. CoddRelational Database1.data stored in tables2.relationships among data stored in tables3.data can be accessed and viewed in different ways SQL and SQLite1. Structured Query Languageprogramming language to manage data in a RDBMS2. SQLite implements most, but not all of SQLhttp://www.sqlite.org/1. SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. 2. SQLite is the most widely deployed SQL database engine in the world. 3. The source code for SQLite is in the public domain.4. Databases created with applications are accessible by name to all classes in application, but no outside applicationSQL and Database1. SQL is the language used to manipulate and manage information in a relational database management system (RDBMS)2. SQL Commands (DDL):CREATE TABLE - creates a new database table ALTER TABLE - alters a database table DROP TABLE - deletes a database table CREATE INDEX - creates an index (search key) DROP INDEX - deletes an index SQL Commands1. SELECT - get data from a database table 2. UPDATE - change data in a database table 3. DELETE - remove data from a database table 4. INSERT INTO - insert new data in a database table Buatlah database1. create subclass of SQLiteOpenHelper 2. Write the statement to manage all the tables3. To use SQLiteOpenHelper, create a subclass that overrides the onCreate(), onUpgrade() and onOpen() callback methods. You may also want to implement onDowngrade(), but it's not required.4. Write the statement to manage all the tables5. Instantiate the subclass of SQLiteOpenHelper6. Put data into databaseInserting Data1. ContentValues: object with key/value pairs that are used when inserting/updating databases2. Each ContentValue object corresponds to one row in a table3. _id being added and incremented automaticallyCursors1. When you execute a query on a database in Android, you get a Cursor backhttp://developer.android.com/reference/android/database/Cursor.html2. "Cursor provided random [access] read-write access to the result of a query"3. Commonly used in other database implementations / modelsCursor1. find out number of rows in result with getCount()2. iterate over rows moveToFirst(), moveToNext(0)3. determine column names with getColumnNames()4. get values for current row5. To use all the data …6. wrap the Cursor in a SimpleCursorAdapter7. pass the Adapter to a ListView or other view to handle lots of data8. NOTE: result must contain and integer column named _ID that is unique for the result set used as id for row in ListViewDelete Information from DatabaseUntuk menghapus baris dari tabel, Anda perlu menyediakan kriteria seleksi yang mengidentifikasi baris. Database API menyediakan sebuah mekanisme untuk menciptakan kriteria seleksi yang melindungi terhadap SQL injection. Mekanisme membagi spesifikasi pilihan dalam klausul seleksi dan pemilihan argumen. Klausa mendefinisikan kolom untuk melihat, dan juga memungkinkan Anda untuk menggabungkan kolom tes. Argumen adalah nilai untuk menguji melawan yang terikat ke dalam klausa. Karena hasil tidak ditangani sama seperti sebuah statement SQL yang biasa, tidak kebal terhadap SQL injection.Update database1. ketika Anda perlu untuk memodifikasi sebuah subset dari nilai-nilai database Anda, menggunakan method update() akan membuat.2. memperbarui tabel menggabungkan sintaks nilai-nilai konten insert() dengan mana sintaks delete().