The key objectives of getting data into the data mark are:
*Copying data form traditional to analytical databases.
*Being able to determine where the data that should come from to fill the data mark.

Issues: […]

Summarize what data mining is and what data mining is not?

Data mining is the process of uncovering patterns in data from database. Similar between groups and rows which tries to discover new information form […]

The metrics is a measurement which shows the outcome of results, these results derive form breaking down data into decision trees while measuring the probability of each outcome.
Issues such as different paths […]

Clustering is used to bring entities together based on their relationship, and is called this because the organization isn’t defined.

Classification is when there are predefined sets of groups that you add entries too.

For instance, data mining is useful for answering problems such as age demographic, market size, consumer behavior. Mining for these issues would be an example of predictive analysis due to the recent data […]

-Classification is when there are predefined sets of groups that yo add entries into

-Clustering is used to bring entities together based on their relationship

-Association rule is discovering relationships […]

A] Not always about business, however this is determined by the questions you want to answer about your organization, say for instance who is my best customer. B] Is the level of detail for each row in table (event) which determines data in the dimensions model C] this is determined by he business process and [...]

Describe the differences between Alter and Insert and provide an example.

Alter modifies, adds, and removes existing columns changing the structure within the database.
ALTER TABLE ‘m59orderdb’ ‘Product’ ADD COLUMN ‘Manufacturer’
Insert adds a new row in the existing table of the database.
INSERT INTO…[Read more]

1. What SQL command is used to retrieve unique values?

The SQL command thats used to retrieve unique values is the SELECT DISTINCT command, which will retrieve all the unique entries and by-pass repeated entries.

Describe the use of back quotes.

The ‘back quotes’ tells the SQL to distinguish a object from a command, in doing so SQL knows your searching for something unique or specific within a table rather than just the table.

Describe the use of back quotes.

The ‘back quotes’ tells the SQL to distinguish a object from a command, in doing so SQL knows your searching for something unique or specific within a table rather then just the table.

The primary key is apart of the analysis process (attribute) and is implemented along with three key elements. For instance, the primary key might be a persons social security number or TU ID number to ensure the specific identity of the customer/person being served. Usage of the primary key is to eliminate confusion throughout multiple [...]

1. Transactional data is captured data that describes something or events taking place within real time. Analytical data is data that supports and reports transactional data into information and is historical. The role of transactional data is for everyday transactions used to make operational decisions. While the role of analytical data is for…[Read more]