|
Thank you for this posting.
I am currently working on the conversion of some very old FORTRAN software for the NASA Voyager data processing as we are one of the instrument teams still working the Voyager Interstellar Mission and I have been struggling to find an option in C# to do exactly this, i.e. as mentioned in a reply this is like the FORTRAN COMMON BLOCK statement.
Now I think I will be able to finish my conversion project a lot easier than attempting to write my own version of a COMMON statement and figuring out how to implement all of the various possibilities.
Jerry W. Manweiler, Ph.D.
Fundamental Technologies, LLC
|
|
|
|
|
 
Starting to think people post kid pics in their profiles because that was the last time they were cute - Jeremy Falcon.
|
|
|
|
|
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.
|
|
|
|
|
I am not really sure about the best practice but this is something we track in spreadsheet and then on an internal portal.
- Table name (logical)
- Table name (physical)
- Business description for the table (what you are probably looking for)
- #1 - #3 for all the columns as well in the table. Along with this constraints are also mentioned for each table.
- For foreign key columns, source table (logical) is to be mentioned
So, if anyone needs to get say, all user addresses, they can take a look at spreadsheet/portal and write a query to get the details.
"It is easy to decipher extraterrestrial signals after deciphering Javascript and VB6 themselves.", ISanti[ ^]
|
|
|
|
|
There are aftermarket apps that serve a useful purpose in terms of documenting databases.
These guys have some interesting stuff, some of which is free.
ApexSQL Doc - SQL Server and BI documentation tool | ApexSQL[^]
".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Taking the lead from JSOP Red-Gate do an excellent suite of tools SQL Toolbelt[^]. They are NOT free, quite expensive actually. We have been using some of their stuff for year but not the documentation tool.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I would add comments directly on the tables and columns.
Foreign Keys and constraints also help define the data dictionary.
For SQL server, search for "SQL Comments on Create Table on SQL Server 2008" for some good examples.
Worse case, create some additional tables for high level documentation.
|
|
|
|
|
Walk the pain and blame right out perhaps? (13)
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Perambulation - anagram of pain blame r out.
Whenever you find yourself on the side of the majority, it is time to pause and reflect. - Mark Twain
|
|
|
|
|
Well, it lasted 40 minutes ... 
You are up tomorrow!
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Just when a five-meter python had his mouth around kitty, his 63 year-old love slave, Mrs, Saving, and neighbors, and local snake--busters, to the rescue. Note the story is written in a form of mutilated English expats sometimes refer to as "Tainglish:" [^]
Rascal python is getting deported to a far forest where perhaps he'll enjoy backpackers.
«... thank the gods that they have made you superior to those events which they have not placed within your own control, rendered you accountable for that only which is within you own control For what, then, have they made you responsible? For that which is alone in your own power—a right use of things as they appear.» Discourses of Epictetus Book I:12
|
|
|
|
|
Google translate isn't being a whole lot of help here:Quote: Mrs. Saving, age 63, the owner of the house heard his cat cats in the back of the house to walk to see that the big boar is eating his own cat. They use a snake bite until the serpent to the wall of the house's mortar by the cats themselves are injured bite the abdomen. Before the rescue team to help.
I think I see what is happening, but ...
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Always said Python was dangerous... 
|
|
|
|
|
BillWoodruff wrote: Rascal python is getting deported to a far forest where perhaps he'll enjoy backpackers.
That's the "official" version for westerners. Meanwhile:
... the villagers are enjoying a meal from a "very long chicken."
... the cat is back enjoying "playing" with other small indigenous wildlife.
|
|
|
|
|
lopati: roaming wrote: villagers are enjoying a meal from a "very long chicken."
Good. Just think of how long Kentucky Fried T-Rex has been out of business.
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
I liked the pictures from another article of an undamaged pickup truck and a totaled front end of a sedan.
|
|
|
|
|
|
Yo! Da sixth Beatle has been identified!
Socialism is the Axe Body Spray of political ideologies: It never does what it claims to do, but people too young to know better keep buying it anyway. (Glenn Reynolds)
|
|
|
|
|
All you need is Yoda!
and coffee!
Everyone has a photographic memory; some just don't have film. Steven Wright
|
|
|
|
|
black coffee
It does not solve my Problem, but it answers my question
modified 19-Jan-21 21:04pm.
|
|
|
|
|
That would've been something...
Twenty years ago today, it was
Taught the band to play, Master Yoda did
In and out of style, they've been going
Raise a smile, they were guaranteed to
Now, introduce to you I may
Master Yoda's Lonely Hearts Club Baaaaand!
Doesn't quite have the same hit potential... 
|
|
|
|
|
The drummer we are looking for this is not ... along move, along move ...
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Reinstalling win 10 in a Laptop from the scratch due to problems with the last update (it was long time offline without net).
Grafic card driver installation. Original file is a big exe, that unpacks and executes on its own.
But as I already had the unpacked folder, I wanted to install it directly:
- If you call the setup yourself, you get the message "it can not be called from this location"
- If you call the exe and give an existent folder, you get the message "it could not create the folder" and it deletes the previously generated folder 
- If you try to unpack the things on your own, you can't "because admin privileges are needed" (needles to say that I am admin) [EDIT: just for nitpicky users... I was using the "exe as admin" too)
Only way to install the driver... delete the folder again, let the installer create it, unpack everything and call the setup.exe on its own. Then... it works.
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
modified 9-Sep-18 9:43am.
|
|
|
|
|
Chances are it called the setup with parameters which tell it what to do and where - it you don't supply them, it can't do its job.
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I suppose you are right. But i find it a bit intrincate. Nevermind... I just wanted to rant a bit about it.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
