December 9, 2008 at 5:31 am
Hi All,
We are going to create our own CMS Database; and I've been asked to do some reasearch. I was wondering if you can guide me to move in the right direction. Googling it, more or less only brings up all the CMS applications available. Havn't been able to find what are the things I should be carefull with? Things like:
1. What datatype should be used as a most efficient way to store large files?
2. And what about the datatype that will store the large amounts of website content?
3. How are such databases different to the OLTP and OLAP databases? in terms of design and otherwise.
4. What about their maintenance? If a website is updated regularly 2-3 GB of changes (new files loaded on a weekly basis) made to a 40 GB Database every week, what do you think the capacity should be planned at? if we need to keep the history, and if we don't need the history.
5. Is there anything else that we need to consider while designing a CMS database?
Your help is much appreciated.
Thanks.
December 9, 2008 at 7:23 am
I don't want to appear rude but my obvious view is that if you are asking these questions you should be finding a consultant or person(s) who can guide you through this. Otherwise you could end up spending a lot of money and time on something which doesn't do what you want.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
December 9, 2008 at 7:32 am
You really need to consider the size of your CMS and how many users you will be supporting on it. I would have a look at the higher-level business requirements before worrying about data-types.
In my experience designing a large CMS is a lot of work that will take a team of people and a lot of time, the task is even more challenging due to the number of web browsers that you will need to support.
Also as this can be a large undertaking, brining in a consultant who is experienced in CMS design, or tendering out the whole system may end up better value than developing this in-house.
December 9, 2008 at 7:35 am
I tend to agree with Colin here. You are asking for a tremendous amount of information, not some detailed issues. These are general questions and you end up not really doing much research if you rely on a few postings here.
December 9, 2008 at 4:13 pm
Thanks Guys, I understand what you are saying. I will talk to my manager about it.
At the same time, I am really interested in knowing about the database design behind a CMS system. Is there an article that explains atleast a little bit about these? Any tips?
December 9, 2008 at 9:45 pm
Unfortunately, there aren't a lot of great design articles out there. It seems strange, but there are books that go very deep and talk relational theory, but not a lot of people writing about design.
You might want to pick up a book on database design, perhaps this one: http://www.amazon.com/gp/product/0201694719?ie=UTF8&tag=dkranchnet&linkCode=as2&camp=1789&creative=390957&creativeASIN=0201694719
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply