Abstract:
A method is provided for the extraction of a data table from a database. The data table includes instances in rows and columns, respectively, and includes indicators characterizing the instances in columns and rows, respectively. The method includes the following steps: a) obtaining an initial specification of the study; b) from the initial specification, building a data table extraction dictionary, which enables specifying instants concerned by the study in the database and enables specifying an extraction formula, a recoding and a role for each of the indicators concerned by the study; and c) carrying out an initial extraction of a data table, in applying the extraction dictionary to the database.
Abstract:
A method for the building and use of a table of reduced profiles of paragons enables the summarizing of a table of profiles of a set of individuals, all the profiles being defined by a same set of indicators, the profile of a given individual comprising values for said set of indicators that are proper to said given individual. The method comprises the following steps: the selecting, from the set of indicators, of a subset of indicators defining reduced profiles of individuals, the reduced profile of a given individual comprising values for said subset of indicators that are proper to said given individual and obtained from data of a data warehouse; the sampling of the set of individuals, enabling a sample of individuals called paragons to be obtained; the obtaining of a table of reduced profiles of paragons comprising, for each of the paragons, a reduced profile specific to said paragons; and the indexing of all the individuals to the paragons, making it possible to obtain an index linking each individual to at least one paragon whose reduced profile is closest to the reduced profile of said individual, so that the content of the table of reduced profiles of paragons can be used for all the individuals.