In a LinkedIn debate about how to update from a select with summarized registers in SQL Server, Sergio Romero has shared an interesting tip about new summarize functions on Oracle 11g R2.
Since the release 1 of Oracle 11g, Oracle provides the ability to encrypt tablespaces in full, to protect sensitive data inside and accessible from the OS. That is, the objective of this new functionality is not to protect sensitive data of users of the database, but to protect the information of the tablespace datafiles.
To explain the usefulness of this feature, it is best to explain situations in which our data without this functionality would be vulnerable. For example, in the case file of a physical backup of a database tablespace were to wrong hands, could see some data "clear" without problems. For example, a single edition of tablespace (or a simple "cat") containing the Employees table, we show clear varchar2 fields can extract sensitive data (you do not believe, try it!).
Last week I attended a Web Seminar Oracle that presented the new features of Oracle Business Intelligence 11g.
The truth is that I was pleasantly surprised, because these improvements solved what I considered so far the main weaknesses of the Oracle BI Suites .
Most significant to me is the integration efforts made in the portal since it can use most of the tools of the suite, and thus reduce the feeling of working with different products. For instance, you can create operational BI Publisher reports from the same portal, and has created an integrated scorecarding tool that allows you to define KPI's, and 'react' with Agents and Actions, another pending issue of the suite. The part of administración system has also been integrated into Enterprise Manager.
Other improvements are those which have been introduced in the creation and display Dashboard, the possibility of using interactive maps, and above all the possibility of using also Answers MOLAP data sources such as Essbase cubes, which enables integration Hyperion, greatly improves the analytic reporting and enables dynamic navigation for multi-dimensional hierarchies, and other features in the reports.
This work is licensed under a Creative Commons Attribution-Share Alike 4.0 License.