Artificial Intelligence (AI)
Is the branch of computer science that deals with the attempt to create computers that think like humans.
Means that transaction date is accumulated until a certin point is reached, and then several tranactions are processed all at once.
Business Intelligence System
Are used to analyze and interpret data to enable managers to make informed decisions about how bust to run a business.
Computational Field (Calculated Field)
Is a numeric field that stores the contents of a calculation, which is generated with a formula in the numeric field.
Compaires the value of data in two or more fields to see if these values are reasonable.
Ensuring integrity, instead of being in multipal lists that have to be maintained, the information is maintained in only one place.
Each time the information in the list changes, multiple lists must be updated and if not, then inconsistent data results.
Three Steps of Data Staging
Step 1: Extraction of the data from source databases.
Step 2: Tranformation (reformatting) of the data.
Step 3: Storage of the data warehouse.
Is a large-scale electronic respository of data that cantains and orgaizes all the data related to an organization in one place.
Database Sdministrator (Database Designer)
An individual trained in the design and building of databases, to assist with the construction of large databases.
Database Managment System (DBMS)
Specially designed application software (such as Oracle Database or Microsoft Access) that interacts with the user, other applications, and the database to capture and analyze data.
A queation you ask the database so that it provides you with the records you wish to view.
Decision Suport System (DSS)
Is another type of business intelligence system designed to help managers develop soultions for specific problems.
Enterprise Resource Planning (ERP) System
Is a broadbased software that integrates multiple data sources and ties together the various processes of an enterprise to enable information to flow more smoothly.
Tried to replicate the decision-making processes of human experts to solve specific problems.
Involves putting it into an electronic file in a format that another application can understand.
External Data Source
Is any source now owned by the company that owns the DSS, such as customer demographic data purchased from third parties, mailing lists, or staistic compiled by the federal government.
Types Of Fields
Text Field, Numeric Field, Computational (Calculated) Field, Date/Time FIeld, Memo Field, Object Field, Hyperlink Field.
Any property that must be satisfield for an entry to be accepted into the database field.
The primary key of another table that is included for purposes of establishing relationships with that other table.
Enable the interjection of exteriential learning into the equation by considering probabilities.
Provides a view of the data fields to be filled, with appropriate labes to assist database users in populating the database.
Provides additional intelligence that supplements the users own intellect an makes the DSS more effective.
Management Information System (MIS)
Provides timely and accurate information that enables managers to make critical business decisions.