SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Comparison of Business Intelligence Strategies between SQL and Oracle


Comparison of Business Intelligence Strategies between SQL and Oracle

Author
Message
Dinesh Priyankara
Dinesh Priyankara
Mr or Mrs. 500
Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)

Group: General Forum Members
Points: 519 Visits: 115
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dPriyankara/comparisonofbusinessintelligencestrategiesbetweens.asp
ckempste
ckempste
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4811 Visits: 1
Hi there

One item you may have overlooked - its important to remember that the "user experience" in all of this is poorly served in both areanas of dbms's. For example the pivot control is hardly useful for any serious BI and the oracle express tools (name has probably changed) are clunky and somewhat limiting. When making a decision, take a careful look at the packages to deliver the real functionality to the end user such as Cognos and others (I cant remember the freaking names!). These tools all "plug in" to the underlying BI infrastructure and their associated API's, the plug in's may also be limitinng based on the company/version your connecting to, and worst still, if the GUI vendor does or does not support XYZ feature from the dbms vendor's cubes/bi framework. The other end of the stick is that the GUI vendor like cognos also gens its own the cubes, with a good security model wrappered around it; so then the matrix of choice broadens for you...

Dont expect to be coding up screens using API's, it may be very costly for you, and there are a huge number of vendors out there will all the hooks to MS and Oracle with extremely function UI's for your hardcore and "standard" users. Perhaps code up the "executives" BI screens yourself, but Id be supprised that you can pull off the rest.

Cheers

Chris


Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
vipulaye
vipulaye
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 1
Hello Everybody
Dinesh has done a good job in pointing the difference betwwen SQL Server and Oracle in favour of Sql Server.Since this place is only for SQL Server everybody will readily accept this but if you this article in an open place(where both Oracle & SQL Server guys can read) we would see a real debate between these two products and can evaluate better.
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/dPriyankara/comparisonofbusinessintelligencestrategiesbetweens.asp
[/quote]



Dinesh Priyankara
Dinesh Priyankara
Mr or Mrs. 500
Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)

Group: General Forum Members
Points: 519 Visits: 115
Hi all,
I received an email from Oracle expert saying it is not so much cost as I have mentioned. As per him, by using only Oracle Express, you can create BI platform even without DW Builder. Any idea?

Another thing, Cognos has so many products for BI like Decision Stream, PowerPlay. For entire BI platform, should buy all these products?


mcp mcse mcsd mcdba
Mike Pearson
Mike Pearson
Mr or Mrs. 500
Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)

Group: General Forum Members
Points: 571 Visits: 1
The costing is a very valid argument. Feature for feature you could make Oracle match SQL (or vice versa) to the point where the business wouldn't really care as long as they got their reports. The simple reality of it all is that the SQL option will be cheaper - and I have seen clients implement a SQL DW + a dedicated resource for the same price it would have cost them to take the Oracle route. In this period of IT Budget contraints (yada yada) price counts for an awful lot...



Mike Pearson
Mike Pearson
Mr or Mrs. 500
Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)Mr or Mrs. 500 (571 reputation)

Group: General Forum Members
Points: 571 Visits: 1
...and besides, the SQL option is just sooooo much easier to implement! Less headache factor Smile



Antares686
Antares686
SSC-Forever
SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)

Group: Moderators
Points: 44702 Visits: 803
I would have also added the difference in cost between and Oracle developer and a SQL developer for ongoing maintainence which can cause a TCO (Total Cost of Ownership) blowup.



Dinesh Priyankara
Dinesh Priyankara
Mr or Mrs. 500
Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)

Group: General Forum Members
Points: 519 Visits: 115
I wonder why the cost of Oracle developer so high. Because of Orcal DBA has wide knowledge than SQL DBA or besoming Oracle DBA is too difficult and too cost.

mcp mcse mcsd mcdba
dweil
dweil
SSC Eights!
SSC Eights! (954 reputation)SSC Eights! (954 reputation)SSC Eights! (954 reputation)SSC Eights! (954 reputation)SSC Eights! (954 reputation)SSC Eights! (954 reputation)SSC Eights! (954 reputation)SSC Eights! (954 reputation)

Group: General Forum Members
Points: 954 Visits: 3348
Obviously an Oracle Fan wrote the following article. In relation to the article mentioned above and the very long discussion about Oracle VS SQL. Are all the arguments that the author makes correct and if so would the cost of Oracle be worth it??

http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci834319,00.html


David Weil



Dinesh Priyankara
Dinesh Priyankara
Mr or Mrs. 500
Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)Mr or Mrs. 500 (519 reputation)

Group: General Forum Members
Points: 519 Visits: 115
As I think, this is depend on cost and familirity. I read the page what you have mentioned but can't agree to all like partitioning, triggers, external file accessing. Even bitmap indexing is also available in SQL 64-bit version. Some parts are unknown to me as I do not have much experience in Oracle. It is better to read this page by someone who has good knowledge on both sides and let us know.

mcp mcse mcsd mcdba
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search