230 likes | 346 Views
DBMS Lab Projects. Information System Design. Auction Portal. Items Bidders Bid Managers Lowest Bid Incremental Bidding. Resume Posting Service. Resume Posts Employers Managers Matching. Tourism Information System. Data Integration Location Aware Services Map Based Interface
E N D
Auction Portal • Items • Bidders • Bid • Managers • Lowest Bid • Incremental Bidding
Resume Posting Service • Resume • Posts • Employers • Managers • Matching
Tourism Information System • Data Integration • Location Aware Services • Map Based Interface • Travel Information
Web Based Dictionary • Data Organization • Graph Structure
Financial Portfolio Managers • Users • Projections • Web based data access
Automatic Time Table and Course Management System • Courses • Class rooms • Hard constraints • Soft Constraints
Social Network of IIT Alumni • Friends • Communities • Blogs • Events
Web 2.0 Mashup is a web application that combines data from more than one source into a single integrated tool via a local database; an example is the use of cartographic data from Google Maps to add location information to real-estate data from Craigslist, thereby creating a new and distinct web service that was not originally provided by either source.
Spatial Database • GIS • Spatio-temporal data • Implement spatial queries and schemas
Multimedia Databases • Content Based Retrieval • Geometric Data Structures • Music Databases
Streaming Data • Network Monitoring • Streaming Queries
XML Databases • Query processor for restricted XQuery • XML to RDBMS Converter • XML database design • Biological data • Financial data
Sequence Databases • Proteins, Gene sequences • Motif, structure finding • http://rdp.cme.msu.edu/
OODB • Build a gaming framework using MyOODB
Fuzzy Databases • FSQL
Text Databases • Indexing – Zipfs law • Search
Data warehousing • Datacube materialization • Warehouse design • OLAP queries
Data Mining • http://mill.ucsd.edu/
Database Security • Checking a SQL query for SQL injection vulnerability • statement := "SELECT * FROM users WHERE name = '" + userName + "';" • setting the "userName" variable as a' or 't'='t , renders • SELECT * FROM users WHERE name = 'a' OR 't'='t'; • If this code were to be used in an authentication procedure then this example could be used to force the selection of a valid username because the evaluation of 't'='t' is always true.