Data Warehouse for Quicker, More Advanced Decision Making
The ability to make quick, well-informed decisions gives a company an important edge in today's competitive global economy. Although the traditional function of an enterprise computer system has been to handle operational aspects of business, today's computer systems are required to do much more. Corporate decision makers need advanced computer technologies to develop analytical systems that can help them to formulate plans of action.
The data warehouse enables a company to access and control the vast amount of information stored within an enterprise information system. A wealth of information can be contained there, especially within legacy systems that have been accumulating data for years. Access to this data can give decision makers powerful knowledge of business trends and fundamentals that can lead to more accurate judgments.
As a global IT vendor, Fujitsu offers a series of products that form an integral part of an advanced data warehouse system.
High-performance databases for an enterprise system
SymfoWARE
SymfoWARE and the GlobalServer systems series form the nucleus of the Fujitsu data warehouse. Together they support mission critical systems that require high performance and high reliability.
| Powerful performance |
|---|
| Continuous scalability SymfoWARE automatically takes advantage of the added processing power of additional CPU clusters-up to a total of four processors-by sharing the workload among them. This spreads large-volume work among several clusters to enhance overall system performance. |
| Random storage function to improve online response SymfoWARE supports the random storage function which improves online processing response times. The random storage function uses hash commands to store data randomly. This reduces I/O bottlenecks, especially to the database index. |
| High speed parallel processing for large-volume batch processing Large-volume batch processing can be parallel processed by separating data and storing it separately. This reduces overall batch processing time. |
| Exceptional reliability |
|---|
| Automatic logging recovery In the event of system failure, the automatic logging functions maintain the integrity of the data even if the failure should occur during a data update. |
| Swap recovery function The swap recovery function enables the recovery of a database without interrupting user applications. This feature enables nonstop operation of the enterprise system and the possibility of automatic operations. |
| Disk mirroring The risk of disk failure can be reduced by duplicating each disk volume where the data is stored. |
| High Operability |
|---|
| Divided operation Disk workloads and processing time can be reduced by splitting the database into smaller units and operating each database parallel and independently. Using divided operations, the maintenance (e.g. backup and recovery) time can also be improved. |
| The Object Manager The Object Manager function assists database operations like database creation, definition printing and data inquiry/update. The GUI interface can also be used to develop and maintain distributed databases. |
| PC tool support SymfoWARE supports the standard interfaces such as ODBC, OLE and OLE-2. These interfaces support commonly used software such as Microsoft EXCEL, Lotus 1-2-3 and Visual Basic when accessing SymfoWARE data. |
