Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2006
    Posts
    23

    Long information text database

    Hey guys

    I am enrolling in a Japanese language school in January and I was thinking that perhaps I could help them out by redesigning their website.

    http://yamasa.org/acjs/english/index.html

    It contains tons of pages with long information texts (i.e click on accommodation) How would I model this kind of information system in a database?

    Is there a standard method for this kind of information website? If so could you please point me to a document on the web that describes it or answer me on this thread?

    many thanks in advance.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    I'm not sure that I understand your question. Are you looking for something like a Content Management System or are you looking for a database schema to actually use with code that you write yourself?

    I think that if you are going to do this for a school where you will stay for at most two years and possibly as little as two weeks, you really need to stay with one of the packaged or open source CMS offerings. There is no way that one person can write, manage, document, and train someone to support a home grown package after you leave.

    -PatP

  3. #3
    Join Date
    Jan 2006
    Posts
    23
    I don't think I'll actually do it. I'm just asking how would a CMS store this information in it's database? Would it store it in an organized fashion? or just all text in one table indexed by an ID and then having a field for ..say.. "category" of the text. (i.e news, information, faq etc.)

  4. #4
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    Quote Originally Posted by arandomfrog
    I don't think I'll actually do it. I'm just asking how would a CMS store this information in it's database? Would it store it in an organized fashion? or just all text in one table indexed by an ID and then having a field for ..say.. "category" of the text. (i.e news, information, faq etc.)
    Yeah, that's pretty much how they work. They also usually use something other than the DBMS's built in capabilities for indexing the text, though some sytems (like MySQL) have pretty good long-text indexing facilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •