Dameng database

The official version of Dameng Database is a high-performance database management system independently developed by Dameng Company. The latest version of Dameng Database has an advanced system architecture that takes into account massive data processing and security, greatly improving product performance. Dameng database management system supports big data management and analysis capabilities, is efficient and stable, and can fully meet the needs of core business systems of large and medium-sized enterprises.

Dameng database software introduction

DM is a new generation database product designed by Dameng Company based on summarizing the development and application experience of DM series products, absorbing the advantages of mainstream database products, and using JAVA-like virtual machine technology. Dameng Database is based on mature relational data models and standard interfaces. It is an efficient and stable database management system that spans multiple software and hardware platforms and has big data management and analysis capabilities.

Dameng database software functions

      high performance

​​Support “big data” applications, using DM Vertical and DM HFS dual-column storage engine, coarse-grained intelligent index, parallel query, multi-level data partitioning, materialized views, analytical functions, bitmap connection index and other advanced technologies meet the needs of massive data online analytical processing (OLAP) and support multi-machine and multi-core intelligent bidirectional Parallel loading, intelligent distribution of client data.

Using intelligent high compression technology, the compression ratio can reach 1:20, which can significantly reduce storage overhead, thereby helping customers significantly reduce the overall database investment cost.

   High availability

Configurable data protection system (active and backup), automatic and rapid fault recovery, and powerful disaster recovery capabilities.

   Cross-platform

Cross-platform, supports mainstream software and hardware systems, and supports mainstream standard interfaces.

   Highly scalable

Supports expanded software packages and a variety of tools to achieve massive data analysis and processing, shared database cluster (RAC) and shared nothing database cluster (MPP) and other extended functions, TB/PB level data analysis and second-level response.

      low investment

​​​​​Built based on high-end servers or ordinary servers, supports heterogeneous systems, and is extremely cost-effective.

      Easy to use

​​Easy to implement and manage, only requires 1/10 of the management cost of traditional databases, and is compatible with major business intelligence tools.

    other

Complies with SQL 92 standard, supports CREATE, ALTER, DROP and other DDL syntax, supports SELECT, INSERT, UPDATE, DELETE, etc. DML syntax supports single table and multi-table joint queries.

Complies with and supports CAPI, ODBC, JDBC, ADO.NET and other international interface specifications.

Dameng database software features

   Full text search

DM provides multi-text data retrieval services, including full-text indexing and full-text retrieval. Full-text indexing provides efficient support for complex word searches in string data. Full-text indexes store information about words and their positions in specific columns. Full-text searches use this information to quickly search for records that contain a specific word or group of words. DM's full-text index supports multiple languages ​​such as Chinese, English, and Russian.

      Multiple character set support

In order to achieve storage and access to multiple languages, Dameng database uses two encoding methods to store data. One is to store according to the system default encoding provided by the operating system, and the other is to use Unicode encoding to store. Because of Unicode's consistency, it has the potential to simplify the internationalization process of software in most cases. It eliminates the need to deal with multiple code pages, and because the encoding is multibyte, the extra processing caused by double-byte character sets is not necessary. Dameng database has been able to effectively support multiple character sets including Chinese, English, Russian, Korean, Japanese, etc.

   Physical data page size optional

The physical data page is the basic unit of data organization within the system. System's high-speed disk buffer, I/O, etc. are all performed in units of data pages. The DM system allows users to select any one of 4K, 8K, 16K or 32K as the page size when building the system to achieve optimal application system performance.

​Agent service and job scheduling

In the DM system, the agent service is a service that runs on the server side, schedules and executes jobs, and monitors alarms. Through it, users can automatically perform some management tasks, such as regular backups, error notifications, etc., to reduce the workload. The agent service must be started before jobs and scheduling can work properly. The agent service loads all system-defined jobs and schedules their execution based on their scheduling information. When a specific moment arrives, the job is started and each step it contains is executed in sequence. The proxy service not only monitors time events, but also monitors alarm events within the server. When the server generates a specific event during operation (such as an execution failure), the proxy service will detect the occurrence of this event and trigger the corresponding alarm.

​Multimedia and spatial information support

DM adopts innovative hybrid database models, expanded multimedia and GIS data types and other technologies to successfully realize the integrated definition, storage and management of spatial data, multimedia data and conventional data. It has obvious advantages in spatial geographical information and multimedia information management. Advantages. In addition, the DM system also provides functions such as hierarchical retrieval, limited retrieval, roaming, close-up, partial amplification, and overlay of geographical information.

Dameng database update log

​​ 1.Fix several bugs;

​​ 2. Optimize detailed issues;