MIS 3500 MIDTERM (Overview of DB)

Can come in various shapes, such as numbers and text. This is the raw piece of data that is extracted from a target group

StudentID, First Name, Last Name, Date of Birth, etc.

Something you get after you change raw data into useful insights (aka processed data)

This type of data has clearly defined types where it is easy to identify valid and invalid data

• Numbers (e.g., product price, produce bar code)

• Text (e.g., Product Name, Color, etc.)

• Dates (e.g., Order Date, Shipment date, etc.)

A type of data that has only loosely defined valid and invalid values. Tends to be very complex and difficult to analyze.

• Images

• Audios

• Videos

• Documents

Descriptions of the properties or characteristics of the actual data, including the data type of the data, file sizes, allowable values, and data context.

In simple terms, it describes the user data.

A collection of data that are specially structured for storing and retrieval

A system/program/application used to create, process, and administer other databases.

Multiple databases can be stored and hosted.

1) Relational

2) Object-orientated

3) NoSQL

4) Single-User/Multi-User

Most commonly used for structured data, and data is stored in tables with rows and columns

This DBMS stores data in the form of objects, similiar to how they are used in object-orientated programming (think of RStudio, how we store vectors in objects)

This type of DBMS are designed to handled unstructured or semi-structured data and provide more flexibility than traditional relational DBMS

This type of DBMS can only be sued by ONE user.

Good for smaller databases.

Some examples are Microsoft Access and LibreOffice Base

This type of DBMS can be used by multiple users.

Good for larger databases that need to be accessed by multiple people.

Some examples are: Microsoft SQL Server, IBM DBS, Oracle, and MySQL

1) Manual File Systems

2) Computerized file systems

A type of data management that used file folders and filing cabinets, and data were often stored on paper and categorized by file folders.

Data processing (DP) specialist created a computer-based system to track data and produce required reports.

1) Program data dependence

2) No standards about defining data & manipulating data

3) No centralized control of data

Data redundancy and inconsistency

Lengthy development times

Excessive program maintenance

Limited data sharing and Lack of data security

1) Program-data independence

2) SQL (Structured Query Language)

3) Centralized Control of Data

A standard language to define and manipulate data

1) Create a database model

2) Create your tables

3) Specifying relationships between tables

4) Insert data

A simplification of reality