Login or register for free to remove ads.

The New Media Juke Box - a multimedia project PROCEEDINGS

, , , NewMinE Lab, Switzerland

EdMedia: World Conference on Educational Media and Technology, in Honolulu, Hawaii, USA ISBN 978-1-880094-48-8 Publisher: Association for the Advancement of Computing in Education (AACE)

Abstract

The New Media Juke-Box is an experiment carried out at the University of Lugano in collaboration with the RTSI – Radio and Television of Italian-speaking Switzerland. The goal of the project was the integration and exploitation of archive media artefact into a new learning context. After a review of a general model of educational multimedia, a case study is presented, along with lessons learnt, general conclusions and some critical remarks.

Citation

Botturi, L., Inglese, T. & Rozalèn, S. (2003). The New Media Juke Box - a multimedia project. In D. Lassner & C. McNaught (Eds.), Proceedings of EdMedia: World Conference on Educational Media and Technology 2003 (pp. 984-989). Association for the Advancement of Computing in Education (AACE).


Feedback and Suggestions please email info@editlib.org or use our online feedback form.


Debugging Information
Railo (Togo) Os FINAL 4.2.1.008 (CFML Version 10,0,0,0)
Template /index.cfm (/var/sites/railo.editlib.org/index.cfm)
Time Stamp Feb 12, 2016 5:39 AM
Time Zone UCT
Locale English (us)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.196.244.206
Host Name www.editlib.org
Architecture 64bit


Execution Time

Total Time Avg Time Count Template
301 ms 301 ms 1 /var/sites/railo.editlib.org/logger/qry_alsoaccessedpapers.cfm
123 ms 123 ms 1 /var/sites/railo.editlib.org/logger/act_logaccess.cfm
25.2 ms 25.2 ms 1 /var/sites/railo.editlib.org/security/act_checkforpaperaccess.cfm
8.49 ms 8.49 ms 1 /var/sites/railo.editlib.org/models/papers/qry_papers.cfm
14.5 ms 4.84 ms 3 /var/sites/railo.editlib.org/models/sources/qry_source.cfm
8.84 ms 4.42 ms 2 /var/sites/railo.editlib.org/models/papers/qry_paper.cfm
8.73 ms 4.36 ms 2 /var/sites/railo.editlib.org/models/papers/qry_papertopics.cfm
4.24 ms 4.24 ms 1 /var/sites/railo.editlib.org/models/papers/qry_references.cfm
7.76 ms 3.88 ms 2 /var/sites/railo.editlib.org/models/papers/qry_authors.cfm
26.9 ms 3.85 ms 7 /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
3.33 ms 3.33 ms 1 /var/sites/railo.editlib.org/models/papers/qry_papertags.cfm
1.36 ms 1.36 ms 1 /var/sites/railo.editlib.org/layouts/lay_new_2014.cfm
2.17 ms 1.08 ms 2 /var/sites/railo.editlib.org/WEB-INF/railo/customtags/cache.cfm
2.13 ms 1.06 ms 2 /var/sites/railo.editlib.org/WEB-INF/railo/customtags/ini2struct.cfm
0.936 ms 0.468 ms 2 /var/sites/railo.editlib.org/reader/inc_share.cfm
0.205 ms 0.205 ms 1 /var/sites/railo.editlib.org/Application.cfm
0.202 ms 0.202 ms 1 /var/sites/railo.editlib.org/models/papers/act_generatecitation.cfm
0.089 ms 0.089 ms 1 /var/sites/railo.editlib.org/models/sources/act_generatesourcetext.cfm
0.056 ms 0.056 ms 1 /var/sites/railo.editlib.org/OnRequestEnd.cfm
0.056 ms 0.056 ms 1 /var/sites/railo.editlib.org/reader/inc_tools.cfm
0.08 ms 0.04 ms 2 /var/sites/railo.editlib.org/logger/act_readnavigationhistory.cfm
0.116 ms 0.038 ms 3 /var/sites/railo.editlib.org/security/act_identifyinstitution.cfm
0.034 ms 0.034 ms 1 /var/sites/railo.editlib.org/security/act_determinesubscriptions.cfm
0.068 ms 0.034 ms 2 /var/sites/railo.editlib.org/reader/inc_login.cfm
0.033 ms 0.033 ms 1 /var/sites/railo.editlib.org/reader/inc_collections.cfm
0.777 ms 0.031 ms 25 /var/sites/railo.editlib.org/fbx_Layouts.cfm
0.03 ms 0.03 ms 1 /var/sites/railo.editlib.org/reader/lay_new.cfm
0.029 ms 0.029 ms 1 /var/sites/railo.editlib.org/reader/inc_breadcrumb.cfm
0.115 ms 0.028 ms 4 /var/sites/railo.editlib.org/logger/fbx_Switch.cfm
0.027 ms 0.027 ms 1 /var/sites/railo.editlib.org/logger/act_lognavigationhistory.cfm
0.662 ms 0.026 ms 25 /var/sites/railo.editlib.org/fbx_Settings.cfm
0.086 ms 0.012 ms 7 /var/sites/railo.editlib.org/models/papers/fbx_Switch.cfm
0.301 ms 0.012 ms 25 /var/sites/railo.editlib.org/fbx_Circuits.cfm
0.047 ms 0.011 ms 4 /var/sites/railo.editlib.org/logger/fbx_Settings.cfm
0.028 ms 0.009 ms 3 /var/sites/railo.editlib.org/models/sources/fbx_Switch.cfm
0.037 ms 0.009 ms 4 /var/sites/railo.editlib.org/logger/fbx_Layouts.cfm
0.166 ms 0.009 ms 18 /var/sites/railo.editlib.org/WEB-INF/railo/customtags/nonessential.cfm
0.216 ms 0.008 ms 25 /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm
0.023 ms 0.007 ms 3 /var/sites/railo.editlib.org/security/fbx_Switch.cfm
0.022 ms 0.007 ms 3 /var/sites/railo.editlib.org/security/fbx_Layouts.cfm
0.158 ms 0.006 ms 25 /var/sites/railo.editlib.org/functions.cfm
0.036 ms 0.005 ms 7 /var/sites/railo.editlib.org/models/paperfiles/fbx_Switch.cfm
0.003 ms 0.003 ms 1 /var/sites/railo.editlib.org/reader/fbx_Layouts.cfm
0.008 ms 0.002 ms 3 /var/sites/railo.editlib.org/models/sources/fbx_Settings.cfm
0.002 ms 0.002 ms 1 /var/sites/railo.editlib.org/layouts/inc_jquery_cdn.cfm
0.006 ms 0.002 ms 3 /var/sites/railo.editlib.org/security/fbx_Settings.cfm
0.014 ms 0.002 ms 7 /var/sites/railo.editlib.org/models/paperfiles/fbx_Settings.cfm
0.014 ms 0.002 ms 7 /var/sites/railo.editlib.org/models/papers/fbx_Settings.cfm
0 ms 0 ms 25 /var/sites/railo.editlib.org/index.cfm
0 ms 0 ms 1 /var/sites/railo.editlib.org/reader/dsp_abstract2014.cfm
0 ms 0 ms 1 /var/sites/railo.editlib.org/reader/fbx_Settings.cfm
0 ms 0 ms 1 /var/sites/railo.editlib.org/reader/fbx_Switch.cfm
0.964 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
12.5 ms  APPLICATION EXECUTION TIME
530 ms  QUERY EXECUTION TIME
544 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Caught Exceptions

Type Message Detail Template
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/sources/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/sources/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/sources/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/sources/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/sources/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/sources/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277


SQL Queries

GetPaper (Datasource=aacepubs, Time=4.69 ms, Records=1) in /var/sites/railo.editlib.org/models/papers/qry_paper.cfm
	SELECT
		Papers.paper_id, 
		Papers.paper_oldid,
		Papers.paper_is_locked,
		Papers.paper_code,
		Papers.paper_title, 
		Papers.paper_type,
		Papers.paper_abstract,
		Papers.paper_description,
		Papers.paper_page_start,
		Papers.paper_page_end,
		Papers.paper_awards,
		Papers.paper_file,
		Papers.paper_is_free,
		Papers.free_for_member,
		Papers.paper_free_until,
		Papers.date_of_publication,
		Papers.paper_status,
		Papers.paper_version,
		Papers.paper_contact_person,
		Papers.paper_price,
		Papers.date_imported,
		Papers.date_indexed,
		ContentPartners.contentpartner_name,
		ContentPartners.contentpartner_code,
		
		SourceIssues.sourceissue_id,
		SourceIssues.sourceissue_title, 
		SourceIssues.sourceissue_date,
		SourceIssues.sourceissue_volume, 
		SourceIssues.sourceissue_number,
		SourceIssues.sourceissue_location, 
		SourceIssues.sourceissue_issn,
		SourceIssues.sourceissue_eissn,
		Sources.source_id,
		Sources.source_type,
		Sources.source_title,
		Sources.source_abbr,
		Sources.source_code,
		Sources.source_publisher,
		Sources.source_image,
		Sources.source_description,
		COALESCE(Papers.paper_copyright, SourceIssues.sourceissue_copyright, Sources.source_copyright) AS copyright,
		Publishers.publisher_name,
		Sources.source_issn,
		Sources.source_eissn,
		Sources.source_url,
		Sources.source_location,
		Sources.source_date,
		Sources.source_paper,
		People.person_code,
		People.email AS contact_email,
		People.first_name AS contact_first,
		People.last_name AS contact_last,
		People.organization AS contact_organization,
		COALESCE(Papers.date_of_publication, SourceIssues.sourceissue_date, Sources.source_date) AS paper_date
	FROM
		((Papers LEFT JOIN SourceIssues ON Papers.paper_sourceissue=SourceIssues.sourceissue_id)
		LEFT JOIN Sources ON Papers.paper_source=Sources.source_id)
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code
		LEFT JOIN People ON Papers.paper_contact_person=People.person_id
		LEFT JOIN ContentPartners ON ContentPartners.contentpartner_id=Papers.paper_contentpartner
	WHERE
		
			Papers.date_deleted IS NULL AND
		
		
			Papers.paper_id=13927
		
GetPapers (Datasource=aacepubs_readonly, Time=8.34 ms, Records=0) in /var/sites/railo.editlib.org/models/papers/qry_papers.cfm
	SELECT
		Papers.paper_id, Papers.paper_code, Papers.paper_title, Paper_Status.paper_status_name AS status_name, 
		Papers.paper_is_locked, Papers.date_created, Papers.date_modified, Papers.paper_type,

		Papers.paper_page_start, Papers.paper_page_end,

		Papers.paper_abstract, Papers.paper_comments,

		Papers.paper_decision, Papers.paper_status, 

		People.email AS contact_email,
		People.first_name AS contact_first, People.last_name AS contact_last,
		People.organization AS contact_organization, Countries.country_name AS contact_country,

		Sources.source_code, Sources.source_issn, Sources.source_type, Sources.source_title, Sources.source_abbr, Sources.source_id, Sources.source_authors,
		Sources.source_image,
		Sources.source_description, Sources.source_location,
		Sources.source_date, 
		SourceIssues.sourceissue_id, 
		SourceIssues.sourceissue_volume, SourceIssues.sourceissue_number, SourceIssues.sourceissue_title, SourceIssues.sourceissue_authors,
		SourceIssues.sourceissue_image,
		SourceIssues.sourceissue_date, 

		COALESCE(Publishers.publisher_name, Sources.source_publisher) as publisher_name,
		COALESCE(Papers.date_of_publication, SourceIssues.sourceissue_date, Sources.source_date) AS paper_date,

		(SELECT
			MIN(FullText.paperfile_name)
			FROM
				PaperFiles AS FullText
			WHERE
				FullText.paperfile_paper=Papers.paper_id
				AND FullText.date_deleted IS NULL AND FullText.paperfile_name > ''
				AND FullText.paperfile_hidden = 0 AND FullText.paperfile_type = 'PAPER'
		) AS fulltext_file,

		Authors.author_id,
		Authors.first_name AS author_first,
		Authors.last_name AS author_last,
		Authors.organization AS author_organization,
		AuthorCountries.country_name AS author_country,
		Authors.email AS author_email,
		Thumbnail.paperfile_name AS paper_thumbnail,
		Papers.paper_sourceissue,
		CAST(SourceIssues.sourceissue_volume AS varchar) + ':' + CAST(SourceIssues.sourceissue_number AS VARCHAR) AS issue_string
		

	FROM
		((((((((Papers 
		LEFT JOIN Authors ON Papers.paper_id=Authors.author_paper AND 
		(Authors.author_type IS NULL OR Authors.author_type <> 'C')
		)
		LEFT JOIN Sources ON Papers.paper_source=Sources.source_id)
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code)
		LEFT JOIN People ON Papers.paper_contact_person=People.person_id)
		LEFT JOIN SourceIssues ON Papers.paper_sourceissue=SourceIssues.sourceissue_id)
		LEFT JOIN Paper_Status ON Papers.paper_status=Paper_Status.paper_status_code)
		)
		LEFT JOIN Countries ON People.country=Countries.country_code)
		LEFT JOIN Countries AS AuthorCountries ON Authors.country=AuthorCountries.country_code
		LEFT JOIN PaperFiles AS Thumbnail ON Papers.paper_id = Thumbnail.paperfile_paper AND Thumbnail.paperfile_type = 'THUMBNAIL'
		
	WHERE
		
		
			Papers.date_deleted IS NULL
		

		

		

		

		

		

		

		

		

		

		

		
		
			
					AND Papers.paper_type='Chapter'
					AND EXISTS (
						SELECT *
						FROM
							Sources
						WHERE
							Papers.paper_source=Sources.source_id AND
							Sources.source_paper=13927
					)
				
		
			
					AND Papers.date_added IS NOT NULL
					AND 
					(
						Papers.paper_status='DL_PUBLISH'
						
					)
				
		

		

	ORDER BY
	
		SourceIssues.sourceissue_volume,
		SourceIssues.sourceissue_number,
		Papers.paper_page_start,
		Papers.paper_page_end
	 
GetPaper (Datasource=aacepubs, Time=4.04 ms, Records=1) in /var/sites/railo.editlib.org/models/papers/qry_paper.cfm
	SELECT
		Papers.paper_id, 
		Papers.paper_oldid,
		Papers.paper_is_locked,
		Papers.paper_code,
		Papers.paper_title, 
		Papers.paper_type,
		Papers.paper_abstract,
		Papers.paper_description,
		Papers.paper_page_start,
		Papers.paper_page_end,
		Papers.paper_awards,
		Papers.paper_file,
		Papers.paper_is_free,
		Papers.free_for_member,
		Papers.paper_free_until,
		Papers.date_of_publication,
		Papers.paper_status,
		Papers.paper_version,
		Papers.paper_contact_person,
		Papers.paper_price,
		Papers.date_imported,
		Papers.date_indexed,
		ContentPartners.contentpartner_name,
		ContentPartners.contentpartner_code,
		
		SourceIssues.sourceissue_id,
		SourceIssues.sourceissue_title, 
		SourceIssues.sourceissue_date,
		SourceIssues.sourceissue_volume, 
		SourceIssues.sourceissue_number,
		SourceIssues.sourceissue_location, 
		SourceIssues.sourceissue_issn,
		SourceIssues.sourceissue_eissn,
		Sources.source_id,
		Sources.source_type,
		Sources.source_title,
		Sources.source_abbr,
		Sources.source_code,
		Sources.source_publisher,
		Sources.source_image,
		Sources.source_description,
		COALESCE(Papers.paper_copyright, SourceIssues.sourceissue_copyright, Sources.source_copyright) AS copyright,
		Publishers.publisher_name,
		Sources.source_issn,
		Sources.source_eissn,
		Sources.source_url,
		Sources.source_location,
		Sources.source_date,
		Sources.source_paper,
		People.person_code,
		People.email AS contact_email,
		People.first_name AS contact_first,
		People.last_name AS contact_last,
		People.organization AS contact_organization,
		COALESCE(Papers.date_of_publication, SourceIssues.sourceissue_date, Sources.source_date) AS paper_date
	FROM
		((Papers LEFT JOIN SourceIssues ON Papers.paper_sourceissue=SourceIssues.sourceissue_id)
		LEFT JOIN Sources ON Papers.paper_source=Sources.source_id)
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code
		LEFT JOIN People ON Papers.paper_contact_person=People.person_id
		LEFT JOIN ContentPartners ON ContentPartners.contentpartner_id=Papers.paper_contentpartner
	WHERE
		
			Papers.date_deleted IS NULL AND
		
		
			Papers.paper_id=13927
		
Source (Datasource=aacepubs, Time=5.12 ms, Records=1) in /var/sites/railo.editlib.org/models/sources/qry_source.cfm
	SELECT
		Sources.source_id,
		Sources.source_title,
		Sources.source_type,
		Sources.source_abbr,
		Sources.source_issn,
		Sources.source_eissn,
		Sources.source_image,
		Sources.source_url,
		Sources.source_publisher,
		Sources.source_location,
		Sources.source_date,
		Sources.source_authors,
		Sources.source_serial,
		Sources.source_description,
		Sources.source_code,
		Sources.date_confirmed,
		Sources.confirmed_by,
		SourceIssues.sourceissue_id,
		SourceIssues.sourceissue_title,
		SourceIssues.sourceissue_location,
		SourceIssues.sourceissue_volume,
		SourceIssues.sourceissue_number,
		SourceIssues.sourceissue_authors,
		SourceIssues.sourceissue_date,
		SourceIssues.sourceissue_issn,
		SourceIssues.sourceissue_image,
		Journals.journal_accepts_submissions,
		COALESCE(Publishers.publisher_name, Sources.source_publisher) AS publisher_name,
		Publishers.publisher_url
	FROM
		(
			Sources LEFT JOIN SourceIssues 
			ON Sources.source_id=SourceIssues.sourceissue_source
			
		)
		
			INNER JOIN Papers on 
				(Papers.paper_source = Sources.source_id)
				AND (
					Papers.paper_sourceissue is null OR 
					Papers.paper_sourceissue = SourceIssues.sourceissue_id
				)
		
		LEFT JOIN Journals ON Sources.source_code=Journals.journal_code
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code
	WHERE
		
			Sources.date_deleted IS NULL AND
			SourceIssues.date_deleted IS NULL
		
		
		
		
		
			AND Papers.paper_id = 13927
		
PaperTopics (Datasource=aacepubs, Time=4.41 ms, Records=0) in /var/sites/railo.editlib.org/models/papers/qry_papertopics.cfm
	SELECT
		Topics.topic_id, Topics.topic_name, Categories.category_id, Categories.category_name
	FROM
		(Topics LEFT JOIN Paper_Topics ON Topics.topic_id=Paper_Topics.topic_id )
		LEFT JOIN Categories ON Topics.topic_category=Categories.category_id
	WHERE
		
			Paper_Topics.paper_id = 13927
		
		
			AND Topics.topic_is_public=1
		
	ORDER BY
		category_name, topic_order, topic_name
Authors (Datasource=aacepubs, Time=4.13 ms, Records=3) in /var/sites/railo.editlib.org/models/papers/qry_authors.cfm
	SELECT
		Authors.author_id, People.person_id AS author_person, Authors.first_name, Authors.last_name, 
		Authors.organization, Authors.country, Countries.country_name, 
		Authors.email, Authors.author_order, Authors.author_type,
		People.person_photo

	FROM
		((Authors INNER JOIN Papers ON Authors.author_paper=Papers.paper_id)
		LEFT JOIN Countries ON Authors.country=Countries.country_code)
		LEFT JOIN People ON Authors.author_person=People.person_id
	WHERE
		
			Papers.date_deleted IS NULL
		

		
			AND Authors.author_type <> 'C'
		

		
		

		
		
			
				AND Authors.author_paper=
					13927
			
		
	ORDER BY
		
		
				Authors.author_order, Authors.author_id, Authors.last_name, Authors.first_name
			
Authors (Datasource=aacepubs, Time=3.52 ms, Records=3) in /var/sites/railo.editlib.org/models/papers/qry_authors.cfm
	SELECT
		Authors.author_id, People.person_id AS author_person, Authors.first_name, Authors.last_name, 
		Authors.organization, Authors.country, Countries.country_name, 
		Authors.email, Authors.author_order, Authors.author_type,
		People.person_photo

	FROM
		((Authors INNER JOIN Papers ON Authors.author_paper=Papers.paper_id)
		LEFT JOIN Countries ON Authors.country=Countries.country_code)
		LEFT JOIN People ON Authors.author_person=People.person_id
	WHERE
		
			Papers.date_deleted IS NULL
		

		
			AND Authors.author_type <> 'C'
		

		
		

		
		
			
				AND Authors.author_paper=
					13927
			
		
	ORDER BY
		
		
				Authors.author_order, Authors.author_id, Authors.last_name, Authors.first_name
			
PaperTopics (Datasource=aacepubs, Time=4.22 ms, Records=0) in /var/sites/railo.editlib.org/models/papers/qry_papertopics.cfm
	SELECT
		Topics.topic_id, Topics.topic_name, Categories.category_id, Categories.category_name
	FROM
		(Topics LEFT JOIN Paper_Topics ON Topics.topic_id=Paper_Topics.topic_id )
		LEFT JOIN Categories ON Topics.topic_category=Categories.category_id
	WHERE
		
			Paper_Topics.paper_id = 13927
		
		
			AND Topics.topic_is_public=1
		
	ORDER BY
		category_name, topic_order, topic_name
PaperTags (Datasource=aacepubs, Time=3.3 ms, Records=0) in /var/sites/railo.editlib.org/models/papers/qry_papertags.cfm
	SELECT
		Tags.tag_id, Tags.tag_text
	FROM
		(Tags LEFT JOIN Paper_Tags ON Tags.tag_id=Paper_Tags.tag_id )
	WHERE
		
			Paper_Tags.paper_id = 13927
		
	ORDER BY
		tag_text
References (Datasource=aacepubs, Time=4.21 ms, Records=0) in /var/sites/railo.editlib.org/models/papers/qry_references.cfm
	SELECT
		Paper_References.paperreference_id,
		Paper_References.paperreference_content,
		Paper_References.paperreference_authors,
		Paper_References.paperreference_doi,
		Paper_References.paperreference_date
	FROM
		Paper_References
	WHERE
		Paper_References.paperreference_paper = 13927
	ORDER BY
		Paper_References.paperreference_order
PaperFiles (Datasource=aacepubs, Time=3.42 ms, Records=1) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=13927
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
Source (Datasource=aacepubs, Time=4.93 ms, Records=1) in /var/sites/railo.editlib.org/models/sources/qry_source.cfm
	SELECT
		Sources.source_id,
		Sources.source_title,
		Sources.source_type,
		Sources.source_abbr,
		Sources.source_issn,
		Sources.source_eissn,
		Sources.source_image,
		Sources.source_url,
		Sources.source_publisher,
		Sources.source_location,
		Sources.source_date,
		Sources.source_authors,
		Sources.source_serial,
		Sources.source_description,
		Sources.source_code,
		Sources.date_confirmed,
		Sources.confirmed_by,
		SourceIssues.sourceissue_id,
		SourceIssues.sourceissue_title,
		SourceIssues.sourceissue_location,
		SourceIssues.sourceissue_volume,
		SourceIssues.sourceissue_number,
		SourceIssues.sourceissue_authors,
		SourceIssues.sourceissue_date,
		SourceIssues.sourceissue_issn,
		SourceIssues.sourceissue_image,
		Journals.journal_accepts_submissions,
		COALESCE(Publishers.publisher_name, Sources.source_publisher) AS publisher_name,
		Publishers.publisher_url
	FROM
		(
			Sources LEFT JOIN SourceIssues 
			ON Sources.source_id=SourceIssues.sourceissue_source
			
		)
		
			INNER JOIN Papers on 
				(Papers.paper_source = Sources.source_id)
				AND (
					Papers.paper_sourceissue is null OR 
					Papers.paper_sourceissue = SourceIssues.sourceissue_id
				)
		
		LEFT JOIN Journals ON Sources.source_code=Journals.journal_code
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code
	WHERE
		
			Sources.date_deleted IS NULL AND
			SourceIssues.date_deleted IS NULL
		
		
		
		
		
			AND Papers.paper_id = 13927
		
Source (Datasource=aacepubs, Time=4.32 ms, Records=1) in /var/sites/railo.editlib.org/models/sources/qry_source.cfm
	SELECT
		Sources.source_id,
		Sources.source_title,
		Sources.source_type,
		Sources.source_abbr,
		Sources.source_issn,
		Sources.source_eissn,
		Sources.source_image,
		Sources.source_url,
		Sources.source_publisher,
		Sources.source_location,
		Sources.source_date,
		Sources.source_authors,
		Sources.source_serial,
		Sources.source_description,
		Sources.source_code,
		Sources.date_confirmed,
		Sources.confirmed_by,
		SourceIssues.sourceissue_id,
		SourceIssues.sourceissue_title,
		SourceIssues.sourceissue_location,
		SourceIssues.sourceissue_volume,
		SourceIssues.sourceissue_number,
		SourceIssues.sourceissue_authors,
		SourceIssues.sourceissue_date,
		SourceIssues.sourceissue_issn,
		SourceIssues.sourceissue_image,
		Journals.journal_accepts_submissions,
		COALESCE(Publishers.publisher_name, Sources.source_publisher) AS publisher_name,
		Publishers.publisher_url
	FROM
		(
			Sources LEFT JOIN SourceIssues 
			ON Sources.source_id=SourceIssues.sourceissue_source
			
		)
		
			INNER JOIN Papers on 
				(Papers.paper_source = Sources.source_id)
				AND (
					Papers.paper_sourceissue is null OR 
					Papers.paper_sourceissue = SourceIssues.sourceissue_id
				)
		
		LEFT JOIN Journals ON Sources.source_code=Journals.journal_code
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code
	WHERE
		
			Sources.date_deleted IS NULL AND
			SourceIssues.date_deleted IS NULL
		
		
		
		
		
			AND Papers.paper_id = 13927
		
PaperFiles (Datasource=aacepubs, Time=4.11 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> Presentations
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=13927
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
		
			
				AND PaperFiles.paperfile_is_presentation=1
			
			
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
PaperFiles (Datasource=aacepubs, Time=3.45 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> Videos
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=13927
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
			AND lower(PaperFiles.paperfile_type)
				
					= 'video'
				
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
PaperFiles (Datasource=aacepubs, Time=4.19 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> Slides
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=13927
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
		
			
			
				AND paperfile_is_presentation = 1
				AND (
					paperfile_type IS NULL OR
					(paperfile_type <> 'paper' AND paperfile_type <> 'press')
				)
				AND (
					paperfile_format IS NULL OR
					paperfile_format <> 'FULL'
				)
				AND (
						PaperFiles.paperfile_name LIKE '%.ppt' OR
						PaperFiles.paperfile_name LIKE '%.pptx' OR
						PaperFiles.paperfile_name LIKE '%.pdf'
				)
			
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
PaperFiles (Datasource=aacepubs, Time=3.43 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> MP3s
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=13927
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
			AND 
			(
			
			
				
				PaperFiles.paperfile_name LIKE '%.mp3'
			
			)
		
	ORDER BY
		
		
				date_created DESC
			
PaperFiles (Datasource=aacepubs, Time=4.29 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> URLs
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=13927
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
			AND lower(PaperFiles.paperfile_type)
				
					= 'url'
				
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
PaperFiles (Datasource=aacepubs, Time=3.63 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> Recordings
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=13927
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
			AND lower(PaperFiles.paperfile_type)
				
					= 'recording'
				
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
AlsoAccessedPapers (Datasource=aacepubs, Time=301 ms, Records=25) in /var/sites/railo.editlib.org/logger/qry_alsoaccessedpapers.cfm
	SELECT TOP 25
		Papers.paper_id AS related_paper, Papers.paper_title AS related_title, COUNT(*) AS number_of_accesses 
	FROM
		Access_Log AS Other_Papers_Accessed
		INNER JOIN Access_Log AS This_Paper ON 
			Other_Papers_Accessed.person_id=This_Paper.person_id AND 
			This_Paper.paper_id <> Other_Papers_Accessed.paper_id AND
			This_Paper.paper_id = 13927
			
		INNER JOIN Papers ON Other_Papers_Accessed.paper_id=Papers.paper_id
	WHERE
		Papers.date_deleted IS NULL AND
		Papers.date_added > '1970-01-01' AND
		Papers.paper_status='DL_PUBLISH'
	GROUP BY Papers.paper_id, Papers.paper_title
	ORDER BY 3 DESC
Paper_GetSource (Datasource=aacepubs, Time=9.06 ms, Records=1) in /var/sites/railo.editlib.org/security/act_checkforpaperaccess.cfm
		SELECT source_type, source_code, sourceissue_date, sourceissue_volume, sourceissue_number, paper_status
		FROM
			(Sources INNER JOIN Papers ON Sources.source_id=Papers.paper_source)
			LEFT JOIN SourceIssues ON Papers.paper_sourceissue=SourceIssues.sourceissue_id
		WHERE
			Papers.paper_id=13927
	
Paper (Datasource=aacepubs, Time=14 ms, Records=3) in /var/sites/railo.editlib.org/security/act_checkforpaperaccess.cfm
		SELECT 
			coalesce(paper_is_free,0) | coalesce(source_is_free,0) | coalesce(sourceissue_is_free,0) as paper_is_free, 
			paper_free_until, free_for_member, person_code, Authors.email
		FROM 
			Papers LEFT JOIN People ON Papers.paper_contact_person=People.person_id
			LEFT JOIN Authors ON Papers.paper_id=Authors.author_paper
			LEFT JOIN Sources ON Papers.paper_source=Sources.source_id
			LEFT JOIN SourceIssues ON Papers.paper_sourceissue=SourceIssues.sourceissue_id
		WHERE
			Papers.paper_id=13927
	
Journal_Is_Free (Datasource=aacepubs, Time=1.79 ms, Records=0) in /var/sites/railo.editlib.org/security/act_checkforpaperaccess.cfm
			SELECT journal_is_free
			FROM
				Journals
			WHERE
				journal_is_free=1 AND
				journal_code='EDMEDIA'
		
RecordedPresentations (Datasource=, Time=0.066 ms, Records=0) in /var/sites/railo.editlib.org/reader/dsp_abstract2014.cfm
		SELECT *
		FROM
			Presentations
		WHERE
			upper(Presentations.paperfile_format) = 'RECORDEDPRESENTATION'
	
GetActions (Datasource=aacepubs, Time=1.93 ms, Records=4) in /var/sites/railo.editlib.org/logger/act_logaccess.cfm
		SELECT accessaction_id, accessaction_name
		FROM
			Access_Actions
	
FullText_Log_INSERT (Datasource=aacepubs, Time=120 ms, Records=0) in /var/sites/railo.editlib.org/logger/act_logaccess.cfm
		INSERT INTO Access_Log ( action, access_action, date_accessed, institution_id, person_id, paper_id )
		VALUES (
			'VIEW',
			2,
			{ts '2016-02-12 05:39:14'},
			
				NULL
			,
			
				NULL
			,
			13927
			)
	


Scope Variables

Application Variables:
applicationname=editlib
INSTITUTION_IPS=Struct (49)
NON_INSTITUTION_IPS=Array (467)
CGI Variables:
auth_password=
auth_type=
auth_user=
cert_cookie=
cert_flags=
cert_issuer=
cert_keysize=
cert_secretkeysize=
cert_serialnumber=
cert_server_issuer=
cert_server_subject=
cert_subject=
cf_template_path=/var/sites/railo.editlib.org/index.cfm
content_length=
content_type=
context_path=
gateway_interface=
http_accept=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
http_accept_encoding=x-gzip, gzip, deflate
http_accept_language=en-us,en-gb,en;q=0.7,*;q=0.3
http_connection=close
http_cookie=
http_host=www.editlib.org
http_referer=
http_user_agent=CCBot/2.0 (http://commoncrawl.org/faq/)
https=
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=172.31.28.109
local_host=ip-172-31-28-109
path_info=
path_translated=/var/sites/railo.editlib.org/index.cfm
query_string=fuseaction=Reader.ViewAbstract&paper_id=13927
remote_addr=54.196.244.206
remote_host=54.196.244.206
remote_user=
request_method=GET
request_url=http://www.editlib.org/index.cfm?fuseaction=Reader.ViewAbstract&paper_id=13927
script_name=/index.cfm
server_name=www.editlib.org
server_port=80
server_port_secure=0
server_protocol=HTTP/1.0
server_software=
web_server_api=
Form Variables:
CACHE_CODE=13927p
Request Variables:
_nonessential_code=false
_nonessential_content=
_nonessential_triggered=false
access_logged=true
addtoken=false
cache_code=13927p
cache_counter=1
cfroot=/editlib
checked_for_user=true
confdatasource=conference
current_path=/p/13927/
current_url=/p/13927/
development_ips=63.172.201.5,82.111.242.163,71.48.156.102,65.41.111.68,71.53.208.41,71.53.210.238,196.205.118.231,41.196.180.26
domain=www.editlib.org
file_delimiter=/
fileroot=/var/sites/railo.editlib.org/
is_ajax=false
is_spider=true
layout=2014
login_javascript=
		
		
		
	
logindatasource=conference
loginpath=/login/
mailinglist_address=listserv@listserv.uh.edu
mailinglist_name=eductech
mailinglist_owner=jdprice@genesis.coe.uh.edu
mailinglist_password=bookstairs
maindatasource=aacepubs
maindatasource_ro=aacepubs_readonly
navigationhistory=Struct (2)
org.apache.catalina.AccessLog.Protocol=HTTP/1.0
org.apache.catalina.AccessLog.RemoteAddr=54.196.244.206
org.apache.catalina.AccessLog.RemoteHost=54.196.244.206
org.apache.catalina.AccessLog.ServerPort=80
page=Struct (13)
page_timeout=10
publications_scope=AACE
pubsdatasource=aacepubs
self=/
settings=Struct (47)
share_js=





site_name=EdITLib
stop_addtoken=true
webroot=/
Server Variables:
A0608BEC-0AEB-B46A-0E1E1EC5F3CE7C9C.1.1=Complex type
coldfusion=Struct (9)
java=Struct (8)
os=Struct (7)
railo=Struct (7)
separator=Struct (3)
servlet=Struct (1)
URL Variables:
fuseaction=Reader.ViewAbstract
paper_id=13927
READER_CACHE=1
Debug Rendering Time: 0 ms