Any thought on this database design? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Any thought on this database design?

Any thought on this database design?# Database - 数据库

c*s2002-09-04 07:09

1 楼

First of all, this is a huge database for economic analysis. 20 years'
data for one state in the U.S. My questions are as following:
1. The data used to stored in tape and CDs, now I would like to integrate
them together, and then move to a server which would allow others to access
the data through the Internet. So what would you do if you were me?
2. The web interface would like to have some real-time customized
demostration,
what would you choose to do if you were me?
Thanks a lot and I apprec

o*z2002-09-04 07:09

2 楼

it depends on your budget

【在 c*******s 的大作中提到】

: First of all, this is a huge database for economic analysis. 20 years'
: data for one state in the U.S. My questions are as following:
: 1. The data used to stored in tape and CDs, now I would like to integrate
: them together, and then move to a server which would allow others to access
: the data through the Internet. So what would you do if you were me?
: 2. The web interface would like to have some real-time customized
: demostration,
: what would you choose to do if you were me?
: Thanks a lot and I apprec

c*s2002-09-04 07:09

3 楼

Under $40,000?

access

【在 o***z 的大作中提到】

: it depends on your budget

o*z2002-09-04 07:09

4 楼

companys like ibm,sun,microsoft,... should sell complete solutions
for problems like yours, just call them

【在 c*******s 的大作中提到】

: Under $40,000?
:
: access

b*e2002-09-04 07:09

5 楼

sql server

【在 c*******s 的大作中提到】

: Under $40,000?
:
: access

b*a2002-09-04 07:09

6 楼

If the data is static and volume is huge, I don't see any reason that you want
to put them into database. To retrieve data directly from file system is way
more faster than from database.
You might want to try the following architecture,
Web Interface Application
|
Data Services
|
Various Data Sources
The data service tier will be some programs reading raw data from various
source and convert them into standard format, and providing services to web

【在 c*******s 的大作中提到】