1/17
Looks like no tags are added yet.
Name | Mastery | Learn | Test | Matching | Spaced |
|---|
No study sessions yet.
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