Image Database Processing and Management

1
Welcome Image Database Processing and
Management Via Informix Dynamic Server ORDBMS
System Carl Hoyer Hoy-Heir, Inc. August
6, 1998
2

• History - Past Present
• C. Hoyer
• Left U of I September 1989
• Student/CCSO/NCSA/Beckman/VIS
• Independent Computer Consulting
• Relational - Object Relational Databases
• Michael Stonebraker UC Berkeley
• Created INGRES Engine Modern RDBMS Engine In
  Use
• Created POSTGRES Engine ORDBMS Engine
• PostgreSQL - Pure ORDBMS
• Illustra Stonebraker Creation Commercial
  Success
• Informix Buyout 1995 Informix Rewrite 96-97
• Informix Dynamic Server Datablade Modules

3

• Do you need a database?
• Have you a bazillion files to manage and
  manipulate?
• Must you correlate images to parameters?
• Looking for a new paradigm for visualization?
• Trade normalization/conversion/parameterization?
• For views/joins/aggregations or plain old
  selections?
• RDBMS
• What? Xbase/Access/MS SQL Server/Oracle/SYBASE
• Traditional Methods and Fields
• Integers, Reals, Text,
• Everything Else gt BLOBs
• Enter the ORDBMS
• It has traditional aspects withEXTENSIBILITY!!!
• Data extensions gt Datablades

4
Example An Object-Relational Schema This section
contains a sample query that will be used to
illustrate several points later in this paper.
This object-relational schema illustrates the
added functionality possible with an
ORDBMS create EMP-OR (name C12, age
int, salary int, dept C12, location
point, picture image) Here, we have added two
additional fields to the traditional
Employee table, the location of the employees
home address, and his picture. These fields are
of the datatypes geographic point and image,
respectively. Here is a typical query to this
table select name from EMP-OR where beard
(picture) gt 0.7 and age gt 60 and location in
circle ( 10,10, 5) This query finds the older
employees with considerable facial hair who live
within a five-mile circle surrounding the point
10,10. The query makes use of a user-defined
operator (in) and a user-defined function (beard)
for the new datatypes. From Architectural
Options for Object-Relational DBMSs Dr. Michael
Stonebraker Chief Technology Officer Informix
Software, Inc.
5

• What Other Kinds of Data?
• Images, Time Series, Spatial, Documents,
  Drawings, Media
• Who?
• Informix Hybrid ORDBMS System
• Just like IBM DB2
• Others PostgreSQL, GoldMedal , Polyhedra
• Summary
• ORDBMS Extensible / Affordable / Accessible /
  Functional
• New Processing Paradigm...

6
Examples ITG Mockup Others http//zfish.uorego
n.edu/ http//www.realfans.com/ http//www.hotel
choice.com/ http//www.cyber24.com/ http//www.a
mericangreetings.com/ http//www.camelotmusic.com
/ http//www.informix.com/
7
Thanks... choyer_at_ssi-net.com