SYSTEM AND METHOD FOR CODE AND DATA VERSIONING IN COMPUTERIZED DATA MODELING AND ANALYSIS

In a first embodiment, an interactive reporting tool allows the user to define, modify, and selectively execute a sequence of queries in an interactive manner. A sequence of queries is entered into rows of an interactive query code table. When the user selects a given row i or a cell in a given row i, then the data table is updated to show the results of the queries 1 through i, such that the user effectively can step through the queries in any order (i.e., sequential or non-sequential, forward or backward) to see the results of each step. In a second embodiment, a sequence of queries is divided into stages, where each stage involves one pass over the data, such that the sequence of queries can be executed using the minimum number of passes over the data. The sequence of queries may be processed into a functional dependency graph that represents the relationships between query parameters (signals) and query operations, and the functional dependency graph then may be processed to divide the queries into a number of successive stages such that each stage includes queries that can be executed based on data that exists prior to execution of that stage. A sequence of queries may, and often does, require that one or more intermediate values or datasets be generated using an aggregate function. In a third embodiment, code and data versioning allows developers to work on code and data without affecting production code and data and without affecting the development activities of other developers. Code and data being worked on by a developer are associated with a task. The system automatically determines the dataset to use for a given development task from among a production dataset, a latest dataset, or a temporary dataset associated with the development task so that development code does not have to be modified to read from a specific dataset. Dans un premier mode de réalisation, un outil d'établissement de rapport interactif permet à l'utilisateur de définir, modifier et exécuter sélectivement et interactivement une séquence d'interrogations. Une séquence d'interrogations est entrée dans des lignes d'une table de codes d'interrogations interactive. Lorsque l'utilisateur sélectionne une ligne donnée i ou une cellule dans une ligne donnée i, la table de données est mise à jour de façon à montrer les résultats des interrogations 1 à i d'une manière telle que l'utilisateur peut efficacement parcourir point par point les interrogations dans n'importe quel ordre (autre