Databases in Telecommunications II: VLDB 2001 International Workshop, DBTel 2001 Rome, Italy, September 10, 2001 Proceedings (Lecture Notes in Computer Science, 2209)

✍ Scribed by Willem Jonker (editor)

• Publisher: Springer
• Year: 2001
• Tongue: English
• Leaves: 187
• Category: Library

✦ Synopsis

Just like the previous workshop at VLDB 1999 in Edinburgh, the purpose of this workshop is to promote telecom data management as one of the core research areas in database research and to establish a strong connection between the telecom and database research communities. As I wrote in the preface of those proceedings, data management in telecommuni- tions is an interesting area of research given the fact that both service management and service provisioning are very data intensive, and pose extreme requirements on data management technology. Given the feedback on the previous workshop we decided to keep the same program set-up for this workshop: an invited speaker, a collection of research papers, and a panel discussion. We received 18 good quality papers from which we selected 12 to construct a very interesting program. The program has been divided into four sections. The first section focuses on CDR data warehouse and data mining technology. Data warehousing and data mining around customer usage data remains an important area of interest for telecommunication operators. The growing competition, especially in the mobile market, means that operators have to put more effort into customer retention and satisfaction. The second section focuses on performance issues around databases in telecommunication. Since telecommunication databases are characterized by their extreme requirements, for example in terms of volumes of data to be processed or response times, high volume data management and embedded and real-time data management are key aspects of the telecommunication data management problems in today’s operational environments.

✦ Table of Contents

Databases in Telecommunications II
Preface
Workshop Organizers
Table of Contents
Telecommunications, Databases, and Evolution
1 Three Epochs of Telecommunications
2 Model of Telecommunications: Networks, Hosts, and Society
3 Distributed Architecture: Mobility, Webs, and Communities
4 Communities of Machines: Remote Sensing and Control
5 Advances in Computing
Data Warehouse Population Platform
1 Introduction
Outline
2 Data Warehouse Population Platform Features
LSN Module – Input Data Dispatching
SDA Module – Shared Data Area
SYNC Module – Units Synchronization
LDR Module – Transforming & Loading Data
3 Case Study
4 Future Works
5 References
Experimenting NT Cluster Technology for Massive CDR Processing
1 Introduction
2 Case Description
2.1 Cluster Architecture
2.2 Database Schema
2.3 Application
3 Configuration
3.1 Approach
3.2 Cluster Configuration
3.3 Database Configuration
3.4 Experiment Configurations
4 Experiment Set-up
4.1 Manageability and Robustness
4.2 Scalability
5 Results of the Experiments
5.1 Manageability
5.2 Robustness
5.3 Scalability
6 Conclusions
Acknowledgements
References
Mining Sequential Alarm Patterns in a Telecommunication Database
1 Introduction
2 Preliminaries
2.1 Alarm Data in GSM
2.2 Procedure of Mining Alarm Sequential Patterns
3 Mining Sequential Alarm Patterns
3.1 Data Cleaning
3.2 Algorithm MSAP: Mining Sequential Alarm Patterns
3.3 An Illustrative Example for Mining Sequential Alarm Patterns
4 Experimental Results
4.1 The Impact of Data Cleaning
4.2 Experimental Results of Algorithm MSAP
Conclusions
Acknowledgement
Reference
Generalized MD-Joins: Evaluation and Reduction to SQL
1 Introduction
1.1 Related Work
1.2 Paper Outline
2 Preliminaries
3 Computing the GMD-join
3.1 The GMD-join Query Engine
3.2 Reducing GMD-joins to SQL
4 Optimizations
5 Comparison Studies and Experiments
6 Conclusion
References
Query Processing in Embedded Control Programs
1 Introduction
2 Embedded Control Programs: Case Studies
2.1 Case 1: The Linux Kernel
2.2 Case 2: A PBX
3 Resource Bounded Plan Generation: Foundations
3.1 Conceptual Schema Declarations
3.2 Query Compilation
4 Restricted Families of Integrity Constraints
5 System Architecture
5.1 Plans for Complex Queries
6 Summary Comments
6.1 Related Work
References
Benchmark for Real-Time Database Systems for Telecommunications
1 Introduction
2 Telecommunication Requirements
3 Benchmark
4 Test Transactions
5 Database Properties
5.1 Atomicity Tests
5.2 Consistency Tests
5.3 Isolation Tests
5.4 Durability Tests
5.5 Availability Tests
6 Computation of Ratings
7 Conclusions
References
Replication between Geographically Separated Clusters - An Asynchronous Scalable Replication Mechanism for Very High Availability
1 Introduction
1.1 TelORB
1.2 The TelORB Database System
2 Geographical Redundancy
2.1 A Quick Walk-Through: Passive Hot Standby.
2.2 Non-Blocking Wide-Area Replication Protocol
2.3 Scalability
2.4 Autonomous Site Configuration.
2.5 Consistency of the Standby
2.6 Minimum Latency
2.7 Compensating the Incompleteness of the Basic Replication
3 Related Work
4 Conclusions and Future Work
5 Acknowledgements
6 References
Yima: Design and Evaluation of a Streaming Media System for Residential Broadband Services
1 Introduction
2 System Architecture
2.1 Data Placement and Scheduling
2.2 Real-Time Multimedia Delivery
2.3 Client Buffer Management
3 Performance Evaluation
3.1 Experimental Setup
3.2 Results
4 Conclusions and Future Work
Acknowledgments
References
QuDAS: A QoS-Based Brokering Architecture for Data Services
1 Introduction
2 QuDAS Overview
3 Data services meta-data
3.1 Interfaces
3.2 Protocols
3.3 Tariffs
4. Broker
4.1 Catalogue for service meta-data
4.1.1 Interfaces storage
4.1.2 Protocols storage
4.1.3 Tariffs storage
4.2 Data Service Manager
4.3 Connection Manager
5. Billing data services
6. Managing access to data services
7. Discussion and Further Work
Acknowledgements
References
LDAP, Databases and Distributed Objects: Towards a Better Integration
1 Introduction
2 Problematic and Requirements
3 Research issues
4 Browsing and Query Facilities
5 Conclusions
Acknowledgements
References
Network Convergence Using Universal Numbers: The UPT Project
1 Introduction
2 UPT
2.1 UPT Architecture
2.2 TRC Architecture
2.3 TRC Processing Flows
2.4 Functionality & Requirements for TRC
2.4.1 Number Assignment & States
2.4.2 Number Portability
2.4.3 Performance & Availability Requirements
3 Discussion
3.1 Network & Database Traffic
3.2 End User Billing
3.3 Settlement
3.4 Privacy & Security
3.5 Quality of Service
4 Status & Future Steps
5 References
Toward Universal Information Models in Enterprise Management
1 Introduction
2 Five Problems in Management Information Modeling
3 From One- To Two-Tier Information Models
3.1 Two tiers: one UIM, several data models
3.2 Advantages of using two-tier models
4 A Research Agenda for UIMs
5 Related Work
6 Conclusion
Acknowledgments
References
Author Index