post #1 of 1
Thread Starter 
So, for the past 2 months I have been building a system for images, videos, and data files.

We upload the the files into the cloud, and I have a table(StagedItems) that points to the location of all the raw files that were uploaded. I then have a process that enumerates trough that table and processes , encodes, or whatever to the files in that table and then pushes it into my system that uses an EF db(Prod) for all of its info. Due to some stupid architectural exception a client threw on me recently, I need to change some stuff around so I am looking at my current setup and seeing if it makes sense.

I like the mentality that I can take my StagedItems table and re-encode\process everything and rebuild everything from scratch just by re-running that process. While this sounds great and all, I can't help but shake the idea in my head that this is just adding another dependency and an excessive amount of duplication. Basically for each item in StagedItems, there will be an entry in Prod , but instead of having all the additional details , metadata, permissions as a comma separated list in a table, it uses foreign keys to make the data more searchable. I think it is in my best interest to copy some of the location information from the StagedItems table so that the Prod table contains all of the information and from there could rebuild everything as well.


The more I talk it trough, the more it makes sense, but i figured I would ask to see if anyone had some insight, advice or something, perhaps a good article in regards to the philosophy of stuff like this.
Zev's Comp
(15 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core i5-2500K Sandy Bridge 3.3GHz GIGABYTE GA-Z68X-UD3H-B3 LGA 1155 Intel Z68 HDM... GeForce GTX 750 Ti G.SKILL Ripjaws X Series 8GB 
Hard DriveHard DriveHard DrivePower
1TB HDD 64GB SSD (Used for SRT) 500 GB. Antec BP550 Plus 550W Continuous Power ATX12V V... 
Case
COOLER MASTER ELITE 335 RC-335-KKN1-GP Black S... 
  hide details  
Reply
Zev's Comp
(15 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core i5-2500K Sandy Bridge 3.3GHz GIGABYTE GA-Z68X-UD3H-B3 LGA 1155 Intel Z68 HDM... GeForce GTX 750 Ti G.SKILL Ripjaws X Series 8GB 
Hard DriveHard DriveHard DrivePower
1TB HDD 64GB SSD (Used for SRT) 500 GB. Antec BP550 Plus 550W Continuous Power ATX12V V... 
Case
COOLER MASTER ELITE 335 RC-335-KKN1-GP Black S... 
  hide details  
Reply