Abstract: Methods and apparatuses are described for capturing and maintaining a timeline of data changes in a relational database system. A server identifies changed records from relational database tables. The server analyzes the changed records to determine a maximum timestamp for each primary key and extracts the changed records associated with each primary key where a timestamp is equal to or greater than the maximum timestamp for the primary key. The server generates timestamp ranges for each primary key, each comprising an effective date and an expiration date. The server determines whether each key-date combination already exists in a historical record table. The server updates an expiration date of an existing record in the historical record table using the effective date and inserts a new record for the timestamp range using the captured records.