text: fig1 shows an information processing system that uses a cost evaluator ( 3 ) that receives information from a set ( 1 ) intended for extracting statistical profiles from data bases ( 21 , 22 ). one relational - type data base ( 21 ) may be of the &# 34 ; oracle &# 34 ; type , for example , while another data base ( 22 ) may be of the &# 34 ; ingres &# 34 ; type . each data base communicates with the profile extraction module ( 10 ) through interfaces ( 12 and 13 ), which are data acquisition manager adapted to the data base . in this way , the profile extraction module ( 10 ) has interfaces ( 12 and 13 ) capable of working with the current data bases , and it is universal and flexible to use . the cost and performance evaluation device ( 3 ) is of the type described in international patent application pct / 92 / 090587 , or in french patent application 91 . 03915 that was published on oct . 2 , 1992 under no . 2 674 651 . this type of device makes use of a set of libraries , one of which is made up of a library of statistical profiles . the subject of the invention relates principally to the device that makes it possible to develop the statistical profile library , and to the method used by this device . the device ( 10 ) is made up of a program executed by an information processing system to enable the development of statistical profiles , while the device ( 11 ) is made up of a program executed by an information processing system to enable the showing of information concerning the profile of the relation and the profile of the attributes of the relation on the screen of the system . the program ( 10 ), after having developed the statistical profiles , creates respective tables ( 210 , 220 ), in which it arranges the statistics . the tables are created in the data base ( 21 and 22 , respectively ) with which it is working . these tables ( 210 and 220 ) are made up of a relation profile table ( rel - prof ), which contains the statistics on the relations ; an attribute profile table ( att - prof ), which contains the statistics on the attributes ; an index profile table ( ind - prof ), which contains the statistics on the indexes ; three tables , uniform - integral ( unif - int ), uniform - decimal ( unif - flo ), uniform - string ( unif - str ), these three tables containing the statistics on the attributes whose values follow uniform distributions . there are two tables , moment - integral ( mom - int ) and moment - decimals ( mom - flo ), which contain the statistics in the attributes whose values follow a nonuniform distribution ; three tables histo - integral ( hist - int ), histo - decimal ( hist - flo ), histo - string ( eist - str ), which contain the statistics in constant height histogram form on the attributes whose values follow nonuniform distributions ; a length - histo table ( leng - hist ), which contains the statistics of the attributes in the form of a constant - width histogram ( for display to the users ); and finally , seven tables , multidimensional histogram ( mult - hist ), integral table ( int - tab ), table of decimals ( flo - tab ), string table ( str - tab ), date table ( dat - tab ), histogram of relations ( rel - mhist ), histogram of the attributes ( att - mhist ), which contain statistics on the multiple attributes . the software ( 10 ) also develops statistics that enable either calculating the logical selectivity or the physical selectivity of the data . in the case of logical selectivity , these statistics make use of the value distribution statistics ( vds ), which are developed in the flow chart ( 20 ) of fig2 and in the case of physical selectivity they make use of the data placement statistics ( dps ). these data placement statistics make it possible to develop the physical selectivity and correspond to the flow chart ( 30 ) in fig3 . for the data placement statistics , the profile extraction program extracts constant height histograms from the data , as can be seen in fig3 . in the case of statistics that make it possible to evaluate the logical selectivity , the statistical profile extraction program follows the flow chart of fig2 . in that case , the program first , in step ( 23 ), performs a verification of correlation to see whether or not there is any correlation among attributes . this verification of correlation is done by a correlation measurement based on the entropy ( marked h ) in the distributions . for example , let there be two attributes x and y , whose value domains are dx and dy , respectively . the question to be answered is : is there any correlation between the values dx and the values dy ? dx and dy with respect to the data of the application may be classified as shown in fig2 b , where k is the number of tuples such that the attribute x assumes the value xj and the attribute y assumes the value yj . ## equ1 ## ni is the number of tuples for the i th value of the domain dx ; n is the total number of tuples . the coefficient u of dependency between x and y becomes : ## equ3 ## the system evaluates h ( x ), h ( y ), h ( y / x ) and then u ( y / x ) to determine the correlation , in the following manner : if correlation exists , then a data structure with a plurality of attributes is involved , and in that case , as shown in fig2 the program in step ( 231 ) represents these correlations in the form of multidimensional constant height histogram structures . in the case where there is no correlation , the programs moves to the next step ( 24 ), which is a step of verifying the distribution to verify whether the distribution is uniform or nonuniform . in the following text , the designation x &# 39 ; is used to represent the cursive &# 34 ; x &# 34 ; of the formula . let ni be the number of tuples observed for a given value of an attribute and ni the number of tuples expected in the distribution studied ( binomial distribution , exponential distribution , normal distribution ). ## equ4 ## if x &# 39 ; 2 is large , this means that the attribute values do not follow the distribution sought . if x &# 39 ; 2 = 0 , this means that the attribute values precisely follow the distribution contemplated . in the case of uniform distribution ( 241 ), the program moves to a step ( 27 ) of representing the relation profile , the attribute profile , and the minimums and maximums . in the case where the distribution is nonuniform ( 242 ), the program moves to a step ( 25 ) of verification of the data type and in step ( 251 ) verifies whether the data are alphabetic , to develop a relation profile or an attribute profile containing the minimal and maximum values , as shown in step ( 27 ), and then develop a constant height histogram as shown in step ( 28 ). in the case where the program determines that the type of data is numerical in step ( 252 ), it develops a relation or attribute profile by way of these minimal and maximum values , as shown in step ( 27 ), and then makes a search for the type of value , as shown for step ( 26 ). in that case , the program develops the profile either in the form of a constant height histogram represented by step ( 28 ) or in the form of a moment of order ( i ) shown in step ( 29 ). a moment of order ( i ) is equal to the sum of values of a specific attribute ( y ), raised to the power ( i ): mi = σy i . thus by applying this statistical extract method as described above to the data of the data base , the device ( 10 ) extracts the tables making up the profile library of the data base . this profile library makes it possible to determine a confidence rate of the statistics extracted from the data base . the rate of error propagated by the statistical profile must be less than the desired confidence rates for the evaluations . thus the evaluation program ( 3 ) will use the statistics stored in the library ( 210 , 220 ), if the error rate of these statistics is less that the desired confidence rate and if the statistics do not require updating . if not , then the profile extraction program will be executed to update the statistics , either because the error rate is below the desired confidence rate or because the data base has been updated and consequently the statistics are not reliable . in fact , the confidence rate is 100 % for a profile that has just been created or updated . any modifications in the real data base reduce this confidence rate . this is due to the consequences of the modifications ( insertion , updating , cancellation ) in the statistics of each attribute , and in particular in the distribution . the value of the extractions done by this profile extractor module ( 10 ) is of having a sufficiently representative profile that can be used in the performance evaluator without entailing any overly major calculation time . this makes it possible , from statistical profiles , either to evaluate the cost of a request as a function of a given architecture or to search for the optimal architecture so that the cost of the given type of request will be minimal , and so forth . in its use of the profile , the evaluation program executes the following steps : access to the statistical profile concerning the attribute of a given relation ; if the statistical profile exists , comparison of the confidence rate with the confidence rate required ; if the statistical profiles do not exist , or if the confidence rate is lower than the required confidence rate , startup of the program of extracting profiles on the attribute of the given relation ; startup of the performance evaluation program once the statistical profile generation is completed . the statistical profile evaluation program ( 10 ) is associated with a representation module ( 11 ) which makes it possible to show the main information on the relation profile and the attribute profile on the screen of the machine on which the evaluations and profiles have been extracted . fig4 shows the profile of a relation developed by the software . this profile is displayed by the module ( 11 ) in the form of a window ( 40 ) including a display box ( 400 ) making it possible to display the name of the relation ; a display box ( 401 ) for displaying the size of the relation ; a display box ( 402 ) enabling display of the attribute number ; a display box ( 403 ) for displaying the home node number of origin ; a display box ( 404 ) enabling display of the name of the owner ; a box ( 405 ) for displaying the size and number of pages ; a box ( 406 ) enabling display of the size of the tuples ; a box ( 407 ) for displaying the declustered tuple number ; a box ( 408 ) enabling display of the date of the last update of the statistic developed by the program ( 10 ); and a box ( 409 ) enabling display of the confidence rate of this statistic . one display line ( 410 ) makes it possible to enter the rank of the attribute that is key for a relation ; a display box ( 411 ) enables displaying the attribute number , and three command buttons ( 412 , 413 , 414 ) make it possible to perform the add , remove or erase , and edit functions , respectively , on the display in the box ( 415 ). a display line ( 416 ) of the global index enables direct access to a datum ; a display box ( 421 ) of an attribute number ; a display box ( 417 ) of the name of an index , and three functions , add , remove , edit , which are relatively accessible by three command buttons ( 418 , 419 , 420 ). these functions make it possible to act upon the display in a box ( 422 ) and also make up the display of the relation profile window ( 40 ). a command button ( 423 ) enables associating a storage structure with the global index defined above ; two structures are possible , either an address calculation structure ( or hash ) or a b - tree structure . the display boxes ( 423 , 431 ) are scrolling menu boxes that enable a selection to be made between an address calculation algorithm storage structure and a tree structure . a line ( 424 ) enables entering a local index ; a box ( 425 ) enables defining the attribute number ; another box ( 426 ) enables defining an index name ; three functions , add ( 427 ), remote ( 428 ) and edit ( 429 ) enable modifying the display of a box ( 430 ); and a command button ( 431 ) makes it possible to associate a storage structure with this index , two structures being available , either an address calculation algorithm or a tree structure . finally , a box ( 432 ) enables defining the type of target environment for the evaluation , that is , whether the memory is distributed or shared , and a line ( 433 ) enables making an attribute sweep and displaying its respective profile . fig6 makes it possible to define or display the attribute profiles by displaying the following boxes in a window ( 60 ): a box ( 601 ) enabling defining the attribute name , a box ( 602 ) enabling defining its originality , a box ( 603 ) enabling defining the number of values taken by the domain , and a display button ( 604 ) enabling indicating the type of attribute , that is , whether it is an integer . a display line ( 605 ) enables defining the logical statistics , and a display box ( 606 ) enables indicating the population for which the profile is made . this box ( 606 ) displays whether the profile is made for all the tuples or for a sampling , the latter so as to reduce the cost of access to the data . a box ( 607 ) enables selecting the type of statistical method , for example a uniform method ; a box ( 608 ) enables defining the mode of attribute distribution , for example a uniform mode ; a box ( 610 ) displays the minimal value of the attribute ; and a box ( 609 ) displays the maximum value . a line ( 614 ) enables indicating the statistics on data placement , and a box ( 611 ) enables indicating whether these statistics were made for all the tuples or simply for a sampling . a box ( 612 ) indicates the statistical method used , for example uniform , and a box ( 613 ) indicates the uniform distribution model for example . the scrolling menu boxes ( 607 , 612 ) enable selecting a method of processing statistics , the selection being between the uniform method , the histogram method , the method based on multidimensional histograms , and the method based on the moments . the scrolling menu boxes ( 608 , 613 ) enable selecting or displaying a data distribution mode , from among the uniform or nonuniform or poisson distribution , or normal distribution modes . further modifications within the competence of one skilled in the art are also within the spirit and scope of the invention . while the preferred forms and embodiments of the invention have been illustrated and described , it will be apparent to those of ordinary skill in the art that various changes and modifications may be made without deviating from the inventive concepts and spirit of the invention as set forth above , and it is intended by the appended claims to define all such concepts which come within the full scope and true spirit of the invention .