Holos
Encyclopedia
Holos is an influential OLAP
(Online Analytical Processing) product of the 1990s. Developed by Holistic Systems in 1987, the product remained in use until around 2004.
database (as opposed to a proprietary one), and also the first to use the new GUI PC for the user interface. In physically separating the number crunching from the user interface, the product was immediately client/server, although the term didn't come into use until some time later. In fact the process was described as cooperative processing at the time as client/server was not a current term at that time. The client/server model used for Holos was initially for a very "light" client as it was not clear at that time (1986/7)that PC's were going to be so commonplace and most PC's were still running MS-DOS. In fact it was technically possible to run the system using "dumb" terminal with reduced functionalty in early versions although save for in Holistic's test environment this was rarely if ever done. In time due to the increased popularly of PC's and their increased power and the available of a stable and more functional version of Microsoft Windows additional functionality was added to the client end mostly in the form of development aids. In addition to data services, the Holos Server supplied business logic and calculation services. It also provided complementary services to the Holos Client which meant the internal processing associated with the report writer, worksheet, etc., was distributed between the two components.
The virtual machine accounts for one of the most misunderstood aspects of the product: OLAP data was handled as a core data type of HL, with specific syntax to accommodate multidimensional data concepts, and complete programmatic freedom to explore and utilise the data. This made it very different from the industry trend of query-based OLAP and SQL engines. On the upside, it allowed amazing flexibility in the applications to which it could be applied. On the downside, it mean that 3-tier configurations were never successfully implemented since the processing had to be close to the data itself. This hindered large-scale deployment to many clients, and the use of OLAP data from other vendors. In reality, its own data access times were probably some of the fastest around—at the individual cell level; they had to be in order to be practical. However, when fetching back bulk data for non-cooperating clients, or data from other vendors, the queries could not be optimised as a whole. Its own data access used a machine-wide shared memory cache.
and MIS
were first coined, the industry norm was "slideshows", i.e. pre-programmed transitions between views, whereas Holos provided data-driven drill-down, i.e. no pre-programmed views or links. The transitions could be made dependent upon the data values and trends, in conjunction with the available business logic.
). It provided a very versatile mechanism for joining cubes, irrespective of their storage technology, dimensionality, or meta-data, and this was eventually given a US patent (called COA—Compound OLAP Architecture ). One novel aspect of this was a 'stack' feature that allowed read/write cubes to be stacked over read-only cubes. Read operations to the overall virtual cube then visited both 'racks' (top first, and then the bottom), whereas write operations only affected the top. The resulting valve-like mechanism found many applications in data sharing, what-if forecasting, and aggregation of slow SQL-based data. Since the overhead of the joining was small, it was not uncommon to have stacks 7 levels deep, and joining terabytes of real OLAP data. Around about V8.5, Holos Server implemented a hierarchical lock manager, allowing nesting of fine and coarse-grain OLAP locks, and full transaction control.
One of the biggest failures was not to provide a thin-client interface to the Holos Server, and this must have contributed to the product's demise. Although an HTML
toolkit was sold, it was clumsy and restricted. By the time a real thin-client mechanism was developed, it was far too late and it never got to market.
in 1996. Along with other companies such as Crystal Services, it was used to create a new subsidiary company called Seagate Software
. Only Holistic and Crystal remained, and Holistic was renamed to Crystal Decisions
. Holistic and Crystal had very different sales models. The average sale for the Holos Product in the United States was in excess of $250,000 and was sold primarily to Fortune 500 companies by a direct sales force. The Crystal sales model was based upon a "shrink wrapped" product Crystal Reports sold primarliy through resellers. As Crystal was acquired prior to Holistic the senior management in the sales and marketing arnea were mostly drawn from that organisation. They felt that all the product range should be through third parties and over a period of time dismatled the direct sales force culmination in a significant drop in sales for the Holos Product. Subsequently after some in-fighting and argument over product strategy, the main Holos development team finally started to leave around 2000, and Crystal Decisions was finally taken over by Business Objects
in 2004. Following the takeover, support for Holos was outsourced to Raspberry Software
, which was set up by former employees of Crystal Decisions.
OLAP
In computing, online analytical processing, or OLAP , is an approach to swiftly answer multi-dimensional analytical queries. OLAP is part of the broader category of business intelligence, which also encompasses relational reporting and data mining...
(Online Analytical Processing) product of the 1990s. Developed by Holistic Systems in 1987, the product remained in use until around 2004.
Conception
The Holos product succeeded an older generation of mainframe products such as System-W. It was the first to use an industry standard SQLSQL
SQL is a programming language designed for managing data in relational database management systems ....
database (as opposed to a proprietary one), and also the first to use the new GUI PC for the user interface. In physically separating the number crunching from the user interface, the product was immediately client/server, although the term didn't come into use until some time later. In fact the process was described as cooperative processing at the time as client/server was not a current term at that time. The client/server model used for Holos was initially for a very "light" client as it was not clear at that time (1986/7)that PC's were going to be so commonplace and most PC's were still running MS-DOS. In fact it was technically possible to run the system using "dumb" terminal with reduced functionalty in early versions although save for in Holistic's test environment this was rarely if ever done. In time due to the increased popularly of PC's and their increased power and the available of a stable and more functional version of Microsoft Windows additional functionality was added to the client end mostly in the form of development aids. In addition to data services, the Holos Server supplied business logic and calculation services. It also provided complementary services to the Holos Client which meant the internal processing associated with the report writer, worksheet, etc., was distributed between the two components.
Architecture
The core of the Holos Server was a Business Intelligence (BI) virtual machine. The Holos Language (HL) was compiled into a soft instruction code, and executed in this virtual machine (similar in concept to Java in more modern systems). The virtual machine was fully fault-tolerant, using structured exception handling internally, and provided a debugger interface. The debugger was machine-level until quite late on, after which it also supported source-level access.The virtual machine accounts for one of the most misunderstood aspects of the product: OLAP data was handled as a core data type of HL, with specific syntax to accommodate multidimensional data concepts, and complete programmatic freedom to explore and utilise the data. This made it very different from the industry trend of query-based OLAP and SQL engines. On the upside, it allowed amazing flexibility in the applications to which it could be applied. On the downside, it mean that 3-tier configurations were never successfully implemented since the processing had to be close to the data itself. This hindered large-scale deployment to many clients, and the use of OLAP data from other vendors. In reality, its own data access times were probably some of the fastest around—at the individual cell level; they had to be in order to be practical. However, when fetching back bulk data for non-cooperating clients, or data from other vendors, the queries could not be optimised as a whole. Its own data access used a machine-wide shared memory cache.
Language
The Holos Language was a very broad language in that it covered a wide range of statements and concepts, including the reporting system, business rules, OLAP data, SQL data (using the Embedded SQL syntax within the hosting HL), device properties, analysis, forecasting, and data mining. It even supported elements to enable self-documentation and self-verification. Placing all these areas on a common footing, and allowing them to co-operate by sharing data, events, etc., was key to the number of possibilities that resulted. For instance, the report writer supported input as well as output, plus interactive graphics, and a comprehensive event mechanism to pass back information about the viewed data to event handlers. Also, reports and data were separate entities, thus allowing the same report to be applied to different data as long as it was described by similar meta-data. This meant that when terms like EISEIS
EIS may refer to:* Terrance B. Lettsome International Airport, an airport in the British Virgin Islands which has IATA airport code EIS* Eastern Independent Schools of Melbourne, a group of schools in Australia...
and MIS
MIS
The abbreviation MIS may refer to:*Miś , a 1980 Polish film directed by Stanisław Bareja*mis, ISO 639-2 and ISO 639-3 three-letter language code for uncoded languages-Biology:...
were first coined, the industry norm was "slideshows", i.e. pre-programmed transitions between views, whereas Holos provided data-driven drill-down, i.e. no pre-programmed views or links. The transitions could be made dependent upon the data values and trends, in conjunction with the available business logic.
OLAP Storage
Holos Server provided an array of different, but compatible, storage mechanisms for its multi-cube architecture: memory, disk, SQL. It was therefore the first product to provide "hybrid OLAP" (HOLAPHOLAP
HOLAP is a combination of ROLAP and MOLAP which are other possible implementations of OLAP. HOLAP allows storing part of the data in a MOLAP store and another part of the data in a ROLAP store, allowing a tradeoff of the advantages of each...
). It provided a very versatile mechanism for joining cubes, irrespective of their storage technology, dimensionality, or meta-data, and this was eventually given a US patent (called COA—Compound OLAP Architecture ). One novel aspect of this was a 'stack' feature that allowed read/write cubes to be stacked over read-only cubes. Read operations to the overall virtual cube then visited both 'racks' (top first, and then the bottom), whereas write operations only affected the top. The resulting valve-like mechanism found many applications in data sharing, what-if forecasting, and aggregation of slow SQL-based data. Since the overhead of the joining was small, it was not uncommon to have stacks 7 levels deep, and joining terabytes of real OLAP data. Around about V8.5, Holos Server implemented a hierarchical lock manager, allowing nesting of fine and coarse-grain OLAP locks, and full transaction control.
Business Rules
The business logic supported full cross-dimensional calculations, automatic ordering of rules using static data-flow analysis, and the identification and solution of simultaneous equations. The rules treated all dimensions in an orthogonal fashion. The aggregation process did not distinguish between simple summation or average calculations, and more complex non-commutative calculations. Both could be applied to any dimension member. The process allowed aggregation levels (i.e. those calculation levels starting with base data (level 0) and proceeding up to the overall grand total) to be individually pre-stored or left to be calculated on demand.Holos Client
The Holos Client was both a design and delivery vehicle, and this made it quite large. Around about 2000, the Holos Language was made object-oriented (HL++) with a view to allowing the replacement of the Holos Client with a custom Java or VB product. However, the company were never sold on this, and so the project was abandoned.One of the biggest failures was not to provide a thin-client interface to the Holos Server, and this must have contributed to the product's demise. Although an HTML
HTML
HyperText Markup Language is the predominant markup language for web pages. HTML elements are the basic building-blocks of webpages....
toolkit was sold, it was clumsy and restricted. By the time a real thin-client mechanism was developed, it was far too late and it never got to market.
Deployment
Before its demise, the Holos Server product ran under Windows NT (Intel and Alpha), VMS (VAX and Alpha), plus about 10 flavours of UNIX, and accessed over half-a-dozen different SQL databases. It was also ported to several different locales, including Japanese.Company
Holistic Systems was purchased by the hardware company Seagate TechnologySeagate Technology
Seagate Technology is one of the world's largest manufacturers of hard disk drives. Incorporated in 1978 as Shugart Technology, Seagate is currently incorporated in Dublin, Ireland and has its principal executive offices in Scotts Valley, California, United States.-1970s:On November 1, 1979...
in 1996. Along with other companies such as Crystal Services, it was used to create a new subsidiary company called Seagate Software
Seagate Software
Seagate Software was an international software corporation headquartered in Scotts Valley, California, United States. It was a majority owned subsidiary of Seagate Technology, the largest independent disc drive and related components company in the world....
. Only Holistic and Crystal remained, and Holistic was renamed to Crystal Decisions
Crystal Decisions
Crystal Decisions is the name of a company that was known for its Business intelligence products....
. Holistic and Crystal had very different sales models. The average sale for the Holos Product in the United States was in excess of $250,000 and was sold primarily to Fortune 500 companies by a direct sales force. The Crystal sales model was based upon a "shrink wrapped" product Crystal Reports sold primarliy through resellers. As Crystal was acquired prior to Holistic the senior management in the sales and marketing arnea were mostly drawn from that organisation. They felt that all the product range should be through third parties and over a period of time dismatled the direct sales force culmination in a significant drop in sales for the Holos Product. Subsequently after some in-fighting and argument over product strategy, the main Holos development team finally started to leave around 2000, and Crystal Decisions was finally taken over by Business Objects
Business Objects (company)
SAP Business Objects is a French enterprise software company, specializing in business intelligence . Since 2007, it has been a part of SAP AG. The company claimed more than 46,000 customers worldwide in its final earnings release...
in 2004. Following the takeover, support for Holos was outsourced to Raspberry Software
Raspberry Software
Raspberry Software is a software company based near Ipswich in Suffolk, England which in the past offered support for legacy applications, currently it develops software for mobile devices....
, which was set up by former employees of Crystal Decisions.