database driven web sites l.
Download
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


  • 243 Views
  • 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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
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

overview
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. 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

------

Interaction

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.

Examples: www.ebay.com

www.google.com

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.

Resource: http://www.ibm.com

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

Resource: http://www.ibm.com

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

Resource: http://www.ibm.com

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

conclusion
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
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 fromhttp://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

slide25

Q & A

Thank You