mysql maximum columns <=1000?# Database - 数据库
l*b
1 楼
Is there any way to create a table with more than 1000 columns?!!
aw
2 楼
WHY DO YOU NEED SUCH A TABLE？
难以想象。
【在 l**b 的大作中提到】
: Is there any way to create a table with more than 1000 columns?!!
难以想象。
【在 l**b 的大作中提到】
: Is there any way to create a table with more than 1000 columns?!!
l*b
3 楼
e.g., a 20000x2000 matrix, which is very common for data mining.
【在 aw 的大作中提到】
: WHY DO YOU NEED SUCH A TABLE？
: 难以想象。
【在 aw 的大作中提到】
: WHY DO YOU NEED SUCH A TABLE？
: 难以想象。
aw
4 楼
恕俺无知，你SURE你的一个RECORD有1000个ATTRIBUTES？ORACLE也就是1000的LIMIT，稍
微具体点讲讲你的DESIGN？
【在 l**b 的大作中提到】
: e.g., a 20000x2000 matrix, which is very common for data mining.
微具体点讲讲你的DESIGN？
【在 l**b 的大作中提到】
: e.g., a 20000x2000 matrix, which is very common for data mining.
l*b
5 楼
We know that the common web server log file is just a flat text file.
suppose we have 2000 web pages in a web site. If a row records all pages
visited by a certain user (he may visit some of 2000 pages), and if 20000
users have been identified, how to load such records (in text file it would be
a 20000x2000 matrix, cell value is how many seconds the user spent on the
page.) into database?
稍
【在 aw 的大作中提到】
: 恕俺无知，你SURE你的一个RECORD有1000个ATTRIBUTES？ORACLE也就是1000的LIMIT，稍
: 微具体点讲讲你的DESIGN？
suppose we have 2000 web pages in a web site. If a row records all pages
visited by a certain user (he may visit some of 2000 pages), and if 20000
users have been identified, how to load such records (in text file it would be
a 20000x2000 matrix, cell value is how many seconds the user spent on the
page.) into database?
稍
【在 aw 的大作中提到】
: 恕俺无知，你SURE你的一个RECORD有1000个ATTRIBUTES？ORACLE也就是1000的LIMIT，稍
: 微具体点讲讲你的DESIGN？
s*e
6 楼
table 1: web page (page_id, ...
table 2: user ( user_id, ...
table 3: access record ( user_id, page_id, access_time )
【在 l**b 的大作中提到】
: We know that the common web server log file is just a flat text file.
: suppose we have 2000 web pages in a web site. If a row records all pages
: visited by a certain user (he may visit some of 2000 pages), and if 20000
: users have been identified, how to load such records (in text file it would be
: a 20000x2000 matrix, cell value is how many seconds the user spent on the
: page.) into database?
:
: 稍
table 2: user ( user_id, ...
table 3: access record ( user_id, page_id, access_time )
【在 l**b 的大作中提到】
: We know that the common web server log file is just a flat text file.
: suppose we have 2000 web pages in a web site. If a row records all pages
: visited by a certain user (he may visit some of 2000 pages), and if 20000
: users have been identified, how to load such records (in text file it would be
: a 20000x2000 matrix, cell value is how many seconds the user spent on the
: page.) into database?
:
: 稍
aw
7 楼
lieb，你该回去复习DATABASE基本概念了，没有冒犯的意思。
would be
恕俺无知，你SURE你的一个RECORD有1000个ATTRIBUTES？ORACLE也就是1000的LIMIT，
【在 s***e 的大作中提到】
: table 1: web page (page_id, ...
: table 2: user ( user_id, ...
: table 3: access record ( user_id, page_id, access_time )
would be
恕俺无知，你SURE你的一个RECORD有1000个ATTRIBUTES？ORACLE也就是1000的LIMIT，
【在 s***e 的大作中提到】
: table 1: web page (page_id, ...
: table 2: user ( user_id, ...
: table 3: access record ( user_id, page_id, access_time )
l*b
8 楼
Thanks, shuke. you are definitely right from the database design perspective.
Then, for table 3 we would have 40,000,000(much fewer if the original matrix
is a sparse matrix.) rows while having only 3 columns.
The only concern is that for separating into more tables, more aggregation
code (join query) need to be written when geting data back to do some
matrix-oriented computation.
Not sure which way is faster, the database tables or a single 20000x2000
matrix-looking text file, in terms of gett
【在 s***e 的大作中提到】
: table 1: web page (page_id, ...
: table 2: user ( user_id, ...
: table 3: access record ( user_id, page_id, access_time )
Then, for table 3 we would have 40,000,000(much fewer if the original matrix
is a sparse matrix.) rows while having only 3 columns.
The only concern is that for separating into more tables, more aggregation
code (join query) need to be written when geting data back to do some
matrix-oriented computation.
Not sure which way is faster, the database tables or a single 20000x2000
matrix-looking text file, in terms of gett
【在 s***e 的大作中提到】
: table 1: web page (page_id, ...
: table 2: user ( user_id, ...
: table 3: access record ( user_id, page_id, access_time )
l*b
9 楼
flush) good reminder, not using database for such a long time...
too much text mining...
20000
the
【在 aw 的大作中提到】
: lieb，你该回去复习DATABASE基本概念了，没有冒犯的意思。
:
: would be
: 恕俺无知，你SURE你的一个RECORD有1000个ATTRIBUTES？ORACLE也就是1000的LIMIT，
too much text mining...
20000
the
【在 aw 的大作中提到】
: lieb，你该回去复习DATABASE基本概念了，没有冒犯的意思。
:
: would be
: 恕俺无知，你SURE你的一个RECORD有1000个ATTRIBUTES？ORACLE也就是1000的LIMIT，
b*e
10 楼
exactly.
【在 aw 的大作中提到】
: lieb，你该回去复习DATABASE基本概念了，没有冒犯的意思。
:
: would be
: 恕俺无知，你SURE你的一个RECORD有1000个ATTRIBUTES？ORACLE也就是1000的LIMIT，
【在 aw 的大作中提到】
: lieb，你该回去复习DATABASE基本概念了，没有冒犯的意思。
:
: would be
: 恕俺无知，你SURE你的一个RECORD有1000个ATTRIBUTES？ORACLE也就是1000的LIMIT，
s*e
11 楼
If you import data into a database, you'd better stick on database for
further computation as much as possible. For example, creating indexes
on user_id or page_id in table 3 could improve your join query performance
a lot. If you can't utilize the advantage of database, just forget it.
【在 l**b 的大作中提到】
: Thanks, shuke. you are definitely right from the database design perspective.
: Then, for table 3 we would have 40,000,000(much fewer if the original matrix
: is a sparse matrix.) rows while having only 3 columns.
: The only concern is that for separating into more tables, more aggregation
: code (join query) need to be written when geting data back to do some
: matrix-oriented computation.
: Not sure which way is faster, the database tables or a single 20000x2000
: matrix-looking text file, in terms of gett
further computation as much as possible. For example, creating indexes
on user_id or page_id in table 3 could improve your join query performance
a lot. If you can't utilize the advantage of database, just forget it.
【在 l**b 的大作中提到】
: Thanks, shuke. you are definitely right from the database design perspective.
: Then, for table 3 we would have 40,000,000(much fewer if the original matrix
: is a sparse matrix.) rows while having only 3 columns.
: The only concern is that for separating into more tables, more aggregation
: code (join query) need to be written when geting data back to do some
: matrix-oriented computation.
: Not sure which way is faster, the database tables or a single 20000x2000
: matrix-looking text file, in terms of gett
相关阅读
help needMySQL: cannot connect现在的发展方向是不是帮帮忙Re: Oracle Certificate?JDBC-ODBC Bridge supporting JDBC API 2.0?1996年Database Market统计1. Oracle vs. SQL92 Re: Justsybase的接口问题Data Mining and OLAP数据库如何适应Internet环境？IBM Overtakes Oracle In Database Race有数据库高高手吗？what is SQL/J?I'm waiting for your oracleOracle for Solaris is available for FREE downloadRe: [转载] somebody posted the junk怎样在T-SQl中执行一条放在varchar中的命令请教[转载] Oracle Database Administrator (DBA) and Developer