Data And Information Flashcards
Information
Information is a collection of processed data from a variety of sources.
Data
Data includes raw facts or observations.
Data is not useful until it has been processed and is presented in a usable form.
Wisdom
Knowing the right thing to do.
Knowledge
The key term associated with knowledge is context.
Knowledge is a dynamic combination of experience, contextual information, expert insight, and grounded intuition that provides a framework for evaluating and incorporating new experiences and information.
What are the 3 levels of Data Management Systems?
Infrastructure as a Service (IaaS) - Virtualize Computer Environment
Platform as a Service (PaaS) - Better for quicker development lifecycles. Online and available
Software as a Service (SaaS) - A platform (windows, Linux, etc.) with software (such as Gmail, YouTube, etc.)
Quality Data Attributes
Precise
Valid - meets requirements of the Dara collection process
Reliable
Timely
Complete
Database
A collection of tables.
Basically, there are a bunch of Excel spreadsheets in one file.
Flat-file Database
Stores data in plain text.
CSV file type
Hierarchical Database
Oldest system
Organized into a tree with nodes and segments
Relational Databases
Most common you’ll see
Contains tables that RELATE to one another
Primary key - unique identifier, each record has one, no two records have the same value in the Primary Key
Foreign Key field relates to the Primary key field in another table, defines the relationship
Structured query language (SQL) code
Includes queries to identify what data should be retrieved or how the data should be manipulated
What does the selection operation do (SQL)?
The selection operation takes rows from one table and creates a new table.
Explain this syntax.
SELECT * FROM Patient
WHERE PatientID = ‘223344’ ;
SELECT - identifies the records that are being requested
Asterisk (*) - means everything from that table
FROM - identifies the table name (Patient)
WHERE - the condition the query is requesting