Transcript Personal Productivity Software

MANAGING
INFORMATION
TECHNOLOGY
CHAPTER 3
COMPUTER SOFTWARE
EVOLUTION OF COMPUTER
PROGRAMMING
First and Second Generation Languages
1. Machine language (1GL)



Each instruction must be expressed in unique form for a
particular computer
Complete program consists of thousands of instructions
Programming was tedious, time-consuming process
2. Assembly languages (2GL)


Use computer itself to perform many aspects of the
programming
Create a machine language program as output, that is
then used by the computer’s control unit
EVOLUTION OF COMPUTER
PROGRAMMING
First and Second Generation Languages
SOURCE
PROGRAM
OBJECT
PROGRAM
(which can be
directly executed
on computer)
EVOLUTION OF COMPUTER
PROGRAMMING
Third and Fourth Generation Languages
3. Procedural Languages (3GL)




Generally are machine independent.
Express a step-by-step procedure developed by
programmer
Must be compiled or interpreted (translated into
machine language)
Include FORTRAN, COBOL, BASIC, PL/1,
PASCAL, ADA, and C
SOURCE
PROGRAM
OBJECT
PROGRAM
Figure 3.2 Compiling and Running
a Procedural Language Program
SOURCE
PROGRAM
Figure 3.3 Interpreting and Running
an Interpretive Language Program
EVOLUTION OF COMPUTER
PROGRAMMING
Third and Fourth Generation Languages
4. Nonprocedural Languages (4GL)






Also referred to as productivity languages
Use more English-like statements for program
instructions
Easier to use, write, and less error-prone
Use a built-in interpreter to convert to machine
language
Take much longer to execute than 3GLs
Include FOCUS, CA-Ramis, IFPS, and SAS
EVOLUTION OF COMPUTER
PROGRAMMING
Third and Fourth Generation Languages
Object-Oriented (Visual) Languages



3GLs with some 4GL features
Built on idea of embedding procedures
(methods) in objects, and putting objects
together to create an application
Include Smalltalk, C++, Java, and Visual Basic
KEY TYPES OF SOFTWARE
1. Applications software
2. Support software
Figure 3.4 The Software Iceberg
Spheres of Influence & Application Software
• Two or more people who work together to achieve a
common goal
• Systems that support information sharing, group
scheduling, group decision making, and conferencing
Workgroup
Personal
• programs that serve the
needs of an individual user
• word processing,
spreadsheets, databases,
e-mail
Enterprise
• programs that support
the firm in its
interaction with its
environment
• order entry, billing
APPLICATIONS SOFTWARE
 Programs written to accomplish particular
tasks
 Diverse … some general-purpose and some
specific
 Examples include:






General ledger accounting
Portfolio management
Sales forecasting
Material requirements planning (MRP)
Electronic mail
Desktop publishing
APPLICATIONS SOFTWARE
Examples of Applications Packages
 Peachtree Accounting Complete



Commercial accounting package for smaller
businesses
Includes general ledger, accounts receivable,
accounts payable, inventory, payroll, time and
billing, job costing, fixed asset accounting, and
analysis and reporting tools
$300 for single-user version
Figure 3.5 “My Business Page” from
Peachtree Complete Accounting
APPLICATIONS SOFTWARE
Personal Productivity Software








Word processing
Spreadsheets
Presentation graphics
Electronic mail and groupware
Database management systems
Desktop publishing
Web browsers
Statistical packages
APPLICATIONS SOFTWARE
Personal Productivity Software
 Word processing




Used to create documents for printing
Most popular is Microsoft Word
Others are Corel WordPerfect, Lotus Word Pro,
and Sun’s StarOffice Writer
All employ WYSIWYG
APPLICATIONS SOFTWARE
Personal Productivity Software
 Spreadsheets




Used to create applications that fit a row-column
format
Most popular is Microsoft Excel
Others are Lotus 1-2-3 and Corel Quattro Pro
All employ rows, columns, cells, formulas, “what-if”
analysis
APPLICATIONS SOFTWARE
Personal Productivity Software
 Database Management Systems




Used to create databases similar to those on larger
machines
Most popular is Microsoft Access
Others are FileMaker Pro, Corel Paradox, and
Lotus Approach
All employ a relational data model
APPLICATIONS SOFTWARE
Personal Productivity Software
 Presentation Graphics




Used to create largely textual business
presentations
Most popular is Microsoft PowerPoint
Others are Corel Presentations and Lotus
Freelance Graphics
All allow embedding of clip art, photos, graphs, and
other media
APPLICATIONS SOFTWARE
Personal Productivity Software
 World Wide Web Browsers







Used to access information on the Web
Requires ISP service to link PC to Internet
Create documents for printing
Most popular are Internet Explorer and Netscape
Navigator … both free!
Both employ standard hypertext-based approach (way
to link text and media objects to each other)
Use pull technology – browser requests a Web page
before it is sent to desktop
Use push technology – data sent to client without
requesting it (such as e-mail)
APPLICATIONS SOFTWARE
Personal Productivity Software
 Electronic Mail


Preferred way of communicating in business today
Easy to use and precise
 Groupware

Incorporates e-mail and other productivity features,
such as calendaring, scheduling, and document
sharing
APPLICATIONS SOFTWARE
Personal Productivity Software
 Office Suites




Popular software applications bundled together and
sold as a single package (suite)
Used for home or office
Most popular is Microsoft Office
Others are Corel WordPerfect Office, Lotus
SmartSuite, and Sun StarOffice
APPLICATIONS SOFTWARE
Personal Productivity Software
Microsoft Office 2003
Edition
Standard
Applications
Purpose
Word
Word processing
Excel
Spreadsheets
PowerPoint
Presentation graphics
Outlook
E-mail, scheduling
Small
Business
Adds:
Professional
Adds:
Publisher
Access
Retail price
$399
$449
Desktop publishing
$499
Database management
SUPPORT SOFTWARE
The Operating System
Operating system –
complex program that controls operation of computer
hardware and coordinates other software


User communicates with operating system software to
control hardware and software resources
Communication made easier with a graphical user
interface (GUI) feature
SUPPORT SOFTWARE
The Operating System
Job Control Language (JCL) –
keyed instructions from the computer user to communicate
with the operating system
SUPPORT SOFTWARE
The Operating System
Multiprogramming –
employed on larger machines to overlap input and output
operations with processing time, keeping the CPU busy
and speeding up execution
Multitasking –
similar to multiprogramming, but employed on
microcomputers
SUPPORT SOFTWARE
The Operating System
 Virtual Memory




Concerned with management of main memory
Makes it appear more memory available than
actually is
Used only on larger computers
Permits multiprogramming to operate more
efficiently
SUPPORT SOFTWARE
The Operating System
Multiprocessing –
work that takes place when two or more CPUs are installed
on same computer system
SUPPORT SOFTWARE
The Operating System
 Sources of Operating Systems
Proprietary systems –
most popular type of operating systems, written for a
particular computer hardware configuration



Microcomputers: Windows XP; Windows Vista;
Mac OS X
Midrange systems: OS/400
Large systems: VM and MVS
SUPPORT SOFTWARE
The Operating System
 Sources of Operating Systems
Open systems –
not tied to any particular computer system or hardware
manufacturer – will run on virtually any computer system

Examples: UNIX and Linux
SUPPORT SOFTWARE
The Operating System
 Sources of Operating Systems
Network operating systems (NOS) –
software running on a server that manages network
resources and controls the operation of a network

Enhanced operating system to allow for
 sharing disk drives and printers
 handling server side of client/server applications
SUPPORT SOFTWARE
The Operating System
 Sources of Operating Systems
Network operating systems (NOS) –
software running on a server that manages network
resources and controls the operation of a network
 Major players include:
 UNIX and Linux
 Microsoft Windows NT, 2000 Server, 2003 Server
 Novell NetWare
SUPPORT SOFTWARE
Third Generation Languages
 Procedural languages (3GL)
Require logical thinking
 Entail development of a detailed step-bystep procedure
 Can be developed using structured
programming

SUPPORT SOFTWARE
Third Generation Languages
Structured programs –
divided into modules, where each has one entry and one
exit point
 Advantages:
Program logic easier to follow
 Maintenance and correction easier and
faster
 Do not use GO TO logic

SUPPORT SOFTWARE
Third Generation Languages
Table 3.1 Stages in the Program
Development Process
SUPPORT SOFTWARE
Third Generation Languages
 Most popular procedural languages:
BASIC
 C
 COBOL

Figure 3.9
BASIC Program
Figure 3.10
C Program
Figure 3.11
COBOL Program
Figure 3.11
COBOL Program
Figure 3.11
COBOL Program
SUPPORT SOFTWARE
Third Generation Languages
 Other procedural languages:
FORTRAN
 PL/1
 PASCAL
 ADA

SUPPORT SOFTWARE
Fourth Generation Languages
 Nonprocedural languages:
Use very high-level instructions
 Require fewer instructions
 Easier to write, modify, understand


Example: FOCUS
Figure 3.12
FOCUS Program and Output
SUPPORT SOFTWARE
Markup Languages
 Most popular:
HTML: used to create Web pages
 XML: used to facilitate data interchange
among Web applications

SUPPORT SOFTWARE
Object-Oriented Programming




Requires more computing power
Has built-in GUI
Neither 3GL nor 4GL … new paradigm
Creates objects only once and stores for
reuse
 Object examples:

Text box, check box, entity in an organization
 Languages:

Smalltalk, C++, Java, Visual Basic.NET
Figure 3.13A
Visual Basic Program
Figure 3.13B
Visual Basic Screen Layout
SUPPORT SOFTWARE
Languages for Developing Web Applications
 HTML
 XML
 Server-side programming languages:




Perl
Java Servlets and Java Server Pages
Microsoft Active Server Pages (ASP, ASP.NET)
ColdFusion
Figure 3.17
Grocery Store HTML Form
HTML and ASP.NET code
to accompany
Grocery Store HTML Form
Figure 3.17
Program to Process Data
from Grocery Store HTML Form
Figure 3.18
Figure 3.19 Grocery Store
Confirmation Web Page
Code to Generate
Confirmation Web Page
Figure 3.19
SUPPORT SOFTWARE
Database Management Systems

DBMS – support software used to create, manage,
and protect organizational data

Database – shared collection of logically related data
organized to meet organizational needs

Relational DBMS




Most common type
Data arranged in simple tables
Records related by storing common data in each
associated table
Examples: Microsoft Access and SQL Server, Paradox,
DB2, and Ingres
SUPPORT SOFTWARE
File Organization

Sequential – arranges
records physically
adjacent and in order
by some (usually
unique) sort key

Direct – uses key for
records placed so that
they are rapidly
accessed from DASDs
Figure 3.20 File Organizations
SUPPORT SOFTWARE
File Organization

Indexed

Compromise between
sequential and direct

Record keys only
arranged in sequence
in a separate table,
along with location of
rest of data associated
with that key

Popular types include
ISAM and VSAM
Figure 3.20 File Organizations
Relational DBMSs use this scheme
Figure 3.21 Relationship Schemes
SUPPORT SOFTWARE
CASE Tools
Computer-aided software engineering (CASE) –
collection of software tools to help automate all phases of
the software development life cycle


Growth slower than anticipated
Radically changed nature of systems analyst and
programmer jobs
SUPPORT SOFTWARE
Communications Interface Software
 Large computers


need to control workstations and terminals
Example software: IBM’s CICS, TSO, and CMS
 LANs and WANs




Need to connect to the Internet
Web browsers
Telenet
File Transfer Protocol (FTP)
THE CHANGING NATURE OF
SOFTWARE







More complexity of hardware/software
arrangements
Less concern with machine efficiency
More purchased applications
More programming using object-oriented and
visual languages
More emphasis on applications that run on
intranets and the Internet
More user development
More use of personal productivity software
THE SOFTWARE COMPONENT OF
THE INFORMATION SYSTEMS
INDUSTRY





More complexity of hardware/software
arrangements
Less concern with machine efficiency
More purchased applications
More programming using object-oriented and
visual languages
More emphasis on applications that run on
intranets and the Internet
Page 92
Trends in Computer Software
Trend: Toward Easy-to-Use Multipurpose Network-Enabled
Application Packages for Productivity and Collaboration
User-written
programs
Machine
languages
Packaged
programs
Symbolic
languages
Operating
systems
High-level
languages
Natural & objectoriented languages
DBMS
Multipurpose
Fourth-generation
graphic-interface
languages
network-enabled
Microcomputer
expert-assisted
packages
packages
Trend: Toward Visual or Conversational Programming Languages
and Tools
UAL was the first airline to offer a competitive
advantage with its frequent flyer mileage
Customer self-service software on the Internet from
FedEx was an example of first-mover advantages