buzzking@ymail.com

burnwholeInternet και Εφαρμογές Web

5 Φεβ 2013 (πριν από 4 χρόνια και 5 μήνες)

201 εμφανίσεις



Info Systems

Fall 2012




The modern role of often not
-
so
-
modern database technology


We will look at

MySQL

SQL

PHP ... first


NoSQL DBs

Mongo and GUIs for it

Maybe HBase, Cassandra ... second

The modern role of often not
-
so
-
modern database technology


Web apps and databases



Why are web apps still mostly SQL
-
based?


...For that matter, the same with non
-
C/S apps...


Traditional PHP and MySQL apps


Web development frameworks


Grails, Rails


MVC environments


...And the way they hide the DB...


HTML DB
-
centric desktop apps


Like
Griffen

The modern role of often not
-
so
-
modern database technology


New client
-
side technology



HTML 5


Local, client
-
side DB support


Canvas for graphics


...is Adobe Flash Builder and Silverlight dead?


...and what about
JavaFX
?


Polyglot sites and apps, and leveraging traditional technologies


JavaScript and
JQuery

in Rails, etc.


When to use what kind of DB and development framework


It is a mistake to separate these

The modern role of often not
-
so
-
modern database technology


Newer software development tools
-

IDEs and editors


Jet Brains


IntelliJ

for Grails


Ruby Mine for Rails


PHP Storm for PHP and SQL


Active State Komodo for lighter weight approach


Free technologies


Aptana


Spring Tools

The modern role of often not
-
so
-
modern database technology


Assignments
-

multiple, small projects


Done partly in class


In groups if you want


We will minimize code writing


Attendance required


Bring your notebook


You will install software and work with real stuff


First to install
-

a web stack with PHP and MySQL


XAMPP, WAMP or MAMP, or
Bitnami


Watch out
-

often Mac stacks are dated, with old
MySQLs


Exams
-

2 on abstract material

The modern role of often not
-
so
-
modern database technology


Abstract and semi
-
formal stuff will be alternated with practical material


Relational model and transactions


Stored procedures and triggers


Distributed DBs and heterogeneous DBs


XML and DBs


OO and OR DBs


... And more

The modern role of often not
-
so
-
modern database technology



Class blog:
http://rogerking.me


buzzking@ymail.com


303 437 7419


Skype:
rogerbuzzking

-

but email or phone in advance,
as I do not stay on Skype


The modern role of often not
-
so
-
modern database technology


Books:
Murach

MySQL and PHP & MySQL

http://www.amazon.com/Murachs
-
PHP
-
MySQL
-
Murach
-
Reference/dp/1890774561/ref=sr_1_1?s=books&ie=UTF8&qid=1343868487&sr=1
-
1&keywords=murach+php+mysql


http://
www.amazon.com/Murachs
-
MySQL
-
Joel
-
Murach/dp/1890774685/ref=sr_1_3?s=books&ie=UTF8&qid=1343868487&sr=1
-
3&keywords=murach+php+mysql


If you want a firmer foundation:


http://
www.amazon.com/Database
-
Systems
-
Application
-
Oriented
-
Approach/dp/0321268458/ref=sr_1_fkmr0_1?ie=UTF8&qid=1343868217&sr=8
-
1
-
fkmr0&keywords=Bernstein+kifer+Lewis+database


There will
be
posted slides on class website

Not required text


http://www.amazon.com/Database
-
Systems
-
Application
-
Oriented
-
Approach/dp/0321268458/ref=sr_1_1?s=
books&ie=UTF8&qid=1345840274&sr=1
-
1&keywords=kifer+lewis+bernstein

The modern role of often not
-
so
-
modern database technology


In sum: a hands
-
on class with a conceptual substructure


"exposure" projects
-

for total of 60% of final grade


2 exams on material presented in class and in
Murach

books
-

20% each
for final grade


Attendance required


Focus on breadth and the future


A big change from versions of this class in previous years...