I will never be bored
-
I'm guessing that the original developer had never even heard of normalisation.
Deja View - the feeling that you've seen this post before.
Pete O'Hanlon wrote:
I'm guessing that the original developer had never even heard of normalisation.
Normalization? What a strange word. :-D
My .NET Business Application Framework My Home Page My Younger Son & His "PET"
-
Xiangyang Liu ??? wrote:
a database table that has 119 fields
What, may I ask is it a table of? I once made a database for Whitbread of EVERYTHING they bought an sold, Beer, Food, Snack, Furniture, pet food, cleaning etc It had over 20,000 records and went to 45 fields, I thought that was a biggun!
------------------------------------ Hungrþverrir lét herjat hríðar gagls á Skíði (the hunger battle-birds were filled in Skye with blood of foemen killed)
Pah! I say. We have a table with over 100 columns, a clone of a customers database has over 400k rows. Works like a charm.
I'm largely language agnostic
After a while they all bug me :doh:
-
I'm guessing that the original developer had never even heard of normalisation.
Deja View - the feeling that you've seen this post before.
We have a few very large tables that really can't be normalized any further. There's just an inordinate number of datapoints that need to be collected for an entity. Any division is arbitrary, although on the really big ones they were split between a common table and an extened details table.
I'm largely language agnostic
After a while they all bug me :doh:
-
Xiangyang Liu ??? wrote:
I suspect it is not the largest table
When I think of that I think of this: You are standing in front of a big darkgrey stonewall with a black iron door in it. The sky is dark and cloudy and it is quiet around you but you have a bad feeling here. What do you want to do now?
cheers, Chris Maunder
CodeProject.com : C++ MVP
Grab a stiff drink... software development is enough to drive you to drink sometimes, if only it was allowed at work, then I'd have to use public transport, which in itself is frustrating enough to drive you to drink, it's a vicious cycle... :-D
He who makes a beast out of himself gets rid of the pain of being a man
-
Grab a stiff drink... software development is enough to drive you to drink sometimes, if only it was allowed at work, then I'd have to use public transport, which in itself is frustrating enough to drive you to drink, it's a vicious cycle... :-D
He who makes a beast out of himself gets rid of the pain of being a man
Phannon wrote:
software development is enough to drive you to drink sometimes
Be careful when working with abstract classes: Don't drink and derive! :)
My .NET Business Application Framework My Home Page My Younger Son & His "PET"
-
Phannon wrote:
software development is enough to drive you to drink sometimes
Be careful when working with abstract classes: Don't drink and derive! :)
My .NET Business Application Framework My Home Page My Younger Son & His "PET"
-
... with a database table that has 119 fields. Exausted maybe, but not bored. I posted several months ago that the boss wanted me to work on a java project with 6000+ classes in 1500+ files. One of the database tables in this project has 119 fields, I suspect it is not the largest table.
My .NET Business Application Framework My Home Page My Younger Son & His "PET"
With code I work on I have a nearly photographic contextual memory. Whenever I am exposed to a massive Charlie Foxtrot years latter it will come back on me like a bad trip of acid. The worst part, will of course be that it only came back because I now have a simple elegant solution that I of course must take to my grave because no one cares. I feel sorry that you have to deal with it but at least its in Java :) I think some users of the forum drink to dull the pain.
Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway
Most of this sig is for Google, not ego. -
Grab a stiff drink... software development is enough to drive you to drink sometimes, if only it was allowed at work, then I'd have to use public transport, which in itself is frustrating enough to drive you to drink, it's a vicious cycle... :-D
He who makes a beast out of himself gets rid of the pain of being a man
-
... with a database table that has 119 fields. Exausted maybe, but not bored. I posted several months ago that the boss wanted me to work on a java project with 6000+ classes in 1500+ files. One of the database tables in this project has 119 fields, I suspect it is not the largest table.
My .NET Business Application Framework My Home Page My Younger Son & His "PET"
Sounds like Oracle Apps. God those people love UserDefined1, etc., Reference1, etc. :(
Cheetah. Ferret. Gonads. What more can I say? - Pete O'Hanlon
-
... with a database table that has 119 fields. Exausted maybe, but not bored. I posted several months ago that the boss wanted me to work on a java project with 6000+ classes in 1500+ files. One of the database tables in this project has 119 fields, I suspect it is not the largest table.
My .NET Business Application Framework My Home Page My Younger Son & His "PET"
Xiangyang Liu ??? wrote:
table that has 119 fields
That's impressive! A few years ago we hired a GPS/GIS company to map our power system and, knowing nothing of the subject, accepted their schema for the device data tables. Now I have a huge .mdb database with tables 70+ fields wide, most of which are empty. I wish there was a tool I could run on it to condense the tables down to only the essential fields, but I haven't located one yet.
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
-
... with a database table that has 119 fields. Exausted maybe, but not bored. I posted several months ago that the boss wanted me to work on a java project with 6000+ classes in 1500+ files. One of the database tables in this project has 119 fields, I suspect it is not the largest table.
My .NET Business Application Framework My Home Page My Younger Son & His "PET"
119 fields? That's nothing! ;P I regularly get to work with an accounting package from Norway which has eight tables with more than 200 fields each, eleven tables with between 100 and 200 fields, and 202 other tables. The winner is a table called
OrdDocLn, with 312 fields. All with wonderful names likeM38,R9,MntTm,NWgtU, andTspAgrNo! :wtf:
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
