Recently, I came into contact with Dameng database management system (DM8). DM8 is a new generation of self-developed database launched by Dameng company on the basis of summarizing the R & D and application experience of DM series products and adhering to the concept of open innovation, simplicity and practicality. DM8 absorbs and draws on the current advanced new technology ideas and the advantages of mainstream database products, integrates the advantages of distributed, elastic computing and cloud computing, and makes large-scale improvements in flexibility, ease of use, reliability and high security. The diversified architecture fully meets the needs of different scenarios, supports large-scale concurrent transaction processing and transaction analysis hybrid business processing, and dynamically allocates computing resources, Realize more refined resource utilization and lower cost investment. A database can meet users' multiple needs and enable users to focus more on business development.

First, introduce the characteristics of a dream database:

generality

DM8 is compatible with a variety of hardware systems and can run on X86, X64, SPARC, POWER and other hardware systems. The structure of DM on various platforms is completely consistent with the message communication structure, which makes various DM components have consistent use characteristics on different hardware platforms. Damon database management system products realize platform independence and support Windows series, various versions of Linux (2.4 and above kernels), Unix, Kylin, AIX, Solaris and other mainstream operating systems. All management tools of Damon database can be used on 32-bit /64 bit operating system.

High performance

It supports column storage, data compression, materialized view and other optimization options for online transaction analysis scenarios; Through the table level row storage and column storage option technology, online transaction processing and online analytical processing business scenarios can be supported in the same product.

High availability

Configurable data guard system (primary and standby), automatic and rapid fault recovery, and powerful disaster recovery processing capability.

Cross platform

Cross platform, support mainstream software and hardware systems (windows, Linux, kylin, Galaxy kylin and other operating systems), and support mainstream standard interfaces.

Highly scalable

Support the expansion of software packages and a variety of tools, and realize the expansion functions of massive data analysis and processing, data sharing cluster (DSC) and unshared database cluster (MPP).

install

1,Download installation package
2. Click setup Exe to install

3. Follow the installation steps step by step until the installation is successful

Database settings

Create user

create user test identified by wdd

Modify user password

alter user SYSDBA identified by SYSDBA

Query the current user's continuous login failure times and login failure limit login time (minutes)

select b.username,a.failed_num,a.failed_attemps,a.lock_time from sysusers a right join all_users b on a.id = b.user_id

Lock user

alter user wdd account lock

Unlock user

alter user wdd account unlock

Enable database audit function

SP_SET_ENABLE_AUDIT(1);

Set database ip white list

alter user wdd allow_ip "61.239.70.23","61.239.70.232";

Cancel database ip whitelist

alter user SYSDBA allow_ip null;

Set database ip blacklist

alter user wdd NOT_ALLOW_IP "61.239.70.23","61.239.70.232";

Cancel database ip blacklist

alter user SYSDBA not_allow_ip null;

View ip rules for all users

Select A.allow_addr,A.not_allow_addr,B.USERNAME from SYSUSERS A ,DBA_USERS B WHERE A.ID=B.USER_ID;

Basic grammar

Create data table

CREATE TABLE "SYSDBA"."STUDENT"
  (
 "SNO" INT,
"SNAME" VARCHAR(50) NOT NULL,
"SEX" CHAR(10) NOT NULL,
"DEPT" VARCHAR(200) NOT NULL,
"BRITH" DATE NOT NULL,
"AGE" INT NOT NULL,
PRIMARY KEY(SNO),
CHECK(SEX IN ('male', 'female'))
,CHECK(DEPT IN ('Department of Fine Arts', 'Department of automation', 'Department of Humanities and Social Sciences', 'Department of economic management', 'faculty of Mathematics', 'physics department', 'Aircraft design department'))
,CHECK(AGE BETWEEN 1 AND 100)) STORAGE(ON "MAIN", CLUSTERBTR) ;

insert data

insert into SYSDBA.STUDENT VALUES(1,'Xiao Wang','female','Department of Humanities','2022-05-19','18')
commit

View data

SELECT * FROM SYSDBA.STUDENT;

Modify data

UPDATE SYSDBA.STUDENT SET DEPT='Electronic information system' WHERE SNAME='Xiao Wang';
SELECT * FROM SYSDBA.STUDENT;

Delete data

DELETE FROM SYSDBA.STUDENT WHERE SNAME='Xiao Wang';