-
编辑 删除
The Secrets of Oracle Bitmap Indexes
Overview Oracle's two major index types are Bitmap indexes and B-Tree indexes. B-Tree indexes are the regular type that OLTP systems make much use of, and bitmap indexes are a highly compressed inde...
-
编辑 删除
Oracle 10g正则表达式
ORACLE终于在10G中提供了对正则表达式的支持，以前那些需要通过LIKE来进行的复杂的匹配就可以通过使用正则表达式更简单的实现。ORACLE中的支持正则表达式的函数主要有下面四个： 1，REGEXP_LIKE ：与LIKE的...
-
编辑 删除
if-else-fi
[jerry@localhost bin]$ cat if-else.sh #!/bin/bashdirectory="./hard_one"if [ -d $directory ]; then echo "Directory exists"else echo "Directory not exits"fi[jerry@loc...
-
编辑 删除
#@ #$ #i
# "$#" number of args# "$@" all args [jerry@localhost bin]$ cat args_test.sh #!/bin/bashecho "This is all parameters: $@"echo "This is parameter one: $1"echo "This is the parameters number: $#"[jerry@...
-
编辑 删除
Arrays
#!/bin/bashARRAY=('debian','ubuntu','fedora')ELEMENTS=${#ARRAY[@]}for ((i=0;i<$ELEMENTS;i++)); doecho ${ARRAY[${i}]}done-----NOTE: there are double "(" and ")" after "for"----[jerry@localh...
-
编辑 删除
for loop
#!/bin/bashfor a in `seq 0 10`; doecho $adone[jerry@localhost bin]$ ./for_test.sh 0123456789101..10
-
编辑 删除
bash trap
#!/bin/bash# bash trap commandtrap bashtrap INT# bash clear screen commandclear;# bash trap function is executed when CTRL-C is pressed:# bash prints message => Executing bash trap subrutine !bashtrap...
-
编辑 删除
reading input to shell
!/bin/bashecho "Please type a word!"read wordecho "You just typed $word"echo "Please type two words!"read word1 word2echo "You just typed $word1 $word2"[jerry@localhost bin]$ ./reply_test.sh ./reply_t...
-
编辑 删除
xecuting shell commands with bash
#!/bin/bash# use backticks " ` ` " to execute shell commandecho `uname -o`# executing bash command without backticksecho uname -o [jerry@localhost bin]$ ./echo.sh GNU/Linuxuname -o
-
编辑 删除
global_variable VS local_variable &functional
#!/bin/bash#Define bash global variable#This variable is global and can be used anywhere in this bash scriptVAR="global variable"function bash {#Define bash local variable#This variable is local t...
-
编辑 删除
Hello world
#!/bin/bash# declare STRING variableSTRING="Hello World"#print variable on a screenecho $STRINGNOTE: There is no space around both sides of "=".
-
编辑 删除
Global Temporary Tables
Global Temporary TablesApplications often use some form. of temporary data store for processes that are to complicated to complete in a single pass. Often, these temporary stores are defined as datab...
-
编辑 删除
informatica 安装
1.先搜个种子然后下载之。2.点server文件夹安装server3.点client文件夹安装client4.DB用户名一定要有creat session权限，可以用system5.添加souce时没有oracle要先添加驱动（程序中添加）安装完毕，下次继续学习...
-
编辑 删除
dba_dependencies scripts
set lines 132select distinct owner, name, referenced_name from dba_dependencies where type in ('PACKAGE BODY','PROCEDURE','TRIGGER')and &...
-
编辑 删除
OLAP之全过程介绍（ETL过程）
经过多年来企业信息化建设，大部分都拥有了自己的财务，OA，CRM 等软件。这些系统都有自己的独立数据库，记录着企业运行情况某个方面的数据。但是单独看这些系统的报表，并不一定能对企业运行情况有全面客观的了解。...
-
编辑 删除
ETL增量抽取方式
ETL增量抽取： 要实现增量抽取，关键是如何准确快速的捕获变化的数据。优秀的增量抽取机制要求ETL能够将业务系统中的变化数据按一定的频率准确地捕获到，同时不能对业务系统造成 太大的压力，影响现有业务。相对全量...
-
编辑 删除
The Secrets of Oracle Bitmap Indexes
The Secrets of Oracle Bitmap Indexes Overview Oracle's two major index types are Bitmap indexes and B-Tree indexes. B-Tree indexes are the regular type that OLTP syste...
-
编辑 删除
Application Design Basics
Data Normalization: OLTP – 3NF DSS – 2NF Data Type Selection: Choose Correct Data Types Right from the beginning Reduce SQL manipulation and data con...
-
编辑 删除
2NF and 3NF
2NF and 3NFThe 2NF and 3NF are very similar--the 2NF deals with composite primary keys and the 3NF deals with single primary keys. In general, if you do an ER diagram, convert many-to-many relationsh...
-
编辑 删除
ORACLE入门之OLTP和DSS不同数据库设计
* 在线事务处理(OLTP=Online transaction Processing )应用程序ex. 订票系统，生产系统* 决策支持系统(DSS=Decision Suport System )应用程序ex: 数据仓库
