|Numbering and Database Products|
Magenta UK Numbering Database - Numbering Membership
The Magenta UK Numbering Database is designed for those that need to fully integrate telephone numbering, tariff band and locality information into their own systems. The original raw database is available as a set of comma separated variable (CSV) text files that may be importing into custom databases. The database comprises the following tables (approximate number of records bracketed, it changes weekly), samples of which can be provided upon request:
The numbering database is a snapshot of current numbers and tariff bands, usually updated weekly, as new source data from BT and Ofcom is released.
Cost of the Magenta UK Numbering Database is £1,000 plus VAT for the first year (which include full site membership), and £300 plus VAT for subsequent years. Existing site members will be credited with their current fee and so only pay the difference. This price licenses the database to be used in one company or organisation only, and does not allow redistribution with applications. Please contact Magenta Systems Ltd for details on redistribution licensing.
The Magenta UK Numbering Database is distributed in a ZIP file, and may be downloaded from the password protected Numbering section of this web site. It is updated weekly, or less often if there is no new numbering or tariff information from Ofcom or BT.
Some of the features of our CodeLook dialling code lookup are available using a Json API, for business and numbering members that prefer to integrate our data into their own systems rather than downloading data files or using a web page.
This Json API is designed for casual use only, similarly to the CodeLook web page, not for sequentially trawling the database, the API tracks usage, business trade users are permitted 50 requests within 24 hours, numbering members 500 requests, before further requests are rejected, the limit for numbering member can be negotiated. Currently, the most popular CodeLook numbering queries are available as Json APIs, but other queries can be added, please just ask. We don't plan to offer any call costing or broadband cabinet lookup APIs.
Full details of the CodeLook API for paid members are at: https://www.telecom-tariffs.co.uk/bus/apidoc.htm
Magenta SQL Telecom Database - Database Membership
The Magenta SQL Telecom Database offers a Microsoft SQL Server 2008 R2/2012 database with both numbering and tariff information, exactly the same database that drives this web site. Unlike Numbering Membership, Database Membership includes all our tariff information which may be used to cost telephone calls for billing or competitive purposes using about 500 different tariffs. A single Microsoft SQL Server 2008 R2/2012 database file is supplied that may be quickly restored to other SQL servers, rather than needing to import lots of CSV files.
The database includes various stored procedures to access the 29 tables with about 800,000 rows of numbering, locality and tariff data. For use with other SQL databases, CSV files are also be available. The SQL database is historic, containing old and current numbering and tariff information allowing telephone calls to be costed as at a specified date.
Please note the tariffs in the database are currently taken from the tariff spreadsheet and only include costs to about 40 countries. Systems are currently being developed to automate the import of tariffs from spreadsheets, CSV and XML files, and web pages (similarly to how numbering has been done for 10 years) so costs for all charge bands will finally be available.
Cost of the Magenta SQL Telecom Database is £2,000 plus VAT for the first year (which include full site membership), and £1,000 per year plus VAT subsequently. Existing site members will be credited with their current fee and so only pay the difference. This price licenses the database to be used in one company or organisation only, and does not allow redistribution with applications. Please contact Magenta Systems Ltd for details on redistribution licensing.
The main database is named magtelecom and is built with Microsoft SQL Server 2008 R2, but is fully compatible with SQL Server 2012 and later. There are five main tables, 12 child tables, one work table and nine small type validation tables.
In addition to the main SQL tables, other tables will exist in the magtelecom database to assist with program control. These include:
The Magenta SQL Gazetteer Database offers a Microsoft SQL Server 2008 R2 database with UK locality information, post codes, town names, place names, post code districts and various other gazetteer information. This database is used to prepare and validate the locality information in the Telecom Database, but may have other purposes. Note there are multiple place or town name tables from different sources, with differing county names, some with partial old post codes, not all of which will validate against other, since there is no 'official' formalised list of places in the UK.
Note the Gazetteer Database is approximately 1.5 gigs in size and is updated four times a year, when Ordnance Survey issues new Code-Point Open post codes.
Copyright © 2021 Magenta Systems Ltd, England. All Rights Reserved.