Click here to Skip to main content
14,358,184 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
 
GeneralRe: Unions in C# Pin
CPallini10-Sep-18 12:04
mveCPallini10-Sep-18 12:04 
GeneralRe: Unions in C# Pin
Eytukan12-Sep-18 20:26
memberEytukan12-Sep-18 20:26 
GeneralRe: Unions in C# Pin
CPallini13-Sep-18 0:54
mveCPallini13-Sep-18 0:54 
GeneralRe: Unions in C# Pin
englebart11-Sep-18 3:07
memberenglebart11-Sep-18 3:07 
GeneralRe: Unions in C# Pin
DSewhuk11-Sep-18 9:21
memberDSewhuk11-Sep-18 9:21 
GeneralRe: Unions in C# Pin
Jerry W. Manweiler, Ph.D.11-Sep-18 12:31
memberJerry W. Manweiler, Ph.D.11-Sep-18 12:31 
GeneralRe: Unions in C# Pin
Eytukan12-Sep-18 20:26
memberEytukan12-Sep-18 20:26 
GeneralData Dictionaries Pin
NeverJustHere10-Sep-18 0:42
memberNeverJustHere10-Sep-18 0:42 
I'm looking for some guidance on best practices for data dictionaries.

I've seen them done poorly (i.e. a dump of sys.columns from the database), sometimes with a brief description but I've never seen them done usefully.

I guess, to provide more context, I'm looking at this more from an analyst perspective, wanting to query a database rather than work with or enhance the application that uses the database.

The sort of thing I think might be useful would be some commentary on when/where a record can change and how. Has anyone seen documentation at this level?

Another way of looking at the question is: If you have found useful data dictionary documentation on a database (either a transaction application or ODS/DW type of DB) then what specifically made it useful? What did it contain?

Also, what systems are around for tracking this - is Word being used - are there more interactive, automated data dictionary systems around that work well. I know some of the ETL tools try in this space - do they work well or are there independent systems you've liked?

Cheers

modified 10-Sep-18 5:49am.

GeneralRe: Data Dictionaries Pin
lw@zi 10-Sep-18 1:19
professional lw@zi 10-Sep-18 1:19 
GeneralRe: Data Dictionaries Pin
#realJSOP10-Sep-18 3:30
mve#realJSOP10-Sep-18 3:30 
GeneralRe: Data Dictionaries Pin
Mycroft Holmes10-Sep-18 15:35
memberMycroft Holmes10-Sep-18 15:35 
GeneralRe: Data Dictionaries Pin
englebart11-Sep-18 3:15
memberenglebart11-Sep-18 3:15 
GeneralWSO CCC OTD 2018-09-10 Pin
OriginalGriff9-Sep-18 22:57
protectorOriginalGriff9-Sep-18 22:57 
GeneralRe: WSO CCC OTD 2018-09-10 Pin
PeejayAdams9-Sep-18 23:34
memberPeejayAdams9-Sep-18 23:34 
GeneralRe: WSO CCC OTD 2018-09-10 - we have a winner Pin
OriginalGriff9-Sep-18 23:38
protectorOriginalGriff9-Sep-18 23:38 
Generalevery Saving's kitten's savior saves humanity, even if pythons go hungry Pin
BillWoodruff9-Sep-18 22:00
mveBillWoodruff9-Sep-18 22:00 
GeneralRe: every Saving's kitten's savior saves humanity, even if pythons go hungry Pin
OriginalGriff9-Sep-18 22:17
protectorOriginalGriff9-Sep-18 22:17 
GeneralRe: every Saving's kitten's savior saves humanity, even if pythons go hungry Pin
glennPattonWork9-Sep-18 22:20
professionalglennPattonWork9-Sep-18 22:20 
GeneralRe: every Saving's kitten's savior saves humanity, even if pythons go hungry Pin
the goat in your machine9-Sep-18 23:26
memberthe goat in your machine9-Sep-18 23:26 
GeneralRe: every Saving's kitten's savior saves humanity, even if pythons go hungry Pin
CodeWraith10-Sep-18 0:29
memberCodeWraith10-Sep-18 0:29 
GeneralRe: every Saving's kitten's savior saves humanity, even if pythons go hungry Pin
Joe Woodbury11-Sep-18 7:51
professionalJoe Woodbury11-Sep-18 7:51 
GeneralI was sent this, and... Pin
OriginalGriff9-Sep-18 6:25
protectorOriginalGriff9-Sep-18 6:25 
GeneralRe: I was sent this, and... Pin
DRHuff9-Sep-18 7:21
memberDRHuff9-Sep-18 7:21 
GeneralRe: I was sent this, and... Pin
Mike Hankey9-Sep-18 9:35
professionalMike Hankey9-Sep-18 9:35 
GeneralRe: I was sent this, and... Pin
0x01AA9-Sep-18 9:45
professional0x01AA9-Sep-18 9:45 

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.