myTrace

애플, 어도비 플래쉬를 또 외면한 이유

2010-02-02T13:28:00.001+09:00

애플이 최근 발표한 아이패드에서도 어도비시스템즈 플래시 기술을 지원하는 것을 거부했다. 아이폰에 이어 아이패드 사용자들도 플래시 기반 콘텐츠를 이용할 수 없게 됐다.
스티브 잡스 애플 최고경영자는 아이패드가 동영상 감상에 있어 넷북이나 스마트폰보다 향상된 경험을 제공할 것이라는 점을 분명히 했다. 그러면서도 웹에서 돌아가는 동영상의 70~75%에 탑재된 플래시 지원을 거절했다는 점에서 그 배경에 비상한 관심이 쏠리고 있다.
아이폰 출시 이후 플래시 지원을 놓고 애플과 어도비는 불편한 관계였다. 어도비는 아이폰에 플래시를 넣고 싶어했지만 애플은 문호를 열어주지 않았다. 한때 아이폰에 플래시가 들어갈 것이란 신호가 포착됐지만 루머에 그쳤다. 애플은 결국 아이패드에서도 플래시에 대한 잠금장치를 풀지 않았다.전문가들에 따르면 아이패드에서 플래시를 지원하지 않는 것은 애플에게는 마이너스가 될 수 있다는 평가. 아이패드는 웹브라우징에 초점이 맞춰져 있다. 그런만큼, 플래시를 배제한 것은 사용성에 문제를 일으킬 수 있다.

CNN, 훌루, 디즈니 등 다수 웹사이트는 지금 플래시 기반이다.어도비도 공격모드로 나섰다. 아이폰에서 외면받았을때만 해도 어도비는 애플과 협력을 기대한다는 뉘앙스을 풍겼으나 아이패드에서도 거부당하자 사용자들은 웹콘텐츠를 제대로 이용할 수 없을 것이라고 경고했다.어도비의 애드리언 루드위그 플래시 플랫폼 매니저는 블로그를 통해 "애플이 아이패드에 플래시를 거부한 것은 아이튠스 서비스에서 사용자들이 콘텐츠를 이용하는 것을 통제하기 위한 것"이라고 지적했다고 뉴욕타임스는 전했다.

어도비는 현재 50개 이상의 파트너들과 협력해 개발자, 콘텐츠 업체들이 자신들의 콘텐츠를 다양한 기기에 접목할 수 있는 오픈스크린 프로젝트를 진행중이다. 디바이스에 상관없이 콘텐츠와 애플리케이션에 접근할 수 있도록 해주겠다는게 골자. 이를 감안하면 아이폰과 아이패드에서 플래시가 돌아가지 않는 것은 어도비에겐 부담스러울 수 밖에 없다.

애플은 아이폰에서 플래시를 지원하지 않는 것과 관련해 너무 무겁기 때문이라는 입장을 밝혀왔다. 아이패드에서 플래시를 거부한 것도 기술적인 이유와 무관치 않은 듯 하다. 애플 데스크톱과 노트북의 경우 현재 플래시를 지원하고 있다. 그러나 플래시로 인해 애플리케이션간 충돌 현상이 벌어진다는 지적. 애플은 아이패드에서도 비슷한 상황이 벌어지는 것을 우려하고 있다는 설명이다.플래시 지원에 따른 시스템 부하와 보안 문제도 거론됐다. 플래시 기반 콘텐츠가 배터리도 많이 잡아먹는다는 것도 문제로 꼽혔다.

애플은 플래시 대신 차세대 웹표준으로 주목받고 있는 HTML5를 주목하는 모습이다. 애플외에 유튜브와 비메오닷컴도 현재 HTML5로의 전환을 추진중이다. 플리커닷컴도 플래시의 대안을 고민하고 있다. 별도 런타임 SW를 깔아야 하는 플래시와 달리 HTML5는 웹브라우저에서 바로 돌아간다. HTML5가 확산될 경우 아이폰과 아이패드 사용자들은 플래시가 없어도 웹기반 동영상 콘텐츠를 이용할 수 있게 된다.그러나 HTML5는 아직 초기 단계다. 게임 제작이나 고급 동영상 기능 지원은 부족하다는 지적이다. 그런만큼, 웹을 HTML5 포맷으로 전환하는 과정은 쉽지도, 빠르지도 않을 것이라고 뉴욕타임스는 전하고 있다. 아직은 플래시가 개발자들에게 멀티미디어 프로그래밍 언어라는 것이다.그럼에도 뉴욕타임스는 많은 동영상 사이트에서 플래시의 대안으로 HTML5를 실험하고 있다는 것을 이유로 들어 플래시 공백에 따른 영향을 길지 않을 수도 있다고 분석했다.

Oracle Certification Program

2010-02-02T12:59:00.002+09:00

OTP (One Time Password)

2010-02-01T17:37:00.002+09:00

A one-time password (OTP) is a password that is only valid for a single login session or transaction. OTPs avoid a number of shortcomings that are associated with traditional (static) passwords. The most important shortcoming that is addressed by OTPs is that, in contrast to static passwords, they are not vulnerable to replay attacks. This means that, if a potential intruder manages to record an OTP that was already used to log into a service or to conduct a transaction, he will not be able to abuse it since it will be no longer valid. On the downside, OTPs cannot be memorized by human beings. Therefore they require additional technology in order to work.

걱정하지 않는 비결

2010-02-01T09:33:00.001+09:00

상당히 예민한 성격이어서
사소한 일에도 신경을 쓰고 걱정하는 사람이 있었다.

그런데 언제부터인가 그런 버릇이 씻은 듯이 없어졌다.
그의 친구가 물었다.

"이봐, 이게 어떻게 된 거야? 자네가 전혀 걱정을 하지 않게 되다니."
"하하하, 나대신 걱정해주는 친구를 하나 채용했어.
일주일에 백만원을 주기로 하고 그 친구를 채용했더니 걱정이 하나도 없어."

"뭐라고? 일주일에 백만원이나?. 도대체 그 많은 돈을 어떻게 마련하려고 그래?"

그러자 그가 밝게 웃으며 대답했다.
"그것도 그 친구가 걱정할 일이지."

Pranav Mistry: The thrilling potential of SixthSense technology

2010-01-11T17:27:00.001+09:00

죽을 때 후회하는 스물다섯 가지

2010-01-11T16:42:00.001+09:00

1. 사랑하는 사람에게 고맙다는 말을 많이 했더라면

2. 진짜 하고 싶은 일을 했더라면

3. 조금만 더 겸손했더라면

4. 친절을 베풀었더라면

5. 나쁜 짓을 하지 않았더라면

6. 꿈을 꾸고 그 꿈을 이루려고 노력했더라면

7. 감정에 휘둘리지 않았더라면

8. 만나고 싶은 사람을 만났더라면

9. 기억에 남는 연애를 했더라면

10. 죽도록 일만 하지 않았더라면

11. 가고 싶은 곳으로 여행을 떠났더라면

12. 고향을 찾아가보았더라면

13. 맛있는 음식을 많이 맛보았더라면

14. 결혼했더라면

15. 자식이 있었더라면

16. 자식을 혼인시켰더라면

17. 유산을 미리 염두에 두었더라면

18. 내 장례식을 생각했더라면

19. 내가 살아온 증거를 남겨두었더라면

20. 삶과 죽음의 의미를 진지하게 생각했더라면

21. 건강을 소중히 여겼더라면

22. 좀 더 일찍 담배를 끊었더라면

23. 건강할 때 마지막 의사를 밝혔더라면

24. 치료의 의미를 진지하게 생각했더라면

25. 아마... 종교를 몰랐던 것?..

Nexus One

2010-01-06T16:08:00.002+09:00

Blogumus : a flash animated label cloud for Blogger

2010-01-05T15:13:00.010+09:00

Update: Improved Widget Code

I have updated the code required to run this widget to activate links in the tag cloud Flash movie. If you have already installed Blogumus, please replace your widget code with the new updated code, or reference the additional lines to modify your existing installation.

How it works

This widget uses a combination of JavaScript and Flash animation to parse and display your blog labels. Once installed in your template, it should work "out of the box" without any additional tweaking required, though of course you may prefer to change the variables for color, background and size if appropriate :)

You should also be able to move the Label Cloud widget through the Page Elements page of your dashboard if you prefer display in a different layout location.

To see Blogumus in action, both Flash and Javascript must be installed and enabled for your internet browser. However, it does degrade relatively gracefully, and label links will still be clickable (though not animated) for those who do not use JavaScript of Flash (including search engine spiders).

How to install Blogumus in your Blogger layout

Installing Blogumus in your Blogger layout is surprisingly simple! You should only need to copy and paste a section of code to your Blogger template, though any tweaks for the style of display will require some manual editing.

Here are the steps required to install Blogumus in your Blogger layout:

Go to Layout>Edit HTML in your Blogger dashboard, and search for the following line (or similar):

<b:section class='sidebar' id='sidebar' preferred='yes'>

Immediatly after this line, paste the following section of code:

<b:widget id='Label99' locked='false' title='Labels' type='Label'>
<b:includable id='main'>
<b:if cond='data:title'>
<h2><data:title/></h2>
</b:if>
<div class='widget-content'>
<script src='http://halotemplates.s3.amazonaws.com/wp-cumulus-example/swfobject.js' type='text/javascript'/>
<div id='flashcontent'>Blogumulus by <a href='http://www.roytanck.com/'>Roy Tanck</a> and <a href='http://www.bloggerbuster.com'>Amanda Fazani</a></div>
<script type='text/javascript'>
var so = new SWFObject("http://halotemplates.s3.amazonaws.com/wp-cumulus-example/tagcloud.swf", "tagcloud", "240", "300", "7", "#ffffff");

// uncomment next line to enable transparency
//so.addParam("wmode", "transparent");
so.addVariable("tcolor", "0x333333");
so.addVariable("mode", "tags");
so.addVariable("distr", "true");
so.addVariable("tspeed", "100");
so.addVariable("tagcloud", "<tags><b:loop values='data:labels' var='label'><a expr:href='data:label.url' style='12'><data:label.name/></a></b:loop></tags>");
so.addParam("allowScriptAccess", "always");
so.write("flashcontent");
</script>
<b:include name='quickedit'/>
</div>
</b:includable>
</b:widget>

Then preview your template. If installed correctly, you should see the tag cloud appear in your sidebar. Then you are free to save your template, edit the colors and dimensions as required, or move it to a different location.

That's all!

Customizing Blogumus

In this default installation, Blogumus includes the following preset variables:

Width is set to 240px
Height is set to 300px;
Background color is white
Test color is grey
Font size is "12"

If you would prefer to make your widget wider, shorter, change the color scheme, etc, you will need to do this by editing various parts of the code. I'll go through these options in the order they appear in the widget code.

Editing width and height

The variables for width and height are found in this line of the script:

var so = new SWFObject("http://halotemplates.s3.amazonaws.com/wp-cumulus-example/tagcloud.swf", "tagcloud", "style="color: red;">240", "style="color: blue;">300", "7", "#ffffff");

The width (currently 240) is highlighted in red, while the height (300px default) is highlighted in blue. These numerical values specify the width and height in pixels, so you can alter these of you prefer.

Editing background color

You can change the background color from white to any other color by altering the hex value in the same line:

var so = new SWFObject("http://halotemplates.s3.amazonaws.com/wp-cumulus-example/tagcloud.swf", "tagcloud", "240", "300", "7", "style="color: red;">#ffffff");

For example, if you prefer a bright red background, you may replace #ffffff with #ff0000. Take a look at this page for a list of commonly used hex color codes.

Alter the color of text

By default, the text is set to display as dark grey ( hex value #333333). You can alter this variable in the following line:

so.addVariable("tcolor", "0xstyle="color: red;">333333");

Be aware that "tcolor" is a Flash variable and doesn't include the usual hash symbol of hex color codes. Be sure to only replace the numbers!

Adjust the font size

The maximum font size of tags is specified in this line:

so.addVariable("tagcloud", "<tags><b:loop values='data:labels' var='label'><a expr:href='data:label.url' style='style="color: red;">12'><data:label.name/></a></b:loop></tags>");

You can alter this to ensure tags are displayed in a bigger or smaller font if you prefer by changing "12" to a larger or smaller number.

While making any of these changes, you should be able to preview your widget and be certain that your new choice of color, dimensions and background are suitable for your needs.

What is difference between WIPI and WIFI

2009-11-25T15:53:00.014+09:00

WIPI is a middleware platform used in South Korea that allows mobile phones, regardless of manufacturer or carrier, to run applications. Much of WIPI is based on Java, but it also includes the ability to download and run compiled binary applications as well.

The specification was created by the Mobile Platform Special Subcommittee of the Korea Wireless Internet Standardization Forum (KWISF). The South Korean government had enforced that all cellular phones sold in that country include the WIPI platform to avoid inordinate competition between mobile companies, but the policy is withdrawn from April 2009

Wi-Fi is a trademark of the Wi-Fi Alliance that may be used with certified products that belong to a class of wireless local area network (WLAN) devices based on the IEEE 802.11 standards. Because of the close relationship with its underlying standard, the term Wi-Fi is often used as a synonym for IEEE 802.11 technology.

excerpted from wikipedia

50대 생활표준화 추진과제

2009-11-24T13:45:00.004+09:00

1 장례식장 서비스 인증 도입 2009
2 전국 지자체간 교통카드 호환 사용을 위한 표준화 2009
3 취업지원자의 편의증진을 위한 표준 이력서 개발 2009
4 건축물 클리닝 서비스 인증 도입 2009
5 맑은 수도물 공급을 위한 수도꼭지, 금속관 등의 수도용 제품 안전성 강화 2009
6 모바일 정보기기(휴대폰, PMP등) 문자입력방식 표준화 2010
7 진공청소기 먼지봉투의 표준화 2010
8 가전제품 공용 리모콘 표준 개발 2010
9 차량 운행정보 기록을 위한 블랙박스 표준화 2010
10 결혼식장 서비스 인증 도입 2010
11 차량수리센터 서비스 인증 도입 2010
12 소비자의 선택을 돕기 위한 고추장 매운맛 등급 표준화 2010
13 조립식 온수온돌 판넬제품 평가방법 표준화 2010
14 RFID기반 공용자전거 통합관리(대여·반납)시스템 표준화 2010
15 가전제품(TV,PC 등)의 무선통신 시스템 표준화 2010
16 모바일 USIM기반의 금융거래 보안 표준화 2010
17 건축용 샌드위치패널 화재 안전성 기준 강화 2010
18 건축물 구조 안전성 확보를 위한 레미콘 품질기준 강화 2010
19 경운기 브레이크등(燈) 표준화 2010
20 녹색 생활체육공간을 위한 인조잔디 표준화 2010
21 휴대용 멀티미디어기기 직류전원장치 표준화 2010
22 휴대폰용 배터리 표준화 2010
23 노트북 전원 어댑터 국제표준화 2011
24 김치냉장고 저장용기의 표준화 2011
25 엘리베이터 버튼위치 표준화 2011
26 공동주택 층간소음 완충재 성능 측정방법 표준화 2011
27 병원간 검사결과(X-ray,CT,초음파 등) 공동 활용을 위한 표준화 2011
28 "빨주노초파남보”알기 쉬운 색채표준 활용 확산 2011
29 의료 시험분석기관의 적합성평가체계 표준화 2011
30 고령자 및 장애인용 생활제품의 표준 개발 2011
31 사회적 배려계층의 안전과 편의를 위한 공공 그림표지 표준 확산 2011
32 차량내장재의 휘발성 유해물질 저감을 위한 표준화 2011
33 한방용 뜸 표준화 2011
34 요식업에서 사용하는 1인분 표준화 2011
35 전기자동차 충전시스템 표준화 2011
36 스마트그리드 기반 실시간 전기요금 관리체계 표준화 2011
37 전기자동차용 배터리 성능 및 안전성 평가방법 표준화 2011
38 서비스용 로봇 성능기준 표준화 2011
39 공기청정기 필터의 표준화 2012
40 최신 한국인 인체정보 확산적용을 위한 제품표준 정비 2012
41 노인요양시설 서비스 표준화 및 인증 도입 2012
42 산후조리원 서비스 인증 도입 2012
43 홍수, 테러 등의 재난대응 시스템 표준화 2012
44 범죄예방을 위해 공원 등 도시설계 표준 개발 2012
45 휴대용 심혈관질환 자가 진단용 바이오센서 표준화 2012
46 방범자재 성능기준 표준화 2012
47 도로교통 시설의 안전ㆍ편의성 향상을 위한 표준화 2012
48 고령자 및 장애인의 기기 활용 편리성 향상 표준화 2012
49 플러그인 하이브리드 전기자동차(PHEV) 연비측정 방법 표준화 2012
50 세제 적정량 사용을 위한 표준 개발 2012

excerpted from 지식경제부 기술표준원

Education Note (Adavanced JSP & Servlet)

2009-11-23T11:40:00.017+09:00

표준기술 - J2EE(Enterprise Edition), J2SE(Standard Edition), J2ME(Micro Edition), 기타 java, javax package
준표준기술 - Library(functional), Framework(architectural)

Layered Architecture Style
1. Presentation Layer
- 표준 : JSP/Servlet
- 준표준 : MVC Framework (Struts + Webwork -> Struts2, Spring MVC)
2. Business Layer
- 표준 : EJB
- 준표준 : Container Framework (Spring Framework)
3. Data Persistence
- 표준 : JDBC
- 준표준 : Data Mapping Framework(iBatis),OR Mapping Framework(Hibernate)

Enterprise System
- 다수의 Request 발생 -> User 증가 -> web(JSP/Servlet)
- 다수의 Transaction 처리 -> Distribute 환경 -> EJB

Servlet/JSP 주요 객체

Class Name	추상화 대상	획득방법	생성/소멸 시점	데이터 공유
HttpServletRequest	client 요청 data	service method의 argument	요청 시 생성 응답 시 소멸	하나의 요청이 끝날 때까지 공유
HttpServletReponse	client 응답 data	service method의 argument	요청 시 생성 응답 시 소멸	-
ServletConfig	web.xml의 Init Parameter data (runtime 시 변경되지 않으며 유지보수 시 사용하기 위한 환경설정	getServletConfig()	Servlet과 동일	-
ServletContext	Web App 대표	getServletContext()	Server 시작/종료 시 생성/소멸	모든 사용자의 모든 요청 시 공유
Cookie	client side 상태 정보값	new Cookie	-	-
HttpSession	server side 상태 정보값	request.getSession()	프로그램에서 제어	현 사용자의 모든 요청 시 공유
RequestDispatcher	다른 JSP/Servlet 실행 목적	context.getRequestDispatcher	-	-

Tools
Ant : XML 형식의 빌드 파일을 이용하여 Source Code 입력 이외 모든 것 자동화
Junit : 자동화된 단위 테스트 구현
Log4j : XML 또는 properties 로그 정책 명시

Custom Tag (Tag Library)
1. Script Tag : <%--, <%, <%=, <%!, <%@
2. Action Tag : <jsp:useBean [ getProperty | setProperty | forward | include...]
3. Custom Tag : 개발자들이 직접 Action tag를 정의, 여러 JSP에서 반복되는 긴 자바코드 or HTML을 Tag로 대체

Tag Comparison
1. <%@ include file="b.jsp" %> : static include (compile 단계), dynamic include에 비해 성능이 아주 약간 더 빠름
2. <jsp:incude page="b.jsp" /> : dynamic include, 변경 시 유지보수 용이, 동일 Web Application 내의 file만 참조 가능 ( ServletContext - RequestDispatcher 이용)
3. <c:import url="b.jsp" /> : dynamic include, 모든 서버 내 file 참조 가능 (Network Program으로 변경)

page redirection
forward 방식 : ServletContext - RequestDispatcher - forward, url 변경이 없으며 새로고침 시 본래 페이지로 이동, 이전 상태 데이터 획득을 위해 Request 객체에 의해 데이터 공유 가능
redirect 방식 : HttpServletResponse - sendRedirect, 브라우저가 현재 페이지의 응답을 client측에 전달하고 다른 페이지로 이동, url 주소 변경 및 새로고침 시 이동한 페이지를 다시 로딩, 이전 상태 데이터 획득을 위해 request객체 대신 Cookie 또는 Session 이용해야 함

J2EE Overview

2009-11-23T11:38:00.003+09:00

The Java History Timeline

2009-11-23T10:14:00.019+09:00

1991	The Green Project Begins MS DOS is the dominant operating system Cell phones weigh half a pound "Biosphere 2" project begins
1992	"Oak" is the language *7 Debuts "Duke" is featured in the Interface Johnny Carson signs off "The Tonight Show" on NBC
1993	The Green Project becomes FirstPerson Mosaic v1.0 is released "Cheers" ends an 11-year run
1994	WebRunner released — the first browser that supports moving objects and dynamic executable content The Apple QuickTake 100, the first consumer digital camera, goes on sale for less than $1,000 "Friends" debuts on NBC
1995	Java technology released to a select group on the Web site wicked.neato.org The San Jose Mercury News runs a front-page article about Java technology Name changed from "Oak" to "Java" Announced at Sun World -- Java technology is officially born
1996	The first JavaOne Developer Conference JDKtm 1.0 software is released Chess computer Deep Blue defeats Garry Kasparov for the first time "Dolly" the first cloned sheep is born
1997	Over 220,000 downloads of JDK 1.1 software occur in just three weeks JavaOne draws 8,000 attendees, becoming the world's largest developer conference Java Card 2.0 platform is unveiled 43% of U.S. families own a computer
1998	JDK 1.1 release downloads top 2 million Visa launches world's first smart card based on Java Card technology The Java Community Process (JCP) program formalized "Who Wants to Be a Millionaire?" premieres in the U.K
1999	Java 2 platform source code is released JavaOne draws 20,000 J2EE beta software is released "Star Wars Episode I: The Phantom Menace" released
2000	Over 400 Java User Groups are established worldwide Java Developer Connection program tops 1.5 million members Steve Jobs joins Scott McNealy on stage at JavaOne to announce a major commitment by Apple in support of Java technology Heavy Metal band Metallica sues Napster for copyright violations
2001	First international JavaOne conference in Yokohama Japan Over 1 million downloads of the Java Platform, Enterprise Edition (Java EE) SDK Google Inc. PageRank search algorithm patent awarded "The Lord of the Rings: The Fellowship of the Ring" is released
2002	J2EE SDK downloads reach 2 million 78% of executives view J2EE technology as the most effective platform for building and deploying Web services The Euro is introduced "The Osbournes" becomes a surprise hit on MTV
2003	Java technology runs in almost 550 million desktops Almost 75% of professional developers use Java programming language as their primary development language Commercial Voice-Over-Internet (VoiP) phone service begins "The Da Vinci Code" is published
2004	Java 2 Platform, Standard Edition 5 (Project Tiger) is released The Java technology-powered Mars Rover (Spirit) touches down on Mars Sun Java Studio Creator is launched
2005	Java technology celebrates its 10th birthday Approximately 4.5 million developers use Java technology Over 2.5 billion Java technology-enabled devices are available java.com bundles the Google Toolbar with the JRE download
2006	Rich Green announces at the JavaOne 2006 Conference that it's not a matter of when Sun will open source Java technology, but how. The NetBeans IDE 5.0 is released. Sun open-sourced Java EE components as the Glassfish Project to java.net. Java SE and ME initial components are released as open source. Pirates of the Caribbean: Dead Man's Chest is released.

from http://www.java.com/en/javahistory/timeline.jsp

개발자가 본 아이폰 '주목할 변화'

2009-11-20T17:44:00.001+09:00

애플 아이폰3GS의 출시와 함께 앱스토어(App Store) 시장도 빠르게 재편될 조짐이다.

또 아이폰3GS가 모바일 게임 앱에 특화된 성능을 갖추게 됨에 따라 모바일 게임시장서 3축을 이뤘던 소니, 닌텐도, ()의 경쟁판도에도 적잖은 변화가 예고되고 있다.

8일(현지시간) 애플의 스마트폰 차세대 모델인 ‘아이폰3GS’가 본격 발표됨에 따라 관련 앱스토어 개발자 사이에선 ‘3차원(D) 입체영상’ 중심의 게임 콘텐츠 개발이 활발히 진행될 것이란 의견이 힘을 받고 있다.

물 론 종전의 아이폰에서도 3D 영상은 지원됐으나 개발에 따른 제약조건이 컸다. 이날 소개된 아이폰3GS는 하지만 모바일 3D 표준엔진이자 최근 소개된 ‘오픈GL ES 2.0’ 버전을 탑재하고, 관련 성능들도 대폭 개선되면서 온라인 PC게임에서 보던 3차원 입체영상의 품질을 아이폰에서도 구현 가능하게 됐다.

앱(App) 개발 전문가인 이창신 ias(iNDI aPPLICATION sOFTWARE) 총감독은 “새로 출시된 아이폰3GS는 기존의 ‘오픈 GL-ES 1.1’ 칩셋에서 2.0 운영체제(OS)로 업그레이드 됐다.”라며 “2.0 OS는 플레이스테이션3(PS3)에서 봤던 최신의 3D 기술을 구현할 수 있으므로 모바일 디바이스 시장에서도 3차원 게임 개발 붐이 일어날 것”이라고 전망했다.

하지만 애플 발표회에선 1.1과 2.0간의 호환성에 대해선 별다른 언급이 없었다. 만일의 경우 종전의 디바이스에선 아이폰3GS에 적합하게 만들어진 게임 앱을 구동할 수 없을 수도 있다.

그러므로 앱 개발자는 제작포맷을 1.1과 2.0 버전 중에서 한 가지를 택하거나, 두 가지 버전을 따로 제작해야 하는 번거로움을 감수해야 한다.

이 에 관해 이감독은 “아직 구체적인 내용은 언급된 바 없지만 애플사의 입장에선 아이폰3GS에 초점을 맞춘 앱들의 등장이 차후 제품 교체시장으로 이어질 것을 기대하는 듯 하다”며 “항간에선 당장의 3차원 게임 앱 제작에 대한 공급량이 많지 않을 것으로 보여 이전 모델인 1.1과 새 모델인 2.0 칩셋에서 모두 이용할 수 있는 듀얼(Dual)시스템으로 갈 가능성이 농후하다”고 내다봤다.

이감독은 아울러 “조만간 아이팟터치 3세대 제품이 출시되면, 국내시장에서도 3차원 모바일게임들이 각광을 받게 될 것이다.”고 풀이했다.

▲ P2P 연결 기능은 멀티플레이어 게임을 가능하게 한다

하드웨어간의 연결성을 확보한 점도 앱 개발자들에겐 주목할만한 변화다.

아 이폰3GS는 제품간 연결을 와이파이(Wi-Fi)에 의존하던 틀을 깨고 P2P(peer to peer: 개인간 파일 공유)가 가능한 블루투스를 지원, 데이터를 더욱 손쉽게 주고 받을 수 있으며 연결된 기기간의 게임대결도 가능하다.

앱 개발자인 김동신 파프리카랩 대표는 “무선랜 환경이 갖춰지지 않았더라도 블루투스를 통해 다이렉트로 연결할 수 있어 게임 네트워크 구축이 더 용이해졌다”며 특히 애플사의 특정제품이 아니더라도 하드웨어간의 연결성을 열어둔 점에 큰 관심을 내비췄다.

즉, 아이폰3GS는 동종 계열의 아이폰이나 아이팟터치 뿐만 아니라 나 닌텐도 등 게임경쟁사의 리모컨이나 첨단 의료보조기기인 모바일 헬스케어와도 연결해 사용할 수 있다.

애 플 발표회에서 시연된 장면을 예로 들면 당뇨환자의 경우 혈당측정기를 아이폰에 연결해서 사용할 수 있다. 만일 환자에게 이상이 발생할 경우 아이폰3GS를 통해 인터넷상에 상태를 알리게 되고, 관련 처방을 인터넷에 연결된 메디컬센터를 통해 받을 수 있다. 아이폰3GS의 무선인터넷을 십분 활용한 것이다.

이 같은 기능은 아이폰용 소프트웨어개발키트(SDK)에서 외부 하드웨어와 액세서리간의 연결을 통제한 API 공개를 통해 가능하게 됐단다. 대부분의 모바일 디바이스간의 연결성을 고려해 게임이나 다른 애플리케이션을 제작할 수 있게 된 것이다.

김동신 대표는 “하드웨어간의 연결성은 소프트웨어 개발자들에겐 그간 개발 쟁점이었으나 아이폰3GS가 출시되면서 이 같은 기술과 노하우를 아이폰에 적용할 수 있게 됐다”며 “애플리케이션 실행속도가 이전보다 더욱 빨라지고, 배터리의 전력소비량도 늘어남에 따라 휴대폰이라기 보단 게임기에 더 가까운 아이폰으로 탈바꿈됐다고 표현하는 것이 맞을 것”이라고 말했다.

김대표는 또 “모바일 게임의 경쟁은 디바이스는 물론 콘텐츠에 의해서 좌우된다”며 “세계 유명한 게임 소프트웨어(SW) 개발자들이 참여하고 있으며, 잘 다져진 유통망과 개발사가 있는 한 모바일 게임시장에선 아이폰이 훨씬 유리한 고지에 있다”고 덧붙였다.

Why Cloud Computing is the Future of Mobile

2009-11-20T17:07:00.003+09:00

Written by Sarah Perez / August 4, 2009 8:50 AM

The term "cloud computing" is being bandied about a lot these days, mainly in the context of the "future of the web." But cloud computing's potential doesn't begin and end with the personal computer's transformation into a thin client - the mobile platform is going to be heavily impacted by this technology as well. At least that's the analysis being put forth by ABI Research. Their recent report, Mobile Cloud Computing, theorizes that the cloud will soon become a disruptive force in the mobile world, eventually becoming the dominant way in which mobile applications operate.

You may be wondering: what does the term "mobile cloud computing" really mean? Basically, it refers to an infrastructure where both the data storage and the data processing happen outside of the mobile device. Today, there are already some good examples of mobile cloud computing applications including mobile Gmail, Google Maps, and some navigation apps. However, the majority of applications today still do most of the data storage and processing on the mobile devices themselves and not in the cloud. In a few years, that could change.

Why Mobile Cloud Computing?

With a Western-centric view of the world, it can sometimes be hard to remember that not everyone owns a smartphone. There are still a large number of markets worldwide where the dominant phone is a feature phone. While it's true that smartphones will grow in percentage and feature phones will become more sophisticated in time, these lower-end phones are not going away anytime soon. And it's their very existence which will help drive the mobile cloud computing trend.
Not only is there a broader audience using feature phones in the world, there are also more web developers capable of building mobile web applications than there are developers for any other type of mobile device. Those factors, combined with the fact that feature phones themselves are becoming more capable with smarter built-in web browsers (and more alternative browsers available for download), will have an impact on mobile cloud computing's growth.

How Will Mobile Cloud Computing Become a Disruptive Force?

There are two primary reasons why ABI believes cloud computing will become a disruptive force in the mobile world. The first is simply the number of users the technology has the power to reach: far more than the number of smartphone users alone. The second reason has to do with how applications are distributed today. Currently, mobile applications are tied to a carrier. If you want an iPhone app, for example, you have to first have a relationship with the mobile operator who carries the iPhone. If you want a Blackberry app, the same rule applies. But with mobile clouding computing applications, as long as you have access to the web, you have access to the mobile application.

Moves by PaaS Players Could Change Everything

When you think of Plaform-as-a-Service (PaaS), one of the first companies that springs to mind is probably Salesforce. With their Force.com platform, business applications can be built and run "in the cloud." But Salesforce is not the only major PaaS player out there today - Amazon Web Services (AWS) and Google's App Engine are also two platforms that could have a major impact on this trend.
Currently, AWS is used by over half a million developers and Google's App Engine hosts 45,000 applications. Now imagine if those two companies along with Force.com all of a sudden started aggressively marketing their mobile capabilities. Today, neither AWS nor Google offers this, and Salesforce's mobile offering is limited to smartphones (Windows Mobile, Blackberry, and iPhone). But if the companies decided to make building for the mobile web as easy as building for the web, you could have a mobile revolution on your hands.

But People Like Apps!

Saying that "mobile cloud computing" is the future doesn't mean phones will be filled with links to websites that work in any browser instead of special, downloadable applications, some of which you can even purchase. Instead, mobile applications will exist in both formats. As for the downloadable applications themselves, they will still appear to be your typical mobile app - end users won't even notice a difference. However, there will be a difference - it will just be on the back-end. Mobile applications will begin to store your data in the cloud as opposed to on the mobile device, and the applications will become more powerful as processing power is also offloaded to the cloud.
The first mobile apps powered by the cloud will likely be business-focused mobile productivity applications where collaboration, data sharing, multitasking, and scheduling are key factors. For consumers, though, navigation and mapping applications will be the most obvious examples of the trend. Plus, there are some specialty applications today which already function as mobile cloud apps - for example, Schlage offers a remote keyless entry system which lets you mobilely control your home from a distance. You can let someone into your house, manage your lights, your thermostat, your camera system, etc. There are also a few applications in the iPhone app store that let you remotely manage your PC and your DVR, too.

Potential Problems

Of course, there are some potential issues that could be barriers to this shift in mobile computing. The most notable problem is the lack of speedy mobile Internet access everywhere. Here in the US, for example, 3G coverage is spotty outside urban areas, leading to intermittent connection issues and slow speeds. Other markets may have it even worse.
However, new technologies like HTML5, which does local caching, could help mobile cloud apps get past those sorts of issues. And there's even a chance that the browser could one day be replaced - at least in some markets - with another technology altogether which provides a better way to access the mobile web. ABI Research mentions initiatives like OMA's Smartcard Web Server, essentially a souped-up SIM card that connects directly with the carrier to push applications to mobile phones. There's also TokTok, a technology that allows access to web services like Gmail and Google Calendar by voice. With voice-enabled search like this, mobile apps could talk directly to the service itself which sits on the edge of the network, as opposed to needing the user to launch a web browser and navigate through the mobile web.

When Will Mobile Cloud Computing Really Take Off?

According to ABI, this change is only a few years away. By 2010, we'll see one or all of the major PaaS players marketing their mobile capabilities, they say. But first, API standards from open-source mobile collaboration group BONDI will go into effect. Later, in 2011, we'll see more of HTML5, and the OneAPI standard will come into play. (OneAPI involves standardized apps for networks allowing developers to consistently access parts of network providers' capabilities, such as location services). All these factors combined will help drive the move to the cloud.
The changes will occur with differing speeds depending on the market. Markets with higher Internet participation will obviously lead the way, as will markets with higher subscriber penetration. That includes Western Europe, North America, and parts of Asia. Other markets will then follow. By 2014, mobile cloud computing will become the predominant application development strategy. By that time, our PCs will be more like thin client devices than they are today, and now it seems our phones will too.

The Top Mobile Web Browser List By Daniel Nations, About.com Guide

2009-11-20T00:27:00.006+09:00

Mobile web browsers differ greatly in terms of features offered an operating systems supported. The best can display most websites and offer page zoom and keyboard shortcuts, while others can only display websites optimizes for mobile devices.
While some devices don't offer much of a choice in which mobile web browser you can use, many new devices are running operating systems like Windows Mobile that has several different mobile web browsers built for it. Mobile devices running the Symbian S60 also have a few choices for which mobile web browser you can use.

Opera Mobile

Key Features: Multiple tabs, Zoom-in
Operating System: Windows Mobile, Symbian
Price: $24

Watch this mobile browser in action.
Read the Review.

Opera Mini

Key Features: Compressed downloads for fast browsing, Zoom-in
Operating System: Java
Price: Free

Read the Review.

Skyfire

Key Features: Display rich websites with Flash or widgets like YouTube, customizable zoom feature
Operating System: Windows Mobile, Symbian
Price: Free

Watch this mobile browser in action.
Sign up for the Open Beta

Safari

Key Features: Display rich websites like YouTube, zoom feature, excellent touch-based user interface
Operating System: iPhone
Price: Free with iPhone

Watch this mobile browser in action.

Mozilla's Minimo

Key Features: Multiple tabs, Social bookmarking
Operating System: Windows Mobile
Price: Free (open source)

Google Android

Key Features: Display rich websites, zoom feature, touch screen interface
Operating System: Google Android
Price: Free with Android

Watch this mobile browser in action.

Bitstream's Thunderhawk

Key Features: Compressed downloads for fast browsing, Zoom-in display
Operating System: Symbian S60, Windows Mobile, Java
Price: $49.95/year or $5.95/month

Microsoft IE for Mobile

Key Features: Standard browser features
Operating System: Windows Mobile
Price: Free with Windows Mobile

Blazer

Key Features: Standard browser features
Operating System: Palm OS
Price: Free with Palm OS

S60 Web Browser

Key Features: Standard browser features
Operating System: S60
Price: Free with S60

reference image

2009-11-19T18:25:00.012+09:00

Useful links

2009-10-07T10:54:00.002+09:00

about JAVA API
eclipse plug-in

Changing Administrator name in Windows XP

2009-09-23T10:09:00.001+09:00

Start > run > control userpasswords2

How to set eclipse.ini file

2009-09-22T15:54:00.002+09:00

-startup
plugins/org.eclipse.equinox.launcher_1.0.200.v20090520.jar
--launcher.library
plugins/org.eclipse.equinox.launcher.win32.win32.x86_1.0.200.v20090519
-product
org.eclipse.epp.package.jee.product
-vm
C:\Program Files\Java\jdk1.6.0_16\bin\javaw.exe
--launcher.XXMaxPermSize
256M
-showsplash
org.eclipse.platform
--launcher.XXMaxPermSize
256m
-vmargs
-Dosgi.requiredJavaVersion=1.5
-Xms256m
-Xmx512m

Location Based Advertising

2009-09-16T16:14:00.001+09:00

What does location based (aware) advertising actually entail? Could you give some real life examples?

Location aware advertising opens up new frontiers for brands to place their advertisements in front of consumers at or near the place where they can obtain them ? thanks to the ubiquitous nature of mobile. In the most basic sense, if an ad server is made aware of a user?s location, then a decision can be made to deliver an advertisement based on either the user?s current location, or a history of where they have been, coupled with a user profile of their interests and previous purchases etc.

While the often used ?Starbucks example? sounds exciting ? you?re walking past a Starbucks and you get an SMS for a free coffee, it is unlikely that this would ever work in practice. Importantly in this example, Starbuck don?t discount their coffee, or have a loyalty program and in cities like London they are simply everywhere.

A more likely use case would be for a movie chain. They most likely will have a movie club and a list of subscribers who have opted in to receive movie news and discounts. If the movie chain wished to fill seats on a slow Thursday afternoon, they would want to know how many of these opted-in members are near one of their cinemas. Importantly, they do not want to know if they are actually at the cinema (then there is no point in sending them an offer as they are already there seeing a movie), but if they are close enough, and the offer is compelling enough (eg 50% off any movie in the next 30 minutes) then they are more likely to respond to the offer ? creating a very targeted, and instantly successful marketing campaign.

In the real world today though, the movie campaign example above would be difficult to execute. Let?s assume for a moment that all of the movie club members have GPS. What percentage of them have the GPS turned on (battery life is measured in hours when a mobile phone has the GPS on), and what percentage are not indoors, and hence able to provide a location fix? Also, how often would you need to check the location of each of these users to see if they are close to the cinema? What is the cost to the subscriber, or advertiser for each of these regular location requests, and how many are wasted if most of the movie club members are nowhere near a cinema. The same holds true (and in a more expensive way) if cell-ID is used, as each subscriber would need to be ?polled? on a regular basis (at a wholesale cost of an SMS) to see if they are near a cinema.

The most effective and efficient way to provide this sort of LBA is with zone detection, where some software resides on the handset, or the SIM card, loaded with all of the movie chain?s cinemas as profiles. Every minute or so, the software checks locally in the phone to see if it is near one of these zones, and if and only if they are ?in the zone? will a message be sent to the ad server. For LBA to take off, it must have an element of zone detection for the push-ad campaigns to work at all.

Starhub in Singapore have just released their own LBA service. Given the way they have designed the service, Starhub may find that in a very short period of time, their cell-ID servers are being overloaded with location requests to check if a user is near a particular store. Checking a subscriber?s location from the network side consumes massive amounts of network resources that are also required to send revenue generating SMS, voice and data traffic. It will be interesting to see how successful this service becomes, and what the return for Starhub actually is.

Location and advertising seem to be a match made in heaven ? what?s holding it back?

The ability to provide a user?s location in real time, at a reasonable price and with a reasonable level of accuracy and reliability is something that has eluded the mobile advertising space until now. Issues with the available technologies (cell-ID and GPS) and their suitability for location based advertising not being commercially or technically viable have been the main reasons for the delay.

With cell-ID, the inherent low accuracy of this solution (100?s of metres to tens of kilometres) coupled with the fact that an operator has to charge the equivalent of a wholesale SMS charge for each location request means that the use of cell-ID for LBA will never take off.

GPS on the other hand is being introduced into a number of new phones, but as a technology it is totally unsuitable for LBA because of the issues with high battery drain, inability to provide a fix indoors, and the time for an initial fix mean that for advertising GPS will never be a real contender. What is required is a technology that sits between cell-ID and GPS, and provides a relatively good level of accuracy without the need to add anything to the phone, or consume network resources by regularly checking a user?s location from the network side to see if they might be near an advertiser?s store.

Can location aware advertising exist without the operator?

Yes ? companies such as Google have shown clearly that they can provide a reliable operator-independent service. The latest version of Google Mobile Maps (GMM) has a feature called ?my location? which allows the user to find their current location on a Google map without dealing directly with an Operator. Google have cleverly deployed the application to enable those users who have a GPS device turned on to report back the cell-identifier (cell-ID) of the nearest mobile base station while the GPS enabled handset is using Google maps.

Google have developed a global database of this information which allows the majority of users who do not have a GPS handset to also pinpoint their location as the GMM application reports back the current, or ?serving? cell-ID and this is compared with the Google database and plotted on a map. Reports from many in the industry suggest that Google has developed their solution without any assistance from the operators.

One issue Google are already facing however is the cell-ID database integrity, as operators are known to change cell-ID numbers frequently, so Google?s system will have a lag as new cells are heard and need to be mapped into the database at the correct position. Clearly, the Google my location initiative has proven that location can be provided without the operator, and importantly, without the need for GPS.

The step for Google from placing a blue dot on a map, to pushing location based ads with their significant ad inventory should be a small and obvious one.

What measures can be put in place to avoid intrusion? Are consumers hesitant about location aware advertising?

There are many stories around about the potential for location based advertising to be perceived a SPAM. Hopefully operators, advertisers and marketers won?t just use raw location in their targeting criteria. Increasingly, consumers are becoming aware that the location of their mobile phone (and hence themselves) is now a reality, with the mass market availability of mapping and navigation services.

Early SMS services that sent unsolicited messages have made consumers very wary of mobile advertising solutions. Giving the end user total control to allow their location to be turned off in any application will give them confidence that they own their own location information. Opt-in and opt-out become even more important when location is involved.

So, what would be the ideal conditions for proximity advertising to really take off?

In general terms, there are 4 key areas of focus to ensure mobile advertising as a whole is a success.

1. Flat rate data plans for all. The UK and other markets have made a good start here, but the realisation by other operators that flat or low rate data plans WILL drive mobile advertising is key

2. A Common framework for mobile page rendering and addressing. Since the beginning of 2008, there is strong evidence that the ?m.? address is winning over .mobi, but the industry has a have a long way to go on the issue of page rendering to ensure mobile compatible pages are presented to mobile users.

3. Mobile location without GPS, but instead using zone detection. Existing location technologies available to day for mass market location are cell-ID from the network operator and GPS. Network cell-ID systems have not had any significant investment as there have been few positive business cases

4. Customer profiling. Smart collection and use of subscriber information goes hand in hand with location information. Location can be seen as one of many targeting and profiling inputs. If you already know I am a 39 year old male living in postcode W11 in London and I like gadgets and technology, the type of ad I am likely to respond to is fairly well defined. Layering this with real-time location information is icing on the cake as I am most likely to respond positively to an ad that is targeted correctly, and is sent to me when I am close to a location where I can take immediate action on the advertisement.

How do you see the future of location advertising? What will be both the technological and business changes?

For location advertising to really work, more work on the targeting and segmentation of subscriber data, as well as intelligence on user behaviour needs to be undertaken.

Recent initiatives by the GSMA & UK operators to explore delivery of cross-operator metrics for mobile advertising, as announced at the recent Mobile World Congress in Barcelona show the commitment from the operator community to make mobile advertising a success.

In terms of technology changes, new approaches to location around zone detection, where the entry or exit of a pre-defined zone is reported to an ad server rather than the exact location (speeding up the location fix as well as the time to select and serve the ad) will be key technical innovations to power location based advertising.

What standards need to be put in place for the respective players?

In countries such as the UK, there has been a code of conduct for location services for some time, however the existing code may not adequately address new uses for location for advertising. The most basic requirements will be for the end user to implicitly and overtly opt-in to receive location based advertising. The ability to easily opt-out of the same should be key also. Interchange of location information should also be standardised between operator and non-operator groups so that an easy to understand API can be used by 3rd party developers wanting to provide everything from ?mashups? to large scale advertising campaigns.

Flash Games

2009-08-12T20:54:00.001+09:00

How to add background or header image in Blogger/Blogspot

2009-07-27T10:41:00.007+09:00

Adding background or header image to blogger or blogspot is easy.
Just follow the following steps.

You can upload the image file to free host site like http://photobucket.com/
Get the Direct Link of uploaded image to add
Log in to Blogger
Go to Template then Edit HTML
Insert or Change image link URL wherever you want to add

in my case

#header-inner {border:1px solid #5d5d5e; background-position:center; margin:15px auto 0; background-image: url("http://i768.photobucket.com/albums/xx325/doyoung777/1.jpg"); background-position: left; width: 939px; min-height: 421px;_ height: 421px; background-repeat: no-repeat;}

compareTime.java (WAS & Database)

2009-07-24T17:30:00.005+09:00

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.Date;
import java.text.SimpleDateFormat;

public class compareTime
{
public static void main(String[] args)
{
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("Driver loading success");
}
catch (ClassNotFoundException e)
{
System.out.println("Driver loading fail");
}

try
{
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@IP:PORT:SID","ID","PASSWORD");
System.out.println("Connection Success");
System.out.println("");

Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select to_char(systimestamp, 'hh24:mi:ss:ff3') as time from dual");

System.out.println(getTime());

if (rs.next())
{
System.out.println("DB1 Time --> " + rs.getString("time"));
}

System.out.println(getTime());

conn.close();
System.out.println("");
System.out.println("Connection finished");
}
catch (SQLException sqle)
{
System.out.println("Connection fail");
}
catch (IllegalArgumentException ille)
{
System.out.println("IllegalArgument input");
}
}

private static String getTime()
{
SimpleDateFormat sdf = new SimpleDateFormat("kk:mm:ss:SS");

return "WAS1 Time --> " + sdf.format(new Date());
}
}

Changing the color scheme of MS Office 2007

2009-05-24T22:06:00.007+09:00

I just got to know today that you can change the color themes of your MS Office 2007.
There are 3 color themes.

Blue (default)

Black

Silver

Here's how you do it.

Open up any Office 2007 application.
Click on the Office Button.

Click on the option button. The option box will be open.

Click on the Popular tab(기본설정) and you'll see the color scheme selector.
Change your color scheme for Office 2007 and then click OK.
The selected color will be applied to Office 2007 (word, excel, powerpoint, outlook).

SQL

2009-02-26T09:49:00.005+09:00

1. sqlplus login

- sqlplus /nolog
conn /as sysdba
alter user hr identified by hr account unlock (sysdba) e
conn scott (default user : scott / tiger)
- disconn

2. Data Dictionary

desc table_name -> Column, Nullable, Type, Commnet
SELECT * FROM Tab -> 존재하는 테이블 확인 SELECT * FROM USER_TABLES -> 각 테이블 정보 상세하게 확인
COMMENT ON [TABLE/COLUMN] [table_name / table_name.column_name] IS '주석 내용'
- data dictionary
-comments 확인SELECT * FROM USER_TAB_COMMENTSSELECT * FROM USER_COL_COMMENTS

3. 연산
= 같다< > or != 같지 않다IS NULL IS NOT NULL

4. dual table
함수 값 사용 sysdate 또는 입력값 표시
SELECT sysdate FROM dual

5. CONCATENATION
SELECT ENAME " " JOB "ENAME JOB" FROM EMP;

=============================================

복원 지점 COMMIT복원 ROLLBACK
============= 여러 건 insert ================

INSERT INTO EMP (ENPNO, ENAME, JOB, MGR)SELECT 9000+rownum, ENAME, JOB, MGR FROM EMP;
================= ORDER BY ==================

default ASC (오름차순)DESC (내림차순)
ORDER BY Column_name DESC

=============================================

SELECT DEPTNOFROM DEPTWHERE EXISTS (SELECT 'X' FROM EMP WHERE DEPT.DEPTNO = EMP.DEPTNO)
-->
SELECT DEPTNO FROM DEPTWHERE DEPTNO IN (SELECT DEPTNO FROM EMP)

=============================================

subquery SELECT, FROM, WHERE 절에 모두 사용가능
================ JOIN =======================

- INNER JOIN (여러 테이블의 key 값이 일치하는 행에 대해서만 적용)SELECT [column] FROM [table 1] INNER JOIN [table 2] ON [JOIN CONDITION 1] AND [JOIN CONDITION 2]
부서위치가 DALLAS인 모든 사원의 이름, 부서번호를 출력.
SELECT e.ENAME, d.DEPTNO, d.LOC FROM EMP e INNER JOIN DEPT d ON e.DEPTNO = d.DEPTNO WHERE d.LOC = 'DALLAS'
- [LEFT/RIGHT] OUTER JOIN (LEFT/RIGHT 를 기준으로 JOIN 기준 테이블의 모든 key 값에 대해 적용)
- NON_Equi JOIN (CROSS JOIN)두 테이블의 같은 column 을 사용하지 않고 join
사원의 이름, 급여, 급여의 등급을 표시SELECT e.ENAME, e.SAL, g.GRADE FROM EMP e, SALGRADE g WHERE e.SAL BETWEEN g.LOSAL AND g.HISAL
================ inline view =====================================
-> 실제 존재하지 않는 테이블이지만 연산을 위해 가상으로 생성
부서평균연봉보다 많이 받는 사원의 이름과 연봉, 부서평균연봉을 조회
SELECT ENAME, SAL, DEPT_AVG FROM EMP INNER JOIN (SELECT DEPTNO, round(AVG(SAL)) AS DEPT_AVG FROM EMP GROUP BY DEPTNO) DEPT ON EMP.DEPTNO = DEPT.DEPTNO WHERE SAL > DEPT_AVG

============================FUNCTION==============================

DECODE - Oracle 함수 ( = CASE WHEN)
DECODE(column_name, value,
CLERK -> GOOD / ANALYST -> NOT GOOD / BAD
SELECT JOB, DECODE(JOB, 'CLERK', 'GOOD', DECODE(JOB, 'ANALYST', 'NOT GOOD', 'BAD')) as test FROM EMP
-->
SELECT JOB, CASE JOB WHEN 'CLERK' THEN 'GOOD' WHEN 'ANALYST' THEN 'NOT GOOD' ELSE 'BAD' END as test FROM EMP
2000까지 A 4000 까지 B 나머지 C
SELECT GRADE, LOSAL, HISAL, CASE WHEN HISAL< salgrade ="=" emp ="=" 1="2" dept =" 10" table_name =" 'DOYOUNG'"> table_name

====================== sequence ==================================

연속적인 숫자값을 자동으로 증가/감소 시켜야 할 경우 자동으로 숫자를 발생시키는 객체 즉, 시퀀스를 생성한 후 호출만하면 연속적으로 번호를 (오라클에서) 증가/감소시켜 제공해 준다. CREATE SEQUENCE [시퀀스명] [INCREMENT BY n] [START WITH n] [MAXVALUE n NOMAXVALUE] [MINVALUE n NOMINVALUE] [CYCLE NOCYCLE] [CACHE NOCACHE]
생성 : CREATE SEQUENCE EMP_seq START WITH 3300 INCREMENT BY 100 MAXVALUE 9900 NOCHACHE NOCYCLE
확인 : SELECT * FROM USER_SEQUENCES삭제 : DROP SEQUENCE sequence_name
함수: sequence_name.nextval sequence_name.currval
======================== 여러 테이블 조인 ===================================
-LOCATIONS, DEPARTMENTS, JOBS, EMPLOYEES 테이블 조인
SELECT E.FIRST_NAME, D.DEPARTMENT_NAME, J.JOB_TITLE, L.CITY FROM LOCATIONS L, DEPARTMENTS D, JOBS J, EMPLOYEES E WHERE L.LOCATION_ID = D.LOCATION_ID AND E.DEPARTMENT_ID = D.DEPARTMENT_ID AND E.JOB_ID = J.JOB_ID
->
SELECT E.FIRST_NAME, D.DEPARTMENT_NAME, J.JOB_TITLE, L.CITY FROM LOCATIONS L INNER JOIN DEPARTMENTS D ON L.LOCATION_ID = D.LOCATION_ID INNER JOIN EMPLOYEES E ON E.DEPARTMENT_ID = D.DEPARTMENT_ID INNER JOIN JOBS J ON E.JOB_ID = J.JOB_ID
- IN 절로 EMPLOYEES 테이블과 DEPARTMENT 테이블을 조인
- employee 테이블을 조회하면서 부서이름을 조회하고 싶은 경우 스칼라 서브쿼리 사용 작성
SELECT E.FIRST_NAME, (SELECT D.DEPARTMENT_NAME FROM DEPARTMENTS D WHERE D.DEPARTMENT_ID = E.DEPARTMENT_ID) DEPARTMENT_NAME FROM EMPLOYEES E
--> OUTER JOIN과 동일
SELECT E.FIRST_NAME, D.DEPARTMENT_NAME FROM EMPLOYEES E LEFT OUTER JOIN DEPARTMENTS D ON E.DEPARTMENT_ID = D. DEPARTMENT_ID

========================== VIEW =============================

- 부서별 평균연봉 뷰
CREATE VIEW DEPT_AVG_SAL_VIEW AS SELECT D.DEPTNO, D.DNAME, E.SAL_AVG FROM DEPT D, (SELECT DEPTNO, AVG(SAL) SAL_AVG FROM EMP GROUP BY DEPTNO) E
- 뷰를 이용해서 부서의 평균 급여보다 적은 급여를 받는 사원 조회
SELECT E.ENAME, E.SAL, V.SAL_AVG FROM EMP E INNER JOIN DEPT_AVG_SAL_VIEW V ON E.DEPTNO = V.DEPTNO WHERE E.SAL < sal_avg ="=" index ="=" index_name =" ix.index_name" table_name =" 'EMP'" index_name ="=" recursive ="=" empno =" MGR" mgr =" prior">

UNIX Command (Solaris)

2009-02-16T15:51:00.011+09:00

UNIX Directory Commands

mkdir [name] : Makes a directory of file group name

cd [directory] : Changes the working directory

pwd : Displays working directory

mv [file1]..[fileN] [directory] : moves file1,..,fileN to directory

cp [file1] [directory]/[file2] : copies [file1] into [file2] in directory [directory]

rmdir [directory] : Removes or erases empty directory

UNIX File Commands

ls -[option] lists files
lists files in 'long format', which contains lost of useful information, e. g.
- l the exact size of the file, who owns the file and who has the right to look at it
and when it was last modified.

ln -[option] filename(to link) filename(to generate) Link file generate (hard link)
-s symbol link

mv filename new_filename rename file(s) and directory(ies)
mv filename directory move file(s) and directory(ies)\
cp filename1 filename2 copies a file

rm -[option] filename(s)
-i Prevent the accidental removal(interactive)
-f Remove files whether write-protected or not
-r Recursively remove directories and subdirectories in the argument list

cat > file_name : 파일에 내용 덮어씌우기
cat >> file_name : 파일에 내용 이어 붙이기
touch file_name : 빈 파일 생성

Setting for Using Intel IPP(Integrated Performance Primitives)

2008-09-18T02:59:00.001+09:00

1. Setting Environment Variables

- Add the path to related Intel IPP files to the existing list, for example:

Select LIB and then type in the directory for the Intel IPP stub libraries (default isC:\Program Files\Intel\IPP\5.3\ia32\stublib),

Select INCLUDE and then type in the directory for the Intel IPP header files(default is C:\Program Files\Intel\IPP\5.3\ia32\include),

Select PATH and then type in the directory for the Intel IPP binaries (default isC:\Program Files\Intel\IPP\5.3\ia32\bin).

2. Configuring Microsoft Visual Studio Environment

- Select Tools > Options > Projects > VC++ Directories

select Include Files, and then type in the directory for the Intel IPP include files (for example, default is:C:\Program Files\Intel\IPP\5.3\ia32\include),

select Library Files, and then type in the directory for the Intel IPP library files (for example, default is: C:\ProgramFiles\Intel\IPP\5.3\ia32\stublib orC:\Program\Files\Intel\IPP\5.3\ia32\lib),

select Executable Files and then type in the directory for the Intel IPP executable files (for example, default is:C:\Program Files\Intel\IPP\5.3\ia32\bin),

- Select Project > Properties > Linker > Input

in the Additional Dependencies line add the libraries you wish to link to (for example, ipps.lib or ippsmerged.lib)

3. Testing Simple Example Program

#include

int main()

{

const int SIZE = 256;

Ipp8u pSrc[SIZE], pDst[SIZE];

int i;

for(i=0;i"<"size;i++)

pSrc[i] = (Ipp8u)i;

ippsCopy_8u(pSrc,pDst, SIZE);
printf("pDst[%d] = %d\n", SIZE-1, pDst[SIZE-1]);

return 0;

}