StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

High Level ETL and Data Mining Requirements - Research Paper Example

Cite this document
Summary
These methodologies consider requirements specification as one of the early activities of the project (Miller & Han, 2001).
There are a few constraints…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER96.1% of users find it useful
High Level ETL and Data Mining Requirements
Read Text Preview

Extract of sample "High Level ETL and Data Mining Requirements"

High Level ETL and Data Mining Requirements Introduction A Data Mining and ETL methodologies seek to organize the pattern discovery process in the data warehouse of an organization. These methodologies consider requirements specification as one of the early activities of the project (Miller & Han, 2001).High Level ETL ETL is the process in database usage especially data warehousing that involves the following activities:Extracting data from external sources.Manipulating data to fit the operational needs.

Loading data to the target.RequirementsBuild and Buy There are a few constraints that may prevent one from purchasing a product. After buying the hardware and software tools, one may not have enough money left for an ETL purchase. When considering on buying versus build, there are a few key items that can guide one in making the decision. The prices of ETL tools have not dropped over the last few years. It is important to evaluate the project keenly. Many people go for the expensive products without considering whether using a low-end or hand coding tool would be easy, fast or cost-effective.

When buying an ETL product, especially a more complex ETL, it will still be essential to train the project personnel. Training is more expensive than buying ETL for a project and should be considered when comparing the buying and development costs.Business Needs Business requirements are the functional requirements needed. They describe the needed solution in business terms. Gathering of information includes requirement interviews, workshop and enterprise objectives.Future Load Plans The future comes with questions as to how much is to be charged for products when combined with other suppliers products.

During the initial load improvement steps, all foreign key constraints are removed before executing the ETL stored procedure. The ETL stored procedure is called with a procedure that is truncated. ETL can be used to convert the data into a layout suitable for use in the new software. The initial load occurs in the analysis phase of the project. The timing to replace the tactical design choices is dependent on time on hand and the business requirements.Implementation Successful implementation starts with asking questions as to whether it is worth building the software, while it can be bought and used diversely in different applications.

If there is evident justification, then it is now appropriate to by the software.Recommendations The company should buy the tool because it is fast and the tool can be reused in other projects. The amount of ETL development time will be significantly reduced. The tools will be of a wide range and can be reused for future projects.Data Mining It is the practice of analyzing information from different dimensions and simplifying it in meaningful information (Clifton, 2010). It allows its users to examine data from many different proportions gives a summary of the relationships listed.

RequirementsData source- Determining which information source is to be utilized and where it is to accomplish its indented objective.Requirements contingency plans - It is necessary to define the contingency plans in order to address emerging problems or setbacks.Restriction requirements - It is necessary to identify requirements limits; they should be consistent.Classification and Clustering Classification and clustering are often mentioned in same categories, although they employ different approaches.

Clustering is a process to group related records together. Related records are categorized together on the basis of having similar characteristics. This approach is often used as an exploratory technique. This is because it is not necessary for the analyst to specify how records should be categorized together ahead of time. ReferencesClifton, C. (2010). Data mining. Encyclopedia Britannica. Retrieved from http://www.britannica.com/EBchecked/topic/1056150/data-miningMiller, H. J. & Han, J. (Eds.). (2001).

 Geographic data mining and knowledge discovery. London: Taylor & Francis.

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“High Level ETL and Data Mining Requirements Research Paper”, n.d.)
High Level ETL and Data Mining Requirements Research Paper. Retrieved from https://studentshare.org/information-technology/1606700-high-level-etl-and-data-mining-requirements
(High Level ETL and Data Mining Requirements Research Paper)
High Level ETL and Data Mining Requirements Research Paper. https://studentshare.org/information-technology/1606700-high-level-etl-and-data-mining-requirements.
“High Level ETL and Data Mining Requirements Research Paper”, n.d. https://studentshare.org/information-technology/1606700-high-level-etl-and-data-mining-requirements.
  • Cited: 0 times

CHECK THESE SAMPLES OF High Level ETL and Data Mining Requirements

Business Process for IKEA to Manage Supply Chain

For TPS, IKEA should introduce RDIF technology in its inventory management for enhanced level of dialing activity with assured tracking system.... On the other that, these opportunities for rapid business growth has also caused in intensifying the competition in international level....
7 Pages (1750 words) Research Paper

Big Data Analytics

For this purpose, there are a number of frameworks and users can select a suitable framework according to their needs and requirements.... The paper "Big data Analytics" presents a detailed analysis of big data analytics.... This paper will discuss various aspects associated with big data analytics.... This paper will discuss some of the uses and issues of big data analytics.... hellip; The term “big data” is normally used as a marketing concept refers to data sets whose size is further than the potential of normally used enterprise tools to gather, manage and organize, and process within an acceptable elapsed time....
7 Pages (1750 words) Literature review

Business Intelligence Dashboards in a Learning Organization

data mining tools such as data marts, data warehouses, dashboards, etc.... CEO, CIO or they may display metrics targeting specific point of view or a department for the managers or they can give a high level as well as a detailed view of the organization's performance based on its data which all the committed employees can gain benefit from.... Business intelligence dashboards gather data from diverse and numerous sources.... The finest of business decisions are data driven....
7 Pages (1750 words) Research Proposal

Distributed Database

In data warehousing project, the logical data model is built based on user requirements, and then it is translated into the physical data model.... Given that the ActiveWear Traders Clothing Australia has a Headquarters in Brisbane (BRISHQ), and warehouses in both Brisbane (BRISWH) and Melbourne (MELWH) with more than 60 retail stores across the country. Create the processes that extract data from source systems; cleanse, transform, and match data according to specified business rules; import data into the data warehouse structure; use query, reporting, and mining tools to access the data and address key business questions … The questions identified encompass business processes related to new subscriber acquisition, demographic household maintenance, subscriber account maintenance, subscription marketing, and customer list profiling. 1....
12 Pages (3000 words) Essay

Whats the Scope of What Can Be Considered a Data Warehousing Failure

Some of them are over budget, extended deadline (unreasonable deadline for a project) or pushing back the milestone dates, management support (lack of formal commitment from management), lack of focus, or difficulty in identifying the scope of the Project (a business case for the data warehouse not clearly defined), poor data warehousing tool selection process,  unproven technology (new or inappropriate software), internal politics within organization, end-user involvement/participation in determining information requirements,  incomplete functionality, unsatisfied end users, data warehouse tool implemented too complicated for users, below standard or unacceptable performance, not expandable once made, quality of report and data, management does not recognize the benefits of data warehousing, the cost is considered instead of a project, inappropriate data sources, etc....
5 Pages (1250 words) Assignment

Quality control throughout the life cycle

After having identified all possible sources and effects of a particular problem and data collection through check sheets, pareto chart helped to identify the problems and its source with largest occurrences.... Also a number of risks may need to be reviewed including regulatory requirements to procurements and additional resource allocation.... ccording to PMBOK (2008), “quality is the degree to which a set of inherent characteristics fulfill the requirements”....
2 Pages (500 words) Assignment

Knowledge Management to Support Business Performance

The paper "Knowledge Management to Support Business Performance" discusses that data mining and knowledge management techniques are really essential for the current business.... data mining and knowledge management are state-of-the-art techniques for future business decision-making and management.... hellip; The BI with data Warehousing involvement has been proposed to give support to our business to carry out standard marketplace trends investigation, follow the corporation's performance in the particular marketplace situations, clientele' and contributor performance, plus their preference in addition expenditure outlines....
8 Pages (2000 words) Coursework

Business in Denver

This will provide an exciting experience to consume high-quality food while window shopping and walking inside the shopping mall.... The researcher of this paper states that 303 Deliche Steak will be a unique restaurant which will meld delicious cuisine with a fun-filled and entertaining environment....
11 Pages (2750 words) Research Paper
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us