230 likes | 355 Vues
Explore innovative projects focusing on system designs for auction portals, resume services, and tourism information systems. Implement incremental bidding for auction items, support alumni networks with social features, and utilize web-based data access for course management. Harness the power of GIS for spatial databases, multimedia content retrieval, and data warehousing to create efficient and secure database applications. These diverse projects showcase advanced techniques in data integration, security measures, and dynamic data retrieval, catering to various domains.
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.