Heterogeneous Actual Warfare of Data Subscribe and Convert Logs Based on canal

What is heterogeneous data processing? Simply put, in order to satisfy the expansion of our business, data is transformed from a specific format to a new data format. Why does this need arise? In traditional enterprises, data are mainly stored in relational databases, such as MySQL, but in order to meet the expansion of demand, the dimension ...

Posted by matthewhaworth on Mon, 14 Oct 2019 20:01:35 -0700

Analysis of php character checking from in_array

The pit of PHP in_array ps: Should be the pit of weakly typed languages php document As the name implies, in_array is to find out whether a value is in an array. problem Assuming the scene of the accident The test code for an sql injection is as follows: $type = $_GET['type']; $types = [2,3,4,5,6]; if(!in_array($type, $types)) { throw new Para ...

Posted by guttyguppy on Mon, 14 Oct 2019 06:50:32 -0700

Building Blog Based on Al egg Framework: Editing Articles

Related articles Blog Building Based on Al egg Framework (1) - Development PreparationsBuilding Blog Based on Al egg Framework (2) - Hello WorldBuilding Blog Based on Al egg Framework (3) - Registration and LoginBlog Building Based on Al egg Framework (4) - Privilege ControlBuilding Blog Based on Al egg Framework (5) - Top Navigation BarBuildin ...

Posted by synted on Mon, 14 Oct 2019 00:11:37 -0700

MySQL database master-slave synchronization process

Following up the following article: Backup database for introduction to MySQL database Installation environment instructions System environment: [root@~]# cat /etc/redhat-release CentOS release 6.5 (Final) [root@~]# uname -r 2.6.32-431.el6.x86_64 Database: Because it is a simulated environment, the master and slave libraries are on the same se ...

Posted by likethegoddess on Sun, 13 Oct 2019 20:22:25 -0700

oracle update operation one or two

os: centos 7.6 db: oracle 19.3 Preparation data Create table -- drop table tmp_t0; create table tmp_t0 ( id VARCHAR2(100), name VARCHAR2(100), memo VARCHAR2(100) ) ; -- drop table tmp_t1; create table tmp_t1 ( id VARCHAR2(100), name VARCHAR2(100) ) ; insert data insert into tmp_t0 val ...

Posted by nikosft on Sun, 13 Oct 2019 12:21:03 -0700

Hive Homework - Return the name of the student with the highest score for each course

Assignment: Return the name of the student who scored the highest mark for each course. t_score_data.txt zhangsan math:90,english:60 lisi chinese:80,math:66,english:77 wangwu chinese:66,math:55,english:80 Return the names of the students for each course and for the highest score chinese ...

Posted by nephish on Sun, 13 Oct 2019 10:23:26 -0700

Random Name Generation Method

 From: http://www.maomao365.com/?p=10025 Abstract: Following is the method of using sql script to generate Chinese names to share, as follows: Experimental environment: sql server 2008 R2 In our work, we sometimes need to generate random names in batches. The following will describe how to use sql scripts to generate random "names&qu ...

Posted by blui on Sat, 12 Oct 2019 10:49:27 -0700

Java in-depth learning: locks

Re-lockable: Simply put, repetitive locking is supported and reusable Features: Locks can be passed, methods can be passed recursively Objective: To avoid deadlock phenomenon. Code: public class Test implements Runnable { @Override public void run() { method1(); } public synchronized void method1() { ...

Posted by sentient0169 on Sat, 12 Oct 2019 02:54:36 -0700

ODI Consistency CDC (Last Update Date) Synchronized Data Operation Details

ODI operation details Consistent CDC (Last Update Date) Synchronized Data Add CDC 1. Check the database version DECLARE -- Validating KM options dbVersion1 NUMBER(2,0); dbVersion2 NUMBER(2,0); BEGIN -- Verify RDBMS version select case when upper(name) = 'COMPATIBLE' then to_number(substr(value, 1, instr(value, ...

Posted by sudhakararaog on Fri, 11 Oct 2019 19:05:52 -0700

MySQL does not open slave how to complete remote replication

1. Loading data in batches through remote binlog New business needs, online database data pulled to this time, but slave service is not allowed to open, database account of direct external network is not established, and the network of database external network can not be connected, so our test enviro ...

Posted by hwmetzger on Fri, 11 Oct 2019 08:05:50 -0700