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

Metadata
Menus
6
(No Transcript)
7
(No Transcript)
8
(No Transcript)
9
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
  Sales1997

10
Dynamic HypermediaEngine Architecture
11
(No Transcript)
12
Dynamic HypermediaEngine Architecture
13
Relationship Manager
14
Dynamic HypermediaEngine Architecture
15
(No Transcript)
16
Dynamic HypermediaEngine Architecture
17
Dynamic HypermediaEngine Architecture
18
(No Transcript)
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. Eac
h type has its own set of generic database
relationship links. For example, an element will
be related to a column, its tuples 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)
29
(No Transcript)
30
(No Transcript)
31
(No Transcript)
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 DesignRelationship 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 DesignRelationship 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