NAV: SLTechnology News&Howtos > Database >

• 

  Detailed explanation of sparkSQL actual combat

  If we want to really master sparkSQL programming, we must first have an overall understanding of the overall framework of sparkSQL and what problems sparkSQL can help us solve, and then have a clear understanding of each level of relationship before we can really master it.

  2022-06-01 12:00:42 Views: 221
• 

  Use Redis to record user online status

  Hash table (HashTable) is a data structure that implements key-value (Key-Value) mapping. According to Key, you can quickly find Value. And, no matter how many key-value pairs there are, the query time remains the same. Python's dictionary is based on ha.

  2022-06-01 12:00:41 Views: 259
• 

  The method of parsing complex json by Oracle

  At present, there is no system method that can be directly used to parse json in Oracle database (version before 11G). Most of the PLSQL scripts spread on the Internet can only parse json strings with single structure, but cannot parse json strings with complex structure. This leads to even if

  2022-06-01 12:00:11 Views: 220
• 

  Fast Note-taking 02-MySQL Master-Slave replication principle semi-synchronous Operation procedure and principle

  = one: MySQL master-slave replication planning master library: (MySQL master) IP:10.0.0.5

  2022-06-01 12:00:10 Views: 264
• 

  Oracle 11g snooping does not recognize errors

  When I installed oracle yesterday, I found that an unlistener error occurred when using pl/sql! Look up a lot of information on the Internet! It's all about changing the listening file, listener.ora file. But after I changed it, I still couldn't listen. I really don't understand! And then I...

  2022-06-01 11:59:58 Views: 290
• 

  Oracle database access

  1: after installing the ODBC-oracle driver, when configuring the data source, the user name and password given were used, and the error occurred: unable to connect SQLState=28000 [oracle] [ODBC] [Ora] ORA-0

  2022-06-01 11:59:58 Views: 239
• 

  Creating Database for Oracle Advanced Learning

  Write before: the default tablespace used by Oracle when creating users is User, which is generally not recommended because the default tablespace is fixed. If all the users we create use the default tablespace, it will lead to insufficient tablespace and point to the User table.

  2022-06-01 11:59:57 Views: 209
• 

  Oracle 11g R2 em garbled

  My system is redhat 5.564 bit, oracle is 11G R2oracle 11g using jdk1.5,jdk1.5, there is an easy way to solve this problem, as long as $JAVA_HOME/jre/lib/

  2022-06-01 11:59:57 Views: 298
• 

  Oracle RAC Study-delete VOTE DISK

  Oracle RAC Study-delete VOTE DISK environment: operating system: AIX 5300-09 Cluster Software: CRS 10.2.0.1 Database: Oracle 10.2.0.1 build RAC under AIX platform

  2022-06-01 11:59:54 Views: 292
• 

  MongoDB Sharding Learning Theory

  MongoDB Sharding technology is to solve the problem that a single MongoDB instance can not deal with with the increase of data and read and write requests in MongoDB. By using Sharding,MongoDB to split the data into multiple parts

  2022-06-01 11:59:31 Views: 208
• 

  Redis- is installed based on centos6 source code

  1. Background the previous chapter introduced memecached installation, this time introduced another star product of NoSQL-> redis. Many Web applications save the data to RDBMS, where the application server reads the data and displays it in the browser. But with the number

  2022-06-01 11:59:21 Views: 266
• 

  3 minutes, YUM upgrade MYSQL,5.1 to 5.6

  This article describes how to upgrade the version of Mysql through YUM (MySQL installed with YUM is version 5.1 by default) Environment: CENTOS6.9 original Mysql version: 5.1 New Mysql version: 5.6 time: within 3 minutes Note: do any

  2022-06-01 11:59:21 Views: 299
• 

  Oracle uses logmnr to analyze online redo logs

  Logmnr must be installed before it can be used. Installation steps: execute the following script to install @ ORACLE_HOME/rdbms/admin/dbmslm.sql@ORACLE_HOME/rdbms/admi as sys user login

  2022-06-01 11:59:21 Views: 227
• 

  Zabbix 3.2Monitoring deployment

  First, the preparatory work 1. System environment system: CentOS 6.8X86_64MySQL:5.7.12Apache:2.4.20PHP:7.1.4Zabbix:3.2.62. Environment required for installation [root@Kry133 ~

  2022-06-01 11:59:12 Views: 288
• 

  Mysql Master + keepalived High availability

  Mysql Master + keepalived High availability 1. Two hosts host:db1 external network: 11.0.0.51 intranet: 172.16.1.51db2 extranet: 11.0.0.52 intranet: 172.16.1.522.

  2022-06-01 11:59:12 Views: 224
• 

  AIX adds bare device data files to oracle

  Platform: AIX 5.3 has a free disk hdisk1 general idea: physical volume PV- > volume group VG- > logical volume LV (type: raw)-> add tablespace 1. View all available volume groups # lsvg-orootvg2. Create ORACL

  2022-06-01 11:59:12 Views: 298
• 

  The theory of sharing experience with MongoDB Replica Set

  MongoDB Replica Set is a master-slave replication and highly available scheme officially recommended by MongoDB, which is used to replace the original Master-Slave master-slave replication scheme. Replicat Set has automatic switching function, when Primary hangs up

  2022-06-01 11:58:51 Views: 281
• 

  [MongoDB Learning Notes 19] cursors and query options for MongoDB

  MongoDB uses cursors to process the result document set queried by find; examples of cursors: > var cursor=db.post.find ({"name.firstname": "joe"}) > cursor

  2022-06-01 11:58:51 Views: 229
• 

  Oracle Study-- Oracle wait event (3)

  Oracle Study-- Oracle wait event (3) Db file parallel read this is a very misleading wait event, but in fact it has nothing to do with parallel operations (such as parallel queries, parallel DML).

  2022-06-01 11:58:50 Views: 299
• 

  SQL SERVER database file deletion and partition formatting solution

  [failure type] Database file deletion, partition formatting, file size changed to "0", or when using backup to restore database, cover database [typical characteristics] ◎ database file (MDF, NDF or LDF) lost "suspect" state; ◎ database data is restored to early data; ◆ detection

  2022-06-01 11:58:50 Views: 277