1 / 31

DBLP database

DBLP database. 1. DBLP Web Site & Search Pages. User Query. Info n. 2. 3. User Knowledge. Info1. Info2. DBLP database. Multiple Authors List Page. (Unique Author Data Page). Multiple Authors List Page. Hyperlinks to individual data pages. Main Author. Home Page.

mahdis
Download Presentation

DBLP database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DBLP database 1. DBLP Web Site & Search Pages User Query Info n 2. 3. User Knowledge Info1 Info2

  2. DBLP database Multiple Authors List Page (Unique Author Data Page)

  3. Multiple Authors List Page Hyperlinks to individual data pages

  4. Main Author Home Page Table Data

  5. DBLP database Multiple Authors List Page (Unique Author Data Page)

  6. Unique Author Data Page

  7. Overview of the Java SQL Wrapper Class A 1. User inputs HTML Author & Title Parsers SQL Parser <HTML>… (Single Title) <TD>data… data</TD> ...</HTML> SQL String Sigmod Author & Title Search Web pages <HTML>… (Single Title) <TD>data… data</TD … … > ...</HTML> <HTML>… (Single Title) <TD>data… data</TD … … > ...</HTML> <HTML>… (Single Title) <TD>data… data</TD … … > ...</HTML> <HTML>… (Single Title) <TD>data… data</TD … … > ...</HTML> B 2. Send SQL Method Builds a database for the query in Oracle C (Store Articles Method) 3. Query sent to Oracle Oracle D (QueryDB Method)

  8. A The SQL Query is parsed, and requests for Author and Title views are sent to the respective web pages. The web pages return streams of HTML which are then parsed to extract the data. Sigmod Author Search page SQL Parser <SUBMIT> Name = Alice This_String_Skipped <SUBMIT> Title = Ways to.. This_String_Skipped This_String_Skipped <SUMIT> Name = Alice Alice Ways to.. Sigmod Title Search page (SQL from user) (HTML to Parsers)

  9. B.1 Parse Author (Zoom) Sigmod Author Search page Single Author or List Page (to Oracle DB) Parse List Parse Title The HTML returned from querying Search Author depends on whether the requested name is unique in the database. If it is unique, an HTML page with data about that author is returned. Otherwise a list of hyperlinks to matching author names is returned. Parse List determines what kind of page has been returned then if it is a list page, extracts each of the author URLs and returns a vector of input streams to each of those authors pages. Sigmod Title Search page <HTML>… (Single Title) <TD>data… data</TD> ...</HTML> (Keyword queries from SQL Parser)

  10. B.2 Single Author Data page Parse Author <HTML>… (Single Author) <TD>data… data</TD> ...</HTML> <HTML>… (Single Author) <TD>data… data</TD> ...</HTML> Parse List Sigmod Author Search page <HTML>… (Single Author1) <TD>data… data</TD> ...</HTML> OR Vector of Authors Parse Author <HTML>… (Single Author2) <TD>data… data</TD> ...</HTML> Multiple Author List page Author1 <HTML>… <LI> Author1</LI> <LI>Author2</LI> ...</HTML> Author2 Parse List Author3 <HTML>… (Single Author3) <TD>data… data</TD> ...</HTML> Parse Title Sigmod Title Search page <HTML>… (Single Title) <TD>data… data</TD> ...</HTML>

  11. C Store Articles Method Results Vector: Tags & Values Prepared Piped SQL Statements Parse Author Author: Alice Kent Author: Joe Stevens Author: Kim Lee “Insert into author values (automatic id, ?, ?)” “Insert into article values (automatic id, ?, ?, ?)” Results Vector: Tags & Values “Insert into rel values (select author_id..)” Parse Title Title: Databases Public: ICDE 1999 Page: 287 Oracle (Query Oracle for Author & Article IDs)

  12. D QueryDB Method SQLWrapper Class ClientBrowser AuthID Name QueryDB Method 87219 Alice.. RMI 53882 Joe Sl.. ...connection.prepareStatement (SQL); Oracle Java Applet ...rs = stmt.executeQuery (); OriginalSQL String //*iterates through records in rs to build a String [ ][ ] containing the resulting data*//

  13. Overview of the Java SQL Wrapper Class A 1. User inputs HTML Author & Title Parsers SQL Parser <HTML>… (Single Title) <TD>data… data</TD> ...</HTML> SQL String Sigmod Author & Title Search Web pages <HTML>… (Single Title) <TD>data… data</TD … … > ...</HTML> <HTML>… (Single Title) <TD>data… data</TD … … > ...</HTML> <HTML>… (Single Title) <TD>data… data</TD … … > ...</HTML> <HTML>… (Single Title) <TD>data… data</TD … … > ...</HTML> B 2. Send SQL Method Builds a database for the query in Oracle C (Store Articles Method) 3. Query sent to Oracle Oracle D (QueryDB Method)

  14. Project Architecture Overview WrapperExp.html <HTML>…. … ... ...</HTML> DBDescript.html <HTML>…. … ... ...</HTML> Personal Web Server (Scarlet.wpi.edu) HTTP Index.html <HTML>…. … ... ...</HTML> ParseAuthor.jjt The Wrapper Class ParseList.java ClientBrowser RMI SQLWrapper.java ..sendSQL() ..queryDB() Java Server Java Applet Oracle

  15. Intuitive RMI Dining Guide (Registry) Naming.lookup (what restaurants) Reg.rebind(“CatchyName”, myRestaurant) The Head Chef (Server Application) The Menu (Interface) The Diner (Client Application) (Implements) Servants & Waiters (Rmic Stubs & Skeletons)

  16. RMI Nitty-Gritties (or: Write--Compile--Run) Must: -Be Public -Extend java.rmi.Remote -Throw java.rmi.RemoteException Html & Java Source Files(4): *Remote Interface *Remote Object Server *Client Applet *HTML page to load Applet -Be Serializable -Implement 1(+) Remote Interfaces -Extend java.rmi.UnicastRemoteObject (or export object explicitly) -Create & install a Security Manager -Create & Register 1(+) Remote Object

  17. RMI Nitty-Gritties (or: Write--Compile--Run) Compiles Source Code to Create Executable Class Files From Command Line: Javac myRestaurant.java Rmic myRestaurant Generates Stubs & Skeletons

  18. RMI Nitty-Gritties (or: Write--Compile--Run) Starts Registry on port# or 1099 by default From Command Line: Start RmiRegistry [port#] Java myRestaurant Runs Java Server application Load Applet in Browser

  19. Cookies import netscape.javascript.*; init(){ QueryServer.java saveToList(string cookie..) … deleteFunction (string cookie..) ... getSavedList (string cookie..) ... QueryApplet.java RMI CookieCode.………. ….…..CookieCode …} JSObject method calls Local File I/O Index.html <HTML>… <HEAD> javaScript Function setCookie Function getCookie Function delCookie Function returnTime </HEAD> … <Applet code=QueryApplet.class ... MAYSCRIPT> </Applet> ...</HTML> ClientQueries (Folder) Cookie1.txt Cookie2.txt Cookie3.txt

  20. Cookie Code Cookie String (Applet Global Variable) = local_host_name (from static method) + TimeStamp (from JavaScript returnTime ) String cookie; try {cookie = InetAddress.getLocalHost().toString();} catch(UnknownHostException uhe){cookie = "Unknown Host";} if ( cookie.indexOf("/") != -1 ) cookie = cookie.substring(0, cookie.indexOf('/')); JSObject win = JSObject.getWindow(this); JSObject doc = (JSObject) win.getMember("document"); Object [] Arg = {"client"}; String ClientCookie = (String) win.call("getCookie", Arg); if (ClientCookie.equals("undefined")) { String time = (String) win.call("returnTime", null); int begin = time.indexOf(',') + 1; int end = time.indexOf('U')-1; time = time.substring(begin, end); time = time.replace(' ', '_'); time = time.replace(':', '_'); time = cookie + time; Object [] Args = {"client", time , new Integer(30)}; win.call("setCookie", Args); cookie = (String) win.call("getCookie", Arg); } else {cookie = ClientCookie;

  21. Swing Tables JComponent TableModel Listener ListSelection Listener TableColumn ModelListener Table ColumnModel TableModel JTable DefaultTable ColumnModel Abstract TableModel ListSelection Model Default TableModel CustomModel DefaultList SelectionModel

  22. The End

More Related