database driven web sites l.
Skip this Video
Loading SlideShow in 5 Seconds..
Database-Driven Web Sites PowerPoint Presentation
Download Presentation
Database-Driven Web Sites

Loading in 2 Seconds...

play fullscreen
1 / 25

Database-Driven Web Sites - PowerPoint PPT Presentation

  • Uploaded on

Database-Driven Web Sites Presented by Wei-Li Liaw Nov. 8 200 5 Overview 1. What is Database-Driven Website 2. W hy b uild a D b ase -driven Website ? 3 . Successful Story 4. What is Database 5. History of Database 6. D atabase choices 7 . IA and Dbase-driven Website

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

Database-Driven Web Sites

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
database driven web sites

Database-Driven Web Sites

Presented by Wei-Li Liaw

Nov. 8 2005

  • 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. IAand Dbase-driven Website
  • 8. Conclusion
  • 9. References
what is database driven website
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 web pages 1
Traditional Web Pages (1)

The data you want to store

traditional web pages 2
Traditional Web Pages (2)

Data is stored in the source code

w hy database driven website 1
Why database-drivenWebsite? (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
w hy database driven website 2
Why database-drivenWebsite? (2)

Example – Team Work

Users /

Web Visual Designers

Database Designers /

Web content managers



w hy database driven website 4
Why database-drivenWebsite? (4)
  • Sorting and Ranking

Using a relational database allows you to quickly and easily answer queries about prices, customers, or products.


successful story 1
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.


successful story 2
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


successful story 3
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


what is database
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
History of Database

1890 –

Herman Hollerith developed the world's first automated information processing equipment.

1960’s - The first database management systems were developed by Charles Bachman.

1980’s - The first commercial products, Oracle and DB2, did not appear until around 1980.

1970 - The relational model was proposed by E. F. Codd.

1990’s - innovation of Object-oriented database.

d atabase choices
Database Choices
  • IBM DB2
  • Oracle Database 10g
  • Microsoft SQL server
  • MySQL
  • And more….
d atabase choices the 2004 market share
Database Choices - the 2004 market share
  • 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
i nformation a rchitects and database driven website 1
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
i nformation architects and database driven website 2
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?
i nformation architects and database driven website 3
Information architects and Database-driven Website (3)
  • Database can provide faster access to data.

Let your users use this function easily

  • 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.
  • Build your own Database Driven Website using PHP & MySQL from
  • SQL Server 2005 Amid DBMS Market Dynamics from
  • Market share analysis from

  • IBM, Oracle Race for Database Dominance from,1759,1820629,00.asp

  • Database Growth Slower but Steady from

  • A Short Database History from

  • UNICCO enhances customer satisfaction with mobile workforce solution from IBM from

  • PHP & MySQL, Luke Welling and Laura Thomson
  • The Rise of Relational Databases from


Q & A

Thank You