Chapter 7 The SUN Intranet Data Warehouse: Architecture and Tools All rights reserved 1
Intranet Data Warehouse : Distributed Networking Computing Peer-to-peer Peer-to-peer:,. C/S Microsoft ActiveX DCOM(Distributed Component Object Model) Sun CORBA(Common Object Request Broker Architecture) OMG(Object Management Group) CORBA IBM, Digital Equipment, HP, Sun Microsystems Sun Intranet DW SMP ( SMP:Symmetric MultiProcessing) SMP : All rights reserved 2
Java: (1) OOP Computing Java (the migration of processing from the mainframe to the desktop to the network) Java DW : Client/Universal warehouse (casual users) applet : : Client/Universal warehouse Java Instruction set OS All rights reserved 3
Java: (2) Java Java Java Source Source Code Code Java Java Compiler Compiler or or Interpreter Interpreter Java Java Universal Universal Bytecode Bytecode Java Java Virtual Virtual Machine Machine Java Virtual Machine Java OS H/W Key Java OS, Machine-Specific Machine-Specific Instructions Instructions All rights reserved 4
Java Java Java API set Layer corruption (C C++ ) bytecode, corruption API : Application Program Interface All rights reserved 5
Java Java Applet Sandbox Sandbox Sandbox Embedded-content model Java All rights reserved 6
Java C C++ Multithread Thread 40KB CGI Perl 25 CGI[Common Gateway Interface]:. http All rights reserved 7
JavaBeans: Write once, run everywhere 3-tier / 2-tier JavaBean OS JavaBean Microsoft ActiveX, IBM OpenDoc, Netscape LiveConnect Intranet DW layer : Palettes of JavaBeans objects, All rights reserved 8
APIs DW ( ) ( ), 3 / Java API TP Monitors RPC ORB.. Java / OS H/W JDBC(Java Database Connectivity) Java IDL(Interface Definition Language) Java RMI(Remote Method Invocation) JNDI(Java Naming Directory Interface) All rights reserved 9
Java Database Connectivity(JDBC)(1) Java RDBMS JDBC-ODBC bridge ODBC JDBC JDBC-ODBC bridge // Connect to the database Class.forName( jdbc.odbc.jdbcodbcdriver ); String myurl = jdbc:odbc:mydatabase ; Connection myconn = DriverManager.getConnection(myURL, myname, mypassword ); // Send SQL to the server java.sql.statement mystmt = myconn.createstatement(); String mysql = SELECT name,address,phone from Person ; ResultSet myresult = mystmt.executequery(mysql); //Get the results while (myresult.next()) { //print the values of each row String name = myresult.getstring( name ); String address = myresult.getstring( address ); String phone = myresult.getstring( phone ); System.out.printLn(name + +address+ +phone); } All rights reserved 10
Java Database Connectivity(JDBC)(2) SQL JDBC DB (raw data), PC --> OLAP Database JDBC Result set SQL Code All rights reserved 11
Java Remote Method Invocation(RMI)(1) Java Java, JavaIDL ORB Java RMI RMI 3 Layer Stub/Skeleton Layer Object Serialization:Java, JavaIDL Remote Reference Layer Transport Layer, All rights reserved 12
Java Remote Method Invocation(RMI)(2) RMI JavaIDL RMI Client Stubs Server Skeletons Stub ( ) Remote Reference Remote Reference Transport All rights reserved 13
Java Remote Method Invocation(RMI)(3) RMI CORBA RMI Java Java RMI CORBA Java, IIOP( ORB ) CORBA All rights reserved 14
Java Interface Definition Language(JavaIDL JavaIDL) OMG IDL ( ) (IDL) CORBA IDL Java IDL Orbix for C++ : IDL --> C++ OrbixWeb : IDL --> Java IDL Java IDL Java IDL Java module package Long,unsigned long int constant Public static final Long long long boolean boolean float float character char double double octet byte enum,struct,union class String,wstring string Sequence,array array Short,unsigned short short operation method All rights reserved 15
Java Naming Directory Interface(JNDI) API :.,,, All rights reserved 16
Java Server API(1),, (cf: ) Java CGI SSI(Server Side Include ) http html http (CGI ) JDBC/ODBC.CGI(Common Gateway Interface) (http ) html CGI ( ) All rights reserved 17
Java Server API(2) CGI ( ) CGI Http TCP/IP,, Database All rights reserved 18
What is CORBA? CORBA = the Common Object Request Broker Architecture ORB Life cycle service :,,, Persistence service :, Naming service : (naming systems) DCE, X.500, Sun NIS Event service : Concurrency control service : ORB (lock) Transaction service :, Relationship service : " " Query service : ORB IIOP (Internet Inter-ORB Protocol) (CORBA 2.0 ) All rights reserved 19
CGI, RMI, IIOP HTML Java HTML flat --> graphical CGI HTML OLAP RMI hard-coded Java IIOP All rights reserved 20
Sun Data Warehouse Java Microsoft ActiveX ActiveX Win32, ActiveX ActiveX ( Intel CPU MS Window) Java JavaBeans ActiveX, OpenDoc, LiveConnect Intranet DW C/S DW Intranet All rights reserved 21
DW Layer Internet Explorer, Netscape Navigator, HotJava Layer OLAP RDBMS Infospace Intranet Data Warehouse Infospace : Intranet Data Warehouse Java,,, PC, Macintosh, Unix Java Infospace Java Multi-thread CGI Query, All rights reserved 22