开发者

What is the name given to tables that hold static information

I am working on a large project that contains many reference / look up type tables. This is maybe not the correct place to ask this question but I would like to find out the name that people give in English to these kind of tables:

The tables contain data such as status_code, status_type. They are preloaded and the data in them will probably never cha开发者_JS百科nge.

Please excuse my not knowing this but ENglish is not my first language and I need to do a presentatation to talk about these kind of tables.


People give different names - LookUpData, ReferenceData, StaticData, etc depending upon the properties of data. Is this answer your questions? If not, probably you need to be more elaborative.


The most often used english name I've encountered is 'static data'. This indicates that the data does not change very often.

Aside: one interesting aspect of static data is that it is a good candidate for caching.


Where the tables contain data that's interesting to the application, but do reflect not the outside world - status codes, for instance - I tend to call them enumeration tables.

Where the table contains values that change rarely, but do reflect the outside world - cities, currencies, etc. - I tend to call them lookup tables.

Where tables contain "friendly" values - e.g translating ISO country/locale codes - I tend to call them reference tables.


We tend to use the term "Reference Data". But there isn't a standard term, it varies a lot in my experience. I haven't heard "Static Data" before, but I like it.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜