How DMS Can Save the Life of DBAs?

Development Phases of the DMS

  1. Flexible Management
  2. Stable Change
  3. Security Collaboration

What Should Be Streamlined Prior Schema Designing

How an organization wants the table
if
@fac.table_kind == 'new' and
@fac.table_name in ["add", "all", "alter", "analyze", "and", "as", "asc", "asensitive", "before", "between", "bigint"]
then
@act.block_submit "[R & D specification] table name is wrong"
end
Table having an unwanted name will be rejected
if
@fun.array_size(@fun.extract_index(@fac.table_index_array, ['Primary'])) < 1
then
@act.mark_high_risk 'Table has no primary key'
end
Environmental execution flow
  1. Set up the table design and its internal default architecture.
  2. Approval for execution.
  3. Once approved execute in the next environment.
  1. Table rules must be designed i.e. table default structure, remarks, unwanted names using DSL (Domain specific language).
  2. Approval Flow i.e. who will approve the request.
  3. Number of environment and their priority number.

Things That Should Be Streamlined Post Designing

Submitting data change request
Ticket to be approved
if
@fac.sql_count > 1000
then
@act.reject_execute 'The number of SQL statements executed at a time cannot exceed 1,000'
else
@act.allow_execute
end

Maintenance Operations

Use MPP Database with DMS to Generate Reports

Best Practices

Original Source:

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alibaba Cloud

Alibaba Cloud

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com