Navigation
New forum topics
RND
Languages
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 Unported License.
User login
Business Intelligence
Oracle Materialized views to optimize a Datawarehouse
Datawarehouse loadings are periodic, and summary tables are useful to improve efficiency and the answer time of our reports. A physical optimisation resource that can bring big improvements in our system is the utilization of materialized views.
The view materialized is not more that a view, defined with one sentences SQL, of which in addition to storing his definition, store the data that returns, realizing an initial load and afterwards each true time a freshen of the same.
Like this, if we have a Datawarehouse that update daily, could use views materialized to go updating intermediate tables that feed our diagrams of DWH, or directly to implement tables agregadas that will freshen from our tables base.
The creation of this type of views no so complex as it can seem, the most important is to have clear each how much time want to update the information of the views, and which method of freshen to use.
Also will have to ensure us that our licence of base of data allows us use them (has to be a version Enterprise).
Manual of metodologia HEFESTO for Datawarehousing
We have published a new manual online in Dataprix. Treat of the Methodology Hefesto prepared by Ricardo Dario Bernabeu, to the one who agradecemos this important aportación to the world BI hispano.
The manual divide in two parts:
EasyAsk, software of BI with searcher of intelligent 'reports'
EasyAsk, of Progress Software, is a tool of BI with the peculiaridad that for the application of reports, analysis or even pictures of control provides to the user an interface where formulates a question or a request of the information that precise, in lenguaje natural, and the tool translates it to SQL, MDX or what do fault to give back a report of what the user requests. It is as a searcher, but applied to our systems of information.
The new is in that seems that no only limit to locate reports, as already do the systems of research of other tools of BI, but that besides interprets the entered by the user in lenguaje natural like parameters to show him fair the information that has requested.
With this functionality remains well justified his classification like tool of Business Intelligence.
Pentaho in a Virtual Machine
We have prepared virtual servers with a preconfigured installation of Pentaho, the well-known open source platform for Business Intelligence (BI Pentaho PCI).
You can freely download a virtual machine ready with the virtualization software VirtualBox 2.0 Sun, and another with VM 2.0 server software:
BI book: Business Intelligence, Compete with Information
Josep Lluis Cano is the author of the book Business Intelligence: compete with Information. This excellent work explains in what consists the Business Intelligence and can be a big guide for abordar projects of BI. It is orientado sobretodo for directors of pymes that want to go in in the world BI, and do his more competitive company, by what the lenguaje is clear and the very practical content.
The first chapters explain all the necessary to know what is the BI, what can aportar to the company, which are his technical bases, and how can organize a project of Business Intelligence:
Chapter 1. Introduction to the Business Intelligence
Chapter 2. Modelización Of the Business
Chapter 3. Model of data
Chapter 4. Components of Business Intelligence
Chapter 5. Projects of Business Intelligence
The two last chapters are especially practical, and contain references to different tools and providers of BI and cases of success of implementations of projects of this type:
Find with Google engine
