what data-driven websites are and how they work

WHAT DATA-DRIVEN

WEBSITES AREAND HOW THEY WORKAn introduction to database driven websites and why they are

important for websites today

Start Here

TESSA MERO * APRIL 2015

TOPICS

DATA-DRIVEN WEBSITES * APRIL 2015

01

02

03

04

05

HOW IS IT USED?

DATABASES! EXPLAIN PLZ?

STATIC VS DYNAMIC, WHAT?

EXAMPLES

CONCLUSION

STATIC WEBSITE – NOTHING CHANGES

DYNAMIC WEBSITE – UPDATES ON REFRESH< - >

DATA-DRIVEN WEBSITES * APRIL 2015

STATIC VS DYNAMIC

STATIC WEBSITES

DATA-DRIVEN WEBSITES * APRIL 2015

What is a static website? • Stores Content in Web File

• Doesn’t Change

• “Brochure” website

• Need data changed? - Hire web dev

DYNAMIC WEBSITES

DATA-DRIVEN WEBSITES * APRIL 2015

What is a dynamic website? • Content Stored Outside of Website

• DATABASE!

• Manipulate data fast

• Examples of Dynamic Sites?

Content Management Systems are all database driven, which allows users to edit their pages on the frontend of their site!

DATA-DRIVEN WEBSITES * APRIL 2015

Dynamically change the information on your products.

Update/edit/delete content on the fly!

CMS’S

E-COMMERCE

BLOGS/FORUMS

If you are on a car website searching for a vehicle, or a ordering something on a website, you need to filter data, which requires data being stored in a database.

FILTERING DATA

MORE DYNAMIC!

TOPICS

DATA-DRIVEN WEBSITES * APRIL 2015

01

02

03

04

05

HOW IS IT USED?

DATABASES! EXPLAIN PLZ?

STATIC VS DYNAMIC, WHAT?

EXAMPLES

CONCLUSION

DATA-DRIVEN WEBSITES * APRIL 2015

82%

PHP

17%

ASP.NET

2.9% JAVA

0.7%

COLDFUSION

0.6% RUBY

(Some) Programming languages that pull the data from the database!

PHP powers 82% of database driven websites!

PROGRAMMING!

DATABASES!

OracleMySQLMS SQLMongoDB

1446ORACLE

1284MySQL

1149MICROSOFT SQL

279MONGODB

DATA-DRIVEN WEBSITES * APRIL 2015

This is an updated rank score that updates live on a monthly basis as of April 2015. Calculations based on jobs available, websites used, mentions on websites, tech discussion, linkedin searchSource: db-engines.com/en/ranking

THE PROCESS

Client Server DB to Server HTML!

The client (computer) reaches into the server (sends http request and gets

response)

The server requests data from database.

Process the results to browser (converts into HTML)

DATA-DRIVEN WEBSITES * APRIL 2015

Programming Language + Databases

• STATIC PAGES DO NOT CHANGE.

• DYNAMIC PAGES CHANGE ON REFRESH

• DATA DRIVEN SITES ARE ACTUALLY DATABASE DRIVEN SITES

• ORACLE AND MYSQL ARE THE MOST POPULAR DATABASES

• SERVER SIDE SCRIPTING LANGUAGES PULL THE DATA FROM THE DATABASE

• PHP AND MYSQL MAKES A DATABASE DRIVEN SITE!!!

MYSQL

DATA-DRIVEN WEBSITES * APRIL 2015

SUMMARY

PHP

TOPICS

DATA-DRIVEN WEBSITES * APRIL 2015

01

02

03

04

05

HOW IS IT USED?

DATABASES! EXPLAIN PLZ?

STATIC VS DYNAMIC, WHAT?

EXAMPLES

CONCLUSION

BENEFITS OF A DB

DATA-DRIVEN WEBSITES * APRIL 2015

Easy and quick to add new content

Change/Add new products on e-commerce siteGive search ability on websites

Create engaging sites, such as blogs, forums, and social networking sites

REDUCES COSTS!

TOPICS

DATA-DRIVEN WEBSITES * APRIL 2015

01

02

03

04

05

HOW IS IT USED?

DATABASES! EXPLAIN PLZ?

STATIC VS DYNAMIC, WHAT?

EXAMPLES

CONCLUSION

DATA-DRIVEN WEBSITES * APRIL 2015

DATA-DRIVEN WEBSITES * APRIL 2015

DATA-DRIVEN WEBSITES * APRIL 2015

DATA-DRIVEN WEBSITES * APRIL 2015

DATA-DRIVEN WEBSITES * APRIL 2015

TOPICS

DATA-DRIVEN WEBSITES * APRIL 2015

01

02

03

04

05

HOW IS IT USED?

DATABASES! EXPLAIN PLZ?

STATIC VS DYNAMIC, WHAT?

EXAMPLES

CONCLUSION

DATA-DRIVEN WEBSITES * APRIL 2015

WEBSITESMost websites are data driven

CONCLUSION

DB & SCRIPTINGAll data-driven sites come

from a database engine and server side scripting

PLANNINGEven if you plan on not changing content on a proposed static site, it’s best practice to use a DB so you can easily update information.

ANYQUESTIONS?

SLIDES WILL ALWAYS BE UPLOADED TO THE CANVAS COURSE AFTERWARDS

DATA-DRIVEN WEBSITES * APRIL 2015