1. Explain in your own words the terms Support, Confidence and Lift used in Association rule discovery?

Support is the proportion of transactions in a data set. Confidence is a percentage value that shows how […]

1. What are the WordPress.org, WordPress.com, and Instant WordPress used for?

WordPress.com is a weblog hosting provider owned by Automattic which opened to beta testers on August 8, 2005 and opened to the […]

The Multitier Architecture pattern is a pattern that involves a separate module for each process. The most common Multitier architecture pattern is the three-tier architecture, which includes the modules: […]

2. Take a look at the SpotCrime website. Type in a few zip codes to see crime statistics in different areas. Would you consider this more an example of data analytics, or more like the OLAP analysis? Explain your […]

Clustering attempts to group entities based on the relationships with each other. Classification attempts to group entities based on a predefined group. Both group entities but in different ways.

1. Describe the METRICS and issues data mining software has to deal with

Metrics are achieved by breaking down data through the predictors. Data mining software has to take large sets of data to compute the […]

Example:

$str = “A ‘title’ is bold“;
echo htmlentities($str);

PHP MySQL Extension:
The pros are that it uses a procedural interface. Each action is an individual and simple function.
The cons are that it is too simple and does not allow for complexity.

Example: $link = […]

Data mining is the process of discovering new patterns from large data sets involving methods from statistics and artificial intelligence but also database management. Data mining is not sales analysis, profitability analysis, or sales force analysis.

Data from social apps like the one mentioned above would be valuable to electoral candidates. Data harmonization can also become a valuable asset.

1. “Users of the Obama 2012 – Are You In? app are not only giving the campaign personal data like their name, gender, birthday, current city, religion and political views, they are sharing their list of friends and information those friends share, like their birthday, current city, religion and political views. As Facebook is now [...]

ISSUES include data consistency and data quality. The keys OBJECTIVES are to extract data from the operational data store, transform it into a analysis ready format, and load it into the analytical database.

DDL: Create, Alter, Drop, Truncate, Comment, Rename
DML: Select, Insert, Update, Delete, Merge, Call, Lock Table

The main difference between cookies and sessions is that cookies are stored in the user’s browser, and sessions are not. This difference determines what each is best used for. A cookie can keep information in the user’s browser until deleted. If a person has a login and password, this can be set as a cookie [...]

1. Choosing the business process is choosing what your data cube is about according to what problems you want to solve for the business. 2. The level of granularity refers to the amount of detail for each row in the table and dictates what type of data belong in each dimension 3. Identifying the fact [...]

2. The DELETE Statement is used to delete rows from a table. DELETE FROM employee WHERE id = 100; The DROP command is used to remove an object from the database. If you drop a table, all the rows in the table is deleted and the table structure is removed from the database. DROP TABLE [...]

4. In PHP, the predefined $_POST variable is used to collect values in a form with method=”post”.

$quantity = $_POST;
$item = $_POST;

2. To add more functionality to a function, we can add parameters. A parameter is just like a variable. Parameters are specified after the function name, inside the parentheses.

<?php
function writeName($fname,$punctuation)
{
echo $fname . " Refsnes" . $punctuation . "”;
}

1. The query and update commands form the DML, such as: SELECT, UPDATE, DELETE. The DDL part of SQL permits database tables to be created or deleted. It also defines indexes (keys), specifies links between tables, and imposes constraints between tables. Examples of DDL are: ALTER TABLE, CREATE DATABASE.

1. The DISTINCT keyword can be used to return only distinct (different) values.