Solved

OLAP – non-sql database vs Oracle ?

Posted on 2013-01-25
2
503 Views
Last Modified: 2013-02-07
We already have Oracle 10g and are thinking about using a non-sql database like Mongo for a static 40,000 part “product list” that gets created nightly which is fine since this is STATIC data.

My other developers want to also use a non-sql database for OLAP.

We are thinking it is probably not worth it and might continue to use Oracle 10g for OLAP.

What do you recommend ?
Do you have any additional links besides the below ?

http://stackoverflow.com/questions/2684462/nosql-and-data-warehouse

http://ayende.com/blog/4552/nosql-and-data-warehousing

http://wekeroad.com/2010/02/05/reporting-in-nosql

http://www.databasejournal.com/sqletc/article.php/3919371/Business-Intelligence---SQL-or-NoSQL---Which-is-better.htm
0
Comment
Question by:finance_teacher
2 Comments
 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 250 total points
ID: 38822802
40000 records is pretty small, if you already have Oracle there is no reason to invest in any new technology.
0
 
LVL 6

Accepted Solution

by:
liija earned 250 total points
ID: 38825874
I agree with sdstuber. 40000 rows is a small table for any db or OLAP.

Question is - what are you going to gain with no-sql?
Do you have some problems with your current technology? Are the developers just more familiar with no-SQL than Oracle OLAP?
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now