Integrating Hypermedia Functionality into Database Applications

1. Integrating Hypermedia Functionality into Database Applications Anirban Bhaumik*+, Deepti Dixit*, Roberto Galnares*, Manolis Tzagarakis**, Michalis Vaitis**, Michael Bieber*, Vincent Oria*, Aparna Krishna*, Qiang Lu*/***, Firas Aljallad*, Li Zhang* * Collaborative Hypermedia Laboratory, CIS Department, NJIT, USA ** Computer Technology Institute, University of Patras, Greece*** Suzhou University, Peoples Republic of China

2. Outline (research agenda) • Motivation • DHE - Dynamic Hypermedia Engine • Basic DB query interface • Schema support • DB application support • Integrating multiple database applications • Data warehousing • Data mining • Database Design: Relationship Analysis current future

3. Motivation • Most database applications have few links • Each element could have multiple links (relationships) • Each element is a potential starting point for exploring • Research Goal: automatically adding links and services to database applications

4. Dynamic Hypermedia Engine • Automatically generate links and other “hypermedia” services for applications: • comments, guided tours, etc. • Automatically integrate applications through external linking

5. Main Application Frame List of Links Menus Metadata

9. 1997 Sales 1997 Expenses $127,322.12 $85,101.99 Dynamic Hypermedia Engine • Links generated based on application structure, not search or lexical analysis • You cannot do a search on the display text “$127,322.12” to find related information… • But you can find relationships for the element Sales[1997]

10. Dynamic HypermediaEngine Architecture

12. Dynamic HypermediaEngine Architecture

13. Relationship Manager

14. Dynamic HypermediaEngine Architecture

16. Dynamic HypermediaEngine Architecture

17. Dynamic HypermediaEngine Architecture

19. Dynamic HypermediaEngine Architecture

20. Dynamic HypermediaEngine Architecture

21. Dynamic HypermediaEngine Architecture

22. DHE Contributions • Only tool that providing automated linking, metadata, and hypermedia services • based on the application structure (not lexical analysis) • without altering applications • for analytical and technical applications that generate display contents dynamically

23. Basic DB Wrapper • Provides a simple query interface • Allows users to make SQL queries directly to a database • Parses the results • Passes results to the Relationship Manager to automatically add links

24. Basic DB Wrapper • Provides a simple query interface • Allows users to make SQL queries directly to a database • Parses the results • Passes results to the Relationship Manager to automatically add links Uses a persistent pool of JDBC Connection Objects to execute SQL statements and retrieve metadata. Currently uses physical schema for metadata Future: dedicated metadata repositories, data dictionaries

25. Main Application Frame Menus Metadata List of Links

26. Database Element Types Any instance of these types can be uniquely identified, have metadata, and relationships.

27. Database Element Types Any instance of these types can be uniquely identified, have metadata, and relationships. Each type has its own set of generic database relationship links. For example, an element will be related to a column, its tuple’s key field & foreign keys, a table, etc. The DB Wrapper generates these links automatically.

28. Schema Manager Automatically generates DB-specific links from a machine-readable E-R schema (e.g., courses taught by a professor)

32. DB Application Wrapper: identifies elements in application screens Links: DB Wrapper: basic links & DB Access Schema Manager: E-R links Appl Wrapper: appl-specific links Existing applications can access database directly as before; New applications could let the DB wrapper provide all database access

33. Outline (research agenda) • Motivation • DHE - Dynamic Hypermedia Engine • Basic DB query interface • Schema support • DB application support • Integrating multiple database applications • Data warehousing • Data mining • Database Design: Relationship Analysis current future

34. DHE can integrate multiple database applications Each wrapper handles its own application. Research questions in specifying related objects across applications in mapping rules...

35. Data Warehousing The DB Wrapper could also load data into and give other applications access to a data warehouse

36. Data Mining DHE relationships are pre-specified in mapping rules in the Relationship Manager and dynamically generated A data mining tool could dynamically mine relationships for DB application elements. But how?

37. Database Design:Relationship Analysis (RA) • A systematic approach to finding the implicit or “hidden” relationships in an information domain • Relationships can be implemented as links • RA is a brainstorming technique for domain experts based on a taxonomy of relationship types

38. Database Design:Relationship Analysis (RA) Research Questions: • How does RA contrast with standard database analysis? • Can RA supplement standard database analysis

39. Outline (research agenda) • Motivation • DHE - Dynamic Hypermedia Engine • Basic DB query interface • Schema support • DB application support • Integrating multiple database applications • Data warehousing • Data mining • Database Design: Relationship Analysis current future