20th entry - SQL Syntax

SQL syntax is easy to understand and learn. This is because SQL syntax is in English. Because it is in English, it does not require user to remember much about the command syntax to query for an operation in SQL. Below are some SQL syntax example referring from W3Schools (2007);

SELECT lastName FROM Persons

INSERT INTO table_name (col1, col2, ...)

UPDATE table_name
SET column_name = col_name
WHERE col_name = value

DELETE FROM table_name
WHERE col_name = value

Above the syntax example are the basic command such as SELECT, UPDATE, INSERT, DELETE and many more.

Reference
W3Schools (2007), "SQL Tutorial", http://www.w3schools.com/sql/default.asp

19th entry - Case study, Frienster + MySQL = result?

As Friendster chooses MySQL according to MySQL AB (2007) network as their databasde management application, they see the result and benefit as they implement MySQL to their server.

The performance of the Friendster server trasnmission bandwidth improved tremendously. Their bandwidth had improved so much that even transaction query up to a billion, the server respond to the client are much more faster and 'lighter'.

With MySQL, their server are being optimized and uptime at all time for reliability, without affecting their servers as maintenance take place or any emergency fail over purposes.

Their server are extensible, where they able to expand their system servers with the open source code flexibility that MySQL provided.

Friendster able to scale out their databases infrastructure with easy integration with open, less expensive components. They only need purchase hardware and software that are affordable to expand their servers system and by doing so with MySQL, it allowing Friendster to save million of dollars.

Friendster's staff able to access to the MySQL knowledge and senior technical advisors. With such services provided my MySQL, it enable Friendster's staff to able to operate the MySQL network much more easier and faster.

Reference
MySQL (2005), "mysql-friendster-casestudy.pdf (application/pdf Object)",
http://www.mysql.com/why-mysql/
case-studies/mysql-friendster-casestudy.pdf