NAV: SLTechnology News&Howtos > Database >

• 

  Ant Financial Services Group self-research database OceanBase how to reach the top of TPC-C

  On October 2, the International Affairs performance Committee (TPC) announced that in the newly released TPC-C ranking, Ant Financial Services Group's self-developed database OceanBase ranked first. InfoQ reporter immediately interviewed Ant Financial Services Group, a researcher and OceanB.

  2022-06-01 13:13:51 Views: 203
• 

  Three steps to start oracle

  The three steps of oracle startup oracle startup will go through three processes, namely, nomount, mount, open I, and nomount nomount phase. You can see that the instance has been started. The oracle process will be created based on the parameter file

  2022-06-01 13:13:47 Views: 273
• 

  SQL introduction Classic (5th Edition) Learning Notes (2)

  1. Judge right or wrong: personal social security number, input format is' 111111111111', it can be any of the following data types: fixed length characters, variable length characters, numeric values. An error cannot be that numeric quotation marks are converted to characters 2. Judge right or wrong: the scale of a numeric type refers to the totality of the numeric value.

  2022-06-01 13:13:47 Views: 241
• 

  Brief introduction of MySQL data deletion and recovery operation

  Brief description of MySQL database: before writing this article, we need to briefly understand the MySQL database: MySQL is an open source relational database management system (RDBMS). The MySQL database system uses the most commonly used database management language-structured query.

  2022-06-01 13:13:29 Views: 254
• 

  Sql statements for common operations of Oracle database

  1.Mel-create the tablespace create tablespace cmdb_db datafile'\ home\ cmdb_11.dbf' size 100m autoextend on next 50m ext

  2022-06-01 13:13:29 Views: 216
• 

  Installation of MyCli tools

  MyCli this is the python development of the mysql client Mini Program, can automatically complete SQL commands. Execute under CentOS: # yum install python-devel# easy_install mycli

  2022-06-01 13:13:26 Views: 219
• 

  Oracle data pump

  First, the advantages of data pump technology the original export and import technology is based on the client, while the data pump technology is based on the server. By default, all dumps, logs, and other files are established on the server. The following are the main advantages of data pump technology: 1, improved performance 2, the ability to restart jobs 3, parallel execution

  2022-06-01 13:13:17 Views: 289
• 

  Basic practice of Mongodb (2)

  In the previous article mainly introduced the MongoDB documents, collections, databases and other operations and the document add, delete, change related knowledge, and then will summarize some of the relevant knowledge of the query. In MySQL, we know that data query is the main content of optimization, read-write separation and other technologies are

  2022-06-01 13:13:16 Views: 272
• 

  A master-slave replication error resolution and the use of pt-slave-restart tools

  Reason: in the test environment, after the master library executes the DDL statement to increase the length of a field, the slave database report cannot modify the length of the field, and the length of this field is already between the original length and the target length. Environment 5.7.19 GTID dual master replication steps: 1. Try to make it by hand

  2022-06-01 13:13:16 Views: 209
• 

  On Linux_MySQL (mariadb) database (3)

  Server command: DDL: data definition language, mainly used to manage database components, such as tables, indexes, views, users, stored procedures CREATE, ALTER, DROPDML: data manipulation language, mainly to manage the data in the table to add, delete, change, query; I

  2022-06-01 13:13:09 Views: 204
• 

  How does xtrabackup back up the mysql database

  Reference: http://mingxiao.blog.51cto.com/8124243/1623634 1 complete 1. Command installation: yum install-y gnupgrpm-Uhv http://www.

  2022-06-01 13:13:08 Views: 275
• 

  Oracle batch columns are separated by commas

  Example: with temp as (select'1 names from dual union all select 2 nums 3 'nums,' a 'names from dual union all select' 4 meme 5')

  2022-06-01 13:13:08 Views: 245
• 

  MySQL cursor

  Cursor declaration cursor DECLARE cursor_name CURSOR FOR select_statement this statement declares a cursor. You can also define multiple cursors in a subroutine, but each cursor in a block must have a unique name.

  2022-06-01 13:13:07 Views: 208
• 

  Summary notes on common operations of Jedis

  Public class TestRedis {private Jedis jedis; @ Before / / Junit Note public void setup ()

  2022-06-01 13:12:37 Views: 214
• 

  Compile and install lamp-1 (mysql)

  Lamp layering mechanism: user-- [httpd protocol]-- apache-- [fastCGI protocol]-- php-- [mysql protocol]-- mysql layering advantage: Apache php and mysql are CPU-intensive services.

  2022-06-01 13:12:37 Views: 254
• 

  Data Dictionary of Oracle

  The data dictionary is the most important part of the oracle database. It provides some system information of the database. The data dictionary records the system information of the database. It is a collection of read-only tables and views. The owner of the data dictionary is sys users who can only perform query operations on the data dictionary.

  2022-06-01 13:12:37 Views: 210
• 

  Oracle 11G GoldenGate realizes one-way synchronization between Windows and Windows

  Oracle GoldenGate realizes one-way synchronization between Windows and Windows this experiment is carried out in win environment. The purpose of this experiment is to realize one-way synchronization between Windows and Windows through GoldenGate to recover the source and library.

  2022-06-01 13:12:37 Views: 211
• 

  Self-connection in database

  Today, Brother Qiang is going to share with you the knowledge of self-connection in the database. In the database design, how to express the superior and subordinate relationship of employees, and how to express the relationship between employees and subordinates? How to express the relationship between subordinates and subordinates? How is the relationship between parent and child nodes represented in the tree menu structure? In the forum post, Lord

  2022-06-01 13:12:36 Views: 202
• 

  Oracle manually delete the library

  When unable to use the graphical interface, we need to manually delete the database 1, manually delete the file system database 1. Stop listening to prevent the creation of new connections. At the same time, if em is configured in the database, you also need to stop $lsnrctl stop listener_name$.

  2022-06-01 13:12:36 Views: 291
• 

  SQL Server 2017 AlwaysOn on Linux configuration and maintenance (3)

  2.1 configuring REQUIRED_SYNCHRONIZED_SECONDARIES_TO_COMMIT affects default resource settings SQL Server 2017 introduces REQUIRED_SYNCHRONIZED_SE

  2022-06-01 13:12:18 Views: 301