All Products
Search
Document Center

Database Optimization Service

Last Updated: Jun 28, 2018

1.       Scope of Services

Party B’s services are listed as below:

  • Based on the current situation and expectations of the database architecture of Party A’s business system (not big data applications), Party B’s expert team shall perform business and technical surveys, collect operation data and logs, collect configuration and architecture information, evaluate the database running status in the inspection scope, and provide the database optimization solution according to the expectations.

The following terms are not inluded in Party B’s services:

  • Development of the business system and big data applications;
  • Transformation and design of the specific application and database;
  • Application transformation, application design, and database logical structure design;
  • Migration of application systems not explicitly included “in the scope” of migration;
  • Migration of data not explicitly included “in the scope” of migration;
  • Design and setup of the cloud platform infrastructure and environment;
  • Communication infrastructure and components required for implementation;
  • Installation or configuration of electrical, electronic communication, and cabling infrastructure and components, and the provision of related support;
  • Installation or configuration of non-IT and desktop equipment, such as office furniture, printers, air conditioners, UPSs, and tapes.

2.       Prerequisites

  • If the Project is implemented on the premises of Party A, upon start of the Project, Party A shall provide the necessary office facilities, including desks and chairs, restroom facilities, mains power supply and outlets, and network cables. Party A shall ensure the personal safety of Party B’s personnel. The office environment provided by Party A shall be free of harmful gases. Outdoor environments provided shall be protected against inclement weather;
  • All work records and documents of the Project shall be in Chinese, and shall be provided as required by Party A. The electronic files shall be submitted in Microsoft Word, Microsoft PowerPoint, Microsoft Excel, or Microsoft Project format;
  • During the Project, Party A and Party B shall communicate with each other in a manner agreed upon by both parties. Optional communication methods include Internet, fax, email, or written communication;
  • Both parties have signed the site arrival report for the on-site service, and confirmed the service start time and end time.

3.       Service Content

3.1   Database Status Analysis and Evaluation

Party B’s expert team shall collect the usage and expectations of Party A’s database through surveys and technical tools, including, but not limited to, database-related business architectures, core business data processes, database read/write policies, database capacity, database/table sharding design, database master/slave or cluster design, different levels of database configuration parameters, database running logs and execution plan, and database storage policies and running indicators. By integrating rich cloud-based hands-on experience and best practices, Party B’s expert team shall also analyze the current situation, architecture, configuration, usage, and running indicators of Party A’s databases, evaluate the running efficiency, robustness, stability, and security of the databases, evaluate the limitations and risks of the databases, and fully master and understand database running condition and support for business to meet Party A’s needs for professional analysis and evaluation of cloud databases.

After database status analysis and evaluation, Party A shall be able to fully master all aspects of the IT system cloud database, master database limitations and risks, and lay the foundation for further database optimization.

3.2   Database Problem Diagnosis and Troubleshooting

The expert team shall collect the current situation related to Party A’s database problems through surveys and technical tools, including but not limited to database-related business architectures, core business data processes, database read/write policies, database capacity, database/table sharding design, database master/slave or cluster design, various levels of database configuration parameters, database running logs and execution plan, and database storage policies and running indicators. By integrating rich cloud-based hands-on experience and best practices, Party B’s database expert team shall also analyze the possible reasons of Party A’s database, diagnose the root causes of database problems, provide the specific solution, and instruct Party A in implementation to meet Party A’s needs for professional analysis and troubleshooting of the cloud database problems and faults in use.

After database problem diagnosis and troubleshooting, Party A shall be able to master the reasons for database faults, eliminate database problems, and master measures for troubleshooting similar problems in the future.

3.3   Database architecture optimization

Party B’s expert team shall collect the current situation related to the capacity, architecture, and performance of Party A’s database through surveys and technical tools, including but not limited to database-related business architectures, core business data processes, database read/write policies, database capacity, database/table sharding design, database master/slave or cluster design, various levels of database configuration parameters, database running logs and execution plan, and database storage policies and running indicators. By integrating rich cloud-based hands-on experience and best practices, Party B’s database expert team shall also analyze the capacity and usage, parameter configuration, response performance, and QPS indicators of Party A’s database, analyze reasons that may affect the database performance, set up the database capacity and performance optimization solutions, and instruct or assist Party A in database capacity and performance optimization to meet Party A’s needs for performance and capacity optimization of the cloud database.

After database capacity and performance optimization, Party A shall be able to improve stability and security of the database, which provides continuous and effective support to business development.

3.4   Database cloudification

Party B’s expert team shall collect information about Party A’s Oracle database through surveys and technical tools, including but not limited to usage of the Oracle database’s clusters, architecture, configuration, capacity, and business, database-related business architectures, core business data processes, database read/write policies, database capacity, database/table sharding design, database master/slave or cluster design, various levels of database configuration parameters, database running logs and execution plan, and database storage policies and running indicators. By integrating rich cloud-based hands-on experience and best practices, Party B’s database expert team shall also analyze the current situation of Party A’s database, select appropriate database and storage cloud products, and design the database deployment, use, optimization, migration, and cutover solutions to meet Party A’s needs for transformation and removal of the Oracle database.

After database cloudification, Party A shall be able to reduce the database authorization cost, and ensure the high-quality cloud database PaaS.

3.5   Distributed Database Architecture Transformation

Party B’s expert team shall collect the usage and expectations of Party A’s database through surveys and technical tools, including but not limited to database-related business architectures, core business data processes, database read/write policies, database capacity, database/table sharding design, database master/slave or cluster design, various levels of database configuration parameters, database running logs and execution plan, and database storage policies and running indicators. By integrating rich cloud-based hands-on experience and best practices, Party B’s expert team shall also analyze the current situation, architecture, configuration, usage, and running indicators of Party A’s database, evaluate the running efficiency, robustness, stability, and security of the database, design the database distributed architecture and transformation and cutover solutions for different stages meeting the expectations, and instruct or assist Party A in database distributed transformation to meet Party A’s needs for distributed transformation of the cloud database.

After distributed database architecture transformation, Party A’s application system and database shall have better performance, carry more data, and firmly ensure the sustained, stable, and fast business growth.

4.       Service Process

The process is described as follows:

Process

Description

Completion criteria

Project kickoff meeting

   Both parties negotiate and determine the stakeholders and contact persons of the Project, and determine the database information to be collected and the collection process.

   Prepare and compile the project kickoff meeting report.

Party B submits the “Kickoff Meeting Report”, Party A is responsible for holding the project kickoff meeting, and both parties reach an agreement on the content and objectives of the Project.

Collect the database information

  Collect cloud database information through surveys, interviews, and tools.

   Collect and submit the database status report.

Party B submits the “Database Status Report”, and both parties agree on the report.

Confirm the optimization solution

   Evaluate the database status by integrating the best practices, and provide the optimization solution meeting the development and business needs.

Party B submits the “Database Optimization Solution”, and both parties agree on the solution.

Optimize the database

   Optimize the database according to the optimization solution, and instruct the business system adjustment and development to adapt to the optimized database.

   Compile the database optimization implementation report.

Party B submits the “Database Optimization Report”, and both parties agree on the report.

Service acceptance

   Prepare and submit other documents related to the Project.

  Prepare the project acceptance report.

Party B submits the “Project Acceptance Report” and Party A signs the report to confirm acceptance.

5.       Project Milestones

The Project has five major milestones:

  • Project kickoff meeting: Alibaba Cloud submits the “Project Kickoff Meeting Report”, the customer is responsible for holding the project kickoff meeting, and both parties reach an agreement regarding the Project’s main content, implementation methods, and expectations.
  • Project solution report: Alibaba Cloud submits the “Database Optimization Solution”, and both parties reach an agreement regarding the Project’s implementation content, processes, steps, and plans.
  • Database optimization solution report: Alibaba Cloud submits the “Database Optimization Solution Report”, and both parties reach an agreement on the solution content.
  • Database optimization report: Alibaba Cloud submits the “Database Optimization Report”, and both parties reach an agreement on the optimization effect.
  • Project acceptance: After Alibaba Cloud submits the “Project Acceptance Report”, the customer shall confirm the content in the report within five working days and sign their acceptance comments.

[NOTE] The Project start time shall be subject to the time for signing the “Database Optimization Service Project Contract”.

Work content

Delivery time

Project kickoff meeting

 

Project solution report

 

Database optimization solution report

 

Database optimization report

 

Project acceptance

 

6.       Customer Responsibilities

  • The customer shall assign a project owner to help Alibaba Cloud smoothly provide the database optimization service. The project owner shall be responsible for coordination between the two parties, management of related matters, and review and acceptance of Alibaba Cloud services;
  • arty B’s project owner: The customer must provide the applications, databases, and other information relevant to the Project, including but not limited to technology stacks, big data tool software, application architectures, deployment architectures, data volumes, and performance information;
  • During Alibaba Cloud’s consulting services, if a fault occurs due to third-party software in the materials provided by the customer, the customer shall be responsible for negotiation with the third-party vendor to help provide the relevant information to Alibaba Cloud.

7.       Acceptance Criteria

Project acceptance can start after the following acceptance criteria are met:

  • Alibaba Cloud provides the customer with the following project reports:

No.

 

Document name

1

Acceptance

deliverables

Cloud Database Optimization Project Kickoff Meeting Report

2

Cloud Database Optimization Survey Report

3

Cloud Database Optimization Solution

4

Cloud Database Optimization Report

  • After these project reports are submitted, Party A shall confirm the solution within five working days. If no objection is raised, both parties sign the “Project Acceptance Report”;
  • Signing of the “Project Acceptance Report” is deemed as completion of project acceptance.

8.       Mark of Completion

The cloud database optimization is complete after project acceptance is finished and both parties sign the “Project Acceptance Report”.