Tabulating machine

thumb|Hollerith 1890 tabulating machine with sorting box.

right|thumb|Hollerith punched card

The tabulating machine was an electromechanical machine designed to assist in summarizing information stored on punched cards. Invented by Herman Hollerith, the machine was developed to help process data for the 1890 U.S. Census. Later models were widely used for business applications such as accounting and inventory control. It spawned a class of machines, known as unit record equipment, and the data processing industry.

The term "Super Computing" was used by the New York World newspaper in 1931 to refer to a large custom-built tabulator that IBM made for Columbia University.

1890 census

The tabulating machine emerged in response to difficulties processing the rapidly growing volume of census data in the United States. In the census of 1860 the population was compiled under 14 age groups, in 1870 the ages were tallied under 25 groups, while in 1880 the census office, in compliance with numerous requests, tabulated the population with over 100 specifications. Each year the problem of compiling a census became more difficult. Since the U.S. Constitution mandates a census every ten years to apportion both congressional representatives and direct taxes among the states, a combination of larger staff and faster-recording systems was needed.The 1880 census required eight years to fully process, raising concerns that future censuses might not be completed before the next constitutionally mandated census was due. John Shaw Billings, a physician and statistician serving as a director of the 1880 census, is credited with suggesting to Herman Hollerith that a machine modeled on the Jacquard loom (an automatic weaving device controlled by punched cards) could accelerate data processing.

In the late 1880s Herman Hollerith, inspired by conductors using holes punched in different positions on a railway ticket to record traveler details such as gender and approximate age, invented the recording of data on a machine-readable medium. Prior uses of machine-readable media had been for lists of instructions (not data) to drive programmed machines such as Jacquard looms. "After some initial trials with paper tape, he settled on punched cards..." Hollerith used punched cards with round holes, 12 rows, and 24 columns. The cards measured . that could be used for counting, sorting, and setting off a bell to let the operator know the card had been read. The tabulator had 40 counters, each with a dial divided into 100 divisions, with two indicator hands; one which stepped one unit with each counting pulse, the other which advanced one unit every time the other dial made a complete revolution. This arrangement allowed a count of up to 9,999. During a given tabulating run, counters could be assigned to a specific hole or, by using relay logic, to a combination of holes, e.g. to count married couples. If the card was to be sorted, a compartment lid of the sorting box would open for storage of the card, the choice of compartment depending on the data in the card.

Before the Census Bureau committed to Hollerith's system, it organized a formal competition in 1888 to evaluate rival approaches. Three systems were tested against each other on sample census data. Charles F. Pidgin, chief clerk of the Massachusetts Bureau of Labor Statistics, proposed a method based on color-coded cardboard chips on which census information was recorded using symbols representing different attributes. These chips were then physically sorted and counted, and a similar approach had previously been used in the 1885 Massachusetts State Census. William C. Hunt, who had also worked on the Massachusetts census, developed a simplified variation of this idea that used paper slips marked with colored inks instead of chips. Herman Hollerith, who had previously worked with the Census Office in 1880, proposed an electromechanical tabulating system that used punched cards. He had already applied similar methods to mortality statistics in several U.S. cities during the late 1880s.

In performance tests, Hollerith completed the data capture phase in 72.5 hours, compared to 100.5 and 144.5 hours for the competing systems. For preparation of data for tabulation, his system required 5.5 hours, while the others required 44.5 and 55.5 hours respectively. The results were decisive, and the Census Bureau awarded Hollerith the contract. The trial is often described as one of the earliest formal government benchmarks for evaluating computational data processing systems, marking a significant milestone in the history of modern information processing.

Clerks used keypunches to punch holes in the cards entering age, state of residence, gender, and other information from the returns. Some 100 million cards were generated and "the cards were only passed through the machines four times during the whole of the operations." According to the U.S. Census Bureau, the census results were "... finished months ahead of schedule and far under budget."

thumb|Cover of the August 30, 1890, Scientific American

The tabulating system also changed the organization of census labor. Large numbers of clerks were employed to transfer information from census returns onto punched cards using keypunch machines. Contemporary illustrations, including the August 30, 1890, cover of Scientific American, depicted both male and female workers seated at rows of card-punch machines in large open rooms. Historians have described this system as an early form of large-scale clerical data processing that influenced later office and government record-keeping practices.

Following the 1890 census

The commercial success of the 1890 census led to increased demand for punched-card tabulating systems in both government and business applications. During preparations for the 1900 census, disagreements arose between Hollerith and the Census Bureau regarding the cost of leasing tabulating equipment. The Census Bureau later supported the development of alternative tabulating systems, including those designed by James Legrand Powers, a former Census Bureau employee. Powers subsequently developed punched-card machines that were used during the 1910 United States Census.

The advantages of the technology were immediately apparent for accounting and tracking inventory. Hollerith started his own business as The Hollerith Electric Tabulating System, specializing in punched card data processing equipment. In 1896, he incorporated the Tabulating Machine Company. In that year he introduced the Hollerith Integrating Tabulator, which could add numbers coded on punched cards, not just count the number of holes. Punched cards were still read manually using the pins and mercury pool reader. 1900 saw the Hollerith Automatic Feed Tabulator used in that year's U.S. census. A control panel was incorporated in the 1906 Type 1.

In 1911, four corporations, including Hollerith's firm, were amalgamated (via stock acquisition) to form a fifth company, the Computing-Tabulating-Recording Company (CTR). The Powers Accounting Machine Company was formed that same year and, like Hollerith, with machines first developed at the Census Bureau. In 1919, the first Bull tabulator prototype was developed. Tabulators that could print, and with removable control panels, appeared in the 1920s. In 1924, CTR was renamed International Business Machines (IBM). In 1927, Remington Rand acquired the Powers Accounting Machine Company. In 1933, The Tabulating Machine Company was subsumed into IBM. These companies continued to develop faster and more sophisticated tabulators, culminating in tabulators such as 1949 IBM 407 and 1952 Remington Rand 409. Tabulating machines continued to be used well after the introduction of commercial electronic computers in the 1950s.

Many applications using unit record tabulators were migrated to computers such as the IBM 1401. Two programming languages, FARGO and RPG, were created to aid this migration. Since tabulator control panels were based on the machine cycle, both FARGO and RPG emulated the notion of the machine cycle and training material showed the control panel vs. programming language coding sheet relationships.

The adoption of tabulating machines contributed to changes in office labor during the late nineteenth and early twentieth centuries. Government agencies, insurance companies, railroads, and other large organizations increasingly relied on punched-card systems to efficiently process in influx of information.

The use of punched-card equipment also expanded clerical employment, especially for women who were frequently employed as keypunch operators and data-entry clerks. Historians have described punched-card systems as part of a broader trend toward office mechanization and large-scale record keeping in the early 20th century. Furthermore, the methods developed around tabulating machines later influenced data processing practices used with electronic computers.

Operation

thumb|IBM Type 285 tabulators in use at U.S. Social Security Administration circa 1936

thumb|Early IBM D11 tabulating machine, with covers removed

thumb|Powers-Samas accounting machine

In its basic form, a tabulating machine would read one card at a time, print portions (fields) of the card on fan-fold paper, possibly rearranged, and add one or more numbers punched on the card to one or more counters, called accumulators. On early models, the accumulator register dials would be read manually after a card run to get totals. Later models could print totals directly. Cards with a particular punch could be treated as master cards causing different behavior. For example, customer master cards could be merged with sorted cards recording individual items purchased. When read by the tabulating machine to create invoices, the billing address and customer number would be printed from the master card, and then individual items purchased and their price would be printed. When the next master card was detected, the total price would be printed from the accumulator and the page ejected to the top of the next page, typically using a carriage control tape.

With successive stages or cycles of punched-card processing, fairly complex calculations could be made if one had a sufficient set of equipment. (In modern data processing terms, one can think of each stage as an SQL clause: SELECT (filter columns), then WHERE (filter cards, or "rows"), then maybe a GROUP BY for totals and counts, then a SORT BY; and then perhaps feed those back to another set of SELECT and WHERE cycles again if needed.) A human operator had to retrieve, load, and store the various card decks at each stage.

Selected models and timeline

Hollerith's first tabulators were used to compile mortality statistics for Baltimore, Jersey City and New York City in 1886.

The first Tabulating Machine Company (TMC) automatic feed tabulator, operating at 150 cards/minute, was developed in 1906.

The first TMC printing tabulator was developed in 1920.

TMC Type IV Accounting Machine (later renamed the IBM 301), from the IBM Archives:

<blockquote>The 301 (better known as the Type IV) Accounting Machine was the first card-controlled machine to incorporate class selection, automatic subtraction, and printing of a net positive or negative balance. Dating to 1928, this machine exemplifies the transition from tabulating to accounting machines. The Type IV could list 100 cards per minute.</blockquote>

H.W.Egli - BULL Tabulator model T30, 1931

IBM 401: <blockquote>The 401, introduced in 1933, was an early entry in a long series of IBM alphabetic tabulators and accounting machines. It was developed by a team headed by J. R. Peirce and incorporated significant functions and features invented by A. W. Mills, F. J. Furman and E. J. Rabenda. The 401 added at a speed of 150 cards per minute and listed alphanumerical data at 80 cards per minute.</blockquote>

IBM 405: <blockquote>Introduced in 1934, the 405 Alphabetical Accounting Machine was the basic bookkeeping and accounting machine marketed by IBM for many years. Important features were expanded adding capacity, greater flexibility of counter grouping, direct printing of the entire alphabet, direct subtraction and printing of either debit or credit balance from any counter. Commonly called the 405 "tabulator," this machine remained the flagship of IBM's product line until after World War II. The British at Hut 8 used Hollerith machinery to gain some knowledge of Known-plaintext attack cribs used by encrypted German messages.</blockquote>

IBM 402 and 403, from 1948, were modernized successors to the 405.

thumb|250px|Control panel for an IBM 402 Accounting Machine

<blockquote>The 1952 Bull Gamma 3 could be attached to this tabulator or to a card read/punch.</blockquote>

IBM 407<blockquote>Introduced in 1949, the 407 was the mainstay of the IBM unit record product line for almost three decades. It was later adapted to serve as an input/output peripheral for several early electronic calculators and computers. Its printing mechanism was used in the IBM 716 line printer for the IBM 700/7000 series and later with the IBM 1130 through the mid-1970s.</blockquote>

<blockquote>The IBM 407 Accounting Machine was withdrawn from marketing in 1976, signaling the end of the unit record era.</blockquote>

Tabulating machine

1890 census

Following the 1890 census

Operation

Selected models and timeline

See also

Notes

References

Further reading

External links

1890 census

Following the 1890 census

Social impact

Operation

Selected models and timeline

See also

Notes

References

Further reading

External links