Upgrade to remove ads
Only $35.99/year

MIS Exam 2 (Ch. 5-8)

Terms in this set (48)

Database
a selfhirarch-describing collection of integrated records
Hierarchy of a database
Table/Files
Records/ Rows
Fields/ columns
Bytes/ Characters
Relationship among rows
one-to one
one-many
many-many
Primary keys and foreign keys
Used to create logical relationships within the relational database model.
The primary key's main function is to uniquely identify a(n) ____ within a table.
row
must have value
must be unique
Foreign Keys (FK)
fields that reference a primary key in a related table
Four database (DBMS)operations are
read
insert
modify
delete data
DBMS (Database Management System)
a program used to create, process, and administer a database
IBM, Access, SQL Microsoft, Oracle
SQLStructured Query Language
international standard language for processing a database
used by most popular DBMS
NoSQL
A new generation of database management systems that is not based on the traditional relational database model.
Highly specialized with limitations
multi-user processing
The situation in which multiple users process the database at the same time.
database application
a collection of forms, reports, queries, and application programs that process a database
cloud
elastic leasing of pooled computer resources over the internet
cloud resources are pooled
cloud services
SaaS, PaaS, IaaS
SaaS (Software as a Service)
A form of cloud computing where a firm subscribes to a third-party software and receives a service that is delivered online.
Full featured
google grid
salesforce
apple i cloud
PaaS (Platform as a Service)
microsoft Azure
oracle on demand
IaaS (Infrastructure as a Service)
- Infrastructure as a service provides companies with computing resources including servers, networking, storage, and data centre space on a pay-per-use basis.
- IaaS Examples: Amazon Web Services (AWS), Cisco Metapod, Microsoft Azure, Google Compute Engine (GCE), Joyent
- Type of cloud computing

The benefits of IaaS
- No need to invest in your own hardware
- Infrastructure scales on demand to support dynamic workloads
- Flexible, innovative services available on demand
elastic
the computing resources leased can be increased or decreased dynamically, programmatically, in a short span of time and that organizations pay for just the resources that they use
VPN (Virtual Private Network)
usesthe internet to create the appearance of privat, secure connections
Private Cloud Computing
The use of the cloud is limited to the organization for which it was developed.
Advantages of Cloud Computing
cheap processors, data communmication, and data storage are nealry free
virtualization technology enables near instantaneous creation of a new virtual machine
Internet-based standards enable cloud hosting vendors to povide processing capabilities in flexible yet standardized ways
disadvantages of cloud computing
when a company is required to have physical control over its data
personal information system
information systems used by a single individual; EX: phone contacts, email accounts
workgroup information system (10-100 usres)
facilitates the activities of a group of people Ex. patient appointments, medical records, equipment
Enterprise information systems (100-1000 users)
information systems that span an organization and support activities of people in multiple departments
inter-enterprise information systems
information systems that are shared by two or more independent organizations
Information silos arise as a result of ________.
data being isolated in systems that are separated across different organizational levels
CRM (Customer Relationship Management)
suite of applications, a database, processes for managing customer relations
ERP (Enterprise Resource Planning)
a suite of applications called modules, a database, and a set of inherent processes for consolidating business operations into a single, consistent, computing platform
EAI (Enterprise Application Integration)
a suite of software applications that integrates existing systems by providing layers of software that connect applications together
Deming Cycle
Plan, Do, Check, Act
what is the difference between logistics and supply chain
Logistics focuses on transporting goods while supply chain focuses on finished product and/or customers.
Challenges of Enterprise Systems
Collaborative management
Requirement gaps
transition problems
Employee resistance
SMIS(social Media Informations system)
supports the sharing of contents among networks of users
Google analytics
Facebook insights
Instagram insights
social media
the use of information technology to support the sharing of content among networks of users
Social Media Roles
sponsors, users, providers
five components of SMIS
1. Hardware
2. Software
3. Data
4. Procedures
5. People
Content Data vs.
Connection Data
content data -data and responses to data contributed by users and SM sponsors
connection data- data about relationships.
social capital
the investment in social relations with the expectations of returns in the marketplace
Hyper-social organization theory
identify two kinds of communities that are important to commerce: defenders of belief and seekers of truth
Costs of Social Media
-Can increase multitasking
-Can erode productivity
-Can be a distraction
direct labor cost
someone to develop, implement and manage social networking procedures
Social Media in Value Chain Activities
...
Porter's Five Forces
threat of entry, threat of substitute, supplier power, buyer power, and competitive rivalry
Moore's Law
The number of transistors per square inch on an integrated chip doubles every 18 months
Information systems
a group of components that interact to produce information
Information Technology (IT)
refers to products, methods, indventions and standards that are usd for the puopose of producing information.
Non-routine skills
abstract reasoning, systems thinking, collaboration, ability to experiment
margin
value-cost
Other sets by this creator