If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Figuring out a design
This may be more suitable for the new users section since I'm a new user, but
it's about design, so I'll try here first. I've got a monster spreadsheet I'd like to put into Access. It's becoming a bit unmanageable, so I'm thinking Access is the way to go. My primary problems are with the nature of the relationships: I have physical servers, virtual servers, and applications. The virtual servers reside on the physical servers, so you will always have a physical server. Each virtual server instance will reside on two physical servers (they're clusters) However, not all physical servers have virtual servers. All servers - whether they be physical or virtual - have applications. The number of applications on one server can range from one to twelve. The same application can reside on different servers, but if they are on a virutal server, they will only be on other virtual servers, and the same applies to physical servers (no mixing). Any thoughts on how I should put this thing together? Thanks, Adin |
#2
|
|||
|
|||
"adin"
I've got a monster spreadsheet I'd like to put into Access. It's becoming a bit unmanageable, so I'm thinking Access is the way to go. Adin, I don't envy your task and I wish you all the luck in making the transition. I only have one large spreadsheet on 1 machine with everyone else touching it; should be a bit easier for me to convert to Access than your setup. Good luck and stick to it! Tim |
#3
|
|||
|
|||
"=?Utf-8?B?YWRpbg==?=" wrote in
: Any thoughts on how I should put this thing together? Starting point: you need to identify all the entities you will be using: PhysicalServers(*PCNumber, OSType, OSVer, etc) VirtualServers(*Ident, SubDomainName, Domain, PCNumber+, etc) IsHostedOn(*VirtualServer+, *DomainID+, MaxStorage, etc) Applications(*AppCode, FullName, NumOfLicences, Distributor, etc) AppOnPhysical(*AppCode+) AppOnVirtual(*AppCode+) \\ nb these two are one-to-one relationships. It is possible to \\ create a RI rule that an Application cannot be an AppOnPhysical \\ at the same time as being an AppOnVirtual VirtualAppHost(*AppCode, VSIdent, etc) \\ nb AppCode is a FK referencing AppOnVirtual, NOT Applications PhysicalAppHost(*AppCode, PCNumber, etc) \\ db AppCode is a FK referencing AppOnPhysical, NOT Applications I strongly suspect you are also going to need to know about domains and subdomains etc? Isn't there an application already on the market for this type of network administration -- and is your time really worth less than getting something that already works? All the best Tim F |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Who owns the copyright on graphic design layouts prepared in MS Wo | Karen | General Discussion | 4 | February 1st, 2005 07:01 AM |
How to assign a menu bar to a report opened in design mode | Gordon | Setting Up & Running Reports | 0 | January 20th, 2005 12:09 AM |
Design Templates don't apply font sizes consistantly | Greg H | Powerpoint | 1 | September 15th, 2004 02:07 PM |
design master problem | J. Vermeer | General Discussion | 0 | September 8th, 2004 03:23 PM |
Action queries changing when reopened in design view | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 12:34 AM |