High CPU usage query & Adding Index

CASE: Specific query is consuming up CPU resource cause CPU Spike(100% usage) when the DB hit count is increased. Type: MSSQL 2012 In such a case, mostly the query is known, so it can be solved by creating index for this query. But in emergency status, when Application Designer is absent and when the instant response is needed by DBA… Read More »

220 total views, no views today

log truncate interruption – open transaction

http://yoonsy.tistory.com/26 Case: DB Type: MS SQL 2012 DB Recovery Model: Full One day, Growing DB log size is pressing the Disk space, it almost full. See the status of db files, the log file size has been increased very big though the transaction log backup task has been taking regularly. Once to handle this situation, just trying… Read More »

243 total views, 1 views today

Apache Giraph – From installation to Example execution

In this article, let me look into Apache Giraph and let’s run the example “SimpleShortestPathsComputation” First, look at the introduction of Giraph (http://giraph.apache.org/) Welcome to Apache Giraph! Apache Giraph is an iterative graph processing system built for high scalability. For example, it is currently used at Facebook to analyze the social graph formed by users and their… Read More »

429 total views, 1 views today

SSH / Key Setup for Seamless Authentication among AWS EC2 Servers

Prerequisite – In this post, it is supposed the EC servers to be exists the topic is related to the SSHD/SSH & Key concept Conditions – It is supposed that There are two EC servers The account of each server is default account, “ec2-user” URL of each server is ec1.compute.amazonaws.com, ec2.compute.amazonaws.com The default pem provided from AWS to… Read More »

967 total views, 1 views today

Data Mining Algorithm List Tree

related material: 『Data Mining』-written by Ian H. Witten Basic Data Mining Algorithm ├───Basic rule extraction: 1R ├───Statistical modeling: Simple Bayesian, Gaussian/Normal distribution (Numeric) ├───Divide-and-conquer method: decision trees ├───Association rule mining ├───Linear Model │               ├Mathmatical Prediction: Linear Regression │               ├Linear Category: Logistic Regression │… Read More »

682 total views, 1 views today

GMAIL SMTP Relay Test using openssl(Windows Environment)

텔넷을 사용하여 SMTP 통신 테스트 방법(SMTP Test over Telnet) How to send email using simple SMTP commands via Gmail? 윈도우 openssl 설치(Installing openssl for windows) OpenSSL for Windows: Download Open the command window and go to the bin folder under the openssl downloaded run commands below


Then test to send email using… Read More »

818 total views, 5 views today

Terms-C4.5(Pseudo Decision Tree Guidance System)

related material: 『Data Mining』-written by Ian H. Witten Category: Divide and conquer technique: Decision Tree Divide and conquer algorithms for Decision Tree So called “Top-down Pseudo Decision Tree Guidance Method Developed & improved J.Ross Quinlan(wiki)  The scheme based on the information gain is identical with the ID3 scheme basically The scheme which use the gain ratio is… Read More »

733 total views, 4 views today

Terms-Information gain ratio

related material: 『Data Mining』-written by Ian H. Witten Category: Divide and conquer technique: Decision Tree Information Gain Ratio : In Decision Tree structure, the creation of child node for a property is decided by the most biggest information gain. But the information gain is tend to prefer the property from which the more properties can be… Read More »

867 total views, 3 views today

Terms – information, bit

related material: 『Data Mining』-written by Ian H, Witten Category: Divide and conquer technique Information Caculating (Decision Tree) Rules yes or no: one of both is 0 – information value = 0 yes & no: Same number –  max information value Information follows multistage property For instance, in case of info([2,3,4]) , a data might belonged to… Read More »

754 total views, no views today

(한국어) [Poet] 절망

Sorry, this entry is only available in Korean. 709 total views, 1 views today

709 total views, 1 views today