Download D12 - MOME Interoperability Database

Transcript
MOME-WP1-0412-D12_INTEROP-DATABASE
Deliverable D12
001990
Monitoring and Measurement Cluster
Table of Contents
ABSTRACT........................................................................................................................................................... 1
KEYWORDS......................................................................................................................................................... 1
TABLE OF CONTENTS...................................................................................................................................... 2
LIST OF FIGURES .............................................................................................................................................. 4
LIST OF TABLES ................................................................................................................................................ 4
LIST OF ACRONYMS ........................................................................................................................................ 5
1
INTRODUCTION........................................................................................................................................ 7
2
REQUIREMENTS FOR TOOLS DATABASE ........................................................................................ 8
2.1 FUNCTIONAL REQUIREMENTS ..................................................................................................................... 8
2.1.1 The Web Server...................................................................................................................................... 8
2.1.2 The Database......................................................................................................................................... 9
2.2 SCALABILITY REQUIREMENTS .................................................................................................................. 10
2.3 SECURITY REQUIREMENTS ....................................................................................................................... 10
3
DATABASE PLATFORM ........................................................................................................................ 11
4
DATABASE SPECIFICATION ............................................................................................................... 13
4.1 DATABASE CONTENTS .............................................................................................................................. 13
4.2 FUNCTIONS ............................................................................................................................................... 13
4.3 TABLES AND STRUCTURE ......................................................................................................................... 15
4.3.1 The Tools table .................................................................................................................................... 15
4.3.2 The Tests table..................................................................................................................................... 16
4.3.3 The Comments table ............................................................................................................................ 16
4.3.4 The Uses table ..................................................................................................................................... 17
4.3.5 The UserAttributes table...................................................................................................................... 17
4.3.6 The MOME database........................................................................................................................... 18
5
IMPLEMENTATION................................................................................................................................ 20
5.1 FRONTEND ................................................................................................................................................ 20
5.2 CORE LOGIC ............................................................................................................................................. 20
5.3 DATABASE BACKEND ............................................................................................................................... 21
6
SYSTEM MANUAL .................................................................................................................................. 22
6.1 NON-REGISTERED USERS .......................................................................................................................... 22
6.1.1 Public access to the MOME databases ............................................................................................... 22
6.1.2 Searching in the Measurement tools database .................................................................................... 22
6.1.3 Browsing in the Measurements Tools database .................................................................................. 23
6.1.4 User registration ................................................................................................................................. 24
6.2 REGISTERED USERS................................................................................................................................... 25
6.2.1 MOME system Login/Logout............................................................................................................... 25
6.2.2 Adding new measurement tool entry.................................................................................................... 25
6.2.3 Modifying and deleting a measurement tool entry .............................................................................. 26
6.3 ADMINISTRATOR ...................................................................................................................................... 26
6.4 CHECKING THE DATABASE STATISTICS ..................................................................................................... 26
REFERENCES.................................................................................................................................................... 27
7
APPENDIX A: HARDWARE AND SOFTWARE REQUIREMENTS ............................................... 28
8
APPENDIX B: PRELIMINARY TESTS ................................................................................................. 29
24/01/2005
Page 2 of 31