Tandem Computers (Now HP)

NonStop SQL/MX Group

Tandem NonStop SQL/MX is an ANSI compliant Relational DBMS on Windows NT and specializes in handling very large database (VLDB) environments. The underlying architecture of this DBMS is highly distributed, parallel, and very much transaction oriented. Therefore, the database manageability tools had to address all the constraints and requirements that come with NonStop SQL/MX. Diyatech played a key role in providing not only architecture and design expertise but implementation, testing, and delivery as well.

Object Oriented Analysis, System Architecture, and Design

Diyatech provided expertise in architecture and implementation of an object-oriented framework for Tandem NonStop SQL/MX database manageability tools on Windows NT. Additionally, helped Tandem with the detailed design of various manageability tools, along with implementation of some. Requirement specification, object oriented analysis and design, implementation, and testing of various tools.

• Data Definition Object Layer (DDOL)

• Data Manipulation Objects (DMO)

• OLE Automation Server for Data Manipulation Objects (OLE DMO)

• Backup/Restore tool for NonStop SQL/MX on Windows NT.

• Import Tool for NonStop SQL/MX on Windows NT

• Configuration Management for multi-user and multi-project environment
  

Data Definition Object Layer (DDOL)

Designed an object-oriented class library (similar to Microsoft Data Access Objects – DAO) for all NonStop SQL/MX tools and utilities. This class library is used for accessing and manipulating meta data of the database. Implementation work shared with another engineer.

• Designed the subsystem using Rumbaugh's OMT Object Oriented Methodology and C++ as development language.

• Subsystem design consisted of over 20 C++ classes and around 10000 lines of C++ code.

• All development done in Visual-C++.
  

Data Manipulation Objects (DMO)

Designed an object-oriented class library (similar to Java’s JDBC) for all NonStop SQL/MX tools and utilities. This class library is used for accessing and manipulating data from the database. Implementation work shared with another engineer.

• Designed the subsystem using Rumbaugh's OMT Object Oriented Methodology and C++ as development language.

• Subsystem design consisted of 8 C++ classes and around 6000 lines of C++ code.

• All development done in Visual-C++.
  

OLE Server for Data Manipulation Objects (OLE DMO)

Designed an OLE Server to provide an OLE Automation Interface for DMO. The intention here is to provide various third-party tools a Tandem-specific way of accessing the data in the database.

• Designed the subsystem using Rumbaugh's OMT Object Oriented Methodology and C++ as development language.

• Subsystem design consisted of 6 C++ classes and around 2500 lines of C++ code.

• All development done in Visual-C++ using MFC for OLE Server development.
  

Import Utility for NonStop SQL/MX on Windows NT

Designed an object-oriented NonStop SQL/MX utilities for importing data in a VLDB environment (billions of records). This utility is initially command-line with future OLE Server and GUI front-end. Implementation work shared with another engineer.

• Designed the subsystem using Rumbaugh's OMT Object Oriented Methodology and C++ as development language.

• Subsystem design consisted of 10 C++ classes and around 10000 lines of C++ code.

• All development done in Visual-C++.
  

Multi-user and multi-project configuration management environment
Designed and implemented a configuration management system with MKS Korn Shell and Visual SourceSafe for a group of multi-user projects on Windows NT. The system included script-based automation for build and release process as well as versioning projects or sub-projects at different stages. The build and release process addressed dependencies that different projects had on each other.