info systems fall 2012
Download
Skip this Video
Download Presentation
Info Systems Fall 2012

Loading in 2 Seconds...

play fullscreen
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
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