클라우드홖경에서싞속하게 웹어플리케이션구축하기 - Oracle Application Express Oracle Korea, TSC Sep 15, 2015
Agenda 1 2 3 4 5 Introduction Oracle Application Express(APEX) Oracle APEX Use Cases Oracle APEX Pseudo Demo Summary Copyright 2015, Oracle and/or its affiliates. All rights reserved. 2
Introduction Copyright 2015, Oracle and/or its affiliates. All rights reserved. 3
비즈니스홖경변화 Mobile Social Market Internet of Things 장소, 시간에구애받지않는오픈비즈니스 새로운레벨의상호고객관리필요 지속적인시장변화및기대에대한빠른응대 폭발적으로증가하는사물정보에대한응대 보다빠르고효율적인비즈니스응대를위한토대 CLOUD Copyright 2015, Oracle and/or its affiliates. All rights reserved. 4
젂통적인방법 : 쉬운방법 : 서버 네트워크 스토리지 DB 라이센스 호스팅서비스 홖경구성인력 시스템관리자 데이터베이스관리자 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 5
클라우드서비스별차이점 On-Premise IT Infrastructure as a Service Platform as a Service Software as a Service Applications Runtime Middleware Database OS Virtualization Servers Storage Networking You Manage Delivered as a Service Copyright 2015, Oracle and/or its affiliates. All rights reserved. 6
오라클데이터베이스클라우드서비스 Schema / PDB 부서별어플리케이션이나특정목적을위해데이터베이스의일부를사용하는형태 스키마또는 PDB 를월단위로구매해서사용하는방식 (5GB, 20GB, 50GB, 250GB*, 500GB*, 1TB*) 오라클이자동적으로데이터베이스관리 가용성과확장성이좋은인프라구조 * Planned for a future release. Full Instance 개발또는테스트등을위해젂용의데이터베이스가필요한경우사용하는형태 젂체데이터베이스를시갂단위또는월단위로구매해서사용하는방식 고객이직접관리하거나오라클이관리해주는형태의서비스선택가능 고객의요구사항에맞게버젂과에디션선택가능 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 7
오라클데이터베이스클라우드서비스홖경 APEX Copyright 2015, Oracle and/or its affiliates. All rights reserved. 8
Oracle Application Express(APEX) Copyright 2015, Oracle and/or its affiliates. All rights reserved. 9
Oracle Application Express (APEX) APEX 란? 웹기반어플리케이션개발모바일 / 데스크탑배포 데이터베이스데이터에대한시각화및관리 SQL 스킬기반기졲데이터베이스기술홗용 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 10
Oracle Application Express (APEX) APEX 의역사 HTML DB 1.5 First Release HTML DB 1.6 Themes APEX 2.1 Oracle XE APEX 2.2 Packaged Applications APEX 3.1 Interactive Reports APEX 4.0 Websheets Dynamic Actions Plug-Ins Team Development APEX 4.2.x Mobile HTML5 Packaged Apps 2004 2005 2006 2007 2008 2009 2010 2011 2012-14 2015 HTML DB 2.0 SQL Workshop APEX 3.0 Flash Charts PDF Printing Access Migration APEX 3.2 Oracle Forms to APEX Conversion APEX 4.1 Data Upload Error Handling ROWID APEX 5.0 Page Designer Universal Theme Modal Dialogs Copyright 2015, Oracle and/or its affiliates. All rights reserved. 11
Oracle Application Express (APEX) APEX 의특징 웹브라우저만으로개발별도개발프로그램설치불필요 개발결과는데이터베이스메타데이터로저장및관리손쉬운관리 한번의개발로다양한기기에대한 UI 지원개발효율성 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 12
Oracle Application Express (APEX) APEX 의특징 쉬운설치 Oracle Database의모든에디션에기본설치됨 (10gR2~) 최싞버젂다운로드 - http://otn.oracle.com/apex 오라클클라우드서비스에포함 Schema and PDB services 5, 20, 50 GB Dedicated DBaaS services 추가비용없이사용, Oracle Support 지원 개발자수, 앱의수, 최종사용자의수와관계없음 APEX 젂문 Oracle Support 엔지니어지원 오라클 DB 의모든기능지원 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 13
Oracle Application Express (APEX) APEX 아키텍처 Apache OHS ORDS Schemas Oracle APEX Web Logic Server WLS Oracle Database Browser Mid Tier Database Tier Copyright 2015, Oracle and/or its affiliates. All rights reserved. 14
Oracle Application Express (APEX) APEX 배포홖경 Cloud / Hosted On Premise In Datacenter On Premise - Departmental Server Personal Database Copyright 2015, Oracle and/or its affiliates. All rights reserved. 15
Oracle Application Express (APEX) APEX 구성요소 - Home Page 종합적인웹어플리케이션 & 데이터베이스어플리케이션개발 Tool Copyright 2015, Oracle and/or its affiliates. All rights reserved. 16
Oracle Application Express (APEX) APEX 구성요소 Application Builder 복잡한프로그래밍대싞 GUI 를통해선언적인방법으로어플리케이션개발 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 17
Oracle Application Express (APEX) APEX 구성요소 SQL Workshop 데이터베이스오브젝트관리부터 SQL 명령어수행, 스크립트수행, RESTful Service 생성기능제공 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 18
Oracle Application Express (APEX) APEX 구성요소 Team Development 공동작업을위해어플리케이션개발에필요한마일스톤, To-Do 관리부터기능추적, 프로그램버그관리, 고객피드백관리기능제공 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 19
Oracle Application Express (APEX) APEX 구성요소 Packaged Applications 오라클에서제공하는미리만들어짂어플리케이션들 갂단한설치및커스터마이징가능 특정기능구현을위한참고어플리케이션으로사용가능 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 20
Oracle Application Express (APEX) APEX 기능 Navigation Lists 기졲의탭메뉴대체 위쪽네비게이션메뉴또는좌측메뉴선택 다계층의메뉴구조지원 데스크탑과모바일홖경모두지원 이젂버젂 APEX 에서생성한메뉴마이그레이션지원 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 21
Oracle Application Express (APEX) APEX 기능 Interactive Report 사용자가임의로리포트변경 데이터필터링, 정렬, 하이라이팅기능 집계, 차트, 검색, 다운로드등의기능제공 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 22
Oracle Application Express (APEX) APEX 기능 Dynamic Actions 페이지에서동적으로일어나는행위지정 선언적으로동적컬럼변경, 계산, 다른페이지이동등의기능구현가능 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 23
Oracle Application Express (APEX) APEX 기능 Calendars 월단위 / 주단위 / 리스트형태의달력기본제공 원하는데이터기준표시데이터변경가능 특정값에대한집계표시가능 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 24
Oracle Application Express (APEX) APEX 기능 Modal Dialogs 팝업창대체 Modal Dialog 는독립적인페이지 일반페이지의모든기능지원 ( 수식계산, 필드검증, 데이터프로세싱, 분기등 ) Copyright 2015, Oracle and/or its affiliates. All rights reserved. 25
Oracle Application Express (APEX) APEX 기능 Master Detail View Copyright 2015, Oracle and/or its affiliates. All rights reserved. 26
Oracle Application Express (APEX) APEX 기능 Chart (HTML5, CSS3, Flash) Copyright 2015, Oracle and/or its affiliates. All rights reserved. 27
Oracle Application Express (APEX) APEX 기능 Plug-ins Copyright 2015, Oracle and/or its affiliates. All rights reserved. 28
Oracle Application Express (APEX) Mobile Development 모바일웹어플리케이션개발을위한선언적홖경지원 다중 UI 지원 (Desktop & Mobile) 모바일페이지는 jquery Mobile 기반의테마와 템플릿사용 데스크탑용페이지보다가볍고빠름 터치기반이벤트와같은모바일이벤트지원 HTML5 를이용하여각종차트와리포팅지원 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 29
Oracle Application Express (APEX) Mobile Development Navigation Menu 모든최상위페이지들은자동적으로네비게이션리스트에등록 좌측상단에메뉴버튺졲재 ( 숨김가능 ) 모바일홖경에특화된네비게이션메뉴형태 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 30
Oracle Application Express (APEX) Mobile Development Mobile List view 모바일홖경 Default Data View 정렬안된리스트기반 자동구분자생성 포맷형태변경가능 검색기능지원 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 31
Oracle Application Express (APEX) Mobile Development Mobile Column Toggle Report 좁은화면을위해선택적으로컬럼표시 사용자가표시할컬럼선택가능 표시할컬럼은대상테이블컬럼기준동적으로변경또는고정 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 32
Oracle Application Express (APEX) Mobile Development Mobile Reflow Table Report 데이터를레이블 / 데이터쌍으로분리 적층적표시방식이기본 화면의넓이에따라리포트의형태변경 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 33
Oracle Application Express (APEX) Mobile Development Mobile Calendar 월별, 주별, 일별그리고리스트형태지원 모바일터치이벤트지원 CSS 를통한커스터마이징가능 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 34
Oracle Application Express (APEX) Mobile Development jquery ThemeRoller 모바일테마는다양한종류의스타일제공 ( 기본 ) ThemeRoller를이용해새로운스타일의테마생성가능 어플리케이션또는워크스페이스에업로드하여사용가능 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 35
Oracle APEX Use Cases Copyright 2015, Oracle and/or its affiliates. All rights reserved. 36
Oracle APEX Use Cases 홗용사례 비즈니스요구사항만족을위한웹어플리케이션개발 ERP 솔루션의확장 ( 추가리포트등 ) Local 데이터기반어플리케이션의고도화 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 37
Oracle APEX Use Cases APEX within Oracle Oracle Store - 오라클제품판매 - 다국어, 다중통화지원 - 데스크탑과모바일모두지원 Oracle Learning Library - 고객대상교육지원 - 다양한종류의컨텐츠업로드및관리 Project Management - 소프트웨어프로젝트관리 - Wiki 페이지, 컨설팅요약제공 Internet Sites - AskTom, ThinkQuest, apex.oracle.com Copyright 2015, Oracle and/or its affiliates. All rights reserved. 38
Oracle APEX Use Cases APEX Commercial Applications 다양한환경에서사용 : On-premises, managed, hosted 대량의사용자대상확장성있는어플리케이션 다양한활용사례 : Enterprise suites, CRM, Workflow, Monitoring, EBS Add-ons 커스터마이징된 UI : Custom CSS, Integrated with Flash and AJAX, Mash-ups Copyright 2015, Oracle and/or its affiliates. All rights reserved. 39
Oracle APEX Use Cases APEX Internet Application Commercial Sites Company Web Sites User Groups / Associations ODTUG, IOUG, etc. Government / Non-Profit site Copyright 2015, Oracle and/or its affiliates. All rights reserved. 40
Skip Oracle APEX Pseudo Demo Copyright 2015, Oracle and/or its affiliates. All rights reserved. 41
1: Workspace 생성 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 42
2: 새로운어플리케이션생성 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 43
3: 생성할어플리케이션타입선택 Application Builder - Create Application Wizard Copyright 2015, Oracle and/or its affiliates. All rights reserved. 44
4: 어플리케이션이름정하기 & 페이지추가 Application Builder - Create Application Wizard Copyright 2015, Oracle and/or its affiliates. All rights reserved. 45
5: 선택사항확인후어플리케이션생성 Application Builder - Create Application Wizard Copyright 2015, Oracle and/or its affiliates. All rights reserved. 46
6: 어플리케이션생성후페이지수정또는실행 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 47
7: 어플리케이션배포 - 사용자에게 URL 공지 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 48
8: 데이터검증 - Interactive report 를이용하여데이터검증 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 49
9: 데이터수정 - Form 을이용하여데이터수정 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 50
10: 어플리케이션고도화 - 어플리케이션생성 실행 Review 수정 ( 반복 ) Copyright 2015, Oracle and/or its affiliates. All rights reserved. 51
Oracle Application Express (APEX) APEX 홖경에서의어플리케이션개발 Develop Customize Deliver 빠르게개발하고, 개선하고, 배포 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 52
Summary Copyright 2015, Oracle and/or its affiliates. All rights reserved. 53
Summary No Cost In Browser Development RAD Declarative Web 2.0 Leverage SQL Self Service SELECT * FROM EMP Copyright 2015, Oracle and/or its affiliates. All rights reserved. 54
관련서적 Copyright 2015, Oracle and/or its affiliates. All rights reserved. 55
추가정보 Oracle Technology Network http://otn.oracle.com/apex APEX Community Oracle Learning Library http://apex.oracle.com/community http://www.oracle.com/oll Hosted evaluation site http://apex.oracle.com FREE Copyright 2015, Oracle and/or its affiliates. All rights reserved. 56