# US 2012/0084307 A1 · Efficient database search for unique indentifiers

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2012/0084307 A1
- Document ID: US20120084307A1
- Status: Published application
- Kind: A1
- Application number: 12/895,240
- Filed: 2010-09-30
- Published: 2012-04-05
- Earliest claimed: 2010-09-30
- Assignees: Alcatel-Lucent Canada Inc.
- Inventors: Guangnian Wu; Tibor Fasanga
- Web page: https://patentgrep.com/patent/US20120084307A1

## CPC

- H04L 47/00: Traffic control in data switching networks (arrangements for detecting or preventing errors in the information received H04L1/00)
- H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M)

## Abstract

The invention is directed to providing an improved method of determining available identifiers (IDs) in a database, especially in the context of using available IDs for provisioning services in a telecommunications system. The method performs a database query for a range of IDs and stores candidate IDs in a local pre-fetch ID set.

## Claims

### Claim 1

A method of searching a database for a unique identifier (ID), the method comprising steps of:
performing a database query for a pre-fetch ID set for a predefined range of candidate IDs; and
determining an available ID within said pre-fetch ID set.

### Claim 2 (depends on 1)

The method of claim 1, wherein said pre-fetch ID set contains all the used IDs for said predefined range of candidate IDs.

### Claim 3 (depends on 1)

The method of claim 1, further comprising a step of repeating said step of determining an available ID.

### Claim 4 (depends on 3)

The method of claim 3, further comprising steps of:
incrementing said starting candidate ID by said predefined range; and
repeating said step of performing a database query.

### Claim 5 (depends on 4)

The method of claim 4, wherein said predefined range comprises an order of magnitude less than a total ID range space.

### Claim 6 (depends on 4)

The method of claim 4, wherein said predefined range comprises between 5% and 20% of a total ID range space.

### Claim 7 (depends on 1)

The method of claim 1 wherein said database query comprises a Structured Query Language (SQL) query.

### Claim 8 (depends on 1)

The method of claim 1 further comprising steps of:
provisioning services in a telecommunication system, using said available ID.

### Claim 9 (depends on 8)

The method of claim 8, wherein said database comprises a network management system database.

### Claim 10 (depends on 1)

A program storage device readable by a machine, tangibly embodying a program of instructions executable by the machine to perform steps of the method of claim 1.
