NAV: SLTechnology News&Howtos > Database >

• 

  Introduction to the advantages and disadvantages of Relational Database and NOSQL Database

  Relational database: 1) the characteristics of relational database are:-data relational model is based on relational model, structured storage, integrity constraints. -based on two-dimensional tables and their relationships, data operations such as join, union, intersection, difference, division and so on are required. -use structured query language (SQL) to do data

  2022-06-01 06:56:35 Views: 220
• 

  [AlwaysOn2017] DMV and DMF-Sys.dm_hadr_auto_page_repair of AlwaysOn

  8 、 Sys. Dm_hadr_auto_page_repair returns one row for each automatic page repair attempt for any availability database on an availability copy hosted by any availability group on the server instance. The view contains the number corresponding to a given principal / auxiliary number

  2022-06-01 06:56:31 Views: 241
• 

  Optimize the deduplication operation of MySQL to the extreme three rounds in a row.

  Optimize the MySQL deduplication operation to the extreme three rounds (1): ingenious use of indexes and variables http://blog.csdn.net/wzy0623/article/details/54377986 experiment preparation: MySQL 5.6.1

  2022-06-01 06:56:31 Views: 230
• 

  Heartbeat+DRBD+MySQL High availability Architecture Scheme and implementation

  Experiment reference http://blog.csdn.net/qq_19175749/article/details/51607210 1, related software introduction 1. Heartbeat introduction official site: http://linu

  2022-06-01 06:56:29 Views: 239
• 

  Reinstall Oracle database Times error, port 1521 has been used as a workaround

  First, vi / etc/services queries the 1521 service, then use the dd command to delete, save and exit, and then check port 1521: netstat-tunlp | grep 1521 delete pid process: kill-9 process number

  2022-06-01 06:56:29 Views: 266
• 

  Database audit-Netwrix's SQLsever database audit tool is the first choice

  Database audit-the preferred Auduit for Netwrix SQLSever database audit concept audit, known as "audit" in English, checks and verifies the accuracy and completeness of targets to prevent false data and deceptive behavior, as well as compliance with established

  2022-06-01 06:56:25 Views: 246
• 

  Install MongoDB Enterprise 3.4.6 on SLES 11.3

  / MongoDB installation / the offline installation method of the rpm package is adopted here, and the networking installation method using http is not described in the official documentation, because in many cases the server is

  2022-06-01 06:56:24 Views: 283
• 

  Detailed explanation of innodb_autoinc_lock_mode parameters of MySQL self-increasing Lock Mode

  The parameter innodb_autoinc_lock_mode controls the behavior of associated locks when inserting data into tables with auto_increment columns; by setting it, we can achieve a balance between performance and security (master-slave data consistency).

  2022-06-01 06:56:24 Views: 281
• 

  Update misoperation in mysql, use binlog log to simulate oracle flashback function.

  Premise: binlog mode is row, isolation mode is read-committed misoperation for update, you can simulate the flashback function of oralce, use binlog log, the specific operations are as follows: mysql > select * fr

  2022-06-01 06:56:24 Views: 221
• 

  Query and Authorization of user roles in oracle

  System permissions owned by the user select privilege from dba_sys_privs where grantee='&USERNAME'union select privilege fr

  2022-06-01 06:56:24 Views: 299
• 

  Mysql Learning Notes 2 Mui-getting started

  -create database kakaxi mysql > create database kakaxi; Query OK, 1 row affected (0.02 sec)-to know which databases are in the system, you can make

  2022-06-01 06:56:24 Views: 206
• 

  Redis On Windows installation record

  Redis is a popular in-memory non-relational database solution. Relying on high performance, replication characteristics and problem-oriented data structure, it is more and more adopted and applied as the core component of the system. For most application environments, Redis is based on the Linux environment, but

  2022-06-01 06:56:23 Views: 272
• 

  SQL Profile (second article)

  Using SQL profile through SQL Tuning Advisor to SQL Tuning Advisor on 11GR2 has become very easy to use, and I like to give some very complex SQL statements to SQL Tuning Ad very much

  2022-06-01 06:56:23 Views: 278
• 

  How do I upgrade Oracle Grid Infrastructure and RAC from 11.2.0.3 to 11.2.0.4?

  How do I upgrade Oracle Grid Infrastructure and RAC from 11.2.0.3 to 11.2.0.4? The main steps to upgrade GI and RAC from 11.2.0.3 to 11.2.0.4: 1. Upgrade GI1)

  2022-06-01 06:56:23 Views: 205
• 

  Use SQL SELECT statements to retrieve data

  First, official Book → SQL Language Reference → 19 SQL Statements: SAVEPOINT to UPDATE → SELECT II, basic grammar SELECT {[di

  2022-06-01 06:56:23 Views: 245
• 

  OCP->047 (Les10 Creating Other Schema Object) [20171213]

  Purpose: to create simple and complex view views to retrieve data to create, maintain, and use sequence creation and maintenance indexes to create private and public synonyms database objects: ObjectDescriptionTableBasic unit of storage

  2022-06-01 06:56:22 Views: 271
• 

  [Case] result set exceeds the maximum size (100m)

  1. The problem phenomenon executes a select statement on PL/SQL Developer, and then a warning box pops up with the message: result set exceeds the maximum size (100m) if nece

  2022-06-01 06:56:21 Views: 202
• 

  ORA-14102: only one LOGGING or NOLOGGING clause may be specified

  ORA-14102: only one LOGGING or NOLOGGING clause may be specified problem: impdp recovers the database. The error in importing the index is as follows: ORA-39083:

  2022-06-01 06:56:16 Views: 309
• 

  Giant Sequoia Tech | using SequoiaDB distributed database to build JIRA process management system

  JIRA is a project and transaction tracking tool produced by Atlassian, which is widely used in defect tracking, customer service, requirements collection, process approval, task tracking, project tracking and agile management. Many enterprises and Internet companies are using Jira as an internal flow

  2022-06-01 06:56:08 Views: 247
• 

  Checksum check algorithm for sorting SQL SERVER data pages

  In versions above SQL SERVER2005, checksum is enabled by default on the data page, identified as m_flagBits & 0x200 = = True, and its value m_tornBits is located in the header 0x3CMagi 4 bytes. The algorithm is summarized as follows:

  2022-06-01 06:56:07 Views: 295