Business Requirements Document Miller Inc Looks Forward Essay

Download this Essay in word format (.doc)

Note: Sample below may appear distorted but all corresponding word document files contain proper formatting

Excerpt from Essay:

Business Requirements Document

Miller Inc. looks forward to creating a data repository for all data collected that is beyond the current relational database it currently uses. The company has currently outgrown the relational database in Oracle that it currently uses. Though it enables data to be stored in different tables that can be linked together using record keys, the amount of keys and records makes it difficult to operate a standard relational database. The company thus needs to adapt database modeling in designing their data warehouse. This is the project. Data modeling extends the online transaction processing models that are common in relational database into data warehousing. The project goal is to develop an appropriate database schema to be designed alongside other components such as identifying metadata. The IT role is to model the data warehouse, implement and test it.

Scope

Scope of the project

The scope of the project is to identify and gather database requirements, design the dimensional model, develop the system architecture, design the relational database and online transactional processing model, develop the data maintenance application, develop analysis applications to test and deploy the system Hughes, 2008()

Applications

In order to meet the target production date, only these applications will be implemented: loading, indexing and summarizing tables, scanning, joining, sorting, aggregating and fetching data. These are deemed to be most relevant to the system needed by Miller Inc. In handling all its data-intensive tasks.

Sites

These sites are considered part of the implementation: testing, live testing, production and backup sites. The testing site will be used for testing applications that are still in the development phase. After testing in the testing site, the live testing site will be used to test the application on a few records in real time to check how it handles live data. The production site will be most important since it will be the one that is used by consumers. The last site is the backup site that will be used to store data backups.

Process re-engineering

The ETL (extract, transform and load) functions will be used to re-engineer the processes used in the relational database. This involves extracting data from all the disparate sources such as the relational database and XML files, transforming it to conform to the schema of the developed data warehouse through removing duplicates, deriving calculated values, generating keys, validating and cleaning the data and then lastly loading it to the data warehouse Humphries, Hawkins, & Dy, 1999()

Customization

Customizations will be limited to calculated data values. This will be done so to minimize the amount of metadata that the system will have as well as ensuring that the system is scalable to include other forms of data that the organization may want to collect and analyze in the future.

Interfaces

The interfaces included are customer, analysts and administrator interfaces. These will all be accessible through web-based applications and will be built entirely in a custom fashion to ensure the organization's data is secure. The customer interface will allow them to view trend data for their websites while the analysts interface will allow them to access all customer data in an anonymous fashion in order to conduct further analyses. The administrator interface will be used to administer the warehouse and the system in general.

Architecture

Before the data warehouse is implemented in full scale, application and technical architecture will be three-layer architecture that is the source, reconciled and data warehouse layer. These will be repopulated through the ETL process earlier described and ensures that the data warehouse works in the best way possible. However, with time, the single-layer architecture will be used to ensure there is minimal redundancy in the system and thus reduce size of data being stored.

Conversion

All data in the relational database will be considered for conversion to the data warehouse schema through the ETL process.

Testing

Four testing engagements will be incorporated. First is new data warehouse testing where the data warehouse will be testing as it is being build using ETL tools. Second, as the data is being migrated, the data warehouse will be tested. Third is change request testing whereby the data warehouse will be tested to meet the needs of the organization and last is report testing where the end result of the data warehouse is tested to validate its layout, the data and, calculations.

Funding

The project is 100% funded by Miller Inc. And funding supports all aspects of development, implementation and testing of the data warehouse.

Training

All members of staff will be trained on the new data warehouse despite their status in the organization. However, different levels of testing will be implemented for different categories of staff. This will ensure that they are aware that the company is using a new data management system and that they understand what the change involves.

Constraints and assumptions

The following constraints have been identified: unique constraints where data in a particular column are not unique and foreign-key constraints where two keys share a primary key-foreign key relationship. The following assumptions have been made in defining the scope, objectives and approach. First is that the data models that underline the services will not support efficient queries that are required to join many concepts together. The second is that the organization will be able to reuse some of the solutions it has such as interfaces. Third is that the data warehouse can be adapted without redesigning or developing new services for consumers.

Risks

One of them major risks that is identified is that the data from the relational database may be too big to be cleaned with ease. Second is that the new technology will not be well understood by all members of staff. A third risk is that the company may have set unrealistic schedules that lead to the project being poorly architected.

Scope control

The scope of the project will be controlled by identifying a representative of the management to manage change control. This individual will also be responsible for any changes that affect the timeline or costs of the project.

Relationship to other systems

The project management team will be responsible for informing the IT department and the organization in general of any other initiative of the business that may have an impact of the project. The only known business initiative is consumer product offering.

Resource

The data warehouse may need to be offshored or outsourced in order to keep running costs low and to reduce or mitigate risk associated with data warehouse management. The organization may also need to increase its staff base in order to have more knowledgeable personnel to manage the data warehouse.

Task

Person in-charge

Time

Planning

Prepare project goals and objectives

Project manager, IT staff

1-week

Review project goals and objectives

Project manager, IT staff

2 days

Review and recap proposals and contracts

Project manager

3 days

Assess opportunities and risks

Project manager

2 days

Identify constraints and other obstacles

Project manager, IT staff

3 days

Identify required nonhuman resources

Project manager

2 days

Review scope of project

Project manager

2 days

Identify the procedure for monitoring and evaluation of the project

Project manager

1 day

Project high-level scope of the project

Project manager

2 days

Assemble core project team

Identify required skills from organization

Project manager

2 days

Identify required skills from other project stakeholders e.g. IBM who are the owners of Oracle

Project manager

3 days

Analyze availability of staff

Project manager, administrator

2 days

Nominate project team members

Project manager

1 day

Review team member's availability

Project manager

1 day

Team members accept responsibility

Project manager, all team members

1 day

Analysis

Analyze and design the project organizational units

Project manager, administrator

2 days

Analyze organizational roles

Project manager

2 days

Analyze stakeholder relationships and roles

Project manager

3 days

Analyze and design network identify policies

Project manager, all team members

2 days

Analyze and design policies and workflows for provisioning

Project manager, administrator

3 days

Analyze and design high level methods for importing data

Project manager

2 days

Analyze software and hardware architecture

Project manager

2 days

Design

Review project goals and objectives with team members

Project manager, all team members

2 days

Develop project plan

Project manager, all team members

Identify resources required

Project manager, all team members

2 days

Review project plan with identified resources

Project manager, all team members

3 days

Design test strategy

Project manager, all team members

1 day

Project communication

Develop communication plan

Project manager, all team members

1 day

Identify and publish project updates

Project manager, all team members

1 day

Publish problems for issue tracking

Project manager, all team members

1 day

Publish scope control instruction

Project manager, all team members

1 day

Publish schedules of the team and team members

Project manager, all team members

1 day

Develop team status reporting rules

Project manager, all team members

1 day

Identify and publish functional responsibility of team members

Project manager, all team members

1 day

Implementation

Confirm suitability of workspaces

Project manager,…[continue]

Cite This Essay:

"Business Requirements Document Miller Inc Looks Forward" (2013, May 31) Retrieved December 5, 2016, from http://www.paperdue.com/essay/business-requirements-document-miller-inc-91230

"Business Requirements Document Miller Inc Looks Forward" 31 May 2013. Web.5 December. 2016. <http://www.paperdue.com/essay/business-requirements-document-miller-inc-91230>

"Business Requirements Document Miller Inc Looks Forward", 31 May 2013, Accessed.5 December. 2016, http://www.paperdue.com/essay/business-requirements-document-miller-inc-91230

Other Documents Pertaining To This Topic

  • Dangerfield Inc A Delaware C Corporation

    Dangerfield and Associate Entities Upon examining this case, it's clear that the claims made by Hartman are completely legitimate. The claims made by Mitchell are somewhat legitimate. This paper will first examine the basis of the lawsuit waged by Hartman, as the bulk of the valid accusations made are made by this particular plaintiff. The crux of Hartman's lawsuit is based on the claim that Dangerfield was liable for the negligence

  • Organisational Culture of J Sainsbury

    Fortress Culture: Employees don't know if they'll be laid off or not. These organisations often undergo massive reorganisation. There are many opportunities for those with timely, specialized skills. Examples are savings and loans, large car companies, etc." According to research, Sainsbury's appears to be a fortress company, as it is struggling to find the right strategy and culture for its business. Edgar Schein, a cultural analysis, has contributed a great deal of

  • E Manufacturing A New Link

    Ayers (2000, p. 4) describes a supply chain as "Life cycle processes supporting physical, information, financial, and knowledge flows for moving products and services from suppliers to end-users." A supply chain can be short, as in the case of a cottage industry, or quite long and complex as in the manufacture, distribution, and sales of automobiles. In fact, the automobile supply chain has its origin in the mining of the

  • Mcdonald s Integrated Marketing Campaign This Paper Is

    McDonald's Integrated Marketing Campaign This paper is divided into two distinct sections. The first chapter is based on literature reviews of various scholarly works that are related to the topic of integrated marketing campaign that are also relevant to the McDonald marketing campaign that was created to celebrate the inherent democracy of the McDonald's brand. The first chapter is further divided into three parts; the first section mainly focus on advertising

  • Children Grief and Attachment Theory

    Figure 1 portrays three of the scenes 20/20 presented March 15, 2010. Figure 1: Heather, Rachel, and Unnamed Girl in 20/20 Program (adapted from Stossel, 2010). Statement of the Problem For any individual, the death of a family member, friend, parent or sibling may often be overwhelming. For adolescents, the death of person close to them may prove much more traumatic as it can disrupt adolescent development. Diana Mahoney (2008), with the

  • Start and Run a Successful

    1.7. Key definitions of terms Research process = a sustained effort concentrated around a topic or subject of study aimed at generating new findings, and characterized by identification and labeling of variables, research design, collection of data, analysis of data and evaluation of the problem (Shinde). Qualitative research = Research method through which researchers address the studied phenomenon by observing it in its natural environment and strive to make sense of it

  • Use of Content Filters on Internet in High School

    Internet has grown exponentially since its first introduction to the public. The precursor to the Internet was the ARPANET. The Advanced Research Projects Agency (ARPA) of the Department of Defense (Carlitz and Zinga, 1997) and the National Science Foundation (NSF) were the primary creators of the ARPANET. Subsequently however, efforts from private entities and universities have helped develop the network infrastructure, as it exists today. "The goals of ARPA's


Read Full Essay
Copyright 2016 . All Rights Reserved