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:
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.
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.
Configurable data guard system (primary and standby), automatic and rapid fault recovery, and powerful disaster recovery processing capability.
Cross platform, support mainstream software and hardware systems (windows, Linux, kylin, Galaxy kylin and other operating systems), and support mainstream standard interfaces.
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).
1,Download installation package
2. Click setup Exe to install
3. Follow the installation steps step by step until the installation is successful
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
alter user wdd account lock
alter user wdd account unlock
Enable database audit function
Set database ip white list
alter user wdd allow_ip "18.104.22.168","22.214.171.124";
Cancel database ip whitelist
alter user SYSDBA allow_ip null;
Set database ip blacklist
alter user wdd NOT_ALLOW_IP "126.96.36.199","188.8.131.52";
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;
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 into SYSDBA.STUDENT VALUES(1,'Xiao Wang','female','Department of Humanities','2022-05-19','18') commit
SELECT * FROM SYSDBA.STUDENT;
UPDATE SYSDBA.STUDENT SET DEPT='Electronic information system' WHERE SNAME='Xiao Wang'; SELECT * FROM SYSDBA.STUDENT;
DELETE FROM SYSDBA.STUDENT WHERE SNAME='Xiao Wang';