1 / 71

DATABASE AND SOFTWARE FOR AUTOMATION OF THE RADIO REGULATIONS

Centre of Excellence Workshop Kiev - 2003 Principles and techniques for spectrum planning and utilization. DATABASE AND SOFTWARE FOR AUTOMATION OF THE RADIO REGULATIONS. B ontcho Balabanov NBU-Sofia. Introduction Problems for using the Radio Regulations

tejano
Download Presentation

DATABASE AND SOFTWARE FOR AUTOMATION OF THE RADIO REGULATIONS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Centre of Excellence Workshop Kiev - 2003 Principles and techniques for spectrum planning and utilization DATABASE AND SOFTWARE FOR AUTOMATION OF THE RADIO REGULATIONS Bontcho Balabanov NBU-Sofia CoE SM Workshop Kiev- 2003

  2. Introduction Problems for using the Radio Regulations How to Automat of the Radio Regulations Database with RR provisions Automation of the Radio Regulations Software modules Harmonization of the frequency tables. Examples Conclutions Автоматизиране на Радио регламента (RR) Automation of the Radio Regulations (RR) CoE SM Workshop Kiev- 2003

  3. ITU- Radio Regulations - RR Automation of the Radio Regulations Specification- SG-4, NTIA, FSS, ITU-BR Database Software modules Conections betwean databases Efficient selection of the information 1.Introduction 1. Introduction CoE SM Workshop Kiev- 2003

  4. 2.a)Radio Regulations ITU Radio Regulations • TABLE OF FREQUENCY ALLOCATION • REGULATORY PROCEDURES - advance publication / coordination / notification & plans ITU ITU ITU ITU RR RR RR RR • ARTICLES • APPENDICES • RESOLUTIONS • Recommendations RR 4 volums- over 1500 pages + Recommendations by reference CoE SM Workshop Kiev- 2003

  5. 2.b) Radio Regulations 2.a)ITU-BRRadio Regulations (RR) • a) The Radio Regulations and the Recommendations of the BR, are based primarily on defining radio services, allocating frequency bands to these services and specifying administrative and technical procedures for the operation of stations in the services. • For example the maritime mobile and the aeronautical mobile services are involve in standardized practices that are intended to ensure their international operability and connectivity • the Radio Regulations serve as the primary international agreement covering rules and procedures for operating radio equipment and for resolving interference. The Table of Frequency Allocations, contained in Article 8, serves as a basis for national allocation of frequencies. CoE SM Workshop Kiev- 2003

  6. 2.b) Radio Regulations 2.b)Radio Regulations • Who decides on their content? • Administrations, Regional Organizations • How? • At Radiocommunication Conferences • When? • Every two or three years CoE SM Workshop Kiev- 2003

  7. Allocation to services Region 3 Region 1 Region 2 • 1 613.8-1 626.5MHz • MOBILE-SATELLITE(Earth-to-space) 5.351A • AERONAUTICAL RADIONAVIGATION • Mobile-satellite (space-to-Earth) • Radiodetermination-satellite(Earth-to-space) • 1 613.8-1 626.5MHz • MOBILE-SATELLITE(Earth-to-space) 5.351A • AERONAUTICALRADIONAVIGATION • Mobile-satellite • (space-to-Earth • 1 613.8-1 626.5MHz • MOBILE-SATELLITE(Earth-to-space) 5.351A • AERONAUTICALRADIONAVIGATION • RADIODETERMINATION-SATELLITE(Earth-to-space) • Mobile-satellite • (space-to-Earth) 5.341 5.355 5.359 5.364 5.365 5.366 5.367 5.368 5.369 5.372 5.341 5.355 5.359 363 5.364 5.365 5.366 5.367 5.368 5.369 5.371 5.372 5.341 5.364 5.365 5.366 5.367 5.368 5.370 5.372 RR Example CoE SM Workshop Kiev- 2003

  8. Example Footnotes 1 FTN 1 5.364 The use of the band 1 610-1 626.5 MHz by the mobile-satellite service (Earth-to-space) and by the radiodetermination-satellite service (Earth‑to‑space) is subject to coordination under No. 9.11A. A mobile earth station operating in either of the services in this band shall not produce a peak e.i.r.p. density in excess of in the part of the band used by systems operating in accordance with the provisions of No. 5.366 (to which No. 4.10 applies), unless otherwise agreed by the affected administrations. In the part of the band where such systems are not operating, the mean e.i.r.p. density of a mobile earth station shall not exceed –3 dB(W/4 kHz). Stations of the mobile-satellite service shall not claim protection from stations in the aeronautical radionavigation service, stations operating in accordance with the provisions of No. 5.366 and stations in the fixed service operating in accordance with the provisions of No. 5.359. Administrations responsible for the coordination of mobile-satellite networks shall make all practicable efforts to ensure protection of stations operating in accordance with the provisions of No. 5.366. CoE SM Workshop Kiev- 2003

  9. Example Footnotes 2 FTN 2 5.367Additional allocation:  The bands 1 610-1 626.5 MHz and 5 000-5 150 MHz are also allocated to the aeronautical mobile-satellite (R) service on a primary basis, subject to agreement obtained under No. 9.21. 5.369 Different category of service:in Angola, Australia, Burundi, China, Côte d’Ivoire, Eritrea, Ethiopia, India, Iran (Islamic Republic of), Israel, Jordan, Lebanon, Liberia, Libya, Madagascar, Mali, Pakistan, Papua New Guinea, Dem. Rep.of the Congo, Syria, Senegal, Sudan, Swaziland, Togo and Zambia, the allocation of the band 1 610-1 626.5 MHz to the radiodetermination-satellite service (Earth-to-space) is on a primary basis (see No. 5.33), subject to agreement obtained under No. 9.21 from countries not listed in this provision.     (WRC-97) CoE SM Workshop Kiev- 2003

  10. RR Art. 9.35 • Examinations with respect to: • i) Any power limits referred to in applicable footnotes, Resolutions or Recommendations; • ii) The power limits for earth stations as specified in Nos 21.8, 21.10, 21.12 and 21.13; • iii) The limits of power flux-density from space stations produced at the Earth's surface as specified in Table 21-4 (21.16), as well as in Tables 22-1A to 22-1D (22.5C); • iv) The limits of power flux-density from space stations produced at the geostationary orbit as specified in Nos 22.5 and 22.5A; • v) The limits of power flux‑density from earth stations produced at the GSO as specified in Table 22.2 (22.5D); • vi) The limits of power flux‑density from space stations produced at any point in the geostationary orbit as specified in Table 22.3 (22.5F); and • vii) The off-axis power limits of earth stations in the fixed‑satellite service specified in Nos 22.26 to 22.39. CoE SM Workshop Kiev- 2003

  11. 3.а)RR Problems 1e 2e 3e Itu Itu Itu Problems for using the Radio Regulations 4 volums- over 1500 pages a lot of manual operations are implemented for network coordinations in BR CoE SM Workshop Kiev- 2003

  12. Examinations of the frequency assignments. Frequency allocation tables. Radio services Footnotes Appendixes Recommendations Resolutions Contradictions in the footnotes Interest of different administrations Additional allocation and different category of service 3.b)Problems for using the Radio Regulations CoE SM Workshop Kiev- 2003

  13. 3. AutomationAttempt Specification - Expert group NTIA, FSS, ITU-BR, SG-4 RR database- MSACCESS Connections between Tables Connections to other databases Software modules • Attempt for automation of the RR CoE SM Workshop Kiev- 2003

  14. Expert group • Software and DB Specification: • The development and the implementation (by BR and by administrations) of the software according to the New Recomendation ITU-R SF-[Doc. 4/117] “Outline of a software specification for automating the examination of satellite network filings for compliance with Article 5” (SG-4), including PFD calculation to help the automation of the satellite examination procedure. CoE SM Workshop Kiev- 2003

  15. 4. RR Database • RR Database • Database with RR provisions • Main Tables: • - Frequency allocation table RRArt. 5 • Table with Radio services • Table with Footnote Text • Table with Pa, PFD, EIRP, Da Limits • Table with Footnote Categories • Information tables • Table with extra conditions • Queries for Data selection • Macros and modules to generate these tables from RR texts. CoE SM Workshop Kiev- 2003

  16. RR texts to Tables • TransferRR Word text to Table. • Processing RR Word Table – separate fields (kHz, MHz, GHz). • Transfer RR Word Table to MS Excel. • Processing MS Excel Table – add missed fields and correct data. • Transfer MS Excel Table to MS Access. • Processing MS Access Table in MS Access-all frequencies as Hz. • Select proper Cyrillic font for MS Access (if applicable). • Separate fields with footnotes and services. • Generate table “Frequency_Allocation”. • Start MS C++ Software. • First Processing MS Access Table with MS C++ function. • Generate separate record for every footnote and service. • Second Processing MS Access Table in MS Access. • Second Processing MS Access Table with MS C++ function. • Third Processing MS Access Table in MS Access. • Test and correction MS Access Table. CoE SM Workshop Kiev- 2003

  17. Tables CoE SM Workshop Kiev- 2003

  18. Frequency • Frequency allocation table • Frequency limits [Hz] • Radio service ID numbers (codes) • Type of the Emissions (E/R) • Regions codes • Footnote numbers • Appendix numbers • Recommendation numbers • Resolution numbers CoE SM Workshop Kiev- 2003

  19. Fr Table Frequency allocation table (Art. 5) CoE SM Workshop Kiev- 2003

  20. Radio services Table with Radio services CoE SM Workshop Kiev- 2003

  21. Footnotes Table with Footnote Texts CoE SM Workshop Kiev- 2003

  22. FTH categories Footnote Categories Auto check Allocation Coordination PFD limit PFD threshold Date Elevation angle Gain Power Antenna diameter Publication date Emission Permissive use Use restriction Additional allocation Alternative allocation Different category of service Protection restriction Authorisation Undefined Other type CoE SM Workshop Kiev- 2003

  23. Category Table Table with Footnote Categories CoE SM Workshop Kiev- 2003

  24. Фиг.3.3.1. Query CoE SM Workshop Kiev- 2003

  25. Algorithm Footnote Examination CoE SM Workshop Kiev- 2003

  26. Algorithm FTN CoE SM Workshop Kiev- 2003

  27. Software The example software main features: • Satellite data extraction from SRS database; • Unique database generation for extracted satellite data with the name of the network; • Data validation for correct satellite data (Pd, Bw); • Selection of the examination options; • Art. 5 examination; • Shows results of the Art.5 examination; • Shows results of the footnote examination; • Generates output reports in table and text format; • PFD calculations; • Satellite data and examination results are saved for future use. CoE SM Workshop Kiev- 2003

  28. Update Art.5 -1 CoE SM Workshop Kiev- 2003

  29. Select Service CoE SM Workshop Kiev- 2003

  30. Select FTN category CoE SM Workshop Kiev- 2003

  31. Test Art.5 CoE SM Workshop Kiev- 2003

  32. Select Satellite Select Stellite CoE SM Workshop Kiev- 2003

  33. Exam Art5 Фиг.1. Examination Art5 CoE SM Workshop Kiev- 2003

  34. Result Ftn Footnote Result CoE SM Workshop Kiev- 2003

  35. Results (short) CoE SM Workshop Kiev- 2003

  36. Results Group Level CoE SM Workshop Kiev- 2003

  37. Results with Services and FTN categories CoE SM Workshop Kiev- 2003

  38. Results test date and FTN CoE SM Workshop Kiev- 2003

  39. Results test areas and regions CoE SM Workshop Kiev- 2003

  40. a)Harmonization of the frequency tables As a result from the work done by the ITU WP4A “Software Rapporteur Group tools for Harmonization of the national and international Frequency Tables are proposed. Software tools and databases are developed an extension to this problem, to help the harmonization of the national and international frequency allocation tables. - Database with national frequency allocation table (MSACCESS). - Database with international frequency allocation table (MSACCESS). - Database with results of comparing the national and the international frequency allocation tables (MSACCESS). National and International frequency tables? CoE SM Workshop Kiev- 2003

  41. b)Harmonization of the frequency tables -Software tools for examination of the national and the international frequency allocation tables including: - Module with dialogs for updating of the national and international frequency tables. - Module with dialog for comparing two plans and for generating new result table for frequency overlapping and with extra fields for conditions of the frequency harmonization. - Module with dialog for examination and updating of the result table. - Module for generating output report on table and text format. All software modules and databases are connected to main navigating module for uninterrupted examinations CoE SM Workshop Kiev- 2003

  42. Фиг.4.5.1. Select Database CoE SM Workshop Kiev- 2003

  43. Фиг.3.1. Tables in frequency database CoE SM Workshop Kiev- 2003

  44. Фиг.4.5.2. Select necessary table CoE SM Workshop Kiev- 2003

  45. Фиг.3.3.1. Query for Harmonization CoE SM Workshop Kiev- 2003

  46. Fields in the result table ServID1 Service1 Ca1 Reg1 Users1 ReqMil1 CondUse1 SpecSysID1 DateFrom1 DateTo1 FootNote1 FrAl1 FrAl2 E_R2 ServID2 Service2 Cat2 Reg2 Users2 SpecSysID2 FootNote2 DateFrom2 DateTo2 IncompExt ActionDo DateFromHA DateToHA; Finance Notes CoE SM Workshop Kiev- 2003

  47. Фиг.3.4.1. Query for Result Table CoE SM Workshop Kiev- 2003

  48. Harmonization Examination The software examines the overlapping of the national and the international frequency allocation bands. The frequencies and the radio services are compared, Freq. Overlapping • Fn1- the lower limit of the national frequency allocation; • Fn2- the higher limit of the national frequency allocation; • Fi1- the lower limit of the international frequency allocation; • Fi2- the higher limit of the international frequency allocation. CoE SM Workshop Kiev- 2003

  49. a)Example of the result table CoE SM Workshop Kiev- 2003

  50. b)Example of the result table CoE SM Workshop Kiev- 2003

More Related