Transcript Database-Driven Web Sites

Database-Driven Web Sites
Presented by Wei-Li Liaw
Nov. 8 2005
Overview
•
•
•
•
•
•
•
•
•
1. What is Database-Driven Website
2. Why build a Dbase-driven Website?
3. Successful Story
4. What is Database
5. History of Database
6. Database choices
7. IA and Dbase-driven Website
8. Conclusion
9. References
What is Database-Driven Website
• A database-driven Web site is a Web site
that uses a database to gather, display, or
manipulate information
Traditional
Html Pages
V.S.
Database-driven
Website
Html Website
DatabaseDriven Website
Where do you store
your data
.html files
Database Tables
How to store your
data
Static
Dynamic
( in real time)
Maintenance
Hard (If you have
many pages)
Easy
Traditional Web Pages (1)
The data you want to store
Traditional Web Pages (2)
Data is stored in the source code
Traditional Web Pages (3)
Why database-driven Website? (1)
• Content is king !!
• Achieving complete separation
between your site's design and the
content you want to present.
• Interaction in real time
• Sorting and Ranking
Why database-driven Website? (2)
Example – Team Work
Users /
Database Designers /
------
Web Visual Designers
Web content managers
Interaction
Why database-driven Website? (3)
Example - Blog
Why database-driven Website? (4)
• Sorting and Ranking
Using a relational database
allows you to quickly and
easily answer queries about
prices, customers, or products.
Examples: www.ebay.com
www.google.com
Successful Story (1)
• Overview
One of the largest facilities maintenance
providers in North America, UNICCO
Service Company (UNICCO) has built its
success on long-term customer loyalty,
earning a 95 percent customer retention
rate. As the industry became increasingly
competitive, UNICCO realized that, to
maintain its high customer retention rate,
it needed to provide its field force with
more sophisticated tools to accelerate the
flow of information.
Resource: http://www.ibm.com
Successful Story (2)
• Website need:
Speed up the flow of information on results
of facilities inspections to improve customer
satisfaction and increase business.
• User’s Opinion:
” (With Database) we’ll be able to continuously
improve our quality with tested, proven and
secure technology.”
- Bilal Khokhar, Development Manager of Field
Applications, UNICCO
Resource: http://www.ibm.com
Successful Story (3)
• 70% to 80% savings in deployment
costs…..;
• ….95% customer retention rate
from integration of the handheld
with corporate data stores;
improved customer satisfaction
Resource: http://www.ibm.com
What is Database
• Definition
A database is an organized collection
of information records that can be
accessed electronically. In the Library
this includes indexing and abstracting
databases, citation databases or
databases of full text journal articles.
History of Database
1890
– -1960’s
- 1980’s
The
first
- The first
1970
- The
1990’s
innovation
database
commercial
relational
model
of Object-oriented
Herman
Hollerith
developed
the
management
Oracle
wasproducts,
proposed
by E.
database.
world's
first
automated
information
systems
wereDB2, did not
and
F. Codd.
processing
equipment.
developed
by until
appear
Charles around
Bachman.
1980.
Database Choices
•
•
•
•
•
IBM DB2
Oracle Database 10g
Microsoft SQL server
MySQL
And more….
Database Choices
- the 2004 market share
Others
12.2%
IBM
34.1%
M$ 20%
Oracle
33.7%
IBM
Oracle
M$
Others
• Total : $7.8 billion
U.S dollars
• The database market
grew by 10.3 percent
in 2004
• According to
numbers released by
the Gartner Inc. in
May 2005
Information Architects and
Database-driven Website (1)
• Good design principles of
Database reduce the
maintenance cost.
• Good designs of IA lead to
better reliability and
performance.
• Combining Database with IA
Information architects and
Database-driven Website (2)
• What you want to achieve with
you website?
• Who is your target users?
• How many users?
• What kind of database is
suitable for you?
Information architects and
Database-driven Website (3)
• Database can provide faster access
to data.
Let your users use this function easily
Information Architects and
Database-driven Website (4)
Efficient Sorting
Conclusion
• Provide useful information.
• Good presentation.
• Answering feedback generated
by the site.
• Not allowing a site to age.
• Tracking the success of the site.
• Maintaining your database.
References
•
•
•
•
•
•
•
•
•
Build your own Database Driven Website using PHP & MySQL
from http://www.sitepoint.com/article/php-mysql-tutorial
SQL Server 2005 Amid DBMS Market Dynamics from
http://www.ftponline.com/wss/2004_12/magazine/columns/trends/
Market share analysis from
http://www.olapreport.com/Market.htm
IBM, Oracle Race for Database Dominance from
http://www.eweek.com/article2/0,1759,1820629,00.asp
Database Growth Slower but Steady from
http://www.thestreet.com/tech/hardware/10225286.html
A Short Database History from
http://math.hws.edu/vaughn/cpsc/343/2003/history.html
UNICCO enhances customer satisfaction with mobile workforce
solution from IBM from
http://www-306.ibm.com/
PHP & MySQL, Luke Welling and Laura Thomson
The Rise of Relational Databases from
http://www.nap.edu/readingroom/books/far/ch6.html
Q&A
Thank You