Book - Chapter 11 In Database Analytics Flashcards Preview

EMCDSA > Book - Chapter 11 In Database Analytics > Flashcards

Flashcards in Book - Chapter 11 In Database Analytics Deck (25)
Loading flashcards...
1

What does in database analytics mean

Describe the processing of data within its repository

2

What are the three advantages to using tables

Disk storage saving. Changes and corrections are easily made. Products can be added to the database prior to any orders being placed.

3

What is the process of reducing duplications

Normalisation

4

What is the select function

Specifies the table columns to be displayed

5

What is the from function

Specifies the name of the table to be queried

6

What is the where function

Specifies the criterion or filter to be applied

7

What is the joint function

Specify the relationships between the multiple tables

8

What is an inner join

Returns rows from the two tables where the ON criteria is met

9

What is the order by function

Sorts of records

10

What is a right outer join function

All rows on the table on the right hand side of the join should be returned regardless of whether there is matching

11

What is the union all function

Mergence the results of the two select statements regardless of any duplicate records appearing in both select statements

12

What is the union function

It is the same as the union all by which it emerges the results of two select statements but it eliminates any duplicates

13

What is the intersect function

Determines any identical records that are returned by two select statements.

14

What is the sub query

Also known as a nested query. It is an SQL query with in a query

15

What is the roll up function

Provides of subtotal

16

What is the cube function

Providing subtotals for each column specified

17

In regular expressions what does this symbol mean
^

Looks for matches at the beginning of the string

18

In regular expressions what does this symbol mean
|

Matches item A or B

19

In regular expressions what does this symbol mean
$

Looks for matches at the end of the string

20

In regular expressions what does this symbol mean
*

Matches preceding item 0 or more times

21

What is a rank function

Can be used to order a set of rose based on some attribute

22

What does EWMA stand for

Exponentially weighted moving average

23

What is madlib

And open source library for scalable in database analytics

24

What does madlib stand for

Magnetic agile deep

25

What is the data lake

Represents an environment that Kalex and stores large volumes of structured and unstructured data sets