From: mhillyer Date: March 2 2006 5:45am Subject: svn commit - mysqldoc@docsrva: r1480 - trunk/sample-data/sakila List-Archive: http://lists.mysql.com/commits/3361 Message-Id: <200603020545.k225jJUY027576@docsrva.mysql.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Author: mhillyer Date: 2006-03-02 06:45:18 +0100 (Thu, 02 Mar 2006) New Revision: 1480 Log: Begin work on Sakila sample DB documentation. Added: trunk/sample-data/sakila/sakila.ent trunk/sample-data/sakila/sakila.xml Added: trunk/sample-data/sakila/sakila.ent =================================================================== --- trunk/sample-data/sakila/sakila.ent 2006-03-02 02:09:28 UTC (rev 1479) +++ trunk/sample-data/sakila/sakila.ent 2006-03-02 05:45:18 UTC (rev 1480) @@ -0,0 +1,2 @@ + + Added: trunk/sample-data/sakila/sakila.xml =================================================================== --- trunk/sample-data/sakila/sakila.xml 2006-03-02 02:09:28 UTC (rev 1479) +++ trunk/sample-data/sakila/sakila.xml 2006-03-02 05:45:18 UTC (rev 1480) @@ -0,0 +1,193 @@ + + + %sakila.entities; + ]> +
+ +
+ + Introduction + + + This document describes the &sampdb; sample database -- its + history, installation, structure and usage. + + + + The &sampdb; sample database is developed and maintained by Mike + Hillyer of the MySQL AB documentation team and is intended to + provide a standard schema that can be used for examples in books, + tutorials, articles, samples, etc. The &sampdb; sample database + also serves to highlight the latest features of MySQL including + Views, Stored Procedures, Triggers, etc. + + + + The &sampdb; sample database is the result of support and feedback + from the MySQL user community and feedback and user input is + always appreciated. Please direct all feedback to docs@stripped + + + Additional information on the &sampdb;ample database and + its usage can be found through the MySQL forums. +
+ +
+ + History + + + The &sampdb; was designed as a replacement to the + World + sample database, also provided by MySQL AB. + + + + The World sample database provides a set of tables containing + information on the countries and cities of the world and is useful + for basic queries, but lacked structures for testing + MySQL-specific functionality and new features found in MySQL 5. + + + + Development of the &sampdb; sample database began in early 2005 + . Early designs were based on the database used in the Dell + Whitepaper + Three + Approaches to MySQL Applications on Dell PowerEdge + Servers. + + + + Where Dell's sample database was designed to represent an online + DVD store, the &sampdb; sample database is designed to represent + a DVD rental store. The &sampdb; sample database still borrows + film and actor names from the Dell sample database. + + + + Development was accomplished using MySQL Query Browser for + schema design with the tables being populated by a combination + of MySQL Query Browser and custom scripts, in addition to + contributor efforts (see ). + + + After the basic schema was completed, various views, stored + routines, and triggers were added to the schema, after which + the sample data was populated. After a series of review + versions, the first official version of the &sampdb; sample + database was released in March 2006. +
+ +
+ Installation + + Fill +
+ +
+ Structure + +
+ Tables +
+ +
+ Views +
+ +
+ Stored Procedures +
+ +
+ Stored Functions +
+ +
+ Triggers +
+ +
+ +
+ Usage Exampled +
+ +
+ + Acknowledgements + + + The following individuals and organizations have contributed to + the development of the Sakila sample database. + + + + + + + Roland Bouman, + Author - + Provided valuable feedback throughout the development process. + + + + + + Ronald Bradford, + Developer + - Developed + first sample + application for use with the &sampdb; sample + database. + + + + + + Dave Jaffe, Dell - Provided schema used in + Dell whitepaper and secured permission to use parts thereof in + &sampdb; sample database. + + + + + + Giuseppe Maxia, CTO of + Stardata + - Provided valuable feedback throughout the development + process, populated some of the sample data, provided some of + the sample views and triggers. + + + + + + Jay Pipes, + MySQL Community + Advocate - Provided some of the sample stored + procedures. + + + + + + + In addition to the individuals mentioned above, there are various + individuals in MySQL AB and the community that have provided + feedback during the course of development. + + +
+ + + +