I am looking for a Term/Word for specific type of tables.I have tried to search a lot, but I could not come up with best search terms for this.Tables that hold some master information, such as products, users, customers, brands etc. for the system are called - Master tables.Tables that hold some transaction information, such as orders, deliveries, invoices etc. are called - Transaction tables.Tables that hold cross join (many to many relationship) information - are called Third tables OR Link Tables.Now, the tables I am looking the term for; stores the information for a specific time period. So, for example past 12 months data only. When a month is lapsed the last month data is wiped out and the current month data would start stacking up. Once the current month is lapsed again the 12th month data would be wiped out, making space for latest month data.The best I have come up with is Rolling Entry Tables, but I want to know if there already exists a common terminology for this.
Term OR word for specific type of a SQL table
terminology;sql
I'm not sure there is a formal name for those sorts of tables. Data is normally cleared down to aid performance although (in the UK at least) you sometimes need to keep N years' worth for auditing purposes.If you have a data store in one database and have a highly performant database with a subset of the that data store for application or reporting purposes, this is a mart/repository type scenario.There is the concept of a sliding window but this really relates to large partitioned tables where you might only have the capacity to store a given amount of data and you either delete or hive off the rest.