NAV: SLTechnology News&Howtos > Database >

• 

  Basic concepts of HBase and common command usage of hbase shell

  1. HBase is a distributed, column-oriented open source database, derived from a paper by google, "bigtable: a distributed Storage system for structured data". HBase is an open source implementation of Google Bigtable, which uses Ha

  2022-06-01 10:26:56 Views: 294
• 

  Common operations of MongoDB

  Common operations of MongoDB

  2022-06-01 10:26:55 Views: 289
• 

  Oracle job has been running

  Use oracle's job to call stored procedures regularly, such as the stored procedure is trapped in a dead loop or other reasons, the state of job is running all the time. At this point, the stored procedure is called manually, and the stored procedure cannot be executed because the table is locked. At this point, you need to stop job. The command is as follows: B

  2022-06-01 10:26:55 Views: 219
• 

  Troubleshooting SQL Serer Latch and Latch timeout

  Troubleshooting SQL Serer latches and latch timeouts from: https://mssqlwiki.com/2012/09/07/latch-timeout-and-sql-server-latch/ in a multithreaded

  2022-06-01 10:26:46 Views: 288
• 

  ORA-01843: invalid month ORACLE import error

  The following date format error occurred during the import of ORACLE database: ORA-39083: object type TABLE failed to create, error: ORA-01843: invalid month login to two databases, query the date format of the two libraries, and found the exported imported

  2022-06-01 10:26:46 Views: 298
• 

  Oracle Series: (30) Flip-flop

  What is a trigger [Trigger]? For different DML (select/update/delete/insert) operations, the trigger can intercept to a certain extent, and the qualified operation can operate the base table; otherwise, the base table cannot be operated. Similar to JavaWe

  2022-06-01 10:26:34 Views: 221
• 

  Normal sequence of oracle 10G rac startup and shutdown

  [root@node-rac1 ~] # su-oracle close node-rac1 [oracle@node-rac1 ~] $cd / app/crs/product/10201/crs/bin/ [o

  2022-06-01 10:26:33 Views: 201
• 

  Oracle11g creates a tablespace for a user

  -- create a temporary tablespace create temporary tablespace sunbing_temp tempfile'd:\ oracle\ data\ ygz_temp.dbf' size 50m au

  2022-06-01 10:26:33 Views: 250
• 

  [MongoDB Learning Notes 16] query for MongoDB: regular expressions in find

  Find queries in MongoDB use Perl-compatible regular expressions perl regular expressions brief description: http://www.chinaunix.net/old_jh/25/159388.html example: > db.post.

  2022-06-01 10:26:33 Views: 224
• 

  Inception_web version installation

  Preface Inception is an automated database operation and maintenance system environment that integrates auditing SQL, performing SQL and rollback: system: centos 6.8Ip: 192.168.137.38Python:Python2.7 deployment steps: #

  2022-06-01 10:26:33 Views: 300
• 

  Oracle11G_ index

  Concept: a structure created to speed up queries, and tables are physically and logically independent of table data; index classification: B-tree indexes (unique indexes, combined indexes, reverse key indexes, function-based indexes), bitmap indexes; create indexes: USERS tablespace by default; analytical indexes:

  2022-06-01 10:26:26 Views: 297
• 

  Delete archive log script regularly under Oracle

  1. Error message A few days ago, the website was suddenly unable to visit, and the following error was reported: ora-27101: shared memory realm does not existora-01034: oracle not availa

  2022-06-01 10:26:26 Views: 224
• 

  Evolution of database architecture and sub-database and table

  When the volume of business in the production environment surges, the amount of database data will also increase greatly. When the amount of data in the database reaches a certain extent (database bottleneck), the load of the database host is too high, which will seriously affect the business and lead to database downtime. In order to avoid this extreme situation, we should do it again.

  2022-06-01 10:26:18 Views: 248
• 

  MSSQL creates a maintenance plan to automatically backup the database

  First, back up the database 1, click "manage -" maintenance Plan, right-click "New Task Plan" 2, and set the automatic execution time of the backup plan according to your own needs. Here I set the backup plan to be executed at 12 am every day. 3, add "backup database" plan 4, set up "backup data"

  2022-06-01 10:25:52 Views: 211
• 

  Install Mariadb

  Based on Centos6 installation, Centos 7 can be installed directly using yum. 1. Prepare mysql groups and users: groupadd-r-g 306 mysqluseradd-r-g mysql-u 306 my

  2022-06-01 10:25:22 Views: 219
• 

  CentOS 7.2 install zabbix 3.2

  System environment: LNMPLinux: Centos 7.2Nginx: 1.10.3Mysql: 5.6.35PHP: 5.4.16 install zabbix-server1 Repository installat

  2022-06-01 10:25:21 Views: 285
• 

  Naming Mechanism of MySQL Software

  Name example: mysql-x.y.z-suffixx: major version number. Y: minor version number. X and y together constitute a release serial number. Z: indicates the version number of a release sequence. Suffix: suffix, optional, alpha, beta, mN may appear

  2022-06-01 10:25:21 Views: 227
• 

  Centos 7 uses shell to achieve rapid installation of redis

  Use shell to write and quickly install the Redis service #! / bin/bashyum install cpp binutils glibc-kernheaders glibc-common glibc-devel

  2022-06-01 10:25:21 Views: 290
• 

  Why is the FILE RECORD size 0 after NTFS deletes more than 4G large files or database files

  Why is the FILE RECORD size 0 after NTFS deletes more than 4G large files or database files? Answer: when NTFS deletes a file, the following processes must be completed: 1. Change the file system $bitmap, free space 2, and change $mft.

  2022-06-01 10:25:21 Views: 274
• 

  Data Warehouse of Oracle Learning (2) understanding of Dimension

  In the data warehouse, there are two concepts: fact table and dimension table. The fact table is the central table in the data warehouse structure, which contains numerical measures and keys that relate to facts and dimension tables. The fact table contains data that describes specific events within a business, such as product sales. A dimension table is a collection of dimension attributes. It's an analytical question.

  2022-06-01 10:25:17 Views: 218