Introduction of quasi-real-time synchronization between Oracle and Hadoop cluster based on OGG

The structured data stored in Oracle is exported to Hadoop system for offline computing, which is a common data processing method. Recent scenarios need to do real-time import of Oracle to Hadoop system. Here is a case to introduce. As a commercial database solution, Oracle is difficult to acquire database transaction log spontaneously. Therefo ...

Posted on Wed, 17 Jul 2019 12:29:17 -0700 by ChaosXero

Oracle 12c Reading Notes (2): Oracle Database Architecture

  Analysis in 11g Database instances include: SGA and a series of background management, monitoring abbreviations The database contains three files: data file, control file, redo log file Database instances and databases are the core parts of Orale's database system   Oracle Server and Instance Example: consists of some in-memory and backgroun ...

Posted on Wed, 17 Jul 2019 10:30:23 -0700 by Jack_Slocum

Big Data Learning: Initial Use of Data Processing Tool Pig

brief introduction Pig is a large-scale data analysis platform based on Hadoop. It provides a SQL-LIKE language called Pig Latin. The compiler of this language converts data analysis requests like SQL into a series of optimized MapReduce operations. Characteristic Focus on massive data set analysis Running on the cluster computing archit ...

Posted on Sun, 14 Jul 2019 13:03:15 -0700 by Hillu

mybatis-generator-core custom modification to make it more suitable for domestic development environment

Customized modification of mybatis-generator-core is more suitable for domestic development environment, currently only tested under mysql. First, the main modification information is as follows: 1: Modify the English annotations generated by the original entity class into Chinese annotations in the database. 2: Change the original generated ...

Posted on Mon, 08 Jul 2019 14:48:12 -0700 by Smeep

oracle environment configuration and basic operations

I. Configuring System Environment 1. View and install base packages [root@localhost ~]# rpm -qa |grep make make-3.81-3.el5 automake16-1.6.3-8.el5.1 automake-1.9.6-2.3.el5 automake17-1.7.9-7.el5.2 imake-1.0.2-3 automake15-1.5-16.el5.2 automake14-1.4p6-13.el5.1 Installation of other base packages yum -y install make, glibc, libaio,compat-l ...

Posted on Mon, 08 Jul 2019 11:43:24 -0700 by ibelimb

PostgreSQL Securities Industry Database Requirement Analysis and Application

Label PostgreSQL, Securities, Time Series Data, JSON, HSTORE, Array, range Index, BRIN Block Index, Time Sharing Trend, Linear Regression, MADlib, Machine Learning background The securities industry produces more data, reading and writing is very frequent. Take stock trading for example, there are thousands of shares in total.There are abou ...

Posted on Mon, 08 Jul 2019 09:15:14 -0700 by WolfRage

Introduction to oracle stored procedures 1

     Stored procedures are combinations of SQL, PL/SQL, Java statements that enable you to move code that executes business rules from your application to the database. As a result, the code is stored once but can be used by multiple programs. It is a block of SQL statements stored on the database server, and its efficiency is 6-10 times high ...

Posted on Sun, 07 Jul 2019 20:00:55 -0700 by mp04

Diagnostic optimization of database performance problems caused by massive concurrent SQL

1. Environmental Introduction Operating System: Aliyun ECS Database: Oracle 11.2.0.1 ADG 2. Introducing knowledge points Firstly, we introduce some knowledge about binding variables. When Oracle parses and executes the target SQL, it finds the matching parent cursor in the database cache based on the hash value of the target SQL's SQL t ...

Posted on Sun, 07 Jul 2019 17:29:01 -0700 by amyhughes

java Learning Notes 14 - JDBC in-depth

The last chapter talked about the most basic operation of jdbc in java, which is deepened here. I. The difference between state and preparedstatement In jdbc, you can use state and preparedstatement to execute sql statements. The difference is that: If a state is to execute two sql statements, it generates two execution plans, and prepareds ...

Posted on Sun, 07 Jul 2019 16:54:01 -0700 by schoi

How iOS reads. db files

In the process of doing a project, we often encounter some large and fixed data processing, such as car brand, model, series, or regional list. These data have a common feature, that is, data will not change much basically, and the amount of data is relatively large, if from the request for service. Apparatus, will be very slow, performance is ...

Posted on Sat, 06 Jul 2019 13:00:41 -0700 by Phirus