Lisa Justine Hernandez Computer Science, BS Director: Dr. Laura J. Baker

1. Online Searchable Database of Chicana/Latina Studies: The Journal of Mujeres Activas en Letras y Cambios Sociales (MALCS) Lisa Justine Hernandez Computer Science, BS Director: Dr. Laura J. Baker

2. Background • Chicana/Latina Journal: The Journal of Mujeres Activas en Letras y Cambios Sociales (MALCS) • established 1991 • a print-based, peer-reviewed journal • generously supported by Loyola Marymount University in California. • MALCS Summer Research Institute Summer 2007 • journal’s editors inquired about a searchable database

3. Problem • Current journal webpage • difficult for editors to update • only displays 2001 and 2004 table of contents • The Project • Portability • hosted on dreamhost.com • Accessibility • web-based interface with HTML, PHP, and MySQL • searchable user-interface with client administration

4. Possible Solutions Ready Made Software • RefWorks research management • COST & STYLE • Web Reference Database scientific literature • COMPLEX & STYLE • MetaPress end-user access for publishers • COST & COMPLEX • Aztlán: A Journal of Chicano Studies

5. MetaPress: Journal Hosting Site Existing Website for Another Journal If you want it done right…

6. Do it yourself: The Project

7. The Project: ADMIN interface

8. MySQL Tables InnoDB and referential integrity

9. Php and HTML //CHECK NUMBER OF ENTRIES in ONE ISSUE (ENTRY TABLE)—start with POST[id] $result=@mysql_query("SELECT * FROM entryWHERE ref_issue_id = $_POST[id]"); //POST[id] is ISSUE ID //fetch entries one row at a time $count=1; while($row =mysql_fetch_object($result)){ $read=$row->id_entry; // ENTRY ID //AUTHOR INFO // get author IDs in ONE ENTRY (ENTRY-HAS-AUTHOR TABLE)—use id_entry $pivot = @mysql_query("SELECT * FROM entry_has_author WHERE entry_id_entry = $row->id_entry"); $authors= @mysql_num_rows($pivot); print("<b>Author"); if ($authors > 1){print("s");} print(": </b>"); while($line = mysql_fetch_object($pivot)){ //look up fields for ONE AUTHOR (AUTHOR TABLE)—use author_id_author $row_name= @mysql_query("SELECT * FROM authorWHERE id_author = $line->author_id_author"); $name = mysql_fetch_object($row_name); print($fn=$name->first_name); print(" "); print($mn=$name->middle_initial); print(" "); print($ln=$name->last_name); if ($authors>2){ print(", ");} else {if ($authors==2){print(" and ");}} --$authors;}

10. Results and Analysis • All functions fully operational • Ongoing testing on three sites • CS server • Dreamhost server • Two mirror sites • Six outside testers • 2 advanced, 2 intermediate, 2 novice • Only half have returned results. • Minor problems in user interface

11. Future Work • Implement clients’ requests • journal editors • minor graphic design and terminology changes • special Spanish characters and font style • admin password maintenance • webmaster • integration of the project into existing site • shopping cart for newer PDF files

12. Conclusion • The project created a web-based searchable database of journal issues published in print. • This web application provides a much-needed service promoting Chicana/Latina studies via the universal media-based world-wide-web. NEXT GOAL: create custom sites for other publications and CONNECT THEM TOGETHER with a shared META-Search Engine

13. Questions? Email: lisah@stedwards.edu