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

short answer: no, i don't know of any

long answer: you do not need that many columns

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.

no you don't

which "mining tools" are you using?

Ok, I will see.

Chris