Sequence number

Last updated

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, [1] or in databases as a surrogate key for registering and identifying unique entries in a table [2] [3] (in which case it is used as a primary key). [4] [5]

Contents

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. [6]

In elections in Norway, sequence numbers are used in the duplicate check to prevent votes being counted twice or to detect duplicate ballots. [7]

An example of a sequence number being used as a surrogate key is the snr number used by Statistics Norway since 1970, [8] 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. [8]

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", [9] where:

See also

Related Research Articles

A relational database is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A database management system used to maintain relational databases is a relational database management system (RDBMS). Many relational database systems are equipped with the option of using SQL for querying and updating the database.

<span class="mw-page-title-main">Serial number</span> Unique code assigned for identification of a single unit

A serial number is a unique identifier used to uniquely identify an item, and is usually assigned incrementally or sequentially.

<span class="mw-page-title-main">Universally unique identifier</span> Label used for information in computer systems

A Universally Unique Identifier (UUID) is a 128-bit label used for information in computer systems. The term Globally Unique Identifier (GUID) is also used, mostly in Microsoft systems.

<span class="mw-page-title-main">Extract, transform, load</span> Procedure in computing

In computing, extract, transform, load (ETL) is a three-phase process where data is extracted from an input source, transformed, and loaded into an output data container. The data can be collated from one or more sources and it can also be output to one or more destinations. ETL processing is typically executed using software applications but it can also be done manually by system operators. ETL software typically automates the entire process and can be run manually or on reccurring schedules either as single jobs or aggregated into a batch of jobs.

In the relational model of databases, a primary key is a specific choice of a minimal set of attributes (columns) that uniquely specify a tuple (row) in a relation (table). Informally, a primary key is "which attributes identify a record," and in simple cases constitute a single attribute: a unique ID. More formally, a primary key is a choice of candidate key ; any other candidate key is an alternate key.

<span class="mw-page-title-main">Product key</span> Specific software-based key for a computer program

A product key, also known as a software key, serial key or activation key, is a specific software-based key for a computer program. It certifies that the copy of the program is original.

A surrogate key in a database is a unique identifier for either an entity in the modeled world or an object in the database. The surrogate key is not derived from application data, unlike a natural key.

The SQL SELECT statement returns a result set of records, from one or more tables.

An SQL INSERT statement adds one or more records to any single table in a relational database.

A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure. Indexes are used to quickly locate data without having to search every row in a database table every time said table is accessed. Indexes can be created using one or more columns of a database table, providing the basis for both rapid random lookups and efficient access of ordered records.

Traitor tracing schemes help trace the source of leaks when secret or proprietary data is sold to many customers. In a traitor tracing scheme, each customer is given a different personal decryption key. (Traitor tracing schemes are often combined with conditional access systems so that, once the traitor tracing algorithm identifies a personal decryption key associated with the leak, the content distributor can revoke that personal decryption key, allowing honest customers to continue to watch pay television while the traitor and all the unauthorized users using the traitor's personal decryption key are cut off.)

<span class="mw-page-title-main">Null (SQL)</span> Marker used in SQL databases to indicate a value does not exist

In SQL, null or NULL is a special marker used to indicate that a data value does not exist in the database. Introduced by the creator of the relational database model, E. F. Codd, SQL null serves to fulfil the requirement that all true relational database management systems (RDBMS) support a representation of "missing information and inapplicable information". Codd also introduced the use of the lowercase Greek omega (ω) symbol to represent null in database theory. In SQL, NULL is a reserved word used to identify this marker.

<span class="mw-page-title-main">Vehicle registration plates of Norway</span> Norway vehicle license plates

The registration plates of cars in Norway are maintained by the Norwegian Ministry of Transport and Communications. As in most countries, cars are identified only by number plates read visually. Each plate is a legal document that both identifies the vehicle and permits its use, and shall be returned to the registration authority when the vehicle is no longer in use.

<span class="mw-page-title-main">Dimension (data warehouse)</span> Structure that categorizes facts and measures in a data warehouse

A dimension is a structure that categorizes facts and measures in order to enable users to answer business questions. Commonly used dimensions are people, products, place and time.

A unique identifier (UID) is an identifier that is guaranteed to be unique among all identifiers used for those objects and for a specific purpose. The concept was formalized early in the development of computer science and information systems. In general, it was associated with an atomic data type.

A relational database management system uses SQL MERGE statements to INSERT new records or UPDATE existing records depending on whether condition matches. It was officially introduced in the SQL:2003 standard, and expanded in the SQL:2008 standard.

In relational database management systems, a unique key is a candidate key. All the candidate keys of a relation can uniquely identify the records of the relation, but only one of them is used as the primary key of the relation. The remaining candidate keys are called unique keys because they can uniquely identify a record in a relation. Unique keys can consist of multiple columns. Unique keys are also called alternate keys. Unique keys are an alternative to the primary key of the relation. In SQL, the unique keys have a UNIQUE constraint assigned to them in order to prevent duplicates. Alternate keys may be used like the primary key when doing a single-table select or when filtering in a where clause, but are not typically used to join multiple tables.

An identity column is a column in a database table that is made up of values generated by the database. This is much like an AutoNumber field in Microsoft Access or a sequence in Oracle. Because the concept is so important in database science, many RDBMS systems implement some type of generated key, although each has its own terminology. Today a popular technique for generating identity is to generate a random UUID.

Language Integrated Query is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, originally released as a major part of .NET Framework 3.5 in 2007.

<span class="mw-page-title-main">Swiss locomotive and railcar classification</span> Classifications of Swiss trains

For more than a century, the Swiss locomotive, multiple unit, motor coach and railcar classification system, in either its original or updated forms, has been used to name and classify the rolling stock operated on the railways of Switzerland. It started out as a uniform system for the classification and naming of all rolling stock, powered and unpowered, but had been replaced and amended by the UIC classification of goods wagons.

References

  1. ↑ "Ordbøkene.no - Bokmålsordboka og Nynorskordboka" (in Norwegian). Retrieved 2024-02-26.
  2. ↑ "Sequences" . Retrieved 2024-02-26.
  3. ↑ MashaMSFT (2023-04-18). "Sequence Numbers - SQL Server" . Retrieved 2024-02-26.
  4. ↑ Roeser, Mary Beth. "CREATE SEQUENCE" . Retrieved 2024-02-26.
  5. ↑ "SQL Server: Sequences (Autonumber)" . Retrieved 2024-02-26.
  6. ↑ "Navneendring, fisjon og fusjon" (in Norwegian Bokmål). 2023-09-27. Retrieved 2024-02-26.
  7. ↑ "Endelig opptelling - Valgmedarbeiderportalen" . Retrieved 2024-02-26.
  8. 1 2 Vangen, Torill. "Snr" (in Norwegian Bokmål). Retrieved 2024-02-26.
  9. ↑ "Sveitsiske lok- og motorvognbetegnelser, er de kryptiske ? Del 2 – M&E" (in Norwegian Bokmål). Retrieved 2024-02-26.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.