User:Dll99

From Wikipedia, the free encyclopedia
Jump to: navigation, search
David Hilbert

JAVA Extensions and architectures closely tied to the Java programming language include:

OLAP (on-line analytical processing) was a term coined by E.F. Codd & Associates published a white paper in 1994, commissioned by Arbor Software (now Hyperion Solutions), entitled ‘Providing OLAP (On-line Analytical Processing) to User-Analysts: An IT Mandate’. (see also article on OLAP).

Codd was one of the originators of the relational database and so his opinions were respected. However Codd was paid to write the white paper to support Arbor's existing Essbase product, rather than the concept being mathematically based. Neverthless Codd's reputation legitimised a useful new arrangement of data in arrays to allow fast analysis. These arrays are called cubes. The arrangement of data into cubes avoids a limitation of relational databases which are not well suited for analysis of large amounts of data almost instananeously. Relational databases are better suited for creating records from a series of transactions (known as OLTP or on-line transaction processing). Although many report-writing tools exist for relational databases, these are slow when the whole database must be summarised. Codd's paper was propaganda that users could show to skeptical IT departments who had often thought that everything their users wanted could be done from a relational database.

OLAP cubes can be thought of as extensions to the two dimensional array of a spreadsheet. For example a company might wish to analyse some financial data by product, by time-period, by city, by type of revenue and cost, and by comparing actual data with budget. These additional methods of analysing the data are known as dimensions.

OLAP cubes can be thought of as extensions Hilbert-space and Extensions JAVA [[1]]