<div>
<div class="content wysiwyg-content">
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.<br />
<br />
My other developers want to also use a non-sql database for OLAP.<br />
<br />
We are thinking it is probably not worth it and might continue to use Oracle 10g for OLAP.<br />
<br />
What do you recommend ?<br />
Do you have any additional links besides the below ?<br />
<br />
<a href="http://stackoverflow.com/questions/2684462/nosql-and-data-warehouse" rel="ugc">http://stackoverflow.com/questions/2684462/nosql-and-data-warehouse</a><br />
<br />
<a href="http://ayende.com/blog/4552/nosql-and-data-warehousing" rel="ugc">http://ayende.com/blog/4552/nosql-and-data-warehousing</a><br />
<br />
<a href="http://wekeroad.com/2010/02/05/reporting-in-nosql" rel="ugc">http://wekeroad.com/2010/02/05/reporting-in-nosql</a><br />
<br />
<a href="http://www.databasejournal.com/sqletc/article.php/3919371/Business-Intelligence---SQL-or-NoSQL---Which-is-better.htm" rel="ugc">http://www.databasejournal.com/sqletc/article.php/3919371/Business-Intelligence---SQL-or-NoSQL---Which-is-better.htm</a>
</div>
</div>


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

OLAP – non-sql database vs Oracle ?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.