Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sparse database best aggregation strategies?

user11440683Nov 7 2017 — edited Nov 9 2017

Hi,

Say you have a database with 2 dense dimensions with middling block size and 5 sparse dimensions with hierarchies that need aggregating, which between them will easily take Essbase into the second 2^52 group, though being a low way shy of the second limit. Data is spread very sparsely across the dimensions with less than 0.09% of the potential sparse combinations populated.

Also imagine that the lions share of its data will be loaded from other systems, so form based aggregation strategies are not useful to you, and external pre-aggregated data is also not possible.

Also assume dimensional ordering is optimal.

Are there any useful strategies that can be employed to minimise the aggregation times in PBCS.

thanks for your input,

Robert.

Comments

843810
Have browsed through the forum and it seems that the
JCE provider bundled with JCE and JDK1.4+ do nothing
on RSA. Can I make this conclusion?
Yes, but: A standard installation of Java comes with 5 providers. SunJCE is only one of these providers. Two other providers, SunJSSE and SunRsaSign do provide RSA for digital signature purposes.
843810
But it seems the SunJCE doesn't provide the RSA (and AES, who knows what else is missing) encryption and decryption functions. Can anyone list what is missing from the SunJCE? Also, from the forum, many have pointed to this bounty castle provider. Can any of you guys who are familiar with this provider give us the procedure of installation? Thanks.
843810
But it seems the SunJCE doesn't provide the RSA (and
AES, who knows what else is missing) encryption and
decryption functions. Can anyone list what is missing
from the SunJCE? Also, from the forum, many have
pointed to this bounty castle provider. Can any of
you guys who are familiar with this provider give us
the procedure of installation? Thanks.
I wouldn't use the term 'missing' here. Sun provides some basic cryptographic functions and that all. If you want more, get another provider. Sun will never be able to provide every possible algorithm. That's why they have implemented the external provider option. So no, I cannot list what is missing.

I can tell you that other providers, for instance BouncyCastle offer much more cryptographic functions. Installation is very easy. Just download the .jar and put it in your <java>\jre\lib\ext directory. After that you can use it in you programs with the following code: 
Provider prov = new org.bouncycastle.jce.provider.BouncyCastleProvider();
Security.addProvider(prov);
You can also install it so that you don't have use this code in every program that uses the provider. How this is accomplished, can be found in the install manual from BouncyCastle.
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 5 2017
Added on Nov 7 2017
#business-intelligence-applications, #pbcs, #performance-management-applications, #planning-and-budgeting
3 comments
231 views