MakingDatabaseWebAccessible.pptVIP

Making Database Web Accessible Track 3 - Basic Course in Database Learning Objectives: At the end of the session, you should be able to: Understand the concepts and technology in Web-accessible databases Name the tools used to make a database accessible to the WWW Database Application Architecture the power of a database is realized in the tools that use it -Yarger 1999 Client/Server A sample database application architecture using WWW/Internet . The server computer that uses a Unix operating system contains the following programs: Apache, a Web server program that administers requests for HTML pages; HTML output generated by the Perl script… !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN /TR/html4/loose.dtd HTMLHEADTITLEContactPerson List generated with Perl/CGI /TITLE /HEADBODYTABLE BORDERTRTH COLSPAN=3List of Contact Person/TH/TR TRTHTitle/THTHFirst Name/THTHLast Name/TH/TR TRTDMs./TDTDRhona/TDTDBautista/TD/TR TRTDMs./TDTDSarah/TDTDEscandor/TD/TR TRTDMadam/TDTDZailan/TDTDKamaruddin/TD/TR /TABLE/BODY/HTML And this is how it looks like on a browser… What do you need to carry out this Web database solution? .An Internet connection. .A Web server. .A DBMS (perhaps MySQL ? ). .Additional applications installed in your Web server such as: Perl 5.x which can be downloaded from the Perl site at DBI/DBD module which can be downloaded from the Comprehensive Perl Archive Network (CPAN) site at /CPAN/authors/id/TIMB/DBI/DBI-1.06.tar.gz Data::ShowTable which is a module that simplifies the act of displaying large amounts of data needed for Mysql modules. It can be downloaded from /CPAN/authors/id/AKSTE/Data-ShowTable-3.3.tar.gz .Somebody with a knowledge of HTML and CGI/Perl programming . Sample sites using WebDB solutions in the Womens Network: AWORC Multi-lingual Search Database (Demo). URL: /aworc/search/search.html European Database: Women in Decision-Making. The European Database - Women in Decision-Making provides information about women in