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
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
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.
Focus on massive data set analysis
Running on the cluster computing archit ...
Posted on Sun, 14 Jul 2019 13:03:15 -0700 by Hillu
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
I. Configuring System Environment
1. View and install base packages
[root@localhost ~]# rpm -qa |grep make
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, Time Series Data, JSON, HSTORE, Array, range Index, BRIN Block Index, Time Sharing Trend, Linear Regression, MADlib, Machine Learning
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
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
1. Environmental Introduction
Operating System: Aliyun ECS
Database: Oracle 184.108.40.206 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
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
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