Redian新闻
>
Is there anyone familiar with data warehouse?
avatar
Is there anyone familiar with data warehouse?# Database - 数据库
p*s
1
My question is very 初级。
The customer already has their own data warehouse which I have no idea what it
is.
I have a question to ask me whether my database is easy for the customer to
access for their data warehouse purpose.
I feel this quesiton is quite weird, however, because I have no idea about
data warehouse,
I mean my database is just normal SQL database, why say easy to access or not.
I think anyone can access it via ODBC.
However, I have no idea whether there is any standard software for
avatar
g*o
2
Data warehousing means putting several databases from different business units
together. the primary concentration is historial data and summary information
that aims to help high level decision making. (Not for daily operations or
transaction processing like a usual database)
For example, your company may have sales department, inventory department and
some other departments that each department maintain different database in
different location. Since the source database are often created and m

【在 p******s 的大作中提到】
: My question is very 初级。
: The customer already has their own data warehouse which I have no idea what it
: is.
: I have a question to ask me whether my database is easy for the customer to
: access for their data warehouse purpose.
: I feel this quesiton is quite weird, however, because I have no idea about
: data warehouse,
: I mean my database is just normal SQL database, why say easy to access or not.
: I think anyone can access it via ODBC.
: However, I have no idea whether there is any standard software for

avatar
w*r
3
Hi germo, are you familiar with data extraction process? how do you make sure
that only the updated data are extracted and loaded to the system? what if the
source database is not in your full control, like you can't add stuff like new
column or trigger? Thanks!

units
information
and
maintained
into
what
to

【在 g***o 的大作中提到】
: Data warehousing means putting several databases from different business units
: together. the primary concentration is historial data and summary information
: that aims to help high level decision making. (Not for daily operations or
: transaction processing like a usual database)
: For example, your company may have sales department, inventory department and
: some other departments that each department maintain different database in
: different location. Since the source database are often created and m

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。