Operational Data Store
Many businesses believe they would benefit greatly from better access to their production data and indeed they would. To make their data more accessible and actionable, what many businesses really need is a reporting environment that does not conflict with production and that is designed for rapid ad hoc analysis – an Operational Data Store (ODS).
Built using powerful tools like Taurus Software’s BridgeWare and DataBridger, an ODS can move your production data in real time to an open systems relational model that’s accessible for analysis, reporting and other downstream data requirements.
One of the chief advantages of an Operational Data Store is its immediacy and level of detail. Our ODS takes heavily coded, non-query-ready data feeds from your various systems and cleans, normalizes, indexes and reconciles that data, making it available for immediate analysis and export to other feeds.
With Taurus’ operational data store, user’s can now have real time production data that’s easy to access via open systems reporting tools and data feeds, all without impacting production. Because our ODS maintains real-time operational data, it can keep a data warehouse or other feed current by passing only incremental changes, vastly reducing the drain on your system performance.
Taurus Software’s ODS offers:
- A responsive, real-time reporting environment
- Reduced conflict with production
- A comprehensive repository for all operational data
- A data consolidation center for single-view analysis
- A unified data cleansing and validation process
- Incremental data updates to external feeds or data warehouses
- Ability to capture history of change
- A stepping stone for migration
Fast, real-time reporting
To make decisions in today’s breakneck business environment you need access to information as it happens.
Our ODS takes heavily coded, non-query-ready data feeds from your various source systems and cleans, normalizes, indexes and reconciles that data, optimizing it for analysis.
Users now have real time production data that’s easy to access via open systems reporting tools, all without impacting production. “What’s the status of my order right now?” may be too intensive to run against production, and too time critical for a data warehouse, but easily executed in the ODS.
Reduced conflict with production
Reporting and analytical requests can have a huge impact on your production operations. Because an ODS maintains real-time operational data, it can be used by users for mission critical operational queries without impacting production.
Downstream data requirements such as refreshing a data warehouse typically require a drop and reload, necessitating a full extract from production. But because an ODS maintains real-time operational data, it can keep a warehouse current by passing only incremental changes⎯vastly reducing the drain on your system.
Plus, your system will run much faster by handling data extracts and downstream feeds⎯for external files, the Web or stars and cubes⎯from the more current and responsive ODS instead of production. By moving data out of production just once, the ODS creates additional efficiencies by precluding a data extract for every single downstream application.
A data consolidation center for single-view analysis
A thorough analysis often requires consolidation of data that may reside in several applications across your enterprise, and in many levels of detail or granularity. Many people have to keep data in Excel spreadsheets and manually merge this with production extracts to get the reports they need.
The ODS is open and can consolidate data from any number of sources. It pulls, cleans, indexes and retains data from all your source systems in real time. An ODS makes cross application queries practical and very simple. Plus, since the ODS operates in an open-system environment, you’re also free to take advantage of the wealth of analytical tools available on the market.
A unified data cleansing and validation process
Trying to cleanse data in-process between your source and target makes it virtually impossible to properly complete the next crucial step reconciling with production. But as BridgeWare and DataBridger move data into your ODS they clean, normalize and validate as they go, offering fully indexed columns available for immediate analysis or a multitude of downstream uses.
Complete history of change
Regulatory requirements like Sarbanes-Oxley⎯even special reporting requests can necessitate a full data audit trail. Was this policy revised? Was that address modified? And when? By who? As Taurus’ data movement tools capture real time changes and post them to an ODS they can keep their prior versions, allowing a complete history of change⎯and complete answers to complex questions.
Protection against source system changes
Data warehouse feeds and extracts run against the ODS rather than production are much less susceptible to structural changes to your system.
Stepping stone for Migration
Real time data, available to users, via open tools without impacting production – this combination gives IT the ability to satisfy their user’s analysis requirements without having to rely on the production systems to do so.
Once the user’s queries are not being developed against production, that system can change without impacting these users. Companies can migrate part of their business to new systems, feeding this new data to the ODS alongside the old and not impacting the users. This allows users to obtain analysis before, during and after a migration – with minimum impact or retraining to the user community.
Many companies decide to stay with their “old” production systems once they have an ODS because it works great for transactional processing. For older systems, where analysis can be cumbersome, the ODS simplifies reporting needs. Other companies buy time with an ODS that allows them to build their own underlying transactional systems.
Regardless of the migration path, giving your users real time analysis via open tools gives you the flexibility to choose.