comparisions (final) Flashcards
(discontinued) there are no comparisions in final.
proprietary software and off the shelf software
Proprietary software: a one-of-a-kind program for a specific application owned by the company, organization, or person that uses it.
Off-the-shelf software: software mass-produced by software vendors.
utility program and middleware
utility program: a program that helps to perform maintenance or correct problems with a system.
middleware:
application software and systems software
application software: consists of programs that helps to solve problems and perform specific tasks
system software: consists of programs that control the computer hardware.
IDE and SDK
IDE: ombines all the tools required for software engineering into one package
SDK:
primary key and data item and attribute
data item: the specific value of an attribute.
primary key: a field or set of fields that uniquely identify a record
attribute: a characteristic of an entity
data validation and data cleansing
data validation: involves the identification of “bad data” and its rejection at the time of data entry.
data cleansing: the process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, irrelevant records that reside in a database.
DML and DDL
DML: a specific lanuage provided with a DBMS, which allows users to access and modify the data, to make queries, and to generate reports.
DDL: a collection of instructions and commands used to define and describe data and realtionships in a specific database.
OLTP and Batch Processing System
Batch Processing System: business transcations are accumulated over a period of time and prepared for processing as a single unit or batch.
OLTP: data processing in which each transaction is processed immediately
