The 3GPP Status
database is a Microsoft Access relational database and application used to
monitor and manage most aspects of the Third Generation Partnership Project (3GPP).
It is intimately linked with other databases maintained by the 3GPP Support
Team (MCC) or the ETSI Secretariat. For example:
§ Directory Services
§ Work Programme Management
§ Meetings Registration
§ Liaison Statements
databases.
Some data is shared by means of linkage between the databases, whilst, for
reasons of portability and off-line use, some data is copied from one database
to another and requires periodic synchronization.
The file format of
the 3GPP Status Database is MS Access 2000. The programme code has been
developed under Access 1997, 2000, and 2003. Due to
backward-incompatibility between Access 2003 and later versions (2007, 2010,
...) it is essential to use Access 2003 as the user interface.
Furthermore, in order to minimize the number of warnings issued by Access, it
is strongly recommended that users disable error reporting, and modify
the security settings to allow the use of macros (and underlying code).
Note that the present user guide is not a guide to the use of Microsoft Access
in general; for such a guide, refer to Microsoft resources.
The master database
is under the control of the 3GPP Specifications Manager. The database
made available to other users (delegates, other members of MCC, external
people) are copies of a secondary master database. The secondary master
is refreshed from the master on a regular basis, and will seldom be more than a
few days out of date. This means that users can make changes to their
copy of the database (eg to perform what-iffing or to write bespoke queries)
without impacting the integrity of the master database.
The user interface
to the database is via a number of "control panels", which are colour
coded for ease of identification and use. Each is treated in the
following subclauses. Each control panel contains a number of buttons
which either display appropriate information (possibly opening another control
panel), or perform some action.
Note that not all
functionality is necessarily covered by buttons. Some functionality
requires the direct use of SQL queries or stored macros or programmes (coded in
Visual Basic for Applications, VBA). This user guide mentions only the
major buttons: the functionality of additional buttons is normally reasonably
self-explanatory by their labels and their grouping with related buttons.
From time to time, new buttons are added and, occasionally, ones which have
fallen into disuse are removed.
The main control panel (yellow) opens automatically when the database application is launched. On the top of the panel are buttons which give access to further control panels, plus two further buttons:
· search button, based on the spec number field
· restart button (for use of this button, see the procedure relating to adding new Specs records)
The main part of the panel consists of a list of all recorded Specs in numerical order, showing
· Spec number
· Title
· TSG/WG with prime responsibility
· Active/withdrawn flag
The text of records for withdrawn (or abandoned) Specs is in fainter font than those for active Specs. The title field for draft Specs appears in blue font until the precise text of the document itself and the database have been checked to be identical.
Pressing the "specs" button to the left of the Spec number opens a form set showing all information relating to the Spec concerned. (See §2.4.)
To quickly find the record for a particular spec, a search button at the top of the panel gives a rapid search facility.
This (turquoise) panel is opened by pressing the "useful things" button at the top of the main panel (§1.1.1).
The "help" button gives access to this user guide. The "what's new" button gives a list of important enhancemenets to the database, in reverse chronological order.
Most other buttons are self explanatory, and provide lists of information. A few are worth mentioning specifically …
The button "Titles for references" provides the full text of the reference entry, correctly formatted for direct copying-and-pasting into the References clause of TSs (and TRs).
The button "specs by Rapporteur" lists the specs for which each rapporteur is responsible. The button "Rapporteurs – all" lists all rapporteurs, with the number of Specs for which they are responsible.
The button "Specs by WG (for web)" lists all active Specs on a per-group basis. (The mention "for web" indicates that the underlying query is also used to produce the equivalent information on the corresponding web pages.)
A set of buttons "41.101 specs" and its neighbours generate the lists of specs in TS 41.101 etc maintained by the 3GPP Support Team (Specs Manager).
At lower right on the panel are buttons which give access to the New CRs panel and to the Statistics panel.
A button at the bottom right of this panel gives access to the Admin control panel.
The "meetings" button on the main panel opens a list of meetings of all 3GPP groups with all details. Most data is imported from the ETSI DS meetings tables, but certain fields are unique to 3GPP. Some fields, in particular:
are calculated automatically (as long as the folders and tdoc obey the usual rules for relative location and names).
Other information – for example, spec availability dates for TSG plenaries, satisfaction survey URL, … – have to be added manually.
A set of buttons at the foot of the meetings list allows the running of a number of stock queries.
The TDocs button on the main panel opens up the tdocs form (dark green). This offers a search for any tdoc (and to open it with a button click) and to list the tdocs from a particular meeting.
A sub-panel at the foot of the page allows new tdocs to be catalogued.
Administrative funtions (§2.2, 2.11) allow the application to search the TSG/WG document areas of the FTP server to discover new TDocs and to catalogue them under the appropriate meeting. A further function allows the automatic discovery of document title and source organization; this discovery function only works for TDocs in Word format, and makes some assumptions about the Word file layout. Other document types and Word files which do not conform to the usual layout cannot be processed.
A button on the main panel opens the Work Plan form. This is imported (manually) from the master work plan maintained in MS Project. The form shows all details, with records colour coded to show their hierarchical level.
A variety of buttons at the bottom of this form allow the running of certain queries, described under §2.11.
The dark blue statistics panel is accessble via a button on the right of the "useful things" panel. It contains buttons for running queries which present some of the most commonly used statistics which can be extracted from the database.
The pale red administrative functions panel is opened via a button on the lower right of the "useful things" panel.
The most commonly used area of this panel is the subpanel with buttons allowing the contents of certain database tables to be refreshed by synchronization with the ETSI DS and WPM databases.
A set of buttons lower left of this panel produce output from the database to be fed to ITU-T and ITU-R to update certain ITU Recommendations relating to IMT-2000 and IMT-Advanced.
A further subpanel can be used to run a standard set of quality checks on new, incoming specifications (following approval at TSG or the incorporation of newly approved CRs at TSG level).
Yet another subpanel generates the static web pages based on
the database contents, and exports them to the subweb at http://www.3gpp.org/ftp/Specs/html-info/
.