Difference between revisions of "ANLY482 AY2017-18 T2 Group 17 Project Overview Data"
Jump to navigation
Jump to search
| Line 50: | Line 50: | ||
<font size=2><b>(i) Proxy Log Data</b></font><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><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''' | ||
| + | |Character | ||
| + | |10 | ||
| + | |URL access by users for the log | ||
| + | |- | ||
| + | |'''Doc ID''' | ||
| + | |VARCHAR | ||
| + | |250 | ||
| + | |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> | <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><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><br> | ||
<font size=2><b>(iii) Jstor’s PDA book usage reportt</b></font><br> | <font size=2><b>(iii) Jstor’s PDA book usage reportt</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. | 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. | ||
Revision as of 20:15, 25 February 2018
| Background | Data | Methodology |
|---|
Metadata
(i) Proxy Log Data
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’.
| Name | Data Type | Length | 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 | Character | 10 | URL access by users for the log |
| Doc ID | VARCHAR | 250 | 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 |
(ii) User Master List
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.
(iii) Jstor’s PDA book usage reportt
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.
