Re: WC Database Format

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 10333
interpreted = N
texte = >Our sked has about 700 classes offered over 2,400 ways: i.e., 700 >records with VARYING total-field info per line. Some have add'l fees, >some don't; some have prerequisites, some don't. Some are taught at any >or all of our 5 main campuses, etc., etc. A class like Agribusiness 110 >might be taught at one location only one time a week, but another like >Biology 101 is taught 40 times across all five sites.Your database is inherently complex (meaning that any solution including FMPro, Tango, etc. will be complex), and yes, WebCatalog2 can do this while WebCatalog 1.6.1 could not.I can give you a pointer in the right direction, but you may want a database consultant (or your mainframe buddy) to help you set up the initial design. It is very important to get a clean database model, otherwise you'll spend a lot of time reworking your site.The key here may be to step away from a single homogenous database, and start using WebCat2's relational features. Without spending too much time on it, I can't tell you exactly what the breakdown should be, but consider dividing your databases into different general 'categories' where all the classes that have the same field structure will go into one database, and all the others get put into another database, and so on.Here's an example of 2 related databases:----------Classes.db--------ClassID Title Professor0001 Math John0002 English Frank0003 Geography Tim--------------------------------------Prerequisites.db--------ClassID PreReqID0001 00200001 00210001 00030002 00030002 0029----------------------------------Notice in this case that Math (0001) has 3 prerequisites: 0020, 0021, and 0003 (Geography). English (0002) has 2 prerequisites: 0003 (Geography) and 0029So when your server displays a class description from Classes.db, you embed a search that finds all the corresponding ClassIDs in the Prerequisites.db that match the particular class that is shown. The 2 are related by a unique code called ClassID. It is a simple [lookup] to get the title and professor given a ClassID.Grant Hulbert, V.P. Engineering | Tools for WebWarriorsPacific Coast Software | WebCatalog, WebCommerce Solution11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMasterSan Diego, CA 92128 |619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

Re: WC Database Format (Dave Herriman 1997)
Re: WC Database Format (Grant Hulbert 1997)
WC Database Format (Dave Herriman 1997)

>Our sked has about 700 classes offered over 2,400 ways: i.e., 700 >records with VARYING total-field info per line. Some have add'l fees, >some don't; some have prerequisites, some don't. Some are taught at any >or all of our 5 main campuses, etc., etc. A class like Agribusiness 110 >might be taught at one location only one time a week, but another like >Biology 101 is taught 40 times across all five sites.Your database is inherently complex (meaning that any solution including FMPro, Tango, etc. will be complex), and yes, WebCatalog2 can do this while WebCatalog 1.6.1 could not.I can give you a pointer in the right direction, but you may want a database consultant (or your mainframe buddy) to help you set up the initial design. It is very important to get a clean database model, otherwise you'll spend a lot of time reworking your site.The key here may be to step away from a single homogenous database, and start using WebCat2's relational features. Without spending too much time on it, I can't tell you exactly what the breakdown should be, but consider dividing your databases into different general 'categories' where all the classes that have the same field structure will go into one database, and all the others get put into another database, and so on.Here's an example of 2 related databases:----------Classes.db--------ClassID Title Professor0001 Math John0002 English Frank0003 Geography Tim--------------------------------------Prerequisites.db--------ClassID PreReqID0001 00200001 00210001 00030002 00030002 0029----------------------------------Notice in this case that Math (0001) has 3 prerequisites: 0020, 0021, and 0003 (Geography). English (0002) has 2 prerequisites: 0003 (Geography) and 0029So when your server displays a class description from Classes.db, you embed a search that finds all the corresponding ClassIDs in the Prerequisites.db that match the particular class that is shown. The 2 are related by a unique code called ClassID. It is a simple [lookup] to get the title and professor given a ClassID.Grant Hulbert, V.P. Engineering | Tools for WebWarriorsPacific Coast Software | WebCatalog, WebCommerce Solution11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMasterSan Diego, CA 92128 |619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Grant Hulbert

DOWNLOAD WEBDNA NOW!

Re: WC Database Format

1997

Top Articles:

Related Readings: