Our document repository is easily searchable and allows you to search for publications, event presentations, journals, whitepapers and much more. If you have a document that you would like to add to the library repository click here to email your submission.
Getting the best out of Data Warehousing with Oracle Database 12c?
In June 2014 Oracle launched the in-memory database option and it is generally available as part of Oracle 12c (184.108.40.206) as an additional cost option to Oracle Enterprise Edition. But
what’s the big deal about in-memory (IM)?
With all the talk about Agile development methods and Extreme Programming, the question arises as to how these approaches can be used to deliver data warehouse and business intelligence projects faster. This article will look at the principles behind the Agile Manifesto and see how they might be applied in the context of a data warehouse project. The goal is to determine a method or methods to get a more rapid (2-4 weeks) delivery of portions of an enterprise data warehouse architecture.
Oracle SQL Developer Data Modeler (Data Modeler) is a tool for designing and documenting
databases. It can be used for Oracle databases as well as Microsoft SQL Server or IBM DB2 databases. The tool is available as standalone product but it is also integrated in Oracle SQL Developer, so a user can decide which way is the best for him/her to use the tool.
With the E-Business Suite upgrade deadline looming, many companies are either grappling with the challenges of making the transition or dealing with the aftermath of the process. The need to optimise processes and software is more pressing than ever but if business processes are not documented in glorious, gory detail organisations could not only find themselves floundering at the first upgrade hurdle but more importantly they could be leaving themselves open to significant risk. Colin Armitage, CEO of Original Software, considers the case for Business Process Capture (BPC) as a solution.
Usually, the conclusion comes at the end. But here I will clearly show my goal: I hope I will never see the optimizer_index_cost_adj parameters again. Especially when going to 12c where Adaptive Join can be completely fooled because of it. Choosing between index access and full table scan is a key point when optimising a query and historically the CBO came with several ways to influence that choice. But on some systems, the workarounds have accumulated one on top of the other – biasing completely the CBO estimations. And we see nested loops on huge number of rows because of those wrong estimations.
In the second article in this three part series we’ll look in more detail at Hive and how you can connect to it using Oracle Business Intelligence, so that you can create dashboards and reports against the data that it contains.
Earlier this year, Oracle released a white paper about the ‘Top 10 Data Warehousing Trends & Opportunities for 2014’, which I have used as the basis for this article.
Throughout this website you will no doubt see articles from leading experts in a whole
range of technologies, using their years of experience to successfully implement solutions
on the Oracle stack. Well in this article I want to tell a slightly different story: a story of how an applications DBA, rather than someone from a development background, managed to
end up successfully designing and building a production on-device mobile application for
Lloyd’s Register. If you want to learn the lessons, and maybe start building your own mobile
applications, then read on!
Published: 21.10.2014 - This document is restricted to members
I-Procurement Catalogs - What and Why