Question : I have a Person with columns like name, address and bio. How do I store data in order […]
Tag: data-versioning
Restore a SQL 7 database into SQL 2014 without in-between versions?
Question : Our software is over 20 years old, and dates way back to databases such as Sybase and SQL […]
Set of datetime versioned rows, how to build the most up to date row
Question : I created this SQL fiddle with the sample data The sample data is this: — — Table structure […]
Running several versions of a MySQL database in parallel?
Question : We have a central read-only MySQL database that contains geo data, etc. It is used by various projects. […]
How to track changes to a record that spans multipe tables
Question : I have the challenge to design a new database using a RDBMS, Oracle, to be precise. In this […]
Equivalents to `ora_rowscn` in other databases?
Question : Do other databases other than Oracle have ora_rowscn (http://docs.oracle.com/cd/B19306_01/server.102/b14200/pseudocolumns007.htm) equivalents, or do you have to implement them yourself […]
Database upgrade script for removing columns
Question : So I have a SQL database project which tracks our application’s database schemas, stored procedures, etc. It also […]
How would I maintain referential integrity across a database where I use versioned records while keeping data in sync?
Question : I am building a database that consists of a few tables that are used as data sources for […]
Identify the version of a collation from ICU in Postgres
Question : Postgres 10 and later incorporates the International Components for Unicode (ICU) library for text-handling and other internationalization issues. […]
History table implementation: “Tuple-versioning” vs Effective Date
Question : I’m designing a database that will have history tables (SCD Type 4 I guess) for auditing purpose. The […]
- 1
- 2