Shulou(Shulou.com)06/01 Report--

Hot information

1. The draft data security law will be unveiled soon: the system of hierarchical and classified data management and emergency disposal will be established.

[abstract] the draft data Security Law will be examined for the first time at the 20th meeting of the standing Committee of the 13th National people's Congress to be held from the 28th to the 30th of this month. The draft mainly includes: establishing the basic systems of data security management such as data classification management and risk assessment, monitoring, early warning and emergency disposal; defining the data security protection obligations of organizations and individuals who carry out data activities, implementing the responsibility of data security protection; adhering to equal emphasis on security and development, and stipulating measures to support the promotion of data security and development. Establish institutional measures to ensure the security of government data and promote the opening of government data. ‍

2. The localization of State Grid database is further! Yunnan Power Grid successfully launched Dameng database!

[abstract] on the evening of June 19, the enterprise-level "human resource management system" of Yunnan Power Grid Co., Ltd., owned by China Southern Power Grid, successfully switched to the online "domestic Dameng database". The system covers the whole province of Yunnan and serves 10W + users. This is another important achievement of domestic transformation and digital upgrading of Yunnan Power Grid recently after the upgrading of the "Integrated Management system" of the "61st" core information system was completed in September 2019.

3. Avatar database will be stationed in China to help more enterprises to make digital transformation.

[abstract] recently, Shenzhou GM officially settled in Huawei Yun Yan Xuan Mall, and released Avatar database management system V7.0 and Avatar original factory technical services and other products. Users can easily purchase Avatar database products quickly at Huawei Cloud strict selection Mall, without wasting time and energy on software procurement. At the same time, according to the needs of different concurrent users, different complexity and different data volume, users can freely choose the number of database deployment to save costs.

4. Mo Tianlun's message set likes and delivers books: "Architecture decryption: from distributed to Micro Services (2nd Edition)"

[abstract] recently, the Electronic Industry Press blog published a new book, "Architecture decryption: from distributed to Micro Services (2nd Edition)". This book deeply decrypts the development and principles of micro-services, cloud native, K8s, Service Mesh and so on: network, distributed systems, RPC, distributed storage, distributed computing, full-text retrieval and message queue middleware, micro-service practice, etc. Motian wheel unites the blog viewpoint and presents five books to everyone. (activity consultation Motianlun assistant Wechat: modb666)

Selected articles

1. How to convert Excel table data into MySQL loaded SQL file

[summary] in many cases, we need to convert Excel table data into sql files in order to insert database tables. Taking MySQL as an example, this paper introduces the method of transforming Excel table data into SQL file (the same is true of Oracle and other databases).

2. ORA-12547: TNS:lost contact causes the database to fail to start

[abstract] the database cannot be started by a customer, the monitoring status of the database is abnormal, and the asm instance of the database is also abnormal. Through diagnostic analysis, the startup failed after InstConnection:connect:excp OCIException OCI error 12547 was reported in the Asm startup process, and the sqlplus / as sysdba login will also have an error of TNS 12547. This paper introduces the detailed fault analysis and diagnosis process, as well as the detailed solution.

3. Fault handling of erroneous deletion of Redo Log files in Dameng database (DM7)

[abstract] this paper introduces the fault handling process of mistakenly deleting Redo Log files in Dameng database (DM7). Fault description: redo log redolog can only be added but not deleted, but has been deleted (and no database backup), how to pull up the database step by step. Solution: initialize the new library with the same parameters as the fault library, and modify the db_magic of the redolog of the new library to be consistent with the fault library. Then copy the new library redo log file to the failure library.

4. COVID-19 in Oracle: ORA-600 2252 is contagious from within the database

[abstract] A Weibo post by a foreign technical expert has aroused widespread interest among netizens about COVID-19 in Oracle, namely ORA-600 2252. ORA-600 2252 means that the SCN number calculated by Oracle for the transaction is an unreasonable value and cannot be specified, so the database service is interrupted. Oracle SCN is communicative, and if a database has an unusually high SCN, it will also be synchronized to all interconnected databases. Once the SCN limit is reached, the database transaction will not be carried out and will be limited to shutdown.

Practical information document

1. "Database Industry report: the Road to Database growth in China, Research on the deductive path based on Global Database Technology"-Dongxing Securities .pdf

[abstract] this document is the 2020 database industry report issued by Societe Generale Securities. According to the report, among global database enterprises, Oracle ranks first and Microsoft ranks second, while Chinese cloud vendors are equally dazzling, with Alibaba ranked 9th, Huawei and Tencent 11th and 13th respectively. In the domestic traditional database, there are obvious differences among the giants; cloud computing is blessed, and the cloud on the database becomes a turning point in the industry.

2. "performance bottleneck Analysis in Oracle stored procedures"-Huai Xiaoming. Pdf

[abstract] this document shares how to locate the performance bottleneck of stored procedures through the performance profiling tool. What are the common ways to write code that cause poor performance problems? How to quickly diagnose problems with stored procedures and improve the ability to write efficient stored procedures?

3. "performance tuning of Kunpeng Software"-Huawei .pdf

[abstract] this paper analyzes how to optimize performance from the characteristics of hardware, and introduces the idea of performance tuning (monitoring-analysis-optimization) and common performance acquisition tools through the case of MariaDB performance tuning.

4. "the practice of landing the core trading system of the domestic database bank under the new situation" .pdf

[abstract] at present, the core trading system of banks is mainly monopolized by a few manufacturers, how to break through the tight encirclement in this situation? This paper introduces the commercial experience of HTAP integrated distributed database EsgynDB in the core trading system of banks.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.