Dear Wiki user, You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification. The following page has been changed by DavidVanCouvering: http://wiki.apache.org/db-derby/Requirement_Specifications ------------------------------------------------------------------------------ === 6.2. Proposed Features === [[Anchor(Feature_Identified)]] - ||Cateogory/Code || Features || Priority (Sanket) || + ||Cateogory/Code || Features || Priority (Sanket) || Priority (David) || - || a) Monitoring || || || + || a) Monitoring || || || || - || MON1 || View derby system/database properties (derby.xxx) || 0 || + || MON1 || View derby system/database properties (derby.xxx) || 0 ||0|| - || MON2 || Sys info e.g. version, jvm version etc.|| 0 || + || MON2 || Sys info e.g. version, jvm version etc.|| 0 ||0|| - || MON3 || Locks held in the system || 1 || + || MON3 || Locks held in the system || 1 ||2|| - || MON4 || Number of commits/sec || 0 || + || MON4 || Number of commits/sec || 0 ||1|| - || MON5 || Number of roll backs/sec || 0 || + || MON5 || Number of roll backs/sec || 0 ||1|| - || MON6 || Time since last save point || 2 || + || MON6 || Time since last save point || 2 ||2|| - || MON7 || Number of system threads || 0 || + || MON7 || Number of system threads || 0 ||1|| - || MON8 || Number of users connected || 0 || + || MON8 || Number of users connected || 0 ||1|| - || MON9 || Number of open connections || 0 || + || MON9 || Number of open connections || 0 ||1|| - || MON10 || Transaction Granularity || 2 || + || MON10 || Transaction Granularity || 2 ||2|| - || MON11 || Open cursors || 1 || + || MON11 || Open cursors || 1 ||1|| - || MON12 || Databases || || + || MON12 || Databases || || || - || MON12.1 || Database properties (derby.xxx)|| 0 || + || MON12.1 || Database properties (derby.xxx)|| 0 ||0|| - || MON12.2 || Database Objects || 2 || + || MON12.2 || Database Objects || 2 ||2|| - || MON12.3 || Database Size || 1 || + || MON12.3 || Database Size || 1 ||2|| - || MON13 || Memory usage stats || 1 || + || MON13 || Memory usage stats || 1 ||1|| - || MON14 || CPU usage stats || 1 || + || MON14 || CPU usage stats || 1 ||1|| - || MON15 || Stats about Garbage collection || 1 || + || MON15 || Stats about Garbage collection || 1 ||2|| - || MON16 || View number of cached objects (Query)|| 2 || + || MON16 || View number of cached objects (Query)|| 2 ||2|| - || MON17 || Deadlocks detected/trace || 1 || + || MON17 || Deadlocks detected/trace || 1 ||2|| - || MON18 || Stats about disk I/O || 0 || + || MON18 || Stats about disk I/O || 0 ||1|| - || MON19 || Query plan || 2 || + || MON19 || Query plan || 2 ||2|| - || b) Management || || || + || b) Management || || || || - || MGMT1 || Modify derby/database properties (derby.xxx) || 0 || + || MGMT1 || Modify derby/database properties (derby.xxx) || 0 ||1|| - || MGMT2 || Boot a database || 1 || + || MGMT2 || Boot a database || 1 ||2|| - || MGMT3 || Shutdown a database || 0 || + || MGMT3 || Shutdown a database || 0 ||0|| - || MGMT4 || Drop a database || 2 || + || MGMT4 || Drop a database || 2 ||2|| - || MGMT5 || Create a database || 2 || + || MGMT5 || Create a database || 2 ||3|| - || MGMT6 || Create database objects || 2 || + || MGMT6 || Create database objects || 2 ||3|| - || MGMT7 || Backup a database || 1 || + || MGMT7 || Backup a database || 1 ||1|| - || MGMT8 || Restore a database from backup || 1 || + || MGMT8 || Restore a database from backup || 1 ||1|| - || MGMT9 || Recovery || 1 || + || MGMT9 || Recovery || 1 ||? Not sure if this is needed - we do auto-recovery|| - || MGMT10 || Force a checkpoint || 2 || + || MGMT10 || Force a checkpoint || 2 ||3|| - || MGMT11 || Rebuild indexes || 2 || + || MGMT11 || Rebuild indexes || 2 ||2|| - || MGMT12 || Security || || + || MGMT12 || Security || || || - || MGMT12.1|| Modify Authorization || 1 || + || MGMT12.1|| Modify Authorization || 1 ||2|| - || MGMT12.2|| Modify Authentication scheme || 1 || + || MGMT12.2|| Modify Authentication scheme || 1 ||2|| - || MGMT13 || Replacement of management servlet|| 2 || + || MGMT13 || Replacement of management servlet|| 2 ||3|| - || c) Notifications || || || + || c) Notifications || || || || - || NOT1 || When a transaction fails || 0 || + || NOT1 || When a transaction fails || 0 ||1|| - || NOT2 || When a database is booted || 1 || + || NOT2 || When a database is booted || 1 ||2|| - || NOT3 || When a database is shutdown || 1 || + || NOT3 || When a database is shutdown || 1 ||2|| - || NOT4 || When a user connects || 2 || + || NOT4 || When a user connects || 2 ||4|| - || NOT5 || When a user disconnects || 2 || + || NOT5 || When a user disconnects || 2 ||4|| - || NOT6 || Every time a query is fired || 2 || + || NOT6 || Every time a query is fired || 2 ||4|| - || NOT7 || Every time a stored procedure/function is run || 2 || + || NOT7 || Every time a stored procedure/function is run || 2 ||3|| - || NOT8 || All database operations like creating/deleting/modifying etc. || 2 || + || NOT8 || All database operations like creating/deleting/modifying etc. || 2 ||4|| This is not an exhaustive list and is open to further discussions by the community. In particular, I would like to see some more suggestions on notifications.