Info systems fall 2012
Download
1 / 11

Info Systems Fall 2012 - PowerPoint PPT Presentation


  • 103 Views
  • Uploaded on

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

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

PowerPoint Slideshow about ' Info Systems Fall 2012' - nowles


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
Info systems fall 2012
Info SystemsFall 2012


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

  • We will look atMySQLSQLPHP ... first

  • NoSQL DBsMongo and GUIs for itMaybe HBase, Cassandra ... second


The modern role of often not so modern database technology1
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 technology2
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 technology3
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


The modern role of often not so modern database technology4
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 technology5
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 technology6
The modern role of often not-so-modern database technology

  • Class blog: http://rogerking.me

  • [email protected]

  • 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 technology7
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


Not required text
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 technology8
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...


ad