Data Marts and Data Warehouses
Corporations today recognize the efficient operation of transactional systems and analytical systems require different data organization. To accommodate the operational requirements of analytical systems, organizations are creating data marts and data warehouses - vast repositories of corporate data for use by data mining and analysis applications.
dbSpaces can complement data marts and data warehouse systems by providing the ability to access data in disparate corporate data sources. When the data warehouse vendor's software does not provide support for a unique data type, or there is a requirement to integrate with external data sources, dbSpaces can be used to provide fast, easy access without requiring the writing of data integration program code.
dbSpaces can also serve the needs of organizations that cannot justify the expense and/or do not have the resources required to implement a datamart or data warehouse, by providing the ability access multiple data sources simultaneously, as if they were a single data source. dbSpaces can act as a virtual data warehouse using its real-time data access capability.
dbSpaces powerful Virtual Database Technology allows you to efficiently manage real-time data marts or data warehouses with its:
- Ability to access, manage, replicate, update, query and deploy any data. dbSpaces allows advanced data source management, regardless of physical location or format, including legacy data sources.
- Modular approach to data - your applications interact with dbSpaces, eliminating the need to write data integration code for each data source.
- Simultaneous Database Access - your applications interact with all your data as if it were a single data source, providing easy access to all the various data sources.
- Data Location Transparency - end users request information without knowing the data source or the physical location of the data.
- Virtual Views of Information - allow users to see a result set that is an aggregation of information that doesn't exist in one specific database.
- Fast Real Time Access - it's easy for your applications to get the data they need, when they need it.
- Alerts and events - applications can track changes in data based on user-defined criteria, and can respond appropriately based on business logic.
- Security and Audit Features - user authorization privileges and audit tracking of changes provide security and protect confidentiality.
- Data Snapshots - capture and view data at specific times for trend analysis.
- Alias Table and Column Names - easily map names which may not be suitable for reporting (legacy, flat file or COBOL) to a more usable name.
- Persistent messaging - queued messages guarantee transaction integrity.
dbSpaces is a key element in helping corporations manage their data-marts and data warehouses to meet the information requirements of a their knowledge users.