Abstract: Methods and systems for determining one most specific row within a database table. An index includes an index structure for each column of the database table. Each index structure includes an array of pointer tuples for each value occurring in the column and a bitmap indicating cells without values. A first pointer of the tuple indicates a value and a second pointer indicates the row of the database table with the value. The index also indicates an order of specificity of the rows of the database table. A computer system processes a request by using the bitmaps of the index structures to maintain all rows of the database table without values and the pointer tuples to filter all rows of the database table that do not include the respective input value. The one row being highest in the order of specificity from the remaining rows is selected and returned.

Abstract: Methods and systems for determining one most specific row within a database table. An index includes an index structure for each column of the database table. Each index structure includes an array of pointer tuples for each value occurring in the column and a bitmap indicating cells without values. A first pointer of the tuple indicates a value and a second pointer indicates the row of the database table with the value. The index also indicates an order of specificity of the rows of the database table. A computer system processes a request by using the bitmaps of the index structures to maintain all rows of the database table without values and the pointer tuples to filter all rows of the database table that do not include the respective input value. The one row being highest in the order of specificity from the remaining rows is selected and returned.

Abstract: Methods and systems for detecting an anomaly in a passenger flow towards a transport device. Historical data relating to the passenger flow is aggregated and a forecast passenger flow value for a target time frame is determined based upon the historical data. A first forecast is computed based upon the passenger flow in a first set of the time frames directly preceding the target time frame. A second forecast is computed based upon the passenger flow in a second set of the time frames, the second set of time frames having occurred on a same weekday and at a same time as the target time frame, in weeks preceding the target time frame. The first and second forecasts are combined to produce the forecast passenger flow value for the target time frame.