From Surf Wiki (app.surf) — the open knowledge base
Sequence number
Mathematical concept
Mathematical concept
A sequence number is a consecutive number in a sequence of numbers, usually of real integers (natural numbers). Sequence numbers have many practical applications. They can be used, among other things, as part of serial numbers on manufactured parts, in case management, or in databases as a surrogate key for registering and identifying unique entries in a table (in which case it is used as a primary key).
Examples
Historically, the Norwegian Mapping Authority have used sequence numbers for land registration as a placeholder in cases where an organization number or national identity number have not been known.
In elections in Norway, sequence numbers are used in the duplicate check to prevent votes being counted twice or to detect duplicate ballots.
An example of a sequence number being used as a surrogate key is the snr number used by Statistics Norway since 1970, which uniquely identifies a person even if their social security number changes. The snr number will then be linked to both social security numbers, and act as a link that ensures that each person can be identified by a unique key at all times.
Comparison with serial number
A distinction is sometimes made between a sequence number and a serial number. For example, a Swiss locomotive may have the designation "Re 465 003-2", where:
- 465 is the serial number, and stands for 4 drive shafts, 6th version, and 5 for the company BLS
- 003 is the sequence number, and means that it is the third locomotive in this series
- -2 is a check digit
References
References
- "Ordbøkene.no - Bokmålsordboka og Nynorskordboka".
- "Sequences".
- MashaMSFT. (2023-04-18). "Sequence Numbers - SQL Server".
- Roeser, Mary Beth. "CREATE SEQUENCE".
- "SQL Server: Sequences (Autonumber)".
- (2023-09-27). "Navneendring, fisjon og fusjon".
- "Endelig opptelling - Valgmedarbeiderportalen".
- Vangen, Torill. "Snr".
- "Sveitsiske lok- og motorvognbetegnelser, er de kryptiske ? Del 2 – M&E".
This article was imported from Wikipedia and is available under the Creative Commons Attribution-ShareAlike 4.0 License. Content has been adapted to SurfDoc format. Original contributors can be found on the article history page.
Ask Mako anything about Sequence number — get instant answers, deeper analysis, and related topics.
Research with MakoFree with your Surf account
Create a free account to save articles, ask Mako questions, and organize your research.
Sign up freeThis content may have been generated or modified by AI. CloudSurf Software LLC is not responsible for the accuracy, completeness, or reliability of AI-generated content. Always verify important information from primary sources.
Report