A support is the frequency of which a certain item is contained in a data set. Confidence determines the frequency of items in the transactions that are alike the observed items. A Lift is used to monitor the […]

SpotCrime.com represents OLAP analysis because the information can be sorted using date, time, type of crime, and address. This information is displayed on a map and is multidimensional. Slicing and dicing this […]

Classification and Clustering both involve grouping data. Classification is a process that organizes the data. This can be done different ways depending on which questions need to be answered. Clustering the […]

Classification and decision trees use the Gini test in order to create more leaf nodes on the decision trees. These leaf nodes make the data more organized and more separate so it is more specific to the […]

Data mining extracts information that was previously unknown and possibly useful. Data mining can predict what will happen in the future and why something is happening. In order to discover patterns in the data […]

Presidential candidates would find social networking sites such as Facebook, Twitter, and YouTube extremely beneficial. Using “likes” and other factors on social media can help candidates determine what to focus […]

When first getting accustomed to a database, SELECT* is the function to use because it returns every column when completed. If you want to search for a specific column or group of columns from your database […]

Four Steps of Data Cube Design:

a) choosing the business process – this step is used to determine what the business cube is about out and figure our what business model the company uses.
b) deciding on the […]

The ALTER command can modify a database while the INSERT command puts information in a database. ALTER is a DDL command and INSERT is a DML command. If you wanted to ALTER a table, you could change someone’s […]

Queries and update commands (select, update, delete, and insert into) are all contained in the Data Manipulation Language (DML). Database tables can be created or deleted, specify links between the multiple […]

Tables, rows, columns, and identifiers (primary key) are all aspects of a relational database. A table uses columns and rows to sort the information, and each row is assigned an identifier. Each database has […]

A primary key is an characteristic, or many characteristics, that are used to identify a specific entity. This primary key is needed so each entity is different from each other. Making them all different makes […]

Kathryn Cudemo, Tuanh Nguyen, Brandon Elz

1. Gender
2. Age
3. Location
4. Photos/Videos
5. Friends
6. Interests (“Likes”)
7. Jobs/Education
8. Games
9. Interactions with other ads
10. Religion

Transactional data is used to complete real-time tasks. Transactional data would be used in order to land an airplane. Analytical data is data gathered in the past to help predict future actions and tasks. This […]