A backing store enables persistent backup of the objects generated and modified at runtime. Use of a backing store enables recovery in the event of a system-wide failure.The backing store feature requires use of Cache object management. Before you add a backing store, develop your caching solution and test it.The JDBC backing store feature supports the DBMS products listed in the product readme file (also listed in TIBCO BusinessEvents Installation).Ease of MaintenanceThe backing store uses relational tables and SQL data types for ease of maintenance. The SQL (DDL) scripts use ANSI SQL type definitions (where supported by the target DBMS product). Because the backing store adheres to SQL standards and a straight-forward structure, standard database tools can be used to view backing store data. See Backing Store Table Reference for more on the table structures.Backing Store RequirementsEnsure that you have access to a supported database management product and driver, and can create a user with permission to connect to the database and create tables and views. Resources Required for Setting Up the Database outlines all the resources you need to set up a backing store.Database LocationInstructions in this chapter assume you are working with a local database for testing purposes. Adapt the instructions if you are working with a remote database. For example, in production environments, you might have to ask a database administrator to create a database user for you. You should then be able to run the other SQL scripts yourself, logged on as the user created by the administrator.Certain aspects of a project ontology may require special handling. See the following sections for details on how to handle these issues.:After You Finish Database SetupAfter you finish database setup, you must configure various project properties to enable and configure backing store functionality. See Adding a JDBC Connection Resource to the Studio Project and Configuring Backing Store Properties in the CDD Editor for details.
Copyright © TIBCO Software Inc. All Rights Reserved.