DBMS packages-3

Note that with this command will have only specified the structure of the record for a file which is to contain customer data. Therefore we should have some way of loading the customer records in the CUSTLIST file. For this purpose we will have to type the following command:

 

..APPEND

With this command we get a screen which provides a blank customer record. As the name implies, this command will append a record to our CUSTLIST file. Thus, it can be used whenever we want to add one more customer to customer list. With the customer we can add product fulfillment types. Product given to customer gives them product fulfillment or order fulfillment. We can add any criteria for that.

 

In the screen provided with above command, we now type the necessary details of a customer. The names of the fields are displayed on the screen to facilitate entry of data for a customer for which we wish to create a record in CUSTLIST file. After we type in all the required details about the customer and type e get another blank record in which we can enter data about next customer and so on. When we type right at the beginning of blank record we get back to dot prompt where we can issue a new dBASE III command.

DataBase Management

The dBASE III package has attained its current popularity mainly for the following reason:

 

1.      It is easy to use and is simple. Its basic features can be learned in a couple of hours.

2.      It provides a very high level language interface which is command oriented. Some people consider it a fourth generation language. In lay man’s terms, fourth generation language means it is superior to standard programming languages like BASIC, COBOL, FORTRAN and PASCAL; and it simplifies and sometimes even avoids programming in a conventional sense.

3.      Small business information systems can be easily implemented in a few days using this package. Insurance CRM or instant life insurance rates application can be implemented easily in small businesss.

4.      This package can be used as a tool to prototype large applications. Prototyping is useful for saving costs in implementing large applications. Parts of a large system may be implemented through dBASE III package to finalize specifications of what users want through the envisaged application and how these parts could possibly be implemented in their final form.

 

We will discuss some features of the DBMS packages in our next post.

APPLICATIONS SOFTWARE

Systems software available on micro-computers includes compilers interpreters for popular programming languages like BASIC, COBOL and FORTRAN. However, because of their large numbers and personal use, powerful applications software which does not require significant programming knowledge has been developed to run on personal computers. The most important categories of this software, which enables a user to autonomously utilize a personal computer are:

 

1. Data Base Management Software
2. Spreadsheet Software
3. Word Processing Software
4. Graphic Software
5. Data Communication Software

Data Base Management

Software packages called Data Base Management System (DBMS) has been developed long before micro-computers to handle the problems of maintaining and integrating large volumes of data on large machines. The most important distinguishing feature of a DBMS package on personal computers is that it provides a very high level language interface which can be learned by a user who is not a computer programmer. In a few hours, it is possible to acquire enough skill to use the basic features of DBMS packages like dBASE III which is the best selling software currently in this class.

Classification Of Computers

 

In the 1970s computers were classified into three categories, namely, super-computers, large computers and mini computers. But the invention of the micro-processor which gave birth to micro-computers in the late 70s has drastically changed the computing scene. A wide range of computers are available today in the market ranging from a personal computer to a super computer.

 

A personal computer (PC) is a micro-computer which has its entire central processing unit on a single micro-processor chip. A PC provides a main memory capacity upto 640 kilo bytes and a processing power of 0.5 MIPS. It supports one or 2 diskette drives of 360 KB each for random access secondary memory. A PC usually comes with a standard key board, a visual display unit and a dot matrix printer. A PC is usually operated by a single user.

 

A super mico-computer has its entire central processing unit on a very powerful micro-processor, provides a main memory capacity of upto 16 mega bytes, has a processing power of 2 to 3 MIPS, supports Winchester disks of capacity 20 to 80 mega bytes and allows simultaneously access to multiple users. Today’s super micro is actually replacing yesterday’s mini computers which provide almost the same computing power it nit less, but based on a different technology.

Operating Systems-1

We are talking computers in management. We talked evaluation of computers and computer softwares in our previous talk. We talked about operating system in our last post, today we continue with that. We talked the drawback of idling the CPU was overcome with the introduction of overlapped processing.

For example why not take up input operation of job 2 and the output operation of job 1 simultaneously? This and similar considerations gave rise to the concept of multi-programming. A multi-programming operating system handles multiple jobs simultaneously by overlapping the input, output and processing cycles of various jobs.

This operating system was introduced along with third generation computers and is still very popular. It has replaced the earlier batch processing (serial) operating system. With multi-programming a CPU’s utilization is increased and hence jobs get executed faster on an average. However a multi-programming operating system is more complex hardware to support it.

Other types of operating systems which are popular today are multi-processing operating systems and real time operating systems. A multi-processing operating system uses multiple CPU’s to process multiple jobs. A real time operating system is a very different type of operating system, because it is used for different type of applications, i.e., real time applications such as airlines reservations, process control, etc.

Utilities

Utility programmes are those which are very often requested by many application programmes. mailing leads and marketing list are few example of such utility programmes which are used in large by industry. A few examples are:

SORT/MERGE for sorting large volumes of data and merging them into a single sort list like mortgage mailing list.

Transfer programmes for transforming contents from one medium to another, e.g., disk to tape, tape to disk, etc.

Language translators

A language translator is system software which will translate a computer programme written by humans into a machine understandable form. The most elemental form of programming uses only the binary digits 0, 1 which is directly understood by the electronic circuits. A programme written using only binary digits is called a machine language programme.

 

Assembly language provide a significant improvement over machine language. Assembly language programmes are written using mnemonic codes like ADD, STORE, etc., rather than their machine language representations in binary digits. Therefore programming in assembly language is easier. Active directory and active directory management or active directory tool can be made with such programming. However, it needs to be translated into machine language codes. This translation is done by an assembler. Both machine language and assembly language programmes are machine dependent. This means that a programme written for one machine cannot be used in another machine.

 

High level languages, which are closer to English overcame the drawback of machine dependence. A few high level languages are FORTRAN, BASIC, PASCAL, COBOL etc. These languages relive the programmers from being machine specific. However a programme written in a high level language needs to be translated into machine language codes before execution. This translation is done either through compilers or through interpreters.

 

A compiler is a translator which reads an entire programme written in a high level language and coverts it into machine language codes. An interpreter on the otherhand, is a translator which interprets statement by statement, any programme written in a high level language. An interpreter is a very effective tools for programme development as it checks for errors statement by statement in an interactive mode. Exchange Management and Exchange Tools require interpreter.  This allows the programmer to correct the errors statement by statement as he enters them. A compiler on the otherhand, will request the user to enter the entire programming statement and then it will check for errors. Basic language provides a compiler and an interpreter.

 

Other language such as Fortran, cobol and Pascal had only compolers initially. However interpreters for these high level languages are also becoming available, partly due to the popularity enjoyed by micro-computers in the field of computing.

COMPUTER SOFTWARE

Today we are going to discuss on Computer Software part. This is a most important topic for Computers. Computer software consists pf sets of programmed instructions which enable the hardware units to perform. Programming a computer to perform has always been a very difficult task. The first electronic computer was programmed using wired panels. Today’s computers are programmed using software.

 

Computer software can be broadly classified into two categories – System Software and Application Software. System software is a set of instructions to the machine hardware to interpret and execute application software. Application software is a set of programming instructions for specific applications like payroll accounting, inventory control, etc. System software consists of language translators [called compilers (compiles program-wise), interpreters (compiles like-wise) and assemblers (converts semi-machine-language, macro-instructions, to machine language)], operating systems, utilities and special purpose software.

 

Computer software or just software is a general term used to describe a collection of computer programs, procedures and documentation that perform some tasks on a computer system. “Software” is sometimes used in a broader context to mean anything which is not hardware but which is used with hardware, such as film, tapes and records. 

We will discuss on languages translator in next post.

blinds, roller shades, woven wood shades

Input and Output Devices-4

Still today we have discussed for different types of the computer hardware devices. Form last few days we are talking on input and output devices which is most important part of the computer hardware. The input or output units of a computer system establish the communication between the system and its users. A large number of input and output units are available in the market. A few of them are discussed in this note.

Most recent trend for data input is towards source data automation. The equipments used for source data automation capture data as a by-product of a business activity thereby completely eliminating manual input of data. Some examples are:

1. Magnetic ink character recognition devices are used by the banking industry to read the account numbers on cheques directly and do the necessary processing.
2. Optical mark recognition devices can sense marks on computer readable papers.

This king of device is used by academic and testing institutions to grade aptitude tests where candidates mark the correct alternatives on a special sheet of paper. These answer sheets are then directly read by the optical mark recognition devices and the information sent to a computer for processing.

Input and Output Devices-3

We talked about input or output units of a computer system. Input and output establish the communication between the system and its users. A large number of input and output units are available in the market. A few of them we are discussing here. We talked about hard disk in our previous post. Today we are going to talk about printer.

 

A printer is a peripheral which produces a hard copy of documents stored in electronic form, usually on physical print media. Printers are purely output devices. Printers are classified into line printers and dot matrix printers. A line printer prints one line of information simultaneously, whereas a dot matrix printer prints one character at a time. A dot matrix printer uses a 5 X 7 or 7 X 9 dot matrix formation to represent each character. Dot matrix printers therefore provide a broken appearance to the characters, whereas a line printer provides a better quality output. A line printer has a speed of about 2000 lines per minute whereas a dot matrix printer has a lower speed of approximately 100 characters per second. If we talke about credit card printer than they need to have a merchant accounts with which credit card processing done. In big shopping mall credit card machine are available there.  With credit card software  and credit card terminal they use credit card printer  to for day to day functions.

Daisy wheel printers and letter quality printers are also character printers. But they produce excellent quality output. However, they are more expensive and slower than dot matrix printers. All the printers discussed so far are called impact printers as they make physical contact with paper while printing. A no impact printer on the other hand transfers information to paper without any physical contact. Example of no impact printers is laser printers, xerographic printers, electrostatic printers, etc.

 

Many printers are primarily used as local peripherals, and are attached by a printer cable or, in most new printers, a USB cable to a computer which serves as a document source. Some printers, commonly known as network printers, have built-in network interfaces (typically wireless or Ethernet), and can serve as a hardcopy device for any user on the network. Individual printers are often designed to support both local and network connected users at the same time.

Input and Output Devices-2

Terminals have become very popular interactive input and output units. A terminal, when connected to a CPU, sends data and instructions directly into the computer. Terminals can be classified into two types, namely, hard copy terminals and soft copy terminals. A hard copy terminal provides a print out on paper whereas a soft copy terminal provides a visual display on a screen. A soft copy terminal is also known as a CRT (Cathode Ray Tube) terminal.

 

Key-to-tape, key-to-disk and key-to-diskette are stand alone data entry stations. There units usually have a small processor attached to a key board and a visual display unit. The processor checks for the accuracy of data at the time of entry. The screen displays what is being entered. There facilities are highly desirable for a data processing centre. Hence most of the data processing centres are switching over from punched card input to data entry stations.

 

A graphic display terminal displays information in both character and graphic forms. These are extensively used for CAD/CAM (computer aided design/computer aided manufacture) applications.

A potter is used to obtain printed copies of graphic outputs. It is used by architects and designers to produce blueprints of their design on paper.