“The world is changing very fast. Big will not beat small anymore
It will be the fast beating the slow” – Rupert Murdoch
- Big Data
- Engineered Systems
- DWH ALM
- Logical Data Warehouse
- In Memory
- Integrated Analytics
- Data Discovery
Data Warehouse Automation
Data Vault Accelerator will accelerate your development and reduce time to minimum 60% of the effort. The Data Vault Accelerator is available for Oracle Warehouse Builder and ODI 12C.
Data Vault Accelerator will generate >90% of all ETL mappings for the foundation layer creating the single source of the fact and the extraction towards the presentation layer which will result in a lower Time to build and Cost.
The Accelerator generates code loaded in the ETL tool. By running the script the needed mappings will generate the Data Vault. In this way one will benefit from the functionalities an ETL tool has to offer : lineage, versioning, knowledge transfer.
Integrating Big Data
Do we need both a data warehouse and Hadoop? In the short term, the answer is clearly “Yes.” A more meaning- ful question is: What’s the best way to use them together to advance the goals of our business? The real solution to the access and data movement problems—and the real answer to a single data store for analysis—is to create a more tightly integrated system that unifies a relational database with Hadoop without losing sight of the unique value proposition each subsys- tem adds to an organization.
The industry as a whole has not made it to this stage, and almost no actual implementations are currently there. The industry’s energy should be focused on find- ing a language and implementation to build a single, logical system.
Exadata Database Machine is engineered to be the highest performing and most available platform for running Oracle Data Warehouse. Although not mandatory to run a DWH it will increase agility.
Big Data Appliance ships pre-integrated toreduce the costand complexity of IT infrastructures. Speed the deployment, increase the performance, and reduce the risk of your big data , No SQL, and Hadoopp rojects.
Exalyticsis the industry’s first engineered system for in-memory analytics that delivers extreme performance for Business Intelligence and Enterprise Performance Management applications. Built using best in class hardware, market- leading business intelligence software and in-memory database technology.
What is Application Lifecycle Management
The purpose of Application Lifecycle Management is to simplify and improve the development process. It addresses the development process and related downstream activities, the production environment (deployment) and the upstream activities like requirements management and issue tracking.
In general the ALM tool needs to serve the complete process and be independent of the development methodology used (e.g. waterfall, spiral, prototyping, agile,…). It should pay attention to the needs of all stakeholders and offer them freedom of tools choice.
The benefits of using ALM are:
- Fewer errors and faster results
- Reduced application development, testing and deployment costs
- Improved quality (CMMI) and traceability
ALM for Oracle Data Integrator (ODI)
There is no integration with standard versioning tools for ODI developers. This makes it difficult to manage releases and bug fixes and there is no support for concurrent development. The release process, deployment to test and production environments is a labor intensive, complex and time consuming process
Our ALM solution for ODI consists of an ODI versioning component for developers and a to ODI tailored framework for release managers to manage a customizable ODI life cycle and a fully automated Build and Deploy process for ODI.
Logical Data Warehouse
The goal of a logical data warehouse is to limit the persistence of data to it’s minimum. In this architecture it would mean that virtual star schema’s will be exposed to the end user. The structure on which the end-user queries is a star schema view or is represented in the reporting metadata as a star schema view while the query physically will be executed to the foundation layer data vault model. This reduces again the development effort and increases the agility. It is mainly the power of the newest engineered systems in combination with in memory technology that allow for this.
OBI EE : 3 layer optimized for Logical Data Warehouses will allow you in combination with Exalytics to virtualize the star schema’s delivering the necessary insights in business.
Oracle Database In-Memory delivers leading-edge in-memory performance without the need to restrict functionality or accept compromises, complexity and risk. Deploying Oracle Database In-Memory with virtually any existing Oracle Database compatible application is as easy as flipping a switch–no application changes are required. It is fully integrated with Oracle Database’s scale-up, scale-out, storage tiering, availability and security technologies making it the most industrial-strength offering in the industry.
In memory technology will allow to implement logical data warehouse without losing any performance.
Integrated analytics will allow to capitalise on your existing data warehouse platform avoiding the cost of a separate platform and the time spend of moving data. Oracle does support the market leading R language and has integrated data mining algorithms in the database. Two environments will support your organisation in every type of data analysis,. The analyst has 2 options to work in : sql developer or R and it’s interfaces.
Oracle Database In-Memory drastically cuts the reporting time and frees the database to quickly handle transactions,. While other products are designed just for analytics, Oracle Database In-Memory works well for both. The in memory option will prove it’s value in complement with Logical data warehouse.
Businesses today must have a fast, focused response when something unexpected happens, or risk losing customers and revenue. Top performers know how hard it can be to analyze information that is vast, varied, and often outside the warehouse. Oracle Endeca Information Discovery is a complete enterprise data discovery platform that combines information of any type, from any source, empowering business user independence in balance with IT governance. Now organizations can access the information they need, when they need it, to make business decisions they can trust.
Tripwire brings the latest concepts and technologies in your architecture to lower the development and maintenance cost :
Due to code generation (Data Warehouse) = 60% less investment
Virtualisation of logic made possible by OBI EE and in memory technology results in lower development time
Integrated platform for analytics will avoid heterogeneous platforms and will reduce the lead time to analyse any type of data
Automated release management will lower your effort in move to production process. This will become more significant when having more and more versions due to increased agility
Agile Approach does not only refer to stand ups, sprint. We allow you to work in a more agile way :
Due to code generation (Data Warehouse) reduces iterations with business upto 50%
Virtualisation of logic will result in faster development of your aggregates avoiding incremental logic since data is not persisted
Integrated platform for analytics will avoid loading data in a specific platform. This increases lead time and cost.
Automated release management will sustain an agile BI environment bringing OBI EE and DWH to a new version.
Data Discovery tools allow you to quickly discover all relevant data but can also be used as prototyping environment towards business to clear out all specifications avoiding scope creep.
Structured and unstructured data are integrated seamless due to Big Data SQL. We recommend that structured data resides in the classic data warehouse and that data with high velocity or unstructured is stored in an hadoop repository. This results in following benefits:
Data integrity is preserved
Generating a through 360° view including Big Data
One Analytics integrated platform being able to handle any type of data
Allow a tailored insight in your business (for business intelligence differentiation is key no standardisation, no industry applications)
Multi speed architecture : high velocity data can reside in hadoop repository
Our solution has Data Vault as the first layer of your data warehouse environment. Data Vault by nature is resilient to change. There are three reasons why Datavault is an adaptive Datamodel approach:
A fundamental reason: Separating the keys, relationships and the descriptive data in separated tables enhances the flexibility and agility of the model.
You can easily add Satellites (within a Concept) to the model without breaking the existing model.
You can easily add Links (a new Concept or a new Concept Constellation) to the model without altering the existing model.
The Oracle Exadata Database Machine combined with Oracle Database In-Memory option are the perfect combination for delivering extreme performance and high availability for data warehousing and reporting systems. Built with scale-out hardware and software that can load data into RAM, PCI-based flash, or disk, Oracle delivers the most efficient and industrial-strength offering for instant insights.
Exalytics delivers extreme in-memory analytics performance for business Intelligence and enterprise performance management applications. Built using best-in-class hardware, market- leading business intelligence software and in-memory database technology, Oracle Exalytics is an optimized system that provides speed-of-thought analysis with unmatched intelligence, simplicity, and manageability.