Skip to content

Sequence number

A sequence number is an identifier assigned according to an ordering rule so receivers can distinguish instances, reconstruct order, detect gaps or duplicates, and coordinate state across a stream or collection.

Core Idea

A sequence number is an identifier drawn from an ordered succession, usually by assigning the next available integer to each new item or event. Its value records position in an allocation sequence and can simultaneously provide uniqueness within a declared scope. Applications include case files, manufactured units, ballots, database rows, messages, and registry entries. The scheme's identity lies in ordered allocation, not in any particular starting value, width, or printed format.

A usable sequence specifies an issuing authority or generator, the namespace in which values are unique, the rule for advancement, and the handling of gaps, resets, concurrency, exhaustion, and reuse. Database sequence objects, for example, can generate values independently of transaction success, so rollbacks and caching may leave gaps. Distributed protocols may compare sequence numbers modulo a finite range and need explicit rules for wraparound. A sequence can serve as a surrogate key when it identifies a record without encoding facts about the entity, or it can be one component of a larger designation alongside type codes and check digits.

A sequence number is not necessarily a count of all existing objects, a timestamp, or evidence that no earlier value is missing. It also differs from a semantically structured serial number: a serial may encode model, location, issuer, or checksum fields, whereas the sequence component only establishes ordered issuance within its series. Consecutive appearance is a policy goal rather than an inherent guarantee when values are reserved, cancelled, or generated concurrently. The abstraction is an order-bearing allocation token whose interpretation depends on a specified generator and scope; it supports identity and ordering but does not, by itself, establish chronology, continuity, or meaning outside that namespace.

Structural Signature

Sig role-phrases:

  • the issuing authority — generator or protocol participant authorized to allocate identifiers
  • the sequence namespace — bounded scope within which values are interpreted and expected to be unique
  • the ordered value domain — integers or modular values carrying succession
  • the advancement rule — procedure selecting the next allocable value
  • the allocation event — creation, transmission, registration, or production instance receiving the number
  • the concurrency policy — reservation, caching, locking, or distributed coordination preventing unintended duplicates
  • the gap-and-rollback behavior — explicit treatment of abandoned, failed, or preallocated values
  • the reset-and-wrap rule — epoch, modulus, exhaustion, and reuse handling
  • the order-bearing output — identifier supporting position or comparison within its series
  • the semantic boundary — no automatic guarantee of complete counts, gapless chronology, or meaning outside the declared generator and scope

What It Is Not

  • Not necessarily a count of objects that still exist. Deletions, cancellations, rollbacks, and reserved values can leave gaps.
  • Not automatically a timestamp. Ordered issuance can correlate with time without encoding an instant or guaranteeing chronological commit order.
  • Not globally unique. Uniqueness holds only within the declared generator, namespace, and reset or reuse policy.
  • Not always consecutive. Caching, concurrency, failed transactions, batching, and allocation ahead of use commonly skip numbers.
  • Not a semantically rich serial number. Model, issuer, location, and checksum fields belong to a larger designation, while the sequence component supplies order.
  • Not free from wraparound ambiguity. Finite protocol fields require modular comparison rules and a bounded active window.
  • Not evidence of business meaning. A surrogate sequence can identify a record precisely while intentionally encoding nothing about the represented entity.

Scope of Application

Sequence numbers apply wherever an issuing protocol allocates order-bearing identifiers within a declared namespace; their functions depend on allocation, comparison, and lifecycle rules.

  • Network messages. Finite-width values support ordering, duplicate detection, loss inference, and replay windows under modular comparison.
  • Database rows and transactions. Central or cached sequences generate surrogate identifiers with concurrency and rollback semantics.
  • Records and cases. Registries, documents, ballots, and administrative files receive controlled order-bearing references.
  • Manufactured units. A sequence component distinguishes items while model, factory, or date may reside in other serial-number fields.
  • Distributed allocation. Reserved blocks improve throughput but create gaps and visible out-of-order issuance.
  • Audit and reconciliation. Missing or repeated allocations can be investigated when issuer, persistence, and reset rules are known.
  • Finite protocol design. Wraparound, reuse, window size, exhaustion, and restart behavior determine safe comparison.
  • Applicability boundary. A sequence number is not a count of surviving objects, trustworthy timestamp, authentication secret, or proof that no identifier is missing; signed time and event records may be needed for chronology.

Clarity

Sequence number identifies position in an ordered allocation scheme and may provide uniqueness only within a declared namespace and lifecycle. It is not automatically a count of successfully completed events, a timestamp, or a gap-free record. Clarity requires the issuing authority, starting and advancement rules, concurrency behavior, reset and wraparound policy, and treatment of abandoned values. The sharper systems question is which ordering or deduplication guarantee consumers may infer from the number and which apparent gaps, reuse, or reordering are legitimate under the generator's contract.

Manages Complexity

Sequence numbers reduce a stream of items or events to ordered identifiers inside a declared namespace. The analyst tracks generator, scope, monotonicity, uniqueness, wraparound, reset, reuse, and gaps rather than retaining the entire allocation history for every comparison. Centralized, partitioned, and distributed branches offer different guarantees. Differences in numbers can expose missing, duplicated, stale, or reordered entries when the contract warrants those inferences. The compression is deliberately limited: a sequence number supplies order or identity, not event time, successful completion, or gaplessness unless the issuing protocol adds those guarantees.

Abstract Reasoning

Ordering move. From sequence values under a monotone allocation contract, infer relative issuance order within the declared namespace. Gap move. Treat missing values as evidence of unused, rolled-back, cached, filtered, or lost entries according to protocol—not proof of data deletion. Deduplication move. Use uniqueness scope to identify repeated transmission or record collision, checking resets and wraparound first. Distributed move. Partition or lease number ranges and infer only the ordering guarantee the generator preserves. Boundary move. Sequence numbers do not supply wall-clock time, successful completion, or global order across namespaces unless those properties are explicitly engineered.

Knowledge Transfer

Within the home domain. Sequence numbers transfer across networking, distributed logs, storage protocols, databases, and message streams whenever ordered identifiers detect loss, duplication, reordering, replay, or staleness. Number space, increment rule, wraparound, session or epoch, and comparison window retain operational meanings. Beyond the home domain (C — ordering instrument). They apply literally to any protocol with discrete ordered events and a defined assignment rule. Their boundary is semantic: sequence order need not equal wall-clock time, causality, priority, or global order; reuse and wraparound make context essential. An ordinal label is not automatically a robust sequence number.

Examples

Canonical

A registry allocates case numbers 1001, 1002, and 1003 as filings are accepted. Number 1004 is reserved, but the filing fails; the authority does not reuse it, so the next case receives 1005. The gap is evidence of allocation policy, not a missing public case. Within this registry and epoch, larger numbers generally indicate later allocation, but they do not prove exact filing time or elapsed duration. Another registry may independently issue 1005 without collision because the namespaces differ.

Mapped back: The registry is the issuing authority, its case series the sequence namespace, integers the ordered value domain, and next-number selection the advancement rule. Filing is the allocation event, skipped 1004 the gap-and-rollback behavior, and the assigned identifier the order-bearing output.

Applied / In Practice

A distributed messaging system gives each stream partition modular sequence numbers. Producers reserve blocks to reduce coordination, receivers compare numbers only within the same partition and epoch, and protocol rules specify behavior when the counter wraps. Crashes can leave unused reservations, so monitoring does not treat the maximum sequence as a count of delivered messages. Deduplication keys include partition and epoch; the number alone is not globally unique.

Mapped back: The partition and epoch define the sequence namespace, reservation is the concurrency policy, and unused blocks the gap-and-rollback behavior. Modulus and epoch implement the reset-and-wrap rule. Local comparison uses the order-bearing output, while rejecting global counts enforces the semantic boundary.

Structural Tensions

T1 — Identity versus admissible variation. Sequence number must remain recognizable across legitimate variants. Admissible variation is bounded by this condition: Finite-width values support ordering, duplicate detection, loss inference, and replay windows under modular comparison. The stable element is expressed by this invariant: A sequence number is an identifier assigned according to an ordering rule so receivers can distinguish instances, reconstruct order, detect gaps or duplicates, and coordinate state across a stream or collection. Treating every surface change as a new abstraction fragments the identity, while allowing a change to the constitutive relation produces a false positive.

Diagnostic: After the proposed variation, can an analyst still establish this invariant: A sequence number is an identifier assigned according to an ordering rule so receivers can distinguish instances, reconstruct order, detect gaps or duplicates, and coordinate state across a stream or collection?

T2 — Recognition versus proxy. The domain needs observable or inferential evidence for Sequence number, but the evidence is not automatically the identity. The working recognition rule is: the semantic boundary — no automatic guarantee of complete counts, gapless chronology, or meaning outside the declared generator and scope. A familiar indicator can occur without the defining relation, and the relation can persist when a customary detector is unavailable.

Diagnostic: Does the evidence establish the defining claim—A sequence number is an identifier assigned according to an ordering rule so receivers can distinguish instances, reconstruct order, detect gaps or duplicates, and coordinate state across a stream or collection—or only a correlated sign?

T3 — Definition versus operational judgment. A compact definition aids reuse, whereas actual classification in identifier design can require expert decisions about boundary conditions, measurements, conventions, or exceptions. A usable sequence specifies an issuing authority or generator, the namespace in which values are unique, the rule for advancement, and the handling of gaps, resets, concurrency, exhaustion, and reuse. The definition must constrain those judgments without pretending that every admissible case can be recognized from a label alone.

Diagnostic: Which observation would make a competent practitioner reject the classification under the stated definition?

T4 — Scope versus overextension. Sequence number has a genuine habitat in which finite-width values support ordering, duplicate detection, loss inference, and replay windows under modular comparison. Yet A sequence number is not a count of surviving objects, trustworthy timestamp, authentication secret, or proof that no identifier is missing; signed time and event records may be needed for chronology. A useful application map therefore has to be broad enough to cover recurring practice and narrow enough to exclude merely topical or metaphorical occurrences.

Diagnostic: Can the claimed application fill the same carrier and relation roles, or has only the name traveled?

T5 — Transfer versus domain accent. Knowledge about Sequence number can travel within its home domain, and some structural lessons may travel farther. Sequence numbers transfer across networking, distributed logs, storage protocols, databases, and message streams whenever ordered identifiers detect loss, duplication, reordering, replay, or staleness. What transfers must be separated from the specialist vocabulary, warrant, and closure conditions that remain anchored in identifier design.

Diagnostic: Is the receiving case a literal instance of Sequence number, a co-instance of Sequencing, or only an analogy?

T6 — Autonomy versus reduction. Sequence number structurally presupposes Sequencing, but the edge does not erase the domain differentia. The broader node supplies only the necessary structural relation; identifier design supplies the carrier, warrant, boundary, and exception conditions expressed by this identity: A sequence number is an identifier assigned according to an ordering rule so receivers can distinguish instances, reconstruct order, detect gaps or duplicates, and coordinate state across a stream or collection. The entry is over-split if those conditions add no discriminating work and under-specified if the parent alone is used for cases that require them.

Diagnostic: Can a domain expert use the added conditions to distinguish Sequence number from another case that equally instantiates Sequencing?

Structural–Framed Character

Sequence number is mixed: structurally specifiable but materially dependent on its disciplinary frame. Its structural side consists of the carrier the issuing authority — generator or protocol participant authorized to allocate identifiers and the constitutive relation A sequence number is an identifier assigned according to an ordering rule so receivers can distinguish instances, reconstruct order, detect gaps or duplicates, and coordinate state across a stream or collection. Its framed side comes from identifier design, which fixes what the terms denote, what counts as evidence, and when a qualification or exception defeats the classification.

Across the principal tests, the entry is not merely a free-floating pattern. Evaluative weight: the identity can be stated descriptively even when its use has practical or normative consequences. Practice dependence: the semantic boundary — no automatic guarantee of complete counts, gapless chronology, or meaning outside the declared generator and scope. Institutional stabilization: disciplinary conventions may stabilize the name and test without necessarily creating every underlying event or relation. Vocabulary portability: the invariant is A sequence number is an identifier assigned according to an ordering rule so receivers can distinguish instances, reconstruct order, detect gaps or duplicates, and coordinate state across a stream or collection. Import versus recognition: an outside case qualifies literally only if the same typed roles and collapse condition are available; otherwise the comparison is analogical.

The reusable remainder is Sequencing under a reviewed Composition relation. That node preserves the necessary cross-domain organization after the identifier design-specific carrier, evidence, and exceptions are removed. Sequence number remains autonomous because its recognition and collapse conditions distinguish cases that the parent alone leaves together.

Structural Core vs. Domain Accent

What is skeletal. The portable skeleton is a typed carrier organized by a constitutive relation, an invariant, a recognition test, and a collapse condition. Here the carrier is the issuing authority — generator or protocol participant authorized to allocate identifiers. The decisive relation is A sequence number is an identifier assigned according to an ordering rule so receivers can distinguish instances, reconstruct order, detect gaps or duplicates, and coordinate state across a stream or collection, which also states the controlling invariant at this level. Stripped of specialist nouns, this organization is represented by Sequencing.

What is domain-bound. identifier design supplies the actual objects or agents, admissible transformations, units or conventions, standards of warrant, and named exceptions. In this case, recognition requires evidence for the semantic boundary — no automatic guarantee of complete counts, gapless chronology, or meaning outside the declared generator and scope. Admissible variation is bounded by the condition that finite-width values support ordering, duplicate detection, loss inference, and replay windows under modular comparison, and the classification collapses when deletions, cancellations, rollbacks, and reserved values can leave gaps. These are constitutive differentia, not illustrative decoration.

Why it remains a domain-specific node. The reviewed DAG relation is Composition to Sequencing. Outside identifier design, the parent captures only the reusable structural remainder. The specialist name remains literal only where the semantic boundary — no automatic guarantee of complete counts, gapless chronology, or meaning outside the declared generator and scope can be established under the domain's standards of warrant.

This entry presupposes Sequencing.

  • Immediate parent — Sequencing (composition/presupposes). Sequence number structurally presupposes Sequencing rather than being a subtype of it. The candidate identity is: A sequence number is an identifier assigned according to an ordering rule so receivers can distinguish instances, reconstruct order, detect gaps or duplicates, and coordinate state across a stream or collection. Its operation cannot be stated without the parent relation—Deliberately ordering steps under precedence constraints so that the arrangement itself, not just the set of tasks, determines the outcome.—but it adds domain-specific carriers, constraints, and warrants. The defining source account begins: A sequence number is an identifier drawn from an ordered succession, usually by assigning the next available integer to each new item or event.
  • Nearest catalog surface declined — Identifier. Its rematch score was 0.16392. Retrieval proximity did not establish synonymy or parentage; the carrier, invariant, and collapse condition remain different.
  • Related reasoning operations. Evidence, comparison, boundary testing, and representation can support a case without becoming additional DAG parents.

Relationships to Other Abstractions

Local relationship map for Sequence numberParents appear above the current abstraction, mutual partners to the right, and children below. Node labels state whether each abstraction is prime or domain-specific; colors identify relation types.Sequence numberDOMAINPrime abstraction: Sequencing — presupposesSequencingPRIME

Current abstraction Sequence number Domain-specific

Parents (1) — more general patterns this builds on

  • Sequence number presupposes Sequencing Prime

    Sequence number structurally presupposes Sequencing rather than being a subtype of it.

Hierarchy paths (3) — routes to 3 parentless roots

Neighborhood in Abstraction Space

Sequence number sits in a sparse region of the domain-specific corpus (62nd percentile for distinctiveness): few abstractions share its structure, so a faithful description tends to retrieve it precisely.

Family — Unclustered & Miscellaneous (2551 abstractions)

Nearest neighbors

Computed from structural-signature embeddings · 2026-10-08

Not to Be Confused With

  • Sequencing. This is the reviewed immediate parent or structural prerequisite, not a synonym. Tell: retain Sequence number only when the domain-specific relation A sequence number is an identifier assigned according to an ordering rule so receivers can distinguish instances, reconstruct order, detect gaps or duplicates, and coordinate state across a stream or collection. and its source-domain warrant are established; otherwise route the case to Sequencing.
  • Keith Number. This is the closest catalog retrieval surface, not an accepted synonym or parent. Tell: Ask which entry's carrier, invariant, and collapse test the case actually satisfies; shared vocabulary or a score of 0.756625 is insufficient.

  • Not necessarily a count of objects that still exist. Deletions, cancellations, rollbacks, and reserved values can leave gaps. Tell: Require the positive recognition condition that the semantic boundary — no automatic guarantee of complete counts, gapless chronology, or meaning outside the declared generator and scope.

  • Not automatically a timestamp. Ordered issuance can correlate with time without encoding an instant or guaranteeing chronological commit order. Tell: Replace the familiar surface feature and test whether a sequence number is an identifier assigned according to an ordering rule so receivers can distinguish instances, reconstruct order, detect gaps or duplicates, and coordinate state across a stream or collection.

  • A detector, representation, or consequence. A method may reveal Sequence number, a notation may describe it, and an outcome may follow from it without any of those being identical to the abstraction. Tell: Would the defining relation remain if the present detector, notation, or downstream effect changed?

  • A metaphorical transfer. A case outside the home domain may resemble the structure while lacking its native role types and standards of warrant. Tell: If only the general organization survives, route the comparison to Sequencing rather than treating it as another Sequence number instance.

References

  • Frozen Wikipedia revision: https://en.wikipedia.org/wiki/Sequence_number (revision 1345243587).
  • Supporting reference preserved in the packet: https://ordbokene.no/bm,nn/ordbokene.no
  • Supporting reference preserved in the packet: https://www.ibm.com/docs/en/db2/11.5?topic=objects-sequences
  • Supporting reference preserved in the packet: https://learn.microsoft.com/en-us/sql/relational-databases/sequence-numbers/sequence-numbers?view=sql-server-ver16
  • Supporting reference preserved in the packet: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-SEQUENCE.html#GUID-E9C78A8C-615A-4757-B2A8-5E6EFB130571
  • Supporting reference preserved in the packet: https://www.techonthenet.com/sql_server/sequences.php
  • Supporting reference preserved in the packet: https://kartverket.no/eiendom/overfore-eiendom/navneendring-fisjon-og-fusjon
  • Supporting reference preserved in the packet: https://valgmedarbeiderportalen.valg.no/eva/opptelling/endelig-opptelling/
  • Supporting reference preserved in the packet: https://www.ssb.no/a/metadata/conceptvariable/vardok/500043/nb

The frozen Wikipedia revision is discovery provenance. The cited source set was reviewed for identity, formal or operational relation, and scope. The encyclopedia's structural synthesis is bounded to those claims; URL transport failure alone was not treated as substantive contradiction.