1 / 10

Database Middleware

Database Middleware. Early client/server database systems Two tier Server does business logic (data analysis & report generation) Server does database logic Client communicates directly with database on the server Client does data formatting and display

portia
Download Presentation

Database Middleware

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. Database Middleware • Early client/server database systems • Two tier • Server does business logic (data analysis & report generation) • Server does database logic • Client communicates directly with database on the server • Client does data formatting and display • Primitive middleware is simply for enabling communication

  2. Database middleware • Business logic – data analysis and report generation takes place on client • Data is needed at the client • Server logic to selectively extract needed data from tables for transmission to client – not entire files

  3. SQL • Structured Query Language • ANSI standard American National Standards Institute • Standard allows interoperability Provides • Create & modify tables and databases • Add, delete, modify and manipulate data • Query • Interfaces through programming languages • Vendors provide enhanced features not part of ANSI SQL • Competitive advantage • Compromises transparent interoperability

  4. SQL processing • Application generates SQL query • Query goes to client middleware • Query is passed (through layers) across network • Server middleware submits query • Database interprets query – result is a dataset • Dataset is transmitted across network to client middleware • Data is presented to the client application Final execution of query is on the local dataset

  5. Proprietary API • Most database vendors provide a proprietary API to link to their database platform (Oracle uses SQL*NET) • Applications then become bound to a particular database • Separate application versions needed for different databases • One solution – a universal API translator into a specific API • Microsoft ODBC – Open Database Connectivity • Provides a set of non-database specific APIs • Layer inserted between client application and middleware • What about interfacing to multiple databases?

  6. ODBC Client Application Oracle Server ODBC Oracle SQL*NET Oracle SQL*NET NOS NOS Physical NW Layers Physical NW Layers

  7. Oracle Server Client Application Sybase Server Oracle SQL*NET Client Middleware Sybase mid-ware NOS NOS NOS Physical NW Layers Physical NW Layers Physical NW Layers 3 Tier ODBC SequelLink SQL*NET ClientMiddle-ware Sybase API NOS Physical NW Layers

  8. Universal Data Access • An alternative solution (newer) • OLE DB: Object Layering and Embedded Database API • Inserts another layer of middleware on the server side • Clients generate OLE DB rather than a proprietary API or SQL

  9. SQL Database Client Application ODBC OLE DB Client Client Middleware OLE NOS NOS Physical NW Layers Physical NW Layers OLE DB SQL Database ODBC OLE DB Client NOS Physical NW Layers

  10. Web Middleware • Middleware to make the application browser-compatible • Development environments • Examples • ActiveX • Java • CGI (Common Gateway Interface)

More Related