Transcript IBM Presentations: Blue Pearl Deluxe template

El rol de DB2 Express-C en la información
para un mundo on-demand
Raul F. Chong
DB2 Express Community Facilitator
IBM Toronto Laboratory
Email: [email protected]
7/7/2015
INNOVACION
Disclaimer/Trademarks
Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements, or other
publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility, or any other
claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those
products.
All statements regarding IBM’s future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only.
This information may contain examples of data and reports used in daily business operations. To illustrate them as completely as
possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious, and any
similarity to the names and addresses used by an actual business enterprise is entirely coincidental.
Trademarks
The following terms are trademarks or registered trademarks of other companies and have been used in at least one of the pages of the
presentation:
The following terms are trademarks of International Business Machines Corporation in the United States, other countries, or both: AIX,
AS/400, DataJoiner, DataPropagator, DB2, DB2 Connect, DB2 Extenders, DB2 OLAP Server, DB2 Universal Database, Distributed
Relational Database Architecture, DRDA, eServer, IBM, IMS, iSeries, MVS, Net.Data, OS/390, OS/400, PowerPC, pSeries, RS/6000, SQL/400,
SQL/DS, Tivoli, VisualAge, VM/ESA, VSE/ESA, WebSphere, z/OS, zSeries
Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or
both.
Intel and Pentium are trademarks of Intel Corporation in the United States, other countries, or both.
UNIX is a registered trademark of The Open Group in the United States and other countries.
Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both.
Other company, product, or service names may be trademarks or service marks of others.
2
INNOVACION
Agenda
 Estrategia de IBM
 DB2 Express-C
 Programa para universidades
 Contactanos!
3
7/7/2015
INNOVACION
Estrategia de IBM
4
7/7/2015
INNOVACION
Estrategia de IBM - Conceptos Claves
 Innovacion
 On demand business
 Information on demand (IOD)
 Service Oriented Architecture (SOA)
 Web services
 XML
5
7/7/2015
INNOVACION
Estrategia de IBM - Conceptos Claves
 Innovacion
 On demand business
 Information on demand (IOD)
 Service Oriented Architecture (SOA)
 Web services
 XML
6
7/7/2015
INNOVACION
Sabes cual es la empresa líder en
registro de patentes?
 a) Microsoft
 b) Motorola
 c) IBM
7
7/7/2015
INNOVACION
Propriedad Intelectual IBM
Patentes registradas entre 1993 y 2003
IBM
25
20
Canon
Canon
Thousands
NEC
NEC
15
Hitachi
Hitachi
Sony
Sony
Matsushita
Matsushita Toshiba
Toshiba
10
5
0
8
7/7/2015
Mitsubishi
Samsung
Motorola
Motorola
INNOVACION
Innovacion de IBM en servidores de datos
Resaltos de innovacion
1968
1981
Primera Base de
datos Jerarquica
• IBM desarrolla IMS
en 1966 para el
programa espacial
Apollo.
2006
Primera base de datos
multi-estructurada
(Hibrida)
Primera base de
datos relacional
• IBM hace disponible la
base de datos DB2 en base
al prototipo System R.
• DB2 9 es la primera base de
datos en apoyar a ambos,
estructuras relacionales y
jerarquicas en un solo
servidor de datos.
La innovacion de IBM continua
9
7/7/2015
INNOVACION
1) Base de datos habilitado para XML: 2 opciones
CLOB/Varchar
Extraer
elementos/atr
seleccionado
Shredding
XML
DOC
XML
DOC
“Decomposicion”
Mapeo Fijo
Triturador
Side Tables
XML DOC
XML DOC
XML DOC
(tablas regulares
de busqueda)
10
Columna Varchar
o clob
(tablas relacionales)
7/7/2015
INNOVACION
2) Base de datos Hibrida o multi-estructurada
 Guarda XML en formato jerarquico (parecido a la
representacion DOM)
create table dept(deptID char(8),…, deptdoc xml);
 Columnas relacionales
se guardan en formato
relacional (tablas)
 Columnas XML se guardan
nativamente
 XML se guarda en UTF8
11
7/7/2015
INNOVACION
Integracion: Datos relacionales y jerarquicos
Tabla PACIENTES
Nombre
Sexo
Edad
Cafe
Fuma
Maria
F
63
30
25
ADN
genX = 123
Pedro
M
37
10
0
genX = 987
…
Ana
F
56
15
20
genX = 123
12
7/7/2015
INNOVACION
SQL con Xquery/XPath
select nombre from PACIENTES
where
xmlexists('$p/paciente/InfoMedica[genX="987"]'
passing PACIENTES.ADN as "p")
and sexo = 'F'
and edad > 55
and fuma > 10
and café > 15
;
13
7/7/2015
INNOVACION
XML en DB2
 “Se siente" relacional y/o Jerarquico (XML)
 Ambos sabores: SQL y Xquery
SERVER
CLIENT
DB2 Client /
Customer Client
Application
SQL/X
Relational
Interface
XQuery
DB2 Storage:
DB2
Engine
XML
Interface
14
Relational
XML
7/7/2015
INNOVACION
Estrategia de IBM - Conceptos Claves
 Innovacion
 On demand business
 Information on demand (IOD)
 Service Oriented Architecture (SOA)
 Web services
 XML
15
7/7/2015
INNOVACION
El rol de DB2 en la informacion para un
mundo On-Demand
On demand business
Information on demand (IOD)
Service Oriented Architecture (SOA)
Web services
XML
Innovacion
16
DB2 9
Innovacion
7/7/2015
INNOVACION
Que es XML?
 XML = eXtensible Markup Language
 HTML: Describe como se muestra la informacion
<b> Raul </b>
 XML: Describe la informacion
<name> Raul </name>
17
7/7/2015
INNOVACION
DB2 9: Respuesta de clientes
Resultados usando DB2 9 basado en una solucion SOA
18
Tarea
Con DB relacional
Con DB2 9
Desarrollo de procesos de
negocio con busqueda y
accesso
CLOB: 8 hrs
30 min.
Numero de lineas de codigo
(Reduccion en 65%)
100
35
Añadir un campo a un
esquema
1 semana
5 min.
Consultas
24 - 36 hrs
20 seg - 10 min
Trituracion: 2 hrs
7/7/2015
INNOVACION
DB2 Express-C
19
7/7/2015
INNOVACION
Ediciones/Soluciones del servidor DB2
DB2 Enterprise Server Edition
DB2 Workgroup Server Edition
DB2 Express Edition
DB2 Express-C
DB2 Personal
Edition
20
Extra
functionality
+
+
Extra
functionality
+
7/7/2015
Extra
functionality
+
Extra
functionality
INNOVACION
DB2 Express-C anunciado Enero 30, 2006
DB2 Express-C es:
una version de DB2 Express para la comunidad.
Gratis para desarrollar, usar en produccion, distribuir*...sin
limites!
Listo para Production
Technologia Innovadora
 No hay limite en el
tamaño de la base de
datos
 La misma tecnologia y
apoyo para programar
que DB2 Express en un
paquete mas pequeño
 No hay limite en el
numero de instancias por
servidor
 No hay limite en el
numero de usuarios
 Un equipo de DB2
Express-C dedicado a la
comunidad
 DB2 Express-C 9 ya esta
disponible y pureXML
esta incluido!
* Se requiere registrarse pero es tambien gratis.
21
Comunidad
7/7/2015
 Apoyo gratis a traves del
foro
 Calificaciones y
habilidades sirven para
cualquier edicion de DB2
INNOVACION
Pagina web DB2 Express-C
www.ibm.com/db2/express
22
7/7/2015
INNOVACION
Programa DB2 para
Universidades
(y Pequeñas-Medianas Empresas)
23
7/7/2015
INNOVACION
Programa “DB2 Express-C para Universidades”
DB2 DBA &
Developer 2-hour
course Code: C1
DB2 Express-C
in the IOD World
Code: SP1
- DBA & Dev eloper
overview
And/Or
DB2 DBA 1-day
Workshop
Motivational Speech (1.5 hours)
- IBM’s Direction
- DB2 Express-C overview
- “Your opportunity” section
Collect Mailing List
Intro DB2 student ambassador program
Download DB2 Express-C use code SP1
to register to the program
Code: WS1
- Basic DBA skills
DB2 Developer
1-day Workshop
DB2 Certification
Exams (2 days)
Code: WS2
- Basic Developer skills
Course in plan, need
to develop
DB2 Migration
Workshop (1 day)
Code: WS3
- Migrate from
MySQL/Postgres
DB2 Performance
(1 day)
DB2
Express-C
Book
Code: WS4
- Basic Perf skills
Rational & DB2 (1 day)
Code: WS5
- DB2 and RAD Web services
- Use course material for book
- Give books away during courses
24
7/7/2015
Convert
courses to
e-Learning
- To do later after feedback
- BP Team has similar material
online now
INNOVACION
Contactanos!
25
7/7/2015
INNOVACION
Contactanos
IBM - Iniciativa Academica
Fernando Gomez – [email protected]
DB2 Express-C Community Team
Raul F. Chong – [email protected]
26
7/7/2015
INNOVACION
Obrigado!, Gracias!, Thank you!
Preguntas ?
Fernando Gomez – [email protected]
Raul F. Chong – [email protected]
www.ibm.com/db2/express
27
7/7/2015