Abstract: A process for systems analysis of a database non-agreement system using a set of gauges. Measurement of the state of a system. A gauge function, a threshold value and a recommendation are associated with at least one part of the gauges. Each gauge function returns a value which characterizes the state of the system analyzed and a recommendation based on the logical relationship between the value returned and the threshold value is emitted for the user of the system. The gauges for the analysis of a system are grouped into investigations. The process can be adapted to the analysis of any system by editing an ASCII data file which contains the list of gauges, of the designations of the associated functions, and of the associated thresholds and the associated recommendations. A graphic interface makes it possible to select the investigations to be applied to the system.

Abstract: The method for help in optimizing a query (10) in a window (24) of a screen of a work station consists of forming a tree (26) representative of the execution plan of the query, representing the tree on the screen (25), making a syntactical analysis of the query in order to form a syntactical graph, comparing the elements of the tree with those of the graph, and completing the tree with elements contained only in the graph. The advantageous result is a method of syntactical analysis consisting of analyzing the function of the RDBMS in order to determine in particular the types of nodes of the syntactical graph and preferably the information associated with these type of nodes.