DC-2003--Seattle Proceedings

Papers and Project Reports for DC-2003 in Seattle, 28 September - 2 October 2003.
Supporting Communities of Discourse and Practice
ISBN: 0-9745303-0-1

Directory	PDF

Full Papers

Integrating Metadata Schema Registries with Digital Preservation Systems to Support Interoperability: a Proposal	PDF
Michael Day	pp. 3-10

Metadata schema registries in the partially Semantic Web: the CORES experience	PDF
Rachel Heery, Pete Johnston, Csaba Fülöp, András Micsik	pp. 11-18

Two Paths to Interoperable Metadata	PDF
Carol Jean Godby, Devon Smith, Eric Rogers Childress	pp. 19-27

Search and Delivery of Standardized Learning Resources Based on SOAP Messaging and Native XML Databases	PDF
Xin Xiang, Ling Guo, Yuanchun Shi	pp. 29-36

Building Quality Assurance into Metadata Creation: An Analysis based on the Learning Objects and e-Prints Communities of Practice	PDF
Jane Barton, Sarah Currier, Jessie M. N. Hey	pp. 39-48

Iterative Design of Metadata Creation Tools for Resource Authors	PDF
Jane Greenberg, Abe Crystal, W. Davenport Robertson, Ellen Leadem	pp. 49-58

A Subject gateway in Multiple Languages: A Prototype Development and Lessons Learned	PDF
Wonsook Lee, Shigeo Sugimoto, Mitsuharu Nagamori, Tetsuo Sakaguchi, Koichi Tabata	pp. 59-66

Distributing and Synchronizing Heterogeneous Metadata for the Management of Geospatial Information Repositories	PDF
Elaine L. Westbrooks	pp. 67-77

Statistical Metadata Needs during Integration Tasks	PDF
Sheila Denn, Stephanie W. Haas, Carol A. Hert	pp. 81-90

Functional Requirements of Metadata System: From User Needs Perspective	PDF
Ya-ning Chen, Shu-jiun Chen, Hon-chung Sum, Simon C. Lin	pp. 91-98

Access to Italian legal literature: Integration between Structured Repositories and Web Documents	PDF
Enrico Francesconi, G. Peruginell	pp. 99-107

The Use of Metadata for the Identification and Retrieval of Resources for K–12 Education	PDF
John S. Kendall	pp. 109-117

Metadata in the Collaboratory for Multi-Scale Chemical Science

PDF

Carmen Pancerella, John Hewson, Wendy Koegler, David Leahy, Michael Lee, Larry Rahn, Christine Yang, James D. Myers, Brett Didier, Renata McCoy, Karen Schuchardt, Eric Stephan, Theresa Windus, Kaizar Amin, Sandra Bittner, Carina Lansing, Michael Minkoff, Sandeep Nijsure, Gregor von Laszewski, Reinhardt Pinzon, Branko Ruscic, Al Wagner, Baoshan Wang, William Pitz, Yen-Ling Ho, David Montoya, Lili Xu, Thomas C. Allison, William H. Green, Jr., Michael Frenklach

pp. 121-129

Metadata with a MISSION: Using Metadata to Query Distributed Statistical Meta-information Syste	PDF
Sally McClean, Brian Scotney, Hans Rutjes	pp. 131-141

Using the OpenURL Framework to Locate Bibliographic Resources	PDF
Ann Apps, Ross MacIntyre	pp. 143-152

Structured Metadata for Direct Resource Location: A Case Study	PDF
Gauri Salokhe, James Weinheimer, Maria Grazia Bovo, Moira Agrimi, Johannes Keizer, Stephen Katz	pp. 153-158

Analyzing Metadata for Effective Use and Re-Use	PDF
Naomi Dushay, Diane I. Hillmann	pp. 161-170

Assessing Metadata Utilization: An Analysis of MARC Content Designation Use	PDF
William E. Moen, Penelope Benardino	pp. 171-180

Towards Identity Conditions for Digital Documents	PDF
Allen Renear, David Dubin	pp. 181-189

AMS--Metadata for Cultural Exhibitions using Virtual Reality	PDF
Nicholaos Mourkoussis, Martin White, Manjula Patel, Jacek Chmielewski, Krzysztof Walczak	pp. 193-202

Imagining the Northwest : A Digital Library Partnership in Oregon	PDF
Corey A. Harper, Nathan Georgitis, Carol Hixson	pp. 203-212

PB Core--the Public Broadcasting Metadata Initiative: Progress Report	PDF
Alison M. While, Alan Baker, Marty Bloss, Paul E. Burrows, Efthimis N. Efthimiadis, Marcia Brooks, David MacCarn, Thom Shepard, Cate Twohill	pp. 213-222

Integrating Resource Metadata and Domain Markup in an NSDL Collection	PDF
Gregory M. Shreve, Marcia Lei Zeng	pp. 223-229

Posters

Using Dublin Core to Facilitate Cross-Collection Searches in an Enterprise Image Repository	PDF
Kevin J. Hegg, Andreas R. Knab	pp. 233--234

Encoding Scheme Registration in the Government of Canada	PDF
Deane Henderson Zeeman, Joy Bell	pp. 235-236

Evolving Metadata Needs for an Institutional Repository: MIT's DSpace	PDF
Margret Branschofsky, Rebecca Lubas, MacKenzie Smith, Sarah Williams	pp. 237-238

Generation of XML Records Across Multiple Metadata Standards	PDF
Kimberly S. Lightle, Judy Ridgway, Janet Kahkonen Smith	pp. 239-240

Developing a Collection Registry for IMLS NLG Digital Collections	PDF
Sarah L. Shreeves, Timothy W. Cole	pp. 241-242

Tracking Metadata Use for Digital Collections	PDF
Ellen Knutson, Carol Palmer, Michael Twidale	pp. 243-244

Study of 13-17th century Marathi manuscripts: author generated metadata and its mapping with Dublin Core	PDF
Shubhada Nagarkar, Harsha Parekh, V.L. Manjul	pp. 245-246

A Preliminary Investigation of Metadata Description Mechanisms for Materials Science	PDF
Laura M. Bartolo, Cathy S. Lowe	pp. 247-248

That was then, this is now…: processes, services and the future of New Zealand government portals	PDF
Sara Barham	pp. 249-251

University of Washington Early Buddhist Manuscripts Project in DSpace	PDF
Kathleen Forsythe, Alan Grosenheider, Eileen Llona, Jennifer Ward	pp. 253-254

Automatically Categorizing Metadata Databases into a Categorization Scheme on a Large Scale Web Site	PDF
Barbara Richards, Boris Lauser, Johannes Keizer, Stephen Katz	pp. 255-256

Effective e-learning Content Discovery Using the Bath Profile	PDF
Dan Noyes	pp. 257-258

ISSN: 1939-1366

SELECT * FROM sessions WHERE session_id = a5ce42b1641fd6a1b36e7b445fa955c7 Speed: 0.919 ms

DELETE FROM sessions WHERE session_id = a5ce42b1641fd6a1b36e7b445fa955c7 Speed: 0.488 ms

INSERT INTO sessions (session_id, ip_address, user_agent, created, last_used, remember, data, acting_as) VALUES (a5ce42b1641fd6a1b36e7b445fa955c7, 38.107.179.228, CCBot/1.0 (+http://www.commoncrawl.org/bot.html), 1328795598, 1328795598, 0, , 0 Speed: 0.451 ms

SELECT * FROM journals WHERE path = pu Speed: 0.258 ms

Speed: 0.224 ms

Speed: 0.307 ms

Speed: 0.574 ms

SELECT * FROM issue_settings WHERE issue_id = 26 Speed: 0.262 ms

SELECT DISTINCT pa.*, a.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev, s.abstracts_not_required AS abstracts_not_required, s.hide_title AS section_hide_title, s.hide_author AS section_hide_author, COALESCE(o.seq, s.seq) AS section_seq, pa.seq FROM published_articles pa, articles a LEFT JOIN sections s ON s.section_id = a.section_id LEFT JOIN custom_section_orders o ON (a.section_id = o.section_id AND o.issue_id = 26) LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US) LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US) LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US) LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US) WHERE pa.article_id = a.article_id AND pa.issue_id = 26 Speed: 14.349 ms

SELECT g.*, a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_galleys g LEFT JOIN article_files a ON (g.file_id = a.file_id) WHERE g.article_id = 7 ORDER BY g.seq2 Speed: 23.100 ms

Speed: 0.263 ms

SELECT * FROM author_settings WHERE author_id = 2036 Speed: 0.258 ms

SELECT * FROM article_settings WHERE article_id = 727 Speed: 0.250 ms

SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 7 ORDER BY s.seq2 Speed: 0.259 ms

Speed: 0.486 ms

SELECT * FROM author_settings WHERE author_id = 2037 Speed: 0.510 ms

SELECT * FROM article_settings WHERE article_id = 728 Speed: 0.523 ms

Speed: 0.522 ms

SELECT * FROM author_settings WHERE author_id = 2038 Speed: 0.453 ms

SELECT * FROM author_settings WHERE author_id = 2039 Speed: 0.460 ms

SELECT * FROM author_settings WHERE author_id = 2040 Speed: 0.463 ms

SELECT * FROM author_settings WHERE author_id = 2041 Speed: 0.459 ms

SELECT * FROM article_settings WHERE article_id = 729 Speed: 0.523 ms

Speed: 0.504 ms

SELECT * FROM author_settings WHERE author_id = 2042 Speed: 0.462 ms

SELECT * FROM author_settings WHERE author_id = 2043 Speed: 0.461 ms

SELECT * FROM author_settings WHERE author_id = 2044 Speed: 0.463 ms

SELECT * FROM article_settings WHERE article_id = 730 Speed: 0.493 ms

Speed: 0.502 ms

SELECT * FROM author_settings WHERE author_id = 2045 Speed: 0.461 ms

SELECT * FROM author_settings WHERE author_id = 2046 Speed: 0.485 ms

SELECT * FROM author_settings WHERE author_id = 2047 Speed: 0.470 ms

SELECT * FROM article_settings WHERE article_id = 731 Speed: 0.505 ms

Speed: 0.506 ms

SELECT * FROM author_settings WHERE author_id = 2048 Speed: 0.541 ms

SELECT * FROM author_settings WHERE author_id = 2049 Speed: 0.476 ms

SELECT * FROM author_settings WHERE author_id = 2050 Speed: 0.475 ms

SELECT * FROM article_settings WHERE article_id = 732 Speed: 0.513 ms

Speed: 0.260 ms

SELECT * FROM author_settings WHERE author_id = 2051 Speed: 0.247 ms

SELECT * FROM author_settings WHERE author_id = 2052 Speed: 0.251 ms

SELECT * FROM author_settings WHERE author_id = 2053 Speed: 0.252 ms

SELECT * FROM author_settings WHERE author_id = 2054 Speed: 0.254 ms

SELECT * FROM article_settings WHERE article_id = 733 Speed: 0.257 ms

Speed: 0.261 ms

SELECT * FROM author_settings WHERE author_id = 2055 Speed: 0.252 ms

SELECT * FROM author_settings WHERE author_id = 2056 Speed: 0.249 ms

SELECT * FROM author_settings WHERE author_id = 2057 Speed: 0.252 ms

SELECT * FROM author_settings WHERE author_id = 2058 Speed: 0.251 ms

SELECT * FROM author_settings WHERE author_id = 2059 Speed: 0.250 ms

SELECT * FROM article_settings WHERE article_id = 734 Speed: 0.257 ms

Speed: 0.472 ms

SELECT * FROM author_settings WHERE author_id = 2060 Speed: 0.492 ms

SELECT * FROM article_settings WHERE article_id = 735 Speed: 0.526 ms

Speed: 0.514 ms

SELECT * FROM author_settings WHERE author_id = 2061 Speed: 0.502 ms

SELECT * FROM author_settings WHERE author_id = 2062 Speed: 0.485 ms

SELECT * FROM author_settings WHERE author_id = 2063 Speed: 0.497 ms

SELECT * FROM article_settings WHERE article_id = 736 Speed: 0.517 ms

Speed: 0.524 ms

SELECT * FROM author_settings WHERE author_id = 2064 Speed: 0.495 ms

SELECT * FROM author_settings WHERE author_id = 2065 Speed: 0.484 ms

SELECT * FROM author_settings WHERE author_id = 2066 Speed: 0.488 ms

SELECT * FROM author_settings WHERE author_id = 2067 Speed: 0.486 ms

SELECT * FROM article_settings WHERE article_id = 737 Speed: 0.500 ms

Speed: 0.495 ms

SELECT * FROM author_settings WHERE author_id = 2068 Speed: 0.478 ms

SELECT * FROM author_settings WHERE author_id = 2069 Speed: 0.499 ms

SELECT * FROM article_settings WHERE article_id = 738 Speed: 0.601 ms

Speed: 0.256 ms

SELECT * FROM author_settings WHERE author_id = 2070 Speed: 0.247 ms

SELECT * FROM article_settings WHERE article_id = 739 Speed: 0.257 ms

Speed: 0.284 ms

SELECT * FROM author_settings WHERE author_id = 2071 Speed: 0.252 ms

SELECT * FROM author_settings WHERE author_id = 2072 Speed: 0.248 ms

SELECT * FROM author_settings WHERE author_id = 2073 Speed: 0.250 ms

SELECT * FROM author_settings WHERE author_id = 2074 Speed: 0.250 ms

SELECT * FROM author_settings WHERE author_id = 2075 Speed: 0.248 ms

SELECT * FROM author_settings WHERE author_id = 2076 Speed: 0.248 ms

SELECT * FROM author_settings WHERE author_id = 2077 Speed: 0.248 ms

SELECT * FROM author_settings WHERE author_id = 2078 Speed: 0.254 ms

SELECT * FROM author_settings WHERE author_id = 2079 Speed: 0.250 ms

SELECT * FROM author_settings WHERE author_id = 2080 Speed: 0.248 ms

SELECT * FROM author_settings WHERE author_id = 2081 Speed: 0.250 ms

SELECT * FROM author_settings WHERE author_id = 2082 Speed: 0.249 ms

SELECT * FROM author_settings WHERE author_id = 2083 Speed: 0.252 ms

SELECT * FROM author_settings WHERE author_id = 2084 Speed: 0.250 ms

SELECT * FROM author_settings WHERE author_id = 2085 Speed: 0.247 ms

SELECT * FROM author_settings WHERE author_id = 2086 Speed: 0.250 ms

SELECT * FROM author_settings WHERE author_id = 2087 Speed: 0.249 ms

SELECT * FROM author_settings WHERE author_id = 2088 Speed: 0.249 ms

SELECT * FROM author_settings WHERE author_id = 2089 Speed: 0.250 ms

SELECT * FROM author_settings WHERE author_id = 2090 Speed: 0.250 ms

SELECT * FROM author_settings WHERE author_id = 2091 Speed: 0.250 ms

SELECT * FROM author_settings WHERE author_id = 2092 Speed: 0.252 ms

SELECT * FROM author_settings WHERE author_id = 2093 Speed: 0.250 ms

SELECT * FROM author_settings WHERE author_id = 2094 Speed: 0.250 ms

SELECT * FROM author_settings WHERE author_id = 2095 Speed: 0.252 ms

SELECT * FROM author_settings WHERE author_id = 2096 Speed: 0.252 ms

SELECT * FROM author_settings WHERE author_id = 2097 Speed: 0.251 ms

SELECT * FROM author_settings WHERE author_id = 2098 Speed: 0.251 ms

SELECT * FROM author_settings WHERE author_id = 2099 Speed: 0.250 ms

SELECT * FROM author_settings WHERE author_id = 2100 Speed: 0.247 ms

SELECT * FROM article_settings WHERE article_id = 740 Speed: 0.262 ms

Speed: 0.507 ms

SELECT * FROM author_settings WHERE author_id = 2101 Speed: 0.491 ms

SELECT * FROM author_settings WHERE author_id = 2102 Speed: 0.481 ms

SELECT * FROM author_settings WHERE author_id = 2103 Speed: 0.487 ms

SELECT * FROM article_settings WHERE article_id = 741 Speed: 0.467 ms

Speed: 0.486 ms

SELECT * FROM author_settings WHERE author_id = 2104 Speed: 0.495 ms

SELECT * FROM author_settings WHERE author_id = 2105 Speed: 0.468 ms

SELECT * FROM article_settings WHERE article_id = 742 Speed: 0.477 ms

Speed: 0.556 ms

SELECT * FROM author_settings WHERE author_id = 2106 Speed: 0.490 ms

SELECT * FROM author_settings WHERE author_id = 2107 Speed: 0.493 ms

SELECT * FROM author_settings WHERE author_id = 2108 Speed: 0.486 ms

SELECT * FROM author_settings WHERE author_id = 2109 Speed: 0.501 ms

SELECT * FROM author_settings WHERE author_id = 2110 Speed: 0.490 ms

SELECT * FROM author_settings WHERE author_id = 2111 Speed: 0.488 ms

SELECT * FROM article_settings WHERE article_id = 743 Speed: 0.494 ms

Speed: 0.495 ms

SELECT * FROM author_settings WHERE author_id = 2112 Speed: 0.492 ms

SELECT * FROM author_settings WHERE author_id = 2113 Speed: 0.497 ms

SELECT * FROM article_settings WHERE article_id = 744 Speed: 0.470 ms

Speed: 0.482 ms

SELECT * FROM author_settings WHERE author_id = 2114 Speed: 0.497 ms

SELECT * FROM author_settings WHERE author_id = 2115 Speed: 0.497 ms

SELECT * FROM article_settings WHERE article_id = 745 Speed: 0.470 ms

Speed: 0.256 ms

SELECT * FROM author_settings WHERE author_id = 2116 Speed: 0.248 ms

SELECT * FROM author_settings WHERE author_id = 2117 Speed: 0.248 ms

SELECT * FROM article_settings WHERE article_id = 746 Speed: 0.261 ms

Speed: 0.533 ms

SELECT * FROM author_settings WHERE author_id = 2118 Speed: 0.452 ms

SELECT * FROM author_settings WHERE author_id = 2119 Speed: 0.473 ms

SELECT * FROM author_settings WHERE author_id = 2120 Speed: 0.451 ms

SELECT * FROM author_settings WHERE author_id = 2121 Speed: 0.456 ms

SELECT * FROM author_settings WHERE author_id = 2122 Speed: 0.463 ms

SELECT * FROM article_settings WHERE article_id = 747 Speed: 0.462 ms

Speed: 0.499 ms

SELECT * FROM author_settings WHERE author_id = 2123 Speed: 0.461 ms

SELECT * FROM author_settings WHERE author_id = 2124 Speed: 0.448 ms

SELECT * FROM author_settings WHERE author_id = 2125 Speed: 0.472 ms

SELECT * FROM article_settings WHERE article_id = 748 Speed: 0.474 ms

Speed: 0.261 ms

SELECT * FROM author_settings WHERE author_id = 2126 Speed: 0.248 ms

SELECT * FROM author_settings WHERE author_id = 2127 Speed: 0.250 ms

SELECT * FROM author_settings WHERE author_id = 2128 Speed: 0.249 ms

SELECT * FROM author_settings WHERE author_id = 2129 Speed: 0.251 ms

SELECT * FROM author_settings WHERE author_id = 2130 Speed: 0.249 ms

SELECT * FROM author_settings WHERE author_id = 2131 Speed: 0.249 ms

SELECT * FROM author_settings WHERE author_id = 2132 Speed: 0.247 ms

SELECT * FROM author_settings WHERE author_id = 2133 Speed: 0.250 ms

SELECT * FROM author_settings WHERE author_id = 2134 Speed: 0.252 ms

SELECT * FROM article_settings WHERE article_id = 749 Speed: 0.255 ms

Speed: 0.491 ms

SELECT * FROM author_settings WHERE author_id = 2135 Speed: 0.476 ms

SELECT * FROM author_settings WHERE author_id = 2136 Speed: 0.472 ms

SELECT * FROM article_settings WHERE article_id = 750 Speed: 0.487 ms

Speed: 0.255 ms

SELECT * FROM author_settings WHERE author_id = 2137 Speed: 0.251 ms

SELECT * FROM author_settings WHERE author_id = 2138 Speed: 0.258 ms

SELECT * FROM article_settings WHERE article_id = 751 Speed: 0.264 ms

Speed: 0.496 ms

SELECT * FROM author_settings WHERE author_id = 2139 Speed: 0.496 ms

SELECT * FROM author_settings WHERE author_id = 2140 Speed: 0.484 ms

SELECT * FROM article_settings WHERE article_id = 752 Speed: 0.499 ms

Speed: 0.551 ms

SELECT * FROM author_settings WHERE author_id = 2141 Speed: 0.487 ms

SELECT * FROM author_settings WHERE author_id = 2142 Speed: 0.470 ms

SELECT * FROM author_settings WHERE author_id = 2143 Speed: 0.498 ms

SELECT * FROM author_settings WHERE author_id = 2144 Speed: 0.488 ms

SELECT * FROM article_settings WHERE article_id = 753 Speed: 0.492 ms

Speed: 0.271 ms

SELECT * FROM author_settings WHERE author_id = 2145 Speed: 0.261 ms

SELECT * FROM author_settings WHERE author_id = 2146 Speed: 0.263 ms

SELECT * FROM author_settings WHERE author_id = 2147 Speed: 0.261 ms

SELECT * FROM article_settings WHERE article_id = 754 Speed: 0.263 ms

Speed: 0.270 ms

SELECT * FROM author_settings WHERE author_id = 2148 Speed: 0.262 ms

SELECT * FROM author_settings WHERE author_id = 2149 Speed: 0.258 ms

SELECT * FROM article_settings WHERE article_id = 755 Speed: 0.264 ms

Speed: 0.266 ms

SELECT * FROM author_settings WHERE author_id = 2150 Speed: 0.261 ms

SELECT * FROM author_settings WHERE author_id = 2151 Speed: 0.260 ms

SELECT * FROM author_settings WHERE author_id = 2152 Speed: 0.259 ms

SELECT * FROM article_settings WHERE article_id = 756 Speed: 0.266 ms

Speed: 0.511 ms

SELECT * FROM author_settings WHERE author_id = 2153 Speed: 0.511 ms

SELECT * FROM author_settings WHERE author_id = 2154 Speed: 0.508 ms

SELECT * FROM author_settings WHERE author_id = 2155 Speed: 0.507 ms

SELECT * FROM article_settings WHERE article_id = 757 Speed: 0.500 ms

Speed: 0.267 ms

SELECT * FROM author_settings WHERE author_id = 2156 Speed: 0.261 ms

SELECT * FROM author_settings WHERE author_id = 2157 Speed: 0.262 ms

SELECT * FROM article_settings WHERE article_id = 758 Speed: 0.265 ms

Speed: 0.471 ms

SELECT * FROM author_settings WHERE author_id = 2158 Speed: 0.520 ms

SELECT * FROM article_settings WHERE article_id = 759 Speed: 0.487 ms

Speed: 0.523 ms

SELECT * FROM author_settings WHERE author_id = 2159 Speed: 0.540 ms

SELECT * FROM author_settings WHERE author_id = 2160 Speed: 0.455 ms

SELECT * FROM author_settings WHERE author_id = 2161 Speed: 0.458 ms

SELECT * FROM author_settings WHERE author_id = 2162 Speed: 0.465 ms

SELECT * FROM article_settings WHERE article_id = 760 Speed: 0.507 ms

Speed: 0.541 ms

SELECT * FROM author_settings WHERE author_id = 2163 Speed: 0.470 ms

SELECT * FROM author_settings WHERE author_id = 2164 Speed: 0.461 ms

SELECT * FROM author_settings WHERE author_id = 2165 Speed: 0.467 ms

SELECT * FROM author_settings WHERE author_id = 2166 Speed: 0.476 ms

SELECT * FROM article_settings WHERE article_id = 761 Speed: 0.518 ms

Speed: 0.267 ms

SELECT * FROM author_settings WHERE author_id = 2167 Speed: 0.261 ms

SELECT * FROM article_settings WHERE article_id = 762 Speed: 0.264 ms

SELECT * FROM journals WHERE journal_id = 1 Speed: 0.260 ms

SELECT pa.*, a.*, COALESCE(stl.setting_value, stpl.setting_value) AS section_title, COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev FROM published_articles pa, articles a LEFT JOIN sections s ON s.section_id = a.section_id LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US) LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US) LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US) LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US Speed: 0.390 ms

SELECT iss.subscription_id FROM institutional_subscriptions iss, subscriptions s, subscription_types st WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD(38.107.179.228, LENGTH(38.107.179.228)+1, '.'))) != 0 AND iss.domain != '' AND iss.subscription_id = s.subscription_id AND s.journal_id = 1 Speed: 0.716 ms

SELECT isip.subscription_id FROM institutional_subscription_ip isip, subscriptions s, subscription_types st WHERE ((isip.ip_end IS NOT NULL AND 644592612 >= isip.ip_start AND 644592612 <= isip.ip_end AND isip.subscription_id = s.subscription_id AND s.journal_id = 1 AND s.status = 1 AND s.type_id = st.type_id AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2012-02-09 22:53:18' >= s.date_start AND '2012-02-09 22:53:18' <= s.date_end))) AND (st.format = 1 OR st.format = 17)) OR (isip.ip_end IS NULL AND 644592612 = isip.ip_start AND isip.subscription_id = s.subscription_id AND s.journal_id = 1 Speed: 0.854 ms

SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = newnav AND setting_name = enabled AND journal_id = 1 Speed: 0.296 ms

UPDATE plugin_settings SET setting_value = 1, setting_type = bool WHERE plugin_name = newnav AND setting_name = enabled AND journal_id = 1 Speed: 0.533 ms

SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = newnav AND journal_id = 1 Speed: 0.262 ms

`0` Logs	`0` Errors
`1` Memory	`1` Speed

memory	310.13 kB string: PKPApplication::construct
speed	1.098 ms PKPApplication::construct