473,327 Members | 1,952 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Oracle DB features that support BI/ warehousing

Does anyone know what the big ORCL database features are really
intended to support OLAP or reporting requirements...so far I
have:

* Query re-write
* Materialized Views
* Bitmap Indexing
* Read Consistency – a previous pilot was required to use NSK "READ
UNCOMMITTED" to get any sort of viable performance, which implies
dirty reads (typically handled with rollback segments in Oracle)
* Data concurrency: Readers don't block readers, readers don't block
writers, writers don't block readers.
* Rollback - undo any uncommitted changes made by a transaction. The
transaction is ended.

Are there others I should consider ?

Thanks,

Jack
Jul 19 '05 #1
1 1799
Jack wrote:
Does anyone know what the big ORCL database features are really
intended to support OLAP or reporting requirements...so far I
have:

* Query re-write
* Materialized Views
* Bitmap Indexing
* Read Consistency – a previous pilot was required to use NSK "READ
UNCOMMITTED" to get any sort of viable performance, which implies
dirty reads (typically handled with rollback segments in Oracle)
* Data concurrency: Readers don't block readers, readers don't block
writers, writers don't block readers.
* Rollback - undo any uncommitted changes made by a transaction. The
transaction is ended.

Are there others I should consider ?

Thanks,

Jack

SQL Analytics
Partitioning (option)
Parallel Operations
Data Compression
OLAP (Option)
Data Mining (Option)
There are more ......

Jul 19 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Bevertec | last post by:
Our client is a major bank and we have the following immediate requirements. Oracle Data Warehousing Consultant We need 2 resources with the following skills to start immediately: Strong Data...
38
by: Mike | last post by:
No flame wars, please! We're planning a move from a non-relational system to a relational system. Our choices have been narrowed to Oracle and DB2. Since we're moving from non-relational to...
0
by: daisy | last post by:
To empower your .NET applications with the Oracle Database, download Oracle Data Provider for .NET (ODP.NET) from : http://otn.oracle.com/tech/windows/odpnet/index.html Try out the new features...
0
by: Daisy | last post by:
To empower your .NET web services with the Oracle Database, download Oracle Data Provider for .NET (ODP.NET) from : http://otn.oracle.com/tech/windows/odpnet/index.html Try out the new features...
5
by: NormaJean Sebastian via DBMonster.com | last post by:
Hi, I almost read all of the "DB2 vs Oracle" thread... The summary I got from that was all databases essentially do the same things, the decision of which one you use primarily depends on...
2
by: _link98 | last post by:
Does IBM publish a complete list of features (of Oracle) which the IBM migration toolkit does *not* convert? The docs seem rather vague. For example: 1. What support for the oracle...
6
by: JV | last post by:
A ref cursor data type can obviously be returned as an output parameter of a stored procedure, but can an ASP.NET application call an oracle proc that uses a ref cursor as an input parameter? If...
2
by: Vinod Sadanandan | last post by:
All, Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features . Precompilers:...
1
by: Jack | last post by:
Does anyone know what the big ORCL database features are really intended to support OLAP or reporting requirements...so far I have: * Query re-write * Materialized Views * Bitmap Indexing *...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.