Intranet client/server application for Club IAG
An Intranet is the implementation of inexpensive Internet technology
providing facilities to do document search, retrieval and display,
electronic mail, and group collaboration. It allows to gather and share
the information instead of platforms diversity because TCP/IP is a very portable
technology.
Intranets can also be connected to existing data base
systems to retrieve information easily and graphically.
An Intranet is used by a limited number of people and can be
connected to the world-wide Internet, if desired.
The Club IAG, student association of
the IAG school of management,
owns a Pentium 133MhZ on which is already running an Internet Web Server.
After analyzing the activities of the association in regard with
the background in Internet technologies and the limited budget available,
I found it could be tremendous to develop an Intranet for three
applications in this order:
- keep available working documents for people involved in projects in a restricted access directory on the WWW;
- collect quickly standardized resumes of students for the CV-Book throughout a form even if they are abroad in exchange program;
- improve stock control of the Course Notes Shop thanks to an ordering form coupled with real time informations about available syllabi and stocks level.
Available hardware and software features
The idea is to build an Intranet based on available material. The
easiest and fastest way is to take advantage of TCP/IP overlay and HTTPd Server that are
already running.
The first step of the Intranet project was to be easily realized by manipulating
the server administrator options, but the second and tird steps require to set up a link
between the server and two databases (students and syllabi). This link
has to respect the following architecture :
HARDWARE
|
- Intel Pentium 133MhZ
- 32MB EDO RAM
- Hard-drives : 1.2GB and 2.5GB (for data)
- Backup unit : HP colorado 600
- 2MB graphic card (Matrox millenium)
|
SOFTWARE
|
- Operating System : Windows 95 migrating to NT 4.0
- Database : MS Access 7.0 (ODBC installed)
- Visual Basic 4.0 Pro
|
INTERNET
|
- Ethernet Card (10Mbits) and TCP/IP connectivity
- HTTPdaemon : Website 1.1e
- FTPdaemon : War-FTPDaemon
- Browsers : Netscape 3.1 and IExplorer 3.0
|
Note : I installed War-FTPD because it is the most complete FTP freeware server and
website because it supports Visual Basic 4.0 CGIs and is free for academic use.
In addition these softwares are 32bits, powerful, scalable on the system and highly configurable.
Website 1.1e + Cold Fusion 2.0 + MS Access 7.0
At first look, it seems that the best solution might be programming CGIs
in Visual Basic. VB is an easy object oriented language fully compatible with
MS Access 7.0 and Win95 (all are released by Microsoft). In addition, WebSite supports
VB CGIs thanks to its CGI32.BAS.
Actually, VB 4.0 was designed before Internet booming and is not really Internet oriented.
So, coding effort is important and you need to recompile every time you
make a modification of HTML code included in CGI or an enhancement of the
capabilities of the script.
Big Internet/Intranet systems use Informix or Oracle
to manage databases with SQL language, but theses systems are too expensive.
Seeking for similar product, I found the
new released Cold Fusion 2.0.
Its requirements are adapted to the existing architecture.
With Cold Fusion, we can create a wide variety of HTML
dynamic pages called CFML pages in reference to CF. Pages are text merging
HTML and CF tags. The new workflow explain you how to come into the system in
order to enhance it.
Cold Fusion encapsulates SQL queries in HTML pages
like Informix but for only $500.
On one side, CFML pages need little programming knowledge, are easy to develop
and very portable.
If you change from relational database, server... to another, it always works! But on the
other side, it is slow (compiled every time), server side oriented and there is no user friendly
interface to write CFML codes.
|