Database session management system and method thereof

The invention relates to a database session management system and method. The system comprises a nano-management database, a data collection unit, and a hierarchical management module, which are connected in sequence. The hierarchical management module is also connected with the nano-management database and an external application terminal. The data collection unit is used for collecting historical session congestion information, SQL execution information and transaction information of the nano-management database; The hierarchical management module is used for monitoring a session in real time, managing a session blocking baseline, analyzing an application end state, monitoring a transaction state, predicting SQL execution duration, managing a module white list, managing configuration parameters and terminating an abnormal session; the external application terminal is used for providing application operation information to the hierarchical management module. Compared with the prior art, on the basis of the c