SIGMOD challenges paper: database issues in telecommunications network management

ABSTRACT

Various types of computer systems are used behind the scenes in many parts of the telecommunications network to ensure its efficient and trouble-free operation. These systems are large, complex, and expensive real-time computer systems that are mission critical, and contains a database engine as a critical component. These systems share some of common database issues with conventional applications, but they also exhibit rather unique characteristics that present challenging database issues. Major DBMS issues for network management include choosing the right data model, handling two different kinds of data in terms of integrity and recovery constraints, supporting temporal queries, satisfying real-time performance and high availability requirements, and several miscellaneous issues. Some of these issues have been investigated in various areas of database researches, but most of them largely remain in the research stage. Advances in these areas that result in actual integrated implementations for data-intensive, real-time and temporal applications are eagerly awaited.

REFERENCES

• Ahn 93: I. Ahn: SQL+T : a Temporal Query Language, Proceedings of the International Workshop on an Infrastructure for Temporal Databases, Jun. 1993.
• ANSI 86: American National Standard for Information Systems: Database Language - SQL, ANSI X3.135-1986, American National Institute, Inc., 1986.
• ANSI 89: American National Standard for Information Systems: Database Language - SQL with Integri# Enhancement, ANSI X3.135-1989, American National Institute, Inc., 1989.
• CCITT 92a: CCITI' Recommendation M.3010: Principles for a Telecommunications Management Network, 1992.
• CCITT 92b: CCITT Recommendation X.722, ISO/IEC 10165-4: Information Technology - Open #,stems lnterconnection - Structure of Management Information: Guidelines for the Definition of Managed Objects, 1992.
• ISO 84: International Standards Organization: Information Processing Systems - Open Systems interconnection - Basic Reference Model, 1984.
• Klever 88: S. Klever: The OSI Management Architecture: An Overview, IEEE Network, Mar. 1988.
• Klever 93: S. Klever: System Management Information Modeling, IEEE Communications Magazine, May 1993.
• Melton 93: J. Melton (editor): ISO-ANSI (Working Draft) Database Language SQL3, X3H2-93-091/YOK- 003, Feb. 1993.
• NMF 89: OSI Network Management Forum: Object Specification Framework, Sep. 1989.
• ODMG 93: Roderick G. Cattell , Tom Atwood, Object Database Standard: ODMG-93, Morgan Kaufmann Publishers Inc., San Francisco, CA, 1993
• OMNIPoint 93: OMNIPoint: Discovering OMNIPoint, Simon & Schuster, 1993.
• Ramamritham 92: K. Ramamritham: Real-Time Databases, International Journal of Distributed and Parallel Databases, 1992.
• Snodgrass & Ahn 86: Richard Snodgrass , Ilsoo Ahn, Temporal databases, Computer, v.19 n.9, p.35-41, Sept. 1986 [doi>10.1109/MC.1986.1663327]
• Snodgrass 90: Richard Snodgrass, Temporal databases status and research directions, ACM SIGMOD Record, v.19 n.4, p.83-89, Dec. 1990 [doi>10.1145/122058.122068]
• Soo 91: Michael D. Soo, Bibliography on temporal databases, ACM SIGMOD Record, v.20 n.1, p.14-23, March 1991 [doi>10.1145/122050.122054]
• Ulusoy 92: Özgür Ulusoy, Current research on real-time databases, ACM SIGMOD Record, v.21 n.4, p.16-21, Dec. 1992 [doi>10.1145/141818.141821]
• Yemini 93: Y. Yemini: The OSI Network Management Model, IEEE Communications Magazine, May 1993.

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT

Additional Classification:
  C. Computer Systems Organization
  C.2 COMPUTER-COMMUNICATION NETWORKS
      C.2.0 General
          Subjects: Data communications

  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.1 Logical Design
          Subjects: Data models
      H.2.4 Systems
          Subjects: Query processing

General Terms:
Design, Languages, Performance