SQL/MX Release 2.0 Best Practices

Project Planning 8
• Reviews queries
• Explains plans
• Is responsible for the physical design of the database based on accepted database design
principles
• Facilitates a transfer of information of the physical design of the database to customer personnel
• Thoroughly understands SQL/MX software technology and its application to a database that must
support database activities
• Understands the implications of the design on load, maintenance, and archive activities
• Works closely with the designer of the logical database to translate the design into an
implementation that meets the project objectives
Extract, Transform, and Load (ETL) Specialist
• Acts as the architect for the design of all NonStop operating system–based data loading, data
extraction, and transformation functions
• Develops functional specifications to be used by programmers to implement the architecture
• Oversees the implementation of the ETL architecture
• Thoroughly understands parallel processing principles and the NonStop operating system
application-development environment
• Thoroughly understands SQL/MX technology and its uses
• Understands various messaging formats (for example, XML)
Performance Consultant
• Provides in-depth knowledge of system-level performance and tuning
• Works closely with other HP consultants and architects to identify potential performance problems
and suggests corrective action
• Aids in the sizing of the system prior to implementation
• Has a thorough knowledge of NonStop operating system tools, such as Measure and HP Asset BMC
Database Communication Consultant (ODBC and/or JDBC)
• Has a specialized knowledge of LAN technology and of the ODBC/MX product or JDBC access
• Is responsible for configuration of the MXCS environment, physical placement of the MXCS Server
installation, and configuration on the workstations to be used by ODBC Server tools and utilities.
• Is responsible for the installation of the Java Runtime for NonStop SQL/MX
Operations and Systems Specialist
• Has general knowledge of operations management best practices
• Has a knowledge of NonStop operating system tools and their applicability to the project
• Has a knowledge of OSS tools and their applicability to the project
• Devises and oversees application and system backup functions
• Devises and tests data-recovery strategy
• Performs system software installation and configuration