Tag: multidimensional databases

  • Before OLAP Had a Name: TM/1 and the Problem of Vocabulary

    Before OLAP Had a Name: TM/1 and the Problem of Vocabulary

    The easiest way to misunderstand early TM/1 is to describe it with vocabulary that did not yet exist.

    Today it is natural to place TM/1 inside a familiar category. We can call it an early OLAP engine, a multidimensional database, a planning system, or the ancestor of later enterprise performance management software. None of those descriptions is empty. Each captures something real. But each arrives too late.

    The more interesting historical question is not what TM/1 later became. It is how the product was described when the market still lacked settled words for this kind of software. The 1980s evidence is valuable because it records that uncertainty in real time. TM/1 moved through a vocabulary that was still unstable, and the instability itself is part of the story.

    A Product Without a Settled Category

    OLAP did not organize the market in the early 1980s. The later phrase Online Analytical Processing gave the industry a useful label for multidimensional, interactive analysis, but it also encouraged a retrospective simplification. Once a category becomes established, older products are pulled into it as if they had always belonged there.

    TM/1 resists that treatment.

    In the surviving trade-press and marketing record, TM/1 appears under several overlapping descriptions. Byte‘s October 1984 notice “Multidimensional Tables Manager Aids Decisions” presents Tables Manager/1, or TM/1, through decision-management, multidimensional, tabular-database, and spreadsheet language at the same time. InfoWorld‘s January 28, 1985 “New Analytical Tools Break The Mold” places TM/1 among analytical tools aimed at managers. Jeffrey Rothfeder’s July 1986 PC Magazine article “Breaking the Mold” describes TM/1 in the Exxon International case as a multidimensional, multiuser spreadsheet and table manager. William J. Lynott’s August 1987 Online Today review calls TM/1 Version 2.0 table-management and spreadsheet software. PC Magazine‘s October 27, 1987 “Analyzing Data From All the Angles” treats TM/1 as part of the 3-D or multidimensional spreadsheet world. Then Sinper’s June 1988 Byte advertisement asks, “What Is A Relational Spreadsheet, And Who Should Own One,” and answers by trying to make TM/1 the category itself.

    That variety is not a nuisance. It is evidence.

    The market was trying to describe a product that sat between familiar things. TM/1 looked enough like a spreadsheet to be understood by spreadsheet users. It behaved enough like a database to separate stored data from worksheet manipulation. It supported multidimensional analysis before multidimensional analysis had become a stable business-software category. The language wobbled because the product crossed boundaries the market had not yet learned to name cleanly.

    Why “Early OLAP” Is Not Enough

    Calling TM/1 “early OLAP” can be useful shorthand. It should not be the whole story.

    The phrase explains the product from the future backward. It tells the reader where TM/1 eventually fits in the history of analytical software. It does not tell the reader how the product was understood in its own moment.

    That distinction matters because the real historical problem sits earlier. The question is not only whether TM/1 anticipated OLAP. The better question is why business software in the early 1980s needed a tool that existing categories could not describe cleanly in the first place.

    Spreadsheets gave users direct manipulation. Databases gave organizations more structure for storing information. Decision support systems promised analytical assistance. TM/1 lived in the space where those traditions overlapped. The vocabulary problem was therefore also an organizational problem. Managers wanted to analyze changing business assumptions without giving up the flexibility they had learned from spreadsheets.

    The Vocabulary Shift Was the Product Story

    The sequence of labels matters because it tracks how the market slowly changed its interpretation of the software.

    The earliest descriptions lean on tables, decision-management, and spreadsheet language because that was the available vocabulary in 1984. By 1986 and 1987, TM/1 is increasingly pulled into the multidimensional spreadsheet conversation. By 1988, Sinper is openly trying to win a category battle with the phrase relational spreadsheet. The language then shifts again in the early 1990s toward spreadsheet connector, client/server spreadsheet engine, and database engine for spreadsheets. Each step is an attempt to solve the same problem: how do you explain software that is still close to spreadsheets at the surface but increasingly farther from them underneath?

    That is why the terminology history is more than a list of names. It captures the market learning, failing, adjusting, and trying again. A later label such as OLAP can make the path look neat. The contemporary language shows that it was anything but neat.

    Trade Press Was Not Neutral, but It Was Revealing

    Trade press is especially useful here because it records the category confusion in real time.

    Reviews and notices were not neutral technical documents. They were written under deadline, often close to vendor language, and sometimes with incomplete technical access. But that is precisely why they matter. They show what could be said publicly about TM/1 at a given moment, what analogies seemed necessary, and which parts of the product the market thought were easiest to grasp.

    When Rothfeder’s 1986 PC Magazine article calls TM/1 a multidimensional, multiuser spreadsheet and table manager, that does not prove the product was only a spreadsheet. When Sinper’s 1988 Byte advertisement calls it “The Relational Spreadsheet,” that does not settle its architecture either. But both expressions show how TM/1 was being positioned and understood before OLAP became the cleaner retrospective label.

    The historian’s task is not to force those descriptions into premature agreement. It is to preserve what they reveal about a market still searching for the right category.

    A Better Historical Frame

    The most useful frame may be this: TM/1 belonged to the pre-OLAP vocabulary of enterprise analysis.

    It belonged to a world of table managers, three-dimensional spreadsheets, decision support tools, spreadsheet connectors, analytical databases, and spreadsheet-database hybrids. Those labels are not interchangeable, and they should not be collapsed into one another. But together they show the market circling around a problem that would later become central to enterprise planning and analytics.

    How could business users analyze numbers across products, periods, regions, scenarios, and assumptions without rebuilding the model every time?

    That question is bigger than any single label. It is also why TM/1 remains historically interesting. The software did not simply arrive before OLAP had a name. It helps explain why such a name eventually became necessary.