Tools for

1
Tools for Webifying Databases

• Chet Seymour
• Melanie Rasmusson
• Scott Licht

2
Some Basics
Database Server

• Web Server

Need some standard method to present information
from the database on the web page
3
Geekiest

• PERL combined with modules
• DBIOracle, DBIMySQL, DBDODBC
• PHP Zend
• SOAP
• XML

4
PHP

• Hypertext Preprocessor
• lt?php function connectDb(user, pass, host,
  db)     //this function connects to a mysql
  server     sock mysql_connect(host, user,
  pass)          //this function connects to a
  mysql database, once a server has been reached.
      if(isset(sock))         if(!mysql_select_
  db(db, sock))             echo
  mysql_error()                   return
  sock //simple use of the function
  socket connectDb('bilbo','b_at_gg1ns','localhost'
  ,'test')
• //create an sql query sql "SELECT   FROM
  sample" //perform the query and return a
  resource identifier to query query
  mysql_query(sql, socket) //show all the data
  via a while loop while(data
  mysql_fetch_assoc(query))     //using
  foreach, list all the data that was returned in
  the data array from mysql_fetch_assoc
      foreach(data as key gt value)
          echo key.' '.value.'ltbrgt'     
      echo 'ltbrgt'
• ?gt   

5
PERL

• Practical Extraction and Report Language
• Modules for ODBC, DBI, DBH, DBD, various specific
  databases
• PERL itself cannot directly present its results
  on a web page reliant on HTML or XML
• VERY robust tools for incorporating data from
  multiple sources

6
ASP.NET Background

• Microsoft Product
• ASP Active Server Pages
• ASP.NET replaced the original ASP
• Relatively low cost 38.00

7
ASP.NET Ease of Use

• Compatible with a wide variety of programming
  languages.
• Classic ASP only supported VBScript and Jscript.
  ASP.NET supports more than 25 different
  languages, with no additional tools required.

8
ASP.NET Ease of Use

• Use far less code than classic ASP.
• Displaying data, validating user input, and
  uploading files are all easy.

9
ASP.NET Ease of Use

• ASP.NET pages work in all browsers.
• This includes Netscape, Opera, AOL, and of course
  Internet Explorer.

10
ASP.NET Ease of Use

• ASP.NET is compatible with any text editor.
• You can even support ASP.NET with Notepad.

11
ASP.NET Ease of Use

• Utilizes familiar drag-drop-double-click
  techniques.
• Built in code support includes statement
  completion and color-coding.

12
ASP.NET Ease of Use

• ASP.NET has a rich class framework.
• The framework offers over 4500 classes that
  encapsulate rich functionality like XML, data
  access, file upload, regular expressions, image
  generation, performance monitoring and logging,
  transactions message queuing, etc

13
ASP.NET Performance

• ASP.NET is fast.
• If you are used to using classic ASP, you will
  notice a 3 to 5 times increase in pages served.
• Microsoft claims 28x faster than Suns fully
  optimized J2EE.
• ASP.NET supported 7.6x as many users, was 28x
  faster, and only used 1/4th as much code as J2EE.
  This according to Microsofts web-site
  http//msdn.microsoft.com/library/default.asp?url
  /library/en-us/dnbda/html/bdasamppet.asp?frametru
  e

14
ASP.NET Performance

• No explicit compile step is required for ASP.NET
• ASP.NET eliminates Just hit save fears. It
  will automatically detect any changes,
  dynamically compile the files if needed, and
  store the compiled results to reuse for
  subsequent requests.

15
ASP.NET Performance

• ASP.NET session state lets you share session data
  across all the machines in your Web Farm.
• Also, now ASP.NET frameworks are face-threaded,
  so that you do not need to worry about thread
  relationships or affinity.

16
ASP.NET Reliability

• ASP.NET automatically recovers from errors like
  deadlocks and memory leaks.
• This automatic feature ensures your applications
  are always available to your users.

17
ASP.NET Ease of Deployment

• Simplified Application Installation
• Microsoft promises deployment of an entire
  application as easily as an HTML page.

18
ASP.NET Ease of Deployment

• Update with restarting the web-server
• ASP.NET promises dynamic updates of an
  application while its running.

19
ASP.NET Ease of Deployment

• Automatic Migration of Existing Applications
• ASP.NET runs on IIS side-by-side with classic ASP
  on Windows 2000 and Windows XP platforms.

20
Cold Fusion MX

• solution for rapidly building and deploying
  Internet applications and web services.

21
CF- What is it?

• It is a JAVA application
• Program that runs on a server
• A scripting language designed specifically for
  web applications development
• CFML HTML Action Script
• Used for low level internet programming tasks
• Build using macromedia Dreamweaver MX

22
CF 4 Built in Engines

• Verity full text search engine for rapid searches
• Charting engine allows charting and delivery of
  business graphics
• Flash remoting for exchange of data
• Web services engine for publishing of web
  services

23
CF Data Connectivity

• Connectivity to JDBC/ODBC databases
• Integration with Legacy system data through web
  services or industry standard interfaces
  COM,CORBA, or JAVA
• Easily connect to any database or directory
• J2EE architecture gives freedom and flexibility
  to choose the environment for applications
• Offers broad OS support such as Windows, Linux,
  Solaris, HP and others

24
CF Deployment Options

• Can be installed in multiple configurations
• Integrated servers
• Enterprise JAVA applications
• Allows for isolated applications in separate
  processes on same server
• Benefit problems with one application do not
  hinder another

25
CF Performance Scalability

• Unlike PHP and ASP which are interpreted
• Runs as compiled JAVA byte code
• Increases speed for run time

26
PHP vs. ASP vs. Cold Fusion
PHP ASP Cold Fusion
Geek Coefficient High Medium Low
Platform Specific Low Medium High
Price Low Medium High
Setup Cost High Medium Low
Maintenance Cost High Medium Low
27
So why isnt every web site in the world using
Cold Fusion?

• Legacy applications
• Legacy knowledge and comfort level
• Mind set LAMP(P)
• Market share
• Initial cost

28
Questions?