1 / 11

Info Systems Fall 2012

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

nowles
Download Presentation

Info Systems Fall 2012

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Info SystemsFall 2012

  2. The modern role of often not-so-modern database technology • We will look atMySQLSQLPHP ... first • NoSQL DBsMongo and GUIs for itMaybe HBase, Cassandra ... second

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

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

  5. The modern role of often not-so-modern database technology • Newer software development tools - IDEs and editors • Jet BrainsIntelliJ for Grails Ruby Mine for Rails PHP Storm for PHP and SQL • Active State Komodo for lighter weight approach • Free technologiesAptana Spring Tools

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

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

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

  9. The modern role of often not-so-modern database technology • Books: Murach MySQL and PHP & MySQLhttp://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+mysqlhttp://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

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

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

More Related