Data and Database Management Flashcards
It is a collection of text, numbers, symbols, images, or videos in raw or unorganized form.
Data
What has to be processed or provided with a context, before it can have meaning?
Data
It describes the object under consideration using a finite set of discrete classes.
Qualitative or Categorical Data
This type of data can’t be counted or measured easily using numbers and therefore divided into categories.
Qualitative or Categorical Data
Since qualitative data can’t be counted or measured easily using numbers, it is therefore divided into what?
Categories
This type of data are usually extracted from audio, images, or text medium.
Qualitative or Categorical Data
What are the two subcategories of qualitative data?
Nominal
Ordinal
The values grouped into these categories have no meaningful order and no hierarchy.
Nominal
What are the examples of Nominal level values?
Gender
Occupation
These types of values have a natural ordering while maintaining their class of values.
Ordinal
What is the example for the Ordinal level value?
Ranking of student’s grades
This data type tries to quantify things and it does by considering numerical values that make it countable in nature.
Quantitative Data
What are the two subcategories of quantitative data?
Discrete
Continuous
The numerical values which fall under are integers.
Discrete
Which category is it where whole numbers are placed?
Discrete
What is the example of Discrete?
Number of clothes in a cabinet
The fractional numbers are considered as continuous values.
Continuous
What are the examples of Continuous?
Days in a week
Months in a year
It is an organized or classified data, which has some meaningful values for the receiver.
Information
It is the processed data on which decisions and actions are based.
Information
For the decision to be meaningful, the processed data must qualify what characteristics?
(CAT)
Completeness
Accuracy
Timely
This characteristic of information means that it should be available when required.
Timely
This characteristic of information means that it should be accurate.
Accuracy
This characteristic of information means that it should be complete.
Completeness
It refers to the raw input that when processed or arranged, makes meaningful output.
Data
It is usually the processed outcome of data.
Information
What happens when data is processed into information?
It becomes interpretable and gains significance.
What is done before data becomes interpretable and gains significance?
Data is processed into information
What is the equation for information?
Data + Meaning = Information
It is produced as a result of understanding the given information and using that information to gain knowledge of how to solve problems.
Knowledge
Knowledge can be what?
- Acquiring and remembering a set of facts
- The use of information to solve problems
What are the two types of knowledge?
Explicit Knowledge
Tacit Knowledge
It is the acquisition by a person of information or the understanding of information.
Explicit Knowledge
This knowledge can be easily passed on to others.
Explicit Knowledge
Most forms of explicit knowledge can easily be stored in certain media like what?
Documents
Books
Computers
This is documented information that can facilitate action.
Explicit Knowledge
This type of knowledge can be easily identified, articulated, shared, and used.
Explicit Knowledge
What are the good examples of Explicit Knowledge?
Encyclopedias
Textbooks
This knowledge is difficult to pass on to someone else.
Tacit Knowledge
This knowledge is embedded in the human mind through experience and jobs.
Tacit Knowledge
This knowledge includes insights and intuitions.
Tacit Knowledge
What is the fragmented pieces of symbols and characters threaded together?
Data
What is the refined data?
Information
What do you call the useful information?
Knowledge
What can give you a lack of context when looked at singularly?
Data
What can give you context to data?
Information
What can give you depth in understanding an information?
Knowledge
What is the outcome for information and knowledge?
Information = Comprehension
Knowledge = Understanding
What is incomprehensible independently?
Data
What is amplifies consciousness?
What is meaningless without being compiled into a sensible structure?
What improves representation?
- Knowledge
- Data
- Information
What are not sufficient to make any predictions?
Data and Knowledge
What do you call when prediction is possible if one possesses the require experience?
Knowledge
What is the data that is connected together to form a statement?
What cannot make any statements?
What brings the ability to have a deduced conclusion using pieces of information?
- Information
- Data
- Knowledge
What cannot independently be a basis for question formation?
What is a text that answers the ‘how’ and ‘why’?
What is a text that answers the ‘who’ ‘what’ ‘when’ and ‘where’?
- Data
- Knowledge
- Information
It is the interdisciplinary process of creating, using, sharing, and maintaining an organization’s information and knowledge.
Knowledge Management
It is a multi-faceted strategy for making the best use of organizational knowledge assets in order to achieve business objectives.
Knowledge Management
What are the business objectives under Knowledge Management?
(BESIC)
Boosting innovation
Enhancing competitive advantage
Sharing insights
Improving performance
Continuously improving the organization
It is part of the organizational learning process.
Knowledge Management
What focuses on the strategic management of knowledge as a shareable business asset?
Knowledge Management
What is the core goal of knowledge Management?
(What, Where, Why, Who)
What: Connect people looking for knowledge
Where: Within the organization
Why: Increase overall knowledge level
Who: Team and Organization
Four Knowledge Management Objectives
(SIMI)
Streamlining and enhancing the KE (knowledge environment)
Improving the KCP (knowledge capture process)
Maintaining knowledge as an OA (organizational asset)
Increasing asset to OK (organizational knowledge)
It is an organized collection of information that can be easily accessed, managed, and updated.
Database
What can typically contain aggregations of data records or files, containing information about sales transactions or interactions with specific customers?
Computer Databases
Who provides the users with access to some permissions in a database?
Database Managers
Database Managers provides users with what?
(ASA)
Ability to control read/write access
Specifically report generation
Analyze usage
What does the abbrev. in ACID compliance mean?
Atomicity
Consistency
Isolation
Durability
What do some databases offer to guarantee that data is consistent and that transactions are complete?
ACID Compliance
Who, where, when did the relational database was invented?
Who: E.F. Codd
Where: IBM
When: 1970
What are the types of databases?
(OG-NCRD)
Object-oriented Database
Graph Database
NoSQL Database
Cloud Database
Relational Database
Distributed Database
It is a tabular database in which data is defined so that it can be reorganized and accessed in a number of different ways.
Relational Database
It is made up of a set of tables with data that fits into a predefined category, where each table has at least one data category in the columns.
Relational Database
It is the standard user and application program interface for a relational database.
SQL
What does SQL stand for?
Standard Query Language
These are easy to extend, and a new data category can be added after the original database creation without requiring to modify all the existing applications.
Relational Database
In a Relational Database, what can be added after the original database creation?
New data category
It is a database in which portions of the database are stored in multiple physical locations.
Distributed Database
Distributed Database can be what?
Homogeneous
Heterogeneous
What do you call the kind of Distributed Database where the physical locations have the same underlying hardware and run the same OS and DB Applications?
Homogeneous Distributed Database
What kind of Distributed Database is it when the hardware, OS, and DB applications are different in every location?
Heterogeneous Distributed Database
It is a database that has been optimized or built for a virtualized environment, either in a hybrid, public, or private.
Cloud Database
What are the benefits that the Cloud Database provides?
Ability to pay for Storage Capacity and Bandwidth on a per-use basis
Provide scalability on demand
Highly available
Cloud Database gives enterprises the opportunity to support business applications in what?
Software-as-a-Service (SaaS)
What kind of data base is useful for large sets of distributed data?
NoSQL Database
What are effective for big data performance issues that relational databases aren’t built to solve?
NoSQL Database
What are most effective when an organization must analyze large chunks of unstructured data or data stored across multiple virtual servers in the cloud?
NoSQL Database
Where do the items created using object-oriented programming languages are often stored?
Relational Database
It is organized around objects rather than actions, and data rather than logic.
Object-oriented Database
It is a type of NoSQL database that uses graph theory to store, map, and query relationships.
Graph Database
It’s basically collections of nodes and edges.
Graph Database
What do the nodes and edges represent in a Graph Database?
Nodes - an entity
Edges - connection between nodes
What is growing in popularity for analyzing interconnections?
Graph Database
It is a declarative programming language and protocol for graph database analytics that Graph Databases often use.
SPARQL