database applications on the web
TRANSCRIPT
![Page 1: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/1.jpg)
Database Applications on the WebAIR Pre-Forum WorkshopMay 30, 1999
John Milam University of Virginia
Mike WoodGeorge Mason University
![Page 2: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/2.jpg)
A Shared Vision of the Web• HTML (forms and tables)
• ODBC/OLE drivers
• SQL
• Web servers
• Middleware products/data streaming
![Page 3: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/3.jpg)
HTML• forms for getting or posting data
• tables for presenting results
![Page 4: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/4.jpg)
ODBC/OLE• Open Database Connectivity
(ODBC) drivers, which make it possible to connect to and use a database without launching the database program itself
• Example - using Access files on the Web withoutrunning Access
![Page 5: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/5.jpg)
SQL• Structured Query Language (SQL) for
sending queries (information requests)to a database
![Page 6: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/6.jpg)
Web servers• Netscape Enterprise Server, Microsoft
Internet Information Server, and Apache which serve documents and data on the Web
• Available in NT, Unix, Solaris, Mac OS
![Page 7: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/7.jpg)
Middleware for data streaming• Software which works between the Web
server and the HTML-based website to publish dynamic (as opposed to static) pages
![Page 8: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/8.jpg)
Middleware Products• Cold Fusion• Active Server Pages (ASP/ Visual InterDev) • Internet Database Connectivity• Perl• Tango• Drumbeat 2000 (ASP)• NetObjects Fusion (ASP)• FrontPage 98/2000
![Page 9: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/9.jpg)
Middleware Products - continued• WebObjects (Mac)• mSQL• Java• IBM Web Connectors• Informix Universal Web Connect• WebFocus• Sapphire Web• Programming languages - C and Cobol
![Page 10: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/10.jpg)
• Page-based Applications
• JIT Compilation and Page Caching
• Web Server APIs
• Multithreaded Service Architecture
• Distributed Objects
• Cold Fusion Studio
• Integrated with Dreamweaver andNetObjects Fusion
• NT, Solaris
![Page 11: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/11.jpg)
Issues
• Cost
• Platform
• Scalability
• Throughput
• Client vs.Server
• Browser
• Graphics
• Staffing
• Training
• Complexity
• Security
• Politics
• Nature of Data
• Mapping
![Page 12: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/12.jpg)
• Driven by Performance Indicators
• Problems w/ admin systems for analysis of aggregate data
• Admin systems focus on transactions
• IR office knows extracts, data dictionary, data administration issues, and analysis tools
Database Apps at GMU (1995)
![Page 13: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/13.jpg)
• Create data source, link ODBC
• Design application
• Pass query parameters with form
• Process queries via .cfm templates containing SQL, special CF tags, and output statements
Cold FusionApplication Development
![Page 14: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/14.jpg)
Data Source
(1) Createdatabasetables
(2) LinkODBC driverswithin Cold FusionAdministrator
![Page 15: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/15.jpg)
SampleTemplate #1
Selectsdistinctlist ofindicatorsto create adynamicallypopulatedform.
![Page 16: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/16.jpg)
SampleTemplate #2
Creates homepagebased onparametersbased fromtemplate #1
![Page 17: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/17.jpg)
Template #1Results
Template #2Results
![Page 18: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/18.jpg)
Internet Resources for IR - Offices.cfm
![Page 19: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/19.jpg)
• CF 4.0 Application Server• Windows NT Server 4.0• Internet Information Server 4.0• Dual Pentium II w/256 MB RAM, three
4.5GB Ultra-Wide SCSI HD’s, hot swappable, RAID5, redundant power supplies & cooling systems
• Moving to database server (SQL Server 7?)
Current Architecture
![Page 20: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/20.jpg)
Operational w/New CF Apps• Faculty workload• Faculty equity database• Budget request/tracking/workflow system• Online surveys for assessment, others• Affirmative action/faculty demographics• University student awards system/voting• Enrollment targets/projections• Provost’s Document Repository
![Page 21: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/21.jpg)
More Apps• GMU website• Membership directories for IR associations• Performance indicators application• Internet Resources for IR• IRR Office website• Degrees Conferred• Space Management Analysis• Student Ratings of Instruction
![Page 22: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/22.jpg)
• Drill down from exec, div, or dept to account and object code level
• Examine sub-groups
• Historical account analysis
• Bar/pie graphs with Java
• Move to Chart FX
• Daily expenditure & revenue data, with special end-of-month files
![Page 23: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/23.jpg)
• Drill down bydivision
• Summary acctdata
• Drill down byacct to objectcode data
•
![Page 24: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/24.jpg)
• Biweekly payroll extracts
• Drill down from exec/div/dept
• Summary data by exec/div
• Detail dept/acct data
• Ethnicity by gender crosstab
• Glossary and data dictionaryof terms used
![Page 25: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/25.jpg)
• Base faculty info
• Tenure by rankcrosstabs
• Rank by agecrosstabs
• Drill down byvarious fields
![Page 26: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/26.jpg)
• Credit hours matrix
• Course FTE matrix
• Drill down at collegeor division level
• Alpha list of faculty
• Matrix of coursestaught by semester
![Page 27: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/27.jpg)
![Page 28: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/28.jpg)
Budget Request System
![Page 29: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/29.jpg)
Course Data:Consumptionvs. Contribution
![Page 30: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/30.jpg)
![Page 31: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/31.jpg)
![Page 32: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/32.jpg)
Enrollment Targets
![Page 33: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/33.jpg)
Student Ratings of Instruction
![Page 34: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/34.jpg)
![Page 35: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/35.jpg)
![Page 36: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/36.jpg)
![Page 37: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/37.jpg)
Space Analysis1.
2.
3.
4.
5.
![Page 38: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/38.jpg)
AIR Structures of Data Project
![Page 39: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/39.jpg)
• Political issues (access, who sees what data)
• Security (NT, SSL, digital certificate, web server permissions, CF app, IP, cookies, tokens, not tied to LAN)
• Support, staffing, resources, communication
• Nature of data (ownership, data dictionary, clean-up, frequency, level of aggregation, historical, census vs. operational
Issues and Constraints
![Page 40: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/40.jpg)
• Mapping of exec/div/dept/unit/acct codes• Graphics, browser support, lowest common
denominator.• Javascript and Java• Database and ODBC drivers• SAS code base, drivers; SPSS Smart Viewer• Scalability• Image as data mart vs. warehouse (what it’s not (for
grade lists, rosters, mailings)
Issues and Constraints - continued
![Page 41: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/41.jpg)
Starting Recommendations• Take the risk. Build it and they will come• Build it (IT) in-house to get more control• Use NT• Learn SQL. Use it everywhere you can.• Webify everything you can. • Network with colleagues (at conferences like AIR)
• Don’t be attached if someone tries to take it.• Be seen as the leader in aggregate use of web-enabled data
for decision-making• Be sure what you want to do with your life
![Page 42: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/42.jpg)
Contact info
John Milam
(804) 924-3880 (voice)[email protected] (email)
Curry School of EducationDept. of Leadership, Policy, and FoundationsUniversity of Virginia405 Emmet Street SouthCharlottesville, VA 22903
Mike Wood
(703) 993-8840 (voice)[email protected] (email)
Institutional Research and Reporting
George Mason UniversityMS3D2, D205 Mason HallFairfax, VA 22030-4444
![Page 43: Database Applications on the Web](https://reader036.vdocuments.us/reader036/viewer/2022062513/5562eb0dd8b42a38778b5114/html5/thumbnails/43.jpg)
Database Applications on the WebAIR Pre-Forum WorkshopMay 30, 1999
John Milam University of Virginia
Mike WoodGeorge Mason University