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 Professor 0001 Math John 0002 English Frank 0003 Geography Tim --------------------------------------Prerequisites.db-------- ClassID PreReqID 0001 0020 0001 0021 0001 0003 0002 0003 0002 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 WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>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 Professor 0001 Math John 0002 English Frank 0003 Geography Tim --------------------------------------Prerequisites.db-------- ClassID PreReqID 0001 0020 0001 0021 0001 0003 0002 0003 0002 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 WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Grant Hulbert
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Using Plug-In while running 1.6.1 (1997)
Empty Shopping Carts? (1998)
File Upload (1997)
Erotic Sites (1997)
Subtotal Taxabletotal Grandtotal **CART** (2005)
Variable Math (1998)
Setting up shop (1997)
New iMac, now ... how do I make webdna serve .html files? (2005)
Date search - yes or no (1997)
Unexpected error (1997)
Purchase Plugin Missing (1996)
Unique Sort (2003)
Summing fields (1997)
Purchase Plugin Missing (1996)
WebCatalog2 Feature Feedback (1996)
Two stores, one server (1998)
Re2: frames & carts (1997)
Disappearing HTML/WebDNA (1998)
[WebDNA] MAX Date (2018)
shipping with weigth (1998)