Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!193.201.147.78.MISMATCH!feeder.news-service.com!postnews.google.com!k36g2000yqn.googlegroups.com!not-for-mail
From: JTP PR <janinepelletier@yahoo.ca>
Newsgroups: comp.databases.oracle.server
Subject: Whitepaper - In-Memory Analytics
Date: Mon, 26 Apr 2010 03:55:46 -0700 (PDT)
Organization: http://groups.google.com
Lines: 35
Message-ID: <46c5e2b4-46db-4cf1-87a5-13b342b6a62f@k36g2000yqn.googlegroups.com>
NNTP-Posting-Host: 93.182.158.98
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1272279346 27020 127.0.0.1 (26 Apr 2010 10:55:46 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 26 Apr 2010 10:55:46 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: k36g2000yqn.googlegroups.com; posting-host=93.182.158.98; 
 posting-account=aj39NAoAAAA3kEWnsMSeVAx_nZ9f4vAl
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; 
 Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 
 3.0.30729; Media Center PC 6.0; .NET CLR 1.1.4322; InfoPath.2),gzip(gfe)
Xref:  news.cambrium.nl

Yellowfin has released its latest Business Intelligence Whitepaper,
this time on "In-memory Analytics"

* No signup or email handover required, just click the link or cut/
past into your browser.

http://yellowfin.com.au/Document.i4?DocumentId=3D104879

Feel free to give us any feedback

Extract

As the name suggests, the key difference between conventional BI tools
and in-memory products is that the former query data on disk while the
latter query data in random access memory (RAM).
When a user runs a query against a typical data warehouse, for
example, the query normally goes to a database that reads the
information from multiple tables stored on a server=92s hard disk.

With a server-based in-memory database, all information is initially
loaded into memory. Users then query and interact with the data loaded
into the machine=92s memory. Accessing data in-memory means it is
literally =93turbo charged=94 as opposed to accessing that same data from
disk.
This is the real advantage of in-memory analysis.

In-memory BI may sound like caching, a common approach to speeding
query performance, but in-memory databases do not suffer from the same
limitations. Caches are typically subsets of data, stored on and
retrieved from disk (though some may load into RAM).
The key difference is that the cached data is usually predefined and
very specific, often to an individual query; but with an in-memory
database, the data available for analysis is potentially as large as
an entire data mart.