Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
63 Cards in this Set
- Front
- Back
INFORMATION GRANULARITY
|
the extent of detail within the information
(fine and detailed or coarse and abstract?) |
|
characteristics of high quality information:
|
-accuracy
-completeness -consistency -uniqueness -timeliness |
|
low quality information:
|
-missing info
-incomplete info -probable duplicate info -potential wrong info -inaccurate info -incomplete info |
|
information is stored in ___
|
databases
|
|
DATABASE
|
maintains info about various types of objects (INVENTORY), events (TRANSACTIONS), people (EMPLOYEES), and places (WAREHOUSES)
|
|
database models:
|
hierarchial network or relational
|
|
HIERARCHIAL DATABASE MODEL
|
info is organized into a tree (using parent/child rlships) in such a way that it cannot have too many relationships
|
|
NETWORK DATABASE MODEL
|
a flexible way of representing objects and their relationships
|
|
RELATIONAL DATABASE MODEL
|
stores info in the form of logically related 2d tables
|
|
database advantages:
|
-Increased flexibility
-Increased scalability and performance -Reduced information redundancy -Increased information integrity (quality) -Increased information security |
|
a well-designed database should:
|
-Handle changes quickly and easily
-Provide users with different views -Have only one physical view -Have multiple logical views |
|
PHYSICAL VIEW
|
deals with the physical storage of information on a storage device
|
|
LOGICAL VIEW
|
focuses on how users logically access information
|
|
SCALABILITY
|
how well a system can adapt to increased demands
|
|
PERFORMANCE
|
measures how quickly a system performs a certain process or transaction
|
|
REDUNDANCY
|
duplication of info or storing the same info in multiple places
|
|
primary problem with redundant information:
|
INCONSISTANCY
|
|
INFORMATION INTEGRITY
|
measures the quality of the info
|
|
INTEGRITY CONSTRAINT
|
rules that help ensure the quality of the info
|
|
RELATIONAL INTEGRITY CONSTRAINT
|
rule that enforces basic and fundamental info-based constraints
|
|
Business-critical integrity constraint –
|
rule that enforce business rules vital to an organization’s success and often require more insight and knowledge than relational integrity constraints
|
|
security features of databases
|
-password
-access level (who has access to different types of info) -access control- like read-only |
|
ENTITY
|
a person, place, thing, transaction, or event about which information is stored
|
|
ATTRIBUTES (fields, colums)
|
characteristics or properties of an entity class (name, phone, etc)
|
|
___ and ___ identify the various entity classes in the database
|
primary keys and foreign keys
|
|
PRIMARY KEY
|
a field (or group of fields) that uniquely identifies a given entity in a table
|
|
FOREIGN KEY
|
a primary key of one table that appears an attribute in another table and acts to provide a logical relationship among the two tables
|
|
DBSM
|
database mgmt systems
software thru which users and application programs interact w/ a database |
|
4 componants of DBSM:
|
Data definition
Data manipulation Data administration Application generation |
|
DATA DEFINITION component
|
creates and maintains the data dictionary and the structure of the database
includes the DATA DICTIONARY |
|
DATA DICTIONARY
|
a file that stores definitions of information types, identifies the primary and foreign keys, and maintains the relationships among the tables
DEFINES THE LOGICAL PROPERTIES OF THE INFO THAT THE DATABASE CONTAINS |
|
DATA MANIPULATION component
|
allows user to create, read, update, and delete info in a database
data manipulation tools include: view, report geenerator, query by example or QBE, and structured uery language SQL |
|
view
|
allows users to see, change, sort, and query the database content
|
|
report generator
|
users can define report formats
|
|
QBE
|
query by example
users can graphically design the answers to specific questions |
|
SQL
|
query language
structured query language |
|
APPLICATION GENERATION component
|
includes tools for creating visually appealing and easy to use applications
|
|
DATA ADMIN component
|
provides tools for managing the overall database environment by providing faculties for backup, recovery, security, and performance
|
|
DATA WAREHOUSE
|
a logical collection of information – gathered from many different operational databases – that supports business analysis activities and decision-making tasks
The primary purpose of a data warehouse is to aggregate information throughout an organization into a single repository for decision-making purposes |
|
ETL
|
extraction, transformation, and loading
a process that extracts information from internal and external databases, transforms the information using a common set of enterprise definitions, and loads the information into a data warehouse |
|
DATA MART
|
containts a subset of data warehouse information
|
|
DATA MINING
|
the process of analyzing data to extract info not offered by the raw data alone
|
|
DATA MINING TOOL
|
uses a variety of techniques to find patterns and relationships in large volumes of information and infers rules that predict future behavior and guide decision making
|
|
ENTERPRISE ARCHITECTURE
|
includes plans for how an org will build, deploly, use, and share its data, processes, and IT assets
|
|
ENTERPRISE ARCHITECT (EA)
|
a person grounded in technology, fluent in business, a patient diplomat, and provides the important bridge between IT and the business
|
|
primary goals of enterprise architectures
|
reduce costs/improve productivity
improve customer satisfaction create competitive advantage |
|
RECOVERY
|
the ability to get a system up and running in the event of a system crash or failure
includes restoring the info backup |
|
WEB SERVICE
|
contains a repertoire of Web-based data and procedural resources that use shared protocols and standards permitting different applications to share data and services
|
|
INTEROPERABILITY
|
- the capability of two or more computer systems to share data and resources, even though they are made by different manufacturers
|
|
EVENT
|
detect threats and opportunities and alert those who can act on the information
|
|
SERVICE
|
more like software products than they are coding projects, and must appeal to a broad audience, and they need to be reusable if they are going to have an impact on productivity
|
|
OPEN SYSTEM
|
a broad, general term that describes nonproprietary IT hardware and software made available by the standards and procedures by which their products work, making it easier to integrate them
Allow systems to seamlessly share information Capitalize on enterprise architectures Eliminate proprietary systems and promote competitive pricing |
|
ERP
|
Enterprise resource planning – integrates all departments and functions throughout an organization into a single IT system (or integrated set of IT systems) so that employees can make enterprisewide decisions by viewing enterprisewide information on all business operations
|
|
reasons ERP systems are powerful organizational tools:
|
-logical solution to the mess of incompatible applications
-addresses the need for global info sharing and reporting -used to avoid the pain and expense fo fixing legacy systems |
|
ERP benefits
|
-Integrate financial information
-Integrate customer order information -Standardize and speed up manufacturing processes -Reduce inventory -Standardize human resource information |
|
ERP risks
|
software cost
consulting fees process rework customization integration and testing training data warehouse integration |
|
MIDDLEWARE
|
several different types of software which sit in the middle of and provide connectivity between two or more software applications
|
|
Enterprise application integration (EAI) middleware –
|
packages together commonly used functionality which reduced the time necessary to develop solutions that integrate applications from multiple vendors
|
|
MASTER DATA
|
does not change very often
A unique master record is created for each General Ledger account contains control info for data entry and data processing |
|
CONFIGURATION
|
Refers to specifying table settings which control how the system operates.
The process of tailoring SAP software by selecting specific functionality from a list of those supported by the software, very much like setting defaults (e.g., Word, Access) DOES NOT involve changes to the underlying software code Very much like changing switches or setting defaults Configuring is what you do to have the system be able to execute your business processes the way you want them to. (e.g. If you deliver steel, you don’t want a Ferrari, you want a semi-truck. SAP can be either depending upon how you configure it.) Be careful with configuration. Once it is done, it is very difficult to undo. |
|
DOCUMENT PRINCIPLE
|
Every transaction is an electronic document. It keeps track of everything you do.
Allows users to track every action taken in a company. Simply put, it allows users to answer the question “Where’s my order.” What Where it is and where it came from, and where is it going next When Who |
|
CHART OF ACCOUNTS
|
The foundation for the General Ledger is the Chart of Accounts
A Chart of Accounts contains a complete list of all of the accounts utilized in the General Ledger for a given company Financial accounting reports are prepared from the balances contained in the General Ledger’s Chart of Accounts Chart of Accounts This is a list of all G/L accounts used by one or several company codes. For each G/L account, the chart of accounts contains the account number, account name, and the information that controls how an account functions and how a G/L account is created in a company code. There are five types of accounts contained in a Chart of Accounts Assets Liabilities Equity Revenues Expenses There are two primary accounting reports prepared from the General Ledger Chart of Accounts Balance Sheet Income Statement Chart of Accounts This is a list of all G/L accounts used by one or several company codes. For each G/L account, the chart of accounts contains the account number, accoun |
|
5 types of accounts in CHART OF ACCOUNTS:
|
assets
liabils equity revenues expenses |