Database - Monday April 9, 2007

1) Prepare for project presentation (final)
     Final will be based on your database project and its functions

2) Bring textbook or any supplement +2 and discuss readings

3) Building user interface to make your system accessible through the web

4) Classmate interview for Quality Assurance Analyst


Can you relate your database with Google?

Both have search

Wikipedia has search and will allow you to insert, delete, and modify

Youtube will let you search and add to the database


Database functions:

1) Insert (Add)

2) Search (Locate, Select)

3) Display

4) Modify (Update, Edit)

From ACM:

dbSwitch™: towards a database utility

Savantis Systems' dbSwitch™ is an innovative commercial product providing database server virtualization and advancing a database utility model. The dbSwitch enables a new architecture, called a Database Area Network (DAN), which pools database server resources and shares them among multiple database applications. Specific benefits of the DAN architecture for enterprise data centers include server consolidation, improved utilization, high availability and capacity management. We describe the major components of the dbSwitch, namely routing of application requests to database instances, optimization of database server resources and capacity visualization and manipulation. We also relate dbSwitch to recent work on utility and grid computing.

Sample Search Function (example of Linear Search O(n)):

int searchCourse(string crn){

          for(int i=0;i<z;i++) if(crn==c[i].CRN) return i;//FOR

                   return -1;

}//SEARCH COURSE BY CRN


Try Dev C++ Compiler or Borland or Visual Studio C++ Express