1331.0 - Statistics - A Powerful Edge!, 1996  
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 31/07/1998   
   Page tools: Print Print Page Print all pages in this productPrint All  
Contents >> Information Studies >> Data and Computers

DATA AND COMPUTERS

Professional organisations have been using computers to process data and provide information for many years now. Computers and computer systems have been growing in sophistication and complexity, but their basic characteristics remain unaltered.

Computer systems are a combination of the following ingredients: hardware, software and users (people). Each is necessary for the system to function. The development history of computing systems has stressed the importance of each ingredient in turn, but it is important to remember that all of them have a necessary place in the system’s operation.


COMPUTERS — A SELECTED HISTORY

BC
5000
EGYPTAbacus developed, world’s first calculating machine.
AD
1622
ENGLAND
Slide rule invented by William Oughtred.
1642
FRANCE
Mechanical calculator invented by Blaise Pascal.
1830s
ENGLAND
Charles Babbage conceived computing components such as input and output units and storage systems.
1859
ENGLAND
George Boole developed symbolic logic; his work is the basis for binary switching, upon which modern computing depends.
1886
USA
Herman Hollerith of the US Census Bureau developed mechanical device to use punched cards for compiling and tabulating data.
1946

USA
The very first electronic computer, ENIAC (Electronic Numerical Integrator and Calculator) was completed at the University of Pennsylvania. Its computing power was far less than that of a current notebook computer.
1951
USA
The first commercially available computer delivered to the US Census Bureau.
1981
USA
First IBM personal computers were introduced.


The electronic computer was introduced to the Australian business community and the world in the 1960s. It was only gradually adopted, as early models were very expensive and slow, and there was little expertise available. Commercial computing skills were not taught at university, and business software applications could not be bought, but had to be developed in-house by programming staff. Good programmers were scarce and expensive.

The following table shows development of computer usage in the ABS, which mirrored a growing use of computers in the large business community.


COMPUTERS — AN ABS HISTORY

1963
A computer running paper tape programs, with a memory of only 512 bytes, was used for initial data entry from punched cards and punched paper tape.
1964
A CDC 3600 mainframe computer was installed for statistical processing. At the time it was one of the biggest in Australia, with 32,768 words of memory, about 20 MB of disk storage and a number of magnetic tape units.
1966The ABS’s largest collection of data, the Census of Population and Housing, was processed using software developed in-house.
1972
Data entry terminals, connected to the mainframe, were installed to replace electro-mechanical devices such as punched tape, punched cards, or key-to-tape equipment.
1976-79 Advances in data communications and increasing computing power enabled centralisation of data resources and the ability to access that data from all State offices. Large hard disk units gradually replaced 100,000 or so magnetic tapes.
1979 A Desktop publishing package was introduced for the production of statistical publications.
1982
A Fujitsu “IBM compatible” mainframe computer was installed, replacing our CDC mainframe computers.
1986 Typing pools were equipped with personal computers (PCs) for routine word processing, replacing electronic “memory” typewriters. Spreadsheet and other PC software was available on these machines.
1988
The ABS distributes population statistics on CD-ROM, and other information such as publications catalogues on diskette.
1989

A PC based Local Area Network was installed which provided an ABS-wide electronic mail system. Typing pools were disbanded and staff did their own typing on desktop PCs.
1991

Unix based mid-range computers were installed to supplement our large Fujitsu mainframe computer. Applications like Computer Aided Telephone Interviewing were used.
1993
Lotus Notes based document databases and electronic mail system introduced. More and more staff had a PC on their desk.
1994Our Fujitsu mainframe computer, the size of a large room and which required large industrial airconditioning systems, was replaced by a new Fujitsu mainframe computer the size of a vending machine. The new machine has the power of the old computer, but only requires normal office airconditioning and just plugs into a wall socket.
1995
E-mail.
ABS has its own Internet site, which contains contact details for ABS offices and news about latest releases of products and services. Clients can contact us by E-mail.
1995
Data warehousing system, which consolidates many ABS data holdings, used as a client servicing tool.


COMMERCIAL COMPUTER INSTALLATIONS

Large companies don’t have just one large computer, but usually a network of specialist computers. Depending on company size, there could be one or two very powerful mainframe computers, a number of small, medium and large Unix based mid-range computers, and individual PCs for all staff who work with information.

These computers are networked together. The network connecting the computers in any one location is usually referred to as a Local Area Network (LAN), while all the individual LANs are connected together by a Wide Area Network (WAN). Using this network, authorised personnel can access data and make use of computer facilities anywhere in the system.

Until about 10-15 years ago, the mainframe was the most common sort of computer in business. Mainframe computers today typically run older computer applications (often called “legacy” systems) written a few years ago; and also applications which require the highest levels of reliability, security and processing power. If the highest performance is not required, these days corporations often find it easier and more economical to use mid-range computers, usually running under the Unix operating system.

Regardless of the type of large computer being used, users interact with their computer systems, and obtain data using their desktop or notebook PC.


THE INTERNET and INTRANETS

Businesses, academic institutions and people at home use the Internet to send E-mail messages around the world or to assist in research. However, most businesses consider that the Internet is too slow, unreliable and not secure enough for widespread internal use. To solve this problem, they set up their own private internal Internets, known as Intranets. This gives them the ease of use and convenience of the Internet, but with the performance and security of an in-house system. Intranets can be connected to the public Internet via secure gateways, which have “firewalls” to prevent unwanted external access to internal systems.


COMPUTER HARDWARE

To function properly, a computer system needs the following hardware components:

Image: Hardware components


An input device allows a user to enter data or program the computer. The processing unit controls all activities within the system. Data Storage holds databases, files and programs. Output devices present the finished information product to the user.

    Input device. Data can be supplied for input to a computer in a range of ways, including: scanned or keyed from paper forms, as files on a floppy disk or CD-ROM, magnetic tape, light pen or bar-code readers, microphone, digital camera, communication and phone lines, or via Internet e-mail and Internet databases.


    Processing unit. The Central Processing Unit (CPU) is the heart of a computer system. In most modern computers the CPU consists of just one or two silicon chips that are small enough to hold in one hand, but which contain many millions of logic circuits. A CPU would typically execute millions of instructions per second.

    Associated with the CPU is the read access memory (RAM) memory. The RAM has to be big enough to hold all programs and data that are being worked on at a given time. RAM size ranges from a few million bytes to a few hundred million bytes.


    Data storage. Disk drives are used on almost all computers to hold data. A current PC might have one 2.0 GB disk drive (two billion bytes), while large computers might have a number of disk drives holding tens or hundreds of GB.

    Data can be copied onto magnetic tapes or CD-ROMs for backup, transfer between computers, or long term storage. A CD-ROM can hold 600 MB, while tape units can range from about 500MB to 24GB. Data can also be copied onto Diskettes (floppy disks), but their small size (1.44MB) limits their usefulness with large data sets.


    Output devices. Output devices include video monitors, various sorts of printers, magnetic disks and tapes, CD-ROMs, data communication and phone lines, and stereo speakers. Computers can also be used to drive industrial processes, control chemical plants, and lock/unlock security doors. Modern car engine management systems, office lifts, VCRs, and numerous other domestic and industrial systems are now controlled by miniature computer systems.

STORAGE AND RETRIEVAL

Much of the computer’s power comes from its ability to store, sort and classify data. Over the past few years, disk systems have become very cheap and reliable, and it is now possible to obtain disk systems that will store billions of bytes of data for just a few hundred dollars. This thousand-fold drop in data storage price, and the development of sophisticated database systems has greatly improved the usefulness of computers. It is now possible to hold all company information, going back for years, on a computer. Laws are being changed to drop the legal requirement for paper storage.


SOFTWARE

There are two basic types of computer software: systems software which controls the operation of the computer, and applications software which performs useful tasks for the user. Computers are purchased in order to run the application software, while system software assists to make this job easy and convenient.

Systems software: is dividied into two classes, operating systems and tools and utilities.

An operating system typically has two levels:

The lower level basic input-output system (BIOS) controls the most basic functions, such as: reading and writing RAM (memory), and input to and output from peripherals such as mouse, keyboard, printer and screen.

The higher level main operating system (eg Windows) acts as a platform to host programs. It provides the user interface to control the computer’s operation, and the environment to effectively operate application software. For example, it provides a file sub-system with its structure of drive names, directories, folders, files, and indexes; and file handling facilities such as creating, copying and deleting.

Typical operating systems are DOS, Unix, Mac OS and Windows 98. Mac OS and Windows 98 have a “user friendly” Graphical User Interface (GUI) which enables computer control by means of windows, menus, icons and a mouse. DOS and UNIX require the user to type precise commands, which can be hard to remember. Windows 98, Mac OS and Unix can run many programs at one time (multiprogramming), which makes for more efficient computer hardware use and user convenience.

Tools and utilities are usually necessary to make productive use of a computer. Some are provided with the operating system and others are purchased separately. Typical system utilities are Internet browsers, anti-virus software, program compilers, editors and file backup systems.

Applications Software can also be divided into two classes: personal productivity tools and other computer applications.

Personal productivity tools are commercial products designed to handle standard computing tasks such as word processing, numerical analysis, data manipulation and storage, and data presentation. Typical products are:
  • Word processing: Word processing software is designed for the creation of documents: letters, reports, newspaper articles and books. They were one of the first applications for personal computers, designed to streamline large amounts of routine typewriting. They succeeded because they allowed text to be edited without having to retype the whole document. MS Word, MS Works, Word Perfect, and Word Pro are typical word processing products.
  • Spreadsheets: These packages are an electronic development of accounts used by bookkeepers to organise business information, and are very useful for handling tabular data. Addition, subtraction, division, multiplication and totalling can be done very quickly, and all results can be automatically recalculated later if new data is inserted. Formatting and graphing facilities are used to aid analysis and presentation. Hundreds of functions are included to enable typical statistical, engineering, economics and business calculations to be performed automatically. Examples are functions for the calculation of compound interest and standard deviation. Typical Spreadsheets packages include MS Excel, MS Works and Lotus 123.
  • Databases: Database packages are a convenient way of organising and storing data in a uniform fashion. Data can be quickly and systematically searched, sorted and presented. They can be used by people with no special training to create mailing lists or record store inventories, but they can also be used by professional programmers to produce complex applications to assist with running a business. MS Access, MS Works and Lotus Approach are typical database packages.
  • Presentation: Presentation packages are used to illustrate talks and lectures. Presentation packages have almost replaced hand-drawn or typed overhead projector slides. In many presentations and lectures given in industry today, the presenter plugs a Notebook computer directly into a projector to show slides on a screen. MS Powerpoint and Lotus Freelance are typical presentation packages
  • Graphics: Graphics packages enable any user to create drawings, paint pictures and enhance or manipulate scanned pictures. MS Paint is a typical graphics package.
  • Desktop publishing: These packages are intended to enhance the final appearance or layout of text and graphics to make them suitable for publishing. Graphics can come from a library of clip art be created by drawing or paint package, or be a scanned image such as a photo. MS Publisher is a typical desktop publishing package.

Other Computer Applications: The above “personal productivity tools” are commonly used by most computer users at home, school and in the office. They are fairly cheap and available on many computers. However, businesses and organisations usually buy computers to automate major business functions, and this is not usually done on personal productivity software.

Some software applications can cost many thousands of dollars to buy or develop, while a major banking or airline reservation system could cost millions. Application software can either be purchased “off the shelf” or developed for a specific purpose. An accounting package is a typical example of a purchased application, while a system to handle parking fines might be designed and written from scratch.

A database application could be used for retail stock control: recording sales and setting up replacement orders. An airplane’s autopilot navigation system is an example of software that receives information (eg. compass heading and global positioning system [GPS] position) and outputs data that controls rudder and flap hydraulics which adjust the course. If it is decided to develop software to automate a task, the work is done by systems analysts and programmers.


SYSTEMS ANALYST

System analysis is the process of breaking down a data processing problem into functional components to determine the best method of handling the problem. The systems analyst must, with consultation:
  • define the system problems of an organisation,
  • analyse the results of the investigation to determine new system requirements,
  • design a new system that is practical, efficient, cost effective and makes best use of available hardware and software,
  • communicate the new system to all parties concerned, and
  • assist in implementing the new system.

PROGRAMMER

Programming is the process of producing a set of instructions to make a computer perform a specified activity. The programmer takes system analysis results and develops computer programs to solve the problem. A programmer must:
  • understand problems and plan solutions,
  • design programs using data flow diagrams and other design tools,
  • write programs to implement the design,
  • test programs and correct any problems,
  • write detailed documentation of programs and their operation.

USER

The user is the final judge of whether a computer system is meeting the needs it was designed to fulfil. The better the link between automated system component and user, the more likely it is that the system will be effective. Modern system designers consult widely with the user in order to design systems that meet user needs, and put considerable effort and ingenuity into designing the interface between a system and its users.


EXERCISES

1.Computer systems are a combination of three ingredients; what are they?
2.Name three hardware components.
3.Give two reasons why many large organisations set up their own internal intranet system.
4.Why would someone doing data analysis find spreadsheets useful?
5.Why is it important that a systems analyst consult with the system user before trying to design a new system?



Previous PageNext Page