转至繁体中文版     | 网站首页 | 图文教程 | 资源下载 | 站长博客 | 图片素材 | 武汉seo | 武汉网站优化 | 
最新公告:     敏韬网|教学资源学习资料永久免费分享站!  [mintao  2008年9月2日]        
您现在的位置: 学习笔记 >> 图文教程 >> 数据库 >> 其他 >> 正文
设计数据仓库的注意事项(PartI)         ★★★★

设计数据仓库的注意事项(PartI)

作者:闵涛 文章来源:闵涛的学习笔记 点击数:1879 更新时间:2009/4/22 23:21:20

Introduction

Identifying and understanding the business and operational requirements that drive any data warehousing project are essential to the project抯 successful completion. You cannot meet your clients?needs if you have not assessed and analyzed what those needs are and how you can address them.

Who Knows?

The most important part of the business requirements process is finding out who knows what the requirements should be. In most cases, the answer to "Who knows what we need to know?" is that nobody knows it all, but everyone knows a part.

And What Do They Know?

The answer to this question is they know far more than they imagine. In most cases your sources do not know they have valuable information and to what extent they are the only possible source for vital information that will help insure the project抯 success.

The Biological Knowledge Base

Systems are designed, created, maintained and operated by people who have first hand system information. This group of experts is collectively identified as the biological knowledge base that you must tap effectively in order to extract the information you require.

Play by the Rules

Your organization抯 business rules (functional requirements) and operational characteristics (non-functional requirements) are the essence of the design requirements for your project. They must be carefully cataloged and analyzed to insure internal consistency. When inconsistencies are found, you need to identify the cause of the inconsistencies (you will find that in some cases the inconsistencies are perfectly valid and reasonable) and determine the proper method(s) for adjusting the project.

How It Has to Work and Why

For each component of your project, you will need to identify the operational and business requirements. For example, there will be times when the need for 24X7 availability will supercede the need for total accuracy. Situations such as this must be taken into consideration and included in your development plan.

Cultural/Political Constraints

Cultural and political constraints will have a serious impact on your success, so they must be addressed while collecting the business requirements that define the project. Even in those cases where the political environment is opposed to the needs of the project team, you can use political relationships to increase the visibility and acceptance of your project, but only if you have a clear understanding of the dynamics involved.

Assessing/Addressing Risks

Every project faces risks, some are minor, some severe. The successful project is based on identifying what those risks are, how likely they are to occur, how serious they are and what actions are best to prevent the issues from arising. Identify the tactics to be used in dealing with the issues when they do arise, because, despite your best efforts, some will still occur.

Mine the Biological Knowledge Base

The biological knowledge base is the complete body of human knowledge and intelligence available. The readily accessible biological knowledge base primarily consists of: designers and developers, knowledge workers, end users, management, system staff, security staff and physical maintenance staff.

Everything you learn from the biological knowledge base should become a part of the business requirements for your project and be fully documented to serve as valuable material for subsequent projects.

Designers/Developers

Design and development staff members are those who are or have been responsible for creating and maintaining existing systems and are tasked with integrating future systems. You will need to gather business requirements and functional constraint information from architects (business, data and system), database administrators, database analysts and programmer analysts. Each will have their own perspective on your project and on the information needed in order to make it successful.

Effectively interviewing the designers and developers will provide you with background information that will give your project a head start toward a successful completion. Their knowledge will provide a foundation upon which to build the final business requirements that your business partners identify.

Architects

Architects create the designs for the environments in which applications and systems function. They are seldom directly involved in building the applications, systems or databases, but provide the blueprints from which such structures are created.

Architects can detail information contained in the design documentation as well as the enterprise standards, logical limitations and business functionality. Architects also begin gathering the data requirements for the project.

DBAs

Database administrators and analysts are experts when it comes to creating, maintaining and optimizing the data structure behind information management applications. These DBAs are an invaluable resource.

DBAs can provide your team with nearly everything it needs to know about database management systems, structure, security, resource requirements (hardware, software and personnel), enterprise standards, physical limitations and how others have integrated business rules into their database implementations.

Programmer Analysts

Programmer analysts are the ones who create the code that makes applications work. Their job is to take a concept and turn it into a functioning system that provides the desired capabilities.

These specialists should be interviewed with the intention of deriving information on operation limitations in their applications, structural standards that constrained the design and development of the applications, how they enforce the business rules that defined their projects and a listing of the design requirements from which they worked.

Knowledge Workers (Subject Matter Experts)

Knowledge workers are those who work with the base information for your project. They consist of business analysts, actuaries, accountants and business consultants, as well as marketing, sales, clerical and production.

Business Analysts

Business analysts are your best resource for understanding the true business meaning for a particular data element or set and for identifying the logic on which the application is based.

They will provide you with information on which business questions need to be answered and where to find the data that will help to answer them. They will also provide you with the specifications on functional reporting requirements ?the information they need to have in order to develop the reports upon which decisions are based.

Actuaries

Actuaries are statistical analysis specialists who determine the likelihood that something will happen a specific number of times within an identified group during a given time period. They can also be called risk analysts because they job identify risks the business faces.

They provide your team with information on the data elements they require in order to perform the statistical analysis upon which their predictions are dependent. They can also identify many of the derived and dependent measures that will assist them in preparing analyses as needs and demographics change.

Accountants

Accountants are the true numbers crunchers of the organization. They are the ones who determine to what extent the organization is profitable. They make sure the books balance. They tend to be detail oriented to the exclusion of nearly every other consideration.

You will get specific information regarding the data that feeds the profit/loss analyses they use in building financial reports and budget management reports. They will also provide detail on the derived and calculated measures from which they build these reports.

Business Consultants

Business consultants, whether internal or external, specialize in identifying ways to improve business functionality and preparing plans for implementing the new processes. In order to accomplish their tasks, they must receive clear and reliable information regarding the current and historical views of the business as well as developing trends.

The consultants will identify the business questions they need answers to in order to identify the current state, which they base their trend analyses on. In many cases, the most important pieces of inf

[1] [2]  下一页


[其他]设计数据仓库的注意事项(PartII)  
教程录入:mintao    责任编辑:mintao 
  • 上一篇教程:

  • 下一篇教程:
  • 【字体: 】【发表评论】【加入收藏】【告诉好友】【打印此文】【关闭窗口
      注:本站部分文章源于互联网,版权归原作者所有!如有侵权,请原作者与本站联系,本站将立即删除! 本站文章除特别注明外均可转载,但需注明出处! [MinTao学以致用网]
      网友评论:(只显示最新10条。评论内容只代表网友观点,与本站立场无关!)

    同类栏目
    · Sql Server  · MySql
    · Access  · ORACLE
    · SyBase  · 其他
    更多内容
    热门推荐 更多内容
  • 没有教程
  • 赞助链接
    更多内容
    闵涛博文 更多关于武汉SEO的内容
    500 - 内部服务器错误。

    500 - 内部服务器错误。

    您查找的资源存在问题,因而无法显示。

    | 设为首页 |加入收藏 | 联系站长 | 友情链接 | 版权申明 | 广告服务
    MinTao学以致用网

    Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved.
    闵涛 投放广告、内容合作请Q我! E_mail:admin@mintao.net(欢迎提供学习资源)

    站长:MinTao ICP备案号:鄂ICP备11006601号-18

    闵涛站盟:医药大全-武穴网A打造BCD……
    咸宁网络警察报警平台