Click here to Skip to main content
15,916,180 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
QuestionHow do I approach a SDI application? Pin
Bob Pokorny5-Feb-07 18:27
Bob Pokorny5-Feb-07 18:27 
AnswerRe: How do I approach a SDI application? Pin
Code_Doctor16-Apr-07 17:50
Code_Doctor16-Apr-07 17:50 
QuestionWhat are better tools or methods to prepare design document(DSD) in asp.net Pin
suriee5-Feb-07 5:27
suriee5-Feb-07 5:27 
QuestionA Question of Object Architecture Pin
Roger Wright1-Feb-07 19:14
professionalRoger Wright1-Feb-07 19:14 
AnswerRe: A Question of Object Architecture Pin
Captain See Sharp4-Feb-07 15:43
Captain See Sharp4-Feb-07 15:43 
GeneralRe: A Question of Object Architecture Pin
DavidNohejl5-Feb-07 22:10
DavidNohejl5-Feb-07 22:10 
AnswerRe: A Question of Object Architecture Pin
#1236-Feb-07 0:05
#1236-Feb-07 0:05 
AnswerRe: A Question of Object Architecture Pin
cmk6-Feb-07 0:23
cmk6-Feb-07 0:23 
- Do you have an existing GIS ?
- Do you model/maintain phase info ?
- Do you model secondary runs from transformer to meter ?
- Do you model transmission (to subs)
(ok, only effect the fields, but i'm curious Smile | :) )

You will not want to break down the tables or class' beyond the type level.
e.g.
InvItem
|__ Fuse
|__ Transformer
| |__ 1 phase (optional)
| |__ 3 phase ('')
|__ Capacitor
|__ Switch
|__ ...

Some of the elec inv systems i've seen didn't even maintained separate tables for facility types.
It was one big table with InvId, vendor, manuf., manuf sku, price, price date, (elec util) sku, description, ...
Decription held "40A fuse", ...

You will make life easier if you match the facility table break down that you use in you GIS (assuming you have a GIS, assuming you don't want to throw all inv items into one table).

The inv system doesn't (generally) care about details like phases, amps, voltage, ... that should all be in the GIS table (that's why you can throw all that info into a inv desc field).

The GIS table should just contain the InvId (unique for vendor/manuf/manuf sku) and optionally the (elec util) SKU (read-only in GIS, to validate InvId), plus the detail info like phases, voltage, circuit, ohug, state, ... .

Of course going to the next level, you break out the detail info in the inv tables, and have the inv system tied to the GIS so that the GIS placement routines use the inv system to display validation tables for the digitizer to select from (then pull phase, ... from inv tables and copy into gis fields).

Once you have all this info you will want to gen std drawings e.g. std pole, std gang-switch (attachment for a pole), ... . This system can then be used by the eng to do quick designs and part/cost estimates. A full system includes things like how many man hrs it takes to install each part as well.

If i were coming to you guys as a consultant the system i would propose would depend LOT on what you already have (what GIS - what schema, do std drawing exist - what format, current inv data system/format, ...) ... and of course how much money you want to spend Smile | :) .


...cmk

Save the whales - collect the whole set

GeneralRe: A Question of Object Architecture Pin
Roger Wright7-Feb-07 13:24
professionalRoger Wright7-Feb-07 13:24 
GeneralRe: A Question of Object Architecture Pin
cmk7-Feb-07 16:47
cmk7-Feb-07 16:47 
AnswerRe: A Question of Object Architecture Pin
Pete O'Hanlon6-Feb-07 1:41
mvePete O'Hanlon6-Feb-07 1:41 
GeneralRe: A Question of Object Architecture Pin
Roger Wright7-Feb-07 13:12
professionalRoger Wright7-Feb-07 13:12 
QuestionNDIS Miniport Driver Pin
hkshah1-Feb-07 3:26
hkshah1-Feb-07 3:26 
AnswerRe: NDIS Miniport Driver Pin
Pete O'Hanlon1-Feb-07 4:45
mvePete O'Hanlon1-Feb-07 4:45 
QuestionDIME, Binary SOAP - sending email with attachment problem Pin
sharmankit30-Jan-07 8:20
sharmankit30-Jan-07 8:20 
QuestionQuesting regarding a triggered execution system Pin
JMP130-Jan-07 3:57
JMP130-Jan-07 3:57 
AnswerRe: Questing regarding a triggered execution system Pin
Pete O'Hanlon30-Jan-07 4:11
mvePete O'Hanlon30-Jan-07 4:11 
Question3tier app in vs 2005 Pin
amc404224-Jan-07 21:05
amc404224-Jan-07 21:05 
AnswerRe: 3tier app in vs 2005 Pin
Pete O'Hanlon24-Jan-07 23:52
mvePete O'Hanlon24-Jan-07 23:52 
GeneralRe: 3tier app in vs 2005 Pin
amc404225-Jan-07 6:11
amc404225-Jan-07 6:11 
GeneralRe: 3tier app in vs 2005 Pin
Pete O'Hanlon25-Jan-07 8:37
mvePete O'Hanlon25-Jan-07 8:37 
GeneralRe: 3tier app in vs 2005 Pin
amc404225-Jan-07 8:55
amc404225-Jan-07 8:55 
GeneralRe: 3tier app in vs 2005 Pin
Pete O'Hanlon25-Jan-07 9:07
mvePete O'Hanlon25-Jan-07 9:07 
AnswerRe: 3tier app in vs 2005 Pin
Daytona_6756-Feb-07 22:29
Daytona_6756-Feb-07 22:29 
GeneralRe: 3tier app in vs 2005 Pin
amc404221-Feb-07 11:56
amc404221-Feb-07 11:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.