MIS Exam 2 Flashcards
(24 cards)
What is the purpose of a database?
-Organize and keep track of things
-Keep track of multiple themes
-General rule:
Single theme - store in a spreadsheet
Multiple themes - use a database
What is a byte in a database?
a character of data
What are alternative names for columns, rows, and tables?
records
What is metadata?
special data that describes the structure of a database
What are keys and foreign keys in a database?
a column or group of columns that identifies a unique row in a table
What is a relational database and what are its features?
databases that carry their data in the form of tables and represent relationships using foreign keys
What is DBMS and its three functions?
database management system.
create, process, and administer a collection of self-describing integrated records
Which DBMS and non-relational data store products are available in the market?
?
Will NoSQL replace relational DBMS?
only for specialized applications
What is SQL?
- Structured Query Language
- international standard
- a DBMS product from microsoft
What is a database application and what does it do?
Collection of forms, reports, queries and application programs serves as intermediary between users and database data.
What are features of browser-based applications?
Provide security, maintain data consistency, and handle special cases.
What is the nature of cloud?
elastic leasing of pooled computer resources over the internet
What does it mean for cloud to be elastic?
Leased computing resources increased or decreased dynamically, programmatically, in a short span of time and organizations only pay for resources used.
What are web services?
they are SOA-designed programs that comply with web service standards
What are pros and cons associated with cloud-based and in-house hosting?
?
Why is cloud hosting becoming popular?
virtualization allows instantaneous creation of new virtual machines
What is SaaS, Paas, and Iaas?
Saas (software as a service)
Paas(platform as a service)
Iaas(infrastructure as a service)
What is CDN and what are CDN’s benefits?
content delivery network.
they reduce users access cost by delivering data faster
What is VPC and what are its characteristics?
virtual private cloud
-can be built on public cloud infrastructure
What is the difference between VPC and VPN?
VPC provides the advantages of cloud storage, but a VPN by itself cannot provide these advantages.
What is the advantage of using a private cloud over a VPC?
Unlike a VPC, a private cloud does not require permission from regulating bodies to host sensitive data.
What is VPN and what are its characteristics?
virtual private network
- it uses the internet to create secure point-to-point connections
- it sends encrypted messages over the public internet
What are potential consequences of cloud computing in the future?
the cost of creating elastic resources will decrease
