production database


Also found in: Medical.

production database

A database that is used in the daily processing of transactions. See production system, data warehouse and copy data.
References in periodicals archive ?
You need to attack problems like this at the source, even if that means, redesigning the production database schema.
- No data loss: maintain extra replicas of data in a case the master database fails, with automatic master failover by promoting one of the slaves as a new master - Performance: use multiple database replicas to scale database performance - Backup and Disaster Recovery: copy data on multiple databases, local or remote, for backup and disaster recovery - Real-time Data Integration: replicate from MySQL to Oracle and vice versa - Real-time Data Warehousing: copy data in real-time from a production database into a data warehouse for analysis and reporting.
Pervasive DataExchange delivers near real-time database replication and synchronization from a production database to one or more backup databases.
For example, a production database would retain its active data on high-end arrays, while a tiered storage manager would archive inactive data onto less expensive ATA disk.
Changes to a production database structure should be additions, reflecting the creation of new entities, new lines of business and so on.
If you have a production database table that has important data.
Figure 2: Number of Copies of Production Data One copy outside our production database 19% Two copies 23% Three copies 24% Four copies 7% Five or more copies 15% Don t know/unsure 12% Note: Table made from bar graph.
Both CA Datacom r12 and CA IDMS r17 allow customers to shift all types of production database workloads--including those generated by online transaction systems, batch processing jobs and distributed platform requests--to zIIP specialty processors.
Performance Center, serves as a 24/7 "watchdog" to monitor production database systems and pinpoint problems impacting performance and scalability.
Since it is ideal to use "realistic" test data, each test database is usually a clone of the production database, and special test cases may be added before testing begins.
With the system, customers can also use output files without direct access to the production database, enabling the customers to easily incorporate external data into their data mart application.
Please refer to the table below for specifications on the OS version, SQL Server version and database count for the production database servers.

Full browser ?