CECS Classes Taught by Dr. Monge
This is the introductory database class taught at CSULB; it is a required course for the BS in computer science. The class covers the following fundamental topics of database systems: database modeling, relational database design, the relational database model, and the query languages: relational algebra and SQL. The class has a design focus and uses UML to represent database models. The content of the course follows the online tutorial on Database Design with UML and SQL by Tom Jewett. It differs greatly from courses taught at other universities in that the focus is database design and query design skills. Typical undergraduate database courses taught in many computer science departments also teach transaction processsing, concurrency control, additional theoretical query languages, query optimization, etc.
This class is scheduled every semester, typically two different sections.
This followup course to CECS-323 focuses on the development of data-intensive applications. It is a project intensive course where students work in groups to design and implement a database and an application. While the application to be built could take different forms, I have always required that a web application be implemented. Lectures and reading materials teach students the issues and processes involved in designing and implementing a web application and practical database development such as transaction management, stored procedures, triggers, views, database API, etc. The technology used can also vary, in the past this has included Perl, PHP, and JSP/Servlets (most recent choice).
The course description has recently been updated as follows which better reflects the topics covered in the class. In addition, CECS-423 fulfills the Computer Science Senior Capstone requirement that's effective starting with the 2007/08 catalog requirements.
The class is typically scheduled in Spring semesters only.
This course will be offered for the first time in Spring-2007. Information retrieval is a field that studies the technology used by search engines like Google in order to retrieving information (web pages that contain the information) from a collection of documents (the entire web) that satisfies a user request (query). For example, given a collection of documents in the field of medicine, a user may want to know what data exists that links the consumption of red wine to a reduction in coronary heart disease. In this class, I will present some of the traditional information retrieval techniques like the vector space model. After studying the traditional concepts, the class will then move on to study WWW information retrieval. In a traditional IR system, the collection of documents is static. Considering the WWW as a collection of web pages (documents), it is clear to see that this is a dynamic collection. In addition to the changes of web pages and the creation/deletion of web pages, they are also linked together. A WWW IR system must therefore crawl the web to find new/changed web pages, index the terms in these pages, and when a query is presented, it must rank the retrieved pages by a measure that is indicative of the relevance of the web page to the query.
This graduate course studies the logical and physical architecture of a database system. The topics covered vary each time offered and include the following: database normalization, query processing and optimization, data organization and indexing, transaction management, concurrency control, OLAP, data mining, object oriented database models.
This course is theoretical in nature and there is typically a limited number of assignments of a practical nature. It is typical for a paper project to be assigned; such a paper might ask students to compare the query processing and optimization features of a database system, or to report on object oriented database products.
It is typically scheduled in Fall semesters only