Managing a database management system using a set of stream computing data

Abstract

Disclosed aspects relate to managing a database management system (DBMS) using a set of stream computing data derived from a stream computing environment. The set of stream computing data which indicates a set of stream computing environment statistics may be collected with respect to the stream computing environment. A proactive database management operation may be determined for performance with respect to the DBMS based on the set of stream computing data which indicates the set of stream computing environment statistics. The proactive database management operation may be performed to manage the DBMS using the set of stream computing data.

What is claimed is: 
     
         1 . A computer-implemented method for managing a database management system (DBMS) using a set of stream computing data derived from a stream computing environment, the method comprising:
 collecting, with respect to the stream computing environment, the set of stream computing data which indicates a set of stream computing environment statistics;   determining, based on the set of stream computing data which indicates the set of stream computing environment statistics, a proactive database management operation for performance with respect to the DBMS; and   performing, with respect to the DBMS, the proactive database management operation to manage the DBMS using the set of stream computing data.   
     
     
         2 . The method of  claim 1 , further comprising:
 analyzing the set of stream computing data which indicates the set of stream computing environment statistics; and   resolving, based on the set of stream computing data, an anticipated database management operation with respect to the DBMS; and   determining, based on the anticipated database management operation with respect to the DBMS, the proactive database management operation for performance with respect to the DBMS in correlation with the anticipated database management operation.   
     
     
         3 . The method of  claim 1 , further comprising:
 determining, based on the set of stream computing data which indicates the set of stream computing environment statistics, to build a projected database object with respect to the DBMS; and   building, with respect to the DBMS, the projected database object to manage the DBMS using the set of stream computing data.   
     
     
         4 . The method of  claim 1 , further comprising:
 determining, based on the set of stream computing data which indicates the set of stream computing environment statistics, to update a projected database object respect to the DBMS; and   updating, with respect to the DBMS, the projected database object to manage the DBMS using the set of stream computing data.   
     
     
         5 . The method of  claim 1 , further comprising:
 determining, based on the set of stream computing data which indicates the set of stream computing environment statistics, to remove a projected database object with respect to the DBMS; and   removing, with respect to the DBMS, the projected database object to manage the DBMS using the set of stream computing data.   
     
     
         6 . The method of  claim 1 , further comprising:
 determining, based on the set of stream computing data which indicates the set of stream computing environment statistics, to build a database object with respect to the DBMS; and   building, with respect to the DBMS, the database object to manage the DBMS using the set of stream computing data.   
     
     
         7 . The method of  claim 1 , further comprising:
 determining, based on the set of stream computing data which indicates the set of stream computing environment statistics, to update a database object with respect to the DBMS; and   updating, with respect to the DBMS, the database object to manage the DBMS using the set of stream computing data.   
     
     
         8 . The method of  claim 1 , further comprising:
 determining, based on the set of stream computing data which indicates the set of stream computing environment statistics, to remove a database object with respect to the DBMS; and   removing, with respect to the DBMS, the database object to manage the DBMS using the set of stream computing data.   
     
     
         9 . The method of  claim 1 , further comprising:
 determining, based on the set of stream computing data which indicates the set of stream computing environment statistics, to bypass an expected database management operation with respect to the DBMS for at least a temporal period; and   bypassing, with respect to the DBMS, the expected database management operation for at least the temporal period to manage the DBMS using the set of stream computing data.   
     
     
         10 . The method of  claim 1 , further comprising:
 determining, based on the set of stream computing data which indicates the set of stream computing environment statistics, to expedite an expected database management operation with respect to the DBMS;   expediting, with respect to the DBMS, performance of the expected database management operation to manage the DBMS using the set of stream computing data; and   performing, in an expedited fashion, the expected database management operation with respect to the DBMS.   
     
     
         11 . The method of  claim 1 , further comprising:
 determining, based on the set of stream computing data which indicates the set of stream computing environment statistics, to partition a set of database data into a plurality of database partitions with respect to the DBMS; and   partitioning, with respect to the DBMS, the set of database data into the plurality of database partitions to manage the DBMS using the set of stream computing data.   
     
     
         12 . The method of  claim 1 , further comprising:
 detecting, with respect to the set of stream computing data which indicates the set of stream computing environment statistics, a set of throughput-oriented data; and   determining, based on the set of throughput-oriented data, the proactive database management operation for performance with respect to the DBMS.   
     
     
         13 . The method of  claim 1 , further comprising:
 detecting, with respect to the set of stream computing data which indicates the set of stream computing environment statistics, a set of anticipated database maintenance values; and   determining, based on the set of anticipated database maintenance values, the proactive database management operation for performance with respect to the DBMS.   
     
     
         14 . The method of  claim 13 , further comprising:
 detecting the set of anticipated database maintenance values is a set of anticipated values selected from the group consisting of:
 a number of records to be inserted, 
 a number of records to be deleted, 
 a number of records to be updated, 
 a number of records based on a key value, and 
 a number of records based on a partition value. 
   
     
     
         15 . The method of  claim 1 , further comprising:
 detecting, with respect to the set of stream computing data which indicates the set of stream computing environment statistics, a data compression merit indication; and   determining, based on the data compression merit indication, the proactive database management operation for performance with respect to the DBMS.   
     
     
         16 . The method of  claim 1 , further comprising:
 executing, in a dynamic fashion to streamline management of the DBMS using the set of stream computing data, each of:
 the collecting, the determining, and the performing. 
   
     
     
         17 . The method of  claim 1 , further comprising:
 executing, in an automated fashion without user intervention, each of:
 the collecting, the determining, and the performing. 
   
     
     
         18 . The method of  claim 1 , further comprising:
 receiving the stream of tuples to be processed by a set of processing elements which operates on a set of compute nodes;   processing, using the set of processing elements operating on the set of compute nodes, the stream of tuples; and   monitoring the stream of tuples to collect the set of stream computing data which indicates the set of stream computing environment statistics.   
     
     
         19 . A system for managing a database management system (DBMS) using a set of stream computing data derived from a stream computing environment, the system comprising:
 a memory having a set of computer readable computer instructions, and a processor for executing the set of computer readable instructions, the set of computer readable instructions including:   collecting, with respect to the stream computing environment, the set of stream computing data which indicates a set of stream computing environment statistics;   determining, based on the set of stream computing data which indicates the set of stream computing environment statistics, a proactive database management operation for performance with respect to the DBMS; and   performing, with respect to the DBMS, the proactive database management operation to manage the DBMS using the set of stream computing data.   
     
     
         20 . A computer program product for managing a database management system (DBMS) using a set of stream computing data derived from a stream computing environment, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, the program instructions executable by a processor to cause the processor to perform a method comprising:
 collecting, with respect to the stream computing environment, the set of stream computing data which indicates a set of stream computing environment statistics;   determining, based on the set of stream computing data which indicates the set of stream computing environment statistics, a proactive database management operation for performance with respect to the DBMS; and   performing, with respect to the DBMS, the proactive database management operation to manage the DBMS using the set of stream computing data.