If it has a plug, it's IT stuff

Aug 29 2008   1:11PM GMT

[TLBAT] Intranet: The database behind

alessandro.panzetta Alessandro Panzetta Profile: alessandro.panzetta

As described in the last post, the Download Center relies on a Microsoft Access database that will be described in this post.

So, first create a new MSAccess database and then create a table called “Packages” like the following:

ID PackageDesc PackageName PackageType NeededGroup

ID:         Auto increment

PackageDesc:    Contains a short description of the file (E.g. Microsoft FrontPage)

PackageName:    Is the filename, avoid using spaces (E.g. “MSaccess.exe” better than “MS Access.exe”) because this will be used to construct the download link

PackageType:    Can be Special or Standard or Goodie. Standard/Goodie will be available for download to everyone while Special will be only for the users that are members of given groups.

NeededGroup:    In case of Special package the visiting user must be part of this group in order to download the package.

Then create another table called “Sites” as the following:

Country Subnet Distrib_Point

Country:    Short name of the Country (E.g. ITA=Italy, GER=Germany)

Subnet:        The third octet of the country/site’s IP address range (E.g. ITA= 192.168.39.x)

Distrib_Point:    The web server in the given country (E.g. websrv_ITA)

The first table will handle information on the packages themselves and whether they’re freely accessible or not; the second table instead will be used in order to redirect the user to his/her local web server in order to save bandwidth. This is applicable only in environments in which the IP subnets are correctly set for country level and where in every country or site there is a local IIS web site.

In the next post I’ll be showing you how to build the homepage for this site and the techniques used for it….keep on reading!

 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: