View source for ANLY482 AY2017-18 T2 Group 17 Project Overview Data

__NOEDITSECTION__
<!--Header Start-->
{|style="background-color:#6A8D9D; color: #F5F5F5; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" |
| style="padding:0.3em; font-size:100%; background-color:#466675; text-align:center; color: #F5F5F5" width="10%" |
[[ANLY482 AY2017-18 T2 Group 17| 
<font color="#F5F5F5" size=2><b>HOME</b></font>]]

| style="background:none;" width="1%" | &nbsp;
| style="padding:0.3em; font-size:100%; background-color:#6A8D9D; text-align:center; color:#F5F5F5" width="10%" | 
[[ANLY482 AY2017-18 T2 Group 17 Findings|
<font color="#F5F5F5" size=2><b>FINDINGS</b></font>]]

| style="background:none;" width="1%" | &nbsp;
| style="padding:0.3em; font-size:100%; background-color:#6A8D9D; text-align:center; color:#F5F5F5" width="10%" | 
[[ANLY482 AY2017-18 T2 Group 17 Project Documentation|
<font color="#F5F5F5" size=2><b>PROJECT DOCUMENTATION</b></font>]]

| style="background:none;" width="1%" | &nbsp;
| style="padding:0.3em; font-size:100%; background-color:#6A8D9D; text-align:center; color:#F5F5F5" width="10%" | 
[[ANLY482 AY2017-18 T2 Group 17 Project Management|
<font color="#F5F5F5" size=2><b>PROJECT MANAGEMENT</b></font>]]

| style="background:none;" width="1%" | &nbsp;
| style="padding:0.3em; font-size:100%; background-color:#6A8D9D; text-align:center; color:#F5F5F5" width="10%" | 
[[ANLY482_AY2017-18_T2_Group_17 About Us|
<font color="#F5F5F5" size=2><b>ABOUT US</b></font>]]

| style="background:none;" width="1%" | &nbsp;
| style="padding:0.3em; font-size:100%; background-color:#6A8D9D; text-align:center; color:#F5F5F5" width="10%" | 
[[Main_Page|
<font color="#F5F5F5" size=2><b>ANLY482 HOMEPAGE</b></font>]]
|} 
<!--Header End-->

<!--Sub Header-->
{| style="background-color:#ffffff; margin: 3px auto 0 auto" width="55%"
|- 
! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="150px"| [[ANLY482 AY2017-18 T2 Group 17 Project Overview| <span style="color:#3d3d3d">Background</span>]]
! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"|

! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #2e2e2e" width="150px"| [[ANLY482 AY2017-18 T2 Group 17 Project Overview Data| <span style="color:#3d3d3d">Data</span>]]
! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"|

! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="150px"| [[ANLY482 AY2017-18 T2 Group 17 Project Overview Methodology| <span style="color:#3d3d3d">Methodology</span>]]
! style="font-size:15px; text-align: center; border-top:solid #ffffff; border-bottom:solid #ffffff" width="20px"|
|}
<!--/Sub Header-->

'''<big><font color="#6A8D9D">Metadata</font></big><br>

<font size=2><b>(i) Proxy Log Data</b></font><br>
Proxy log data records each user access to various academic materials provided by SMU Libraries via the libraries’ proxy. Every click or download via SMU Libraries’ portal will be recorded and identified by the ‘Session ID’ and ‘User ID’. <br>

{| class="wikitable" style="text-align: center; background: white; margin: 0px auto; width:80%" 
! style="background: #6A8D9D; color: #F5F5F5; font-weight: bold;" | Name
! style="background: #6A8D9D; color: #F5F5F5; font-weight: bold; " | Data Type
! style="background: #6A8D9D; color: #F5F5F5; font-weight: bold; " | Length
! style="background: #6A8D9D; color: #F5F5F5; font-weight: bold; " | Description
|-
|'''IP Address'''
|VARCHAR
|15
|Internet protocol address of users
|-
|'''Session ID'''
|CHAR
|15
|Unique session identifier of users
|-
|'''User ID'''
|CHAR
|64
|Email of users which is hashed for privacy reasons
|-
|'''URL'''
|VARCHAR
|250
|URL access by users for the log
|-
|'''Doc ID'''
|VARCHAR
|20
|Unique Identifier of file accessed by users
|-
|'''Date and Time'''
|DATETIME
|17
|Date and Time at point of access. Format is DD-MMM-YYYY HH:MM:SS e.g ‘05Dec2017 10:28:24’
|-
|'''Downloads'''
|BOOLEAN
|1
|Binary attribute where 0 is online view and 1 is pdf download
|-
|'''Chapter'''
|NUMERIC
|2
|Specific chapter access within e-book
|-
|}
<br>
<font size=2><b>(ii) User Master List</b></font><br>
User master list shows the complete list of users in SMU community and is identify by their unique email. More detailed information such as faculty and admission year are also provided where relevant. <br>
{| class="wikitable" style="text-align: center; background: white; margin: 0px auto; width:80%" 
! style="background: #6A8D9D; color: #F5F5F5; font-weight: bold;" | Name
! style="background: #6A8D9D; color: #F5F5F5; font-weight: bold; " | Data Type
! style="background: #6A8D9D; color: #F5F5F5; font-weight: bold; " | Length
! style="background: #6A8D9D; color: #F5F5F5; font-weight: bold; " | Description
|-
|'''User ID'''
|CHAR
|64
|Contains the email of the user
|-
|'''User Group'''
|VARCHAR
|50
|Contain the category that user belongs
|-
|'''School'''
|VARCHAR
|50
|Contain faculty which user belongs
|-
|'''Area of Study'''
|VARCHAR
|100
|Programme that user is enrolled under in SMU
|-
|'''Admission Year'''
|CHAR
|7
|Admission year of user
|-
|'''Graduation Year'''
|CHAR
|7
|Graduation or expected graduation year
|-
|}
<br>
<font size=2><b>(iii) Jstor’s PDA book usage report</b></font><br>
Jstor’s PDA book usage report shows the complete list of e-books under PDA scheme. The table also contains information on purchased date and prices for the corresponding books if possible.<br>
{| class="wikitable" style="text-align: center; background: white; margin: 0px auto; width:80%" 
! style="background: #6A8D9D; color: #F5F5F5; font-weight: bold;" | Name
! style="background: #6A8D9D; color: #F5F5F5; font-weight: bold; " | Data Type
! style="background: #6A8D9D; color: #F5F5F5; font-weight: bold; " | Length
! style="background: #6A8D9D; color: #F5F5F5; font-weight: bold; " | Description
|-
|'''Title'''
|VARCHAR
|250
|Title of book
|-
|'''Doc ID'''
|VARCHAR
|20
|Unique identifier of PDA e-books
|-
|'''Publisher'''
|VARCHAR
|50
|Publisher of e-book
|-
|'''Author'''
|VARCHAR
|50
|Author of e-book
|-
|'''Editor'''
|VARCHAR
|50
|Co-editor of e-book (can be null)
|-
|'''ISBN'''
|NUMERIC
|13
|International Standard Book Number. Standardised serial number on all books
|-
|'''Primary Discipline'''
|VARCHAR
|20
|Genre of e-book
|-
|'''Purchase Date'''
|DATETIME
|17
|Purchase time of e-book can be null. Format is DD-MM-YY HH:MM e.g. 12-5-17 00:00
|-
|'''Chapter View'''
|NUMERIC
|2
|Number of chapters viewed
|-
|'''PDF download'''
|NUMERIC
|2
|Number of chapters downloaded from e-book
|-
|'''Listed Price'''
|NUMERIC
|4
|Listed price of e-book
|-
|'''Price Paid'''
|NUMERIC
|4
|Price paid for e-book (usually at a discount)
|-
|}