NERO LARP :: Forums :: Main Category :: NERO Database Discussion
 
<< Previous thread | Next thread >>
Normalize on the fly?
Moderators: KenGillis, KatieMueller, AdamTaylor, jvalenti, Clint, NickDenny, ShellyHollon, KnightofEvendarr, jasonmote, JSchneider, fdhogan, DDS, jvalentinero, BrianCook, dcashel
Author Post
RyanCaleb
Thu Dec 07 2017, 08:20AM
Registered Member #68204
Joined: Tue Sep 12 2017, 12:02PM
Posts: 87
Hi,
I have a large table that is completely denormalized. I'm averaging about 300,000 inserts per minute. (I didn't design this, I inherited it)

Due to the flat structure, its fast to write into, but takes up too much space so I can't maintain much before having to truncate. I want to normalize it a little bit. The nature of the data is that it contains repetitive strings, but each transaction is unique and does not have any kind of numeric "id"s that make it easy for me to normalize.

Based on repetitive sets of data, I have determine which tables I want to create, so the main table uses a single integer to reference each table/entry. The problem is, I don't know how to normalize this efficiently.
Any idea?




Please help.
Thanks!

I didn't find the right solution from the Internet.

References:http://forums.databasejournal.com/showthread.php?52109-Normalize-on-the-fly

best introduction videos
Back to top
 

Jump:     Back to top

Syndicate this thread: rss 0.92 Syndicate this thread: rss 2.0 Syndicate this thread: RDF
Powered by e107 Forum System