GUI Architectures

http://martinfowler.com/eaaDev/uiArchs.html

What is Index (database)?

http://en.wikipedia.org/wiki/Index_(database)

A database index is a data structure that improve the speed of operations in the table. Indexes can be created using one or more columns, providing the basis of both rapid random lookups and efficient ordering of access to records.

Architecture
Clustered or non-Clustered.

Column Order
Is very important.

Applications and limitations
reverse(email_address);

Types
Bitmap
Dense
Sparse

What is Foriegn Key?

The foreign key is a field in a relational table that matches a primary key column of another table. Foreign key can be used to cross-reference tables.

What is Primary Key?

The primary key of a relational table uniquely identifies each record in the table. It can either be a normal attribute that is guaranteed to be unique, or generated by the DBMS. Primary key may consist of a single attribute or multiple attributes in combination.

IMG_6028_m

http://www.flickr.com/photos/rainee007/532845721/

http://www.flickr.com/photos/rainee007/532845723/

http://www.flickr.com/photos/rainee007/525963592/

IMG_6028_m, originally uploaded by Ren Jun.

Feeding birds by Joondalup lake park.

IMG_6587

IMG_6587, originally uploaded by Ren Jun.

Happy time.

Happy boy in oz summer

IMG_6595, originally uploaded by Ren Jun.

IMG_6592

IMG_6592, originally uploaded by Ren Jun.

Happy day!

Flickr

This is a test post from , a fancy photo sharing thing.