LESSON 6: DATA MANAGEMENT

DATABASES( RELATIONAL)

MULTIDMEINSIONAL; allowing information to be accused from various views through internal linking between entries

DATABASE RESEARCH

THE ACT OF ANALYZING AND CONVERTING DATA INTO INFORMATION THAT CAN BE USED IN DECSISION-MAKING

DATABASE TABLE:

IS COMPOSED OF RECORDS AND FIEELDS THAT HOLD DATA( DATA IS TORED IN RECORDS)

TYPES OF DATA

INTERGERS. FLOATING POINT NUMBERS, CHARACTERS, CHARCTER STRING. BOOLRAN VALUES

INTEGERS

4,34,394850

FLOATING POINT NUMBERS

9.5, 45.5, 1.7

CHARCTERS

F, !, #

CHARCTER STRING

ABC, DEF456, 3ERF78: @

BOOLEAN VALUES

TRUE, FALSE

PRODUCT OPERATION

CREATES A TABLE THAT INCLUDES ALL OR THE ATTRIBUTES FROM THE TWO TABLES

JOIN OPERATION

COMBINES TWO TABLES, BUT RECORDS ARE ONLY APPENDED  WHEN A MATERNITITY CRTIERON IS MET

NOSQL:

DATABASES CAN ACCOMMODATE A WIDE VARIETY OF DATA MODELS INCLUDING KEY-VALUE, DOCUMENT, COULUMNAR, AND GRAPH FORMULAS(USEFUL WITH LARGE SETS OF DISTRUBUTED DATA)

DATA LAKES:

IS A SYSTEM OF DATA STORED IN A RAW FROMAT

DISTRUBUTED DATABASE

CONSISTS OF DATA RESIING ON DATA RESIDING ON ON DIFFERENT MACHINES

SQL(STRUCUTURED QUERY LANAGUAGE

MOST COMMON WAY TO QUERY A DATABSE