Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2007
    Posts
    19

    Unanswered: Looking for Database with many columns

    Hi,

    I'm looking for a database which can create very, very many columns.

    The maximum I found is the MySQL with a maximum of 3398 colums.
    DB2: 1012
    Oracle: 1000
    PostgreSQL: 1600

    Does anybody know a database which can create more columns?

    Chris

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    short answer: no, i don't know of any

    long answer: you do not need that many columns
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2007
    Posts
    19
    normally I would say YES. You won't need that many columns.
    But I'm working for project at my university and we have to transform existing tables.
    For instance, there is a table with two columns, users and rights. Then I need a second table with one column for the user and as many columns as rights. After that I will translate the rights into 0 and 1. If a user has the right he will get an 1 in the specific column, otherwise a 0.
    It looks roughly like this:
    User - Right1 - Right2 - Right3 - .... - Rightn
    X - 0 - 1 - 0 - 1 -
    Y - 1 - 1 - 1 - 1 -
    ...

    That's the base for some mining tools.

    As it seems there is no database which supports our project. I think we have to shorten the input.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Chriz81
    Then I need a second table with one column for the user and as many columns as rights.
    no you don't

    which "mining tools" are you using?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Jun 2007
    Posts
    19
    Ok, I will see.

    Chris

Posting Permissions

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