zaheer_aniz
New Member
I'm trying to develop a web based digital asset management application. I'm planning to do it in Codeigniter with mysql as db. This is for a popular regional newspaper. They will have 1000 of entries and TB's of data as daily tons of information will be entered. There will be different content types like Media, Personality, Event, Issue, Misc etc... All this will be categorized. The thing is all will be interconnected. For example the event "olympics" will be connected to all the participants in personlity table and all the media related to this. I'm planning to implement this complex inter-connection using a table 'connections'\[code\]id - subject - connection - type ------------------------------------------- 1 98 190 media 2 283 992 issue 3 498 130 info\[/code\]So when a person takes the event olympics... all the connections will be populated from this table. The 'subject' column will have id of 'olympics' and connection will have id of the connected entry. Is there a better way to do this? The content will have to searched based on 100's of different criteria. But the end-users will be very less. Only the reporters of the newspaper(Max 100) will have access to this app so the traffic or load will be very less but the amount of information stored will be very high. I would like to hear from experienced developers as i don't have much experience doing something big like this.