Transcript Blue Group (ADO) - DePaul University

Universal Data Access with
The Blue Group
*Jennifer Kochan
*Rebecca Orozco
*Chris Papandria
*Alicja Stanczak
3/10/98
Blue Group (ADO)
ActiveX Data Objects
Outline
ODBC
OLE DB
ADO Overview
ADO Examples
Conclusion
3/10/98
Blue Group (ADO)
Universal Data Access
Overview
3/10/98
Blue Group (ADO)
• Technology is new and constantly changing
• In-depth look at Microsoft® Universal Data
Access: Specifically ADO.
• Description of Universal Data Access and
ADO
• Two working examples of data access using
ADO
– Microsoft’s Internet Explorer
– International Software Group’s Navigator
Universal Data Access
3/10/98
Blue Group (ADO)
WHY?
• End users want uniform access to ALL types
of data (hierarchical and relational).
• End users want to combine different types
of information.
• Simple data stores don’t want to implement
relational engines in order to expose a
common interface.
• IS Managers do not want to move the data
from its original location.
Universal Data Access
3/10/98
Blue Group (ADO)
WHO?
Microsoft Data Access Components (MDAC)
• ADO (ActiveX Data Objects)
• OLE DB
• ODBC (Open Database Connectivity)
Universal Data Access
3/10/98
Blue Group (ADO)
With these tools, Microsoft is trying to provide
the following standards:
• High-performance access to data
-New access method should provide same level of
performance
-Performance must be maintained as usage grows
• Reliability
-database solutions perform reliably (fail-safe)
-minimize maintenance and support costs
• Vendor commitment and Industry Support
-Easy to use interface that works with any tool or language
-Leverage skills developers already have
3/10/98
Blue Group (ADO)
Universal Data Access
WHAT?
• Microsoft’s strategic application-level programming
interface to data and information
• Designed for those developing client server or
Web-based data-driven solutions
• Provides a framework so that data can be accessed
from multiple sources on many different platforms
3/10/98
Blue Group (ADO)
Universal Data Access
• What types of data need high-performance
universal access?
–
–
–
–
–
–
Production Databases
File Systems
Computed Data
Indexed Sequential files
Personal Databases
Spreadsheets, Project Management, Email,
Directory Services, ...
3/10/98
Blue Group (ADO)
Universal Data Access
• ADO is all the client needs to
know in order to access data
• OLE DB defines a component
architecture for Universal Data
Access
• Microsoft is committed to
standards, ODBC and JAVA
support
ODBC
3/10/98
Blue Group (ADO)
(Open Database Connectivity)
• Provides access to different relational data on
multiple platforms
• Open standard originally created by Microsoft
in 1992
• Relies on ANSI SQL to define its functionality
• Broadly supported interface with over 170 drivers
3/10/98
Blue Group (ADO)
OLE DB
• OLE DB is a Microsoft COM-based set of standard
interfaces for Universal Data Access
• Database architecture designed to provide
access to data regardless of location or type
• Access relational as well as nonrelational
information sources including mainframe,
e-mail/file system stores, text, graphical data etc...
• By definition, OLE DB is a C++ API. It is not
language independent (that’s where ADO comes in)
• OLE DB is fully able to leverage existing ODBC
drivers
• OLE DB heavily uses COM and DCOM therefore
is better for the Internet than ODBC
ADO
(ActiveX Data Objects)
ADO
Rows of Data
OLE DB
0:00.00 Begin Transaction T000
0:00.15 Commit Transaction T000
0:00.17 Begin Transaction T001
0:01.00 Join Transaction T001 Resource R902
0:02.07 insert 9.72 to Resource R902
0:05.17 Begin Transaction T002
0:06.92 insert 8.73 to Resource R902
0:07.18 Join Transaction T001 Resource R910
0:07.19 Join Transaction T002 Resource R731
0:09.27 insert 1913.87 to Resource R902
0:09.28 delete 1913.87 from Resource R910
0:09.30 Commit Transaction T000
OLE DB
address: http:www.microsoft.com/oledb/
ole db
Log
File
e
HTML
Data
Product info
specification
Download
Resources
3/10/98
Blue Group (ADO)
Application
OLE DB
OLE DB
ISAM
Data
OLE DB
OLE DB
Mail
Data
Spreadsheet
Data
SQL
Data
ADO
(ActiveX Data Objects)
3/10/98
Blue Group (ADO)
• Strategic High-level data access objects
– Provides a uniform interface to data for all business
application programmers
– Merges RDO and DAO
• “Language Neutral”
– C/C++, Java, Visual Basic®, VBScript
• Provides access to underlying Rowset
– Ultimate extensibility
– OLE DB and ADO clients can share data
3/10/98
Blue Group (ADO)
ADO
Examples
Example using Commercial Middleware product.
Example using Microsoft Internet Explorer
and Access.
3/10/98
Blue Group (ADO)
Conclusion
•Our Website
•Questions?
-Thank You-