Chinese Transactional Database: A User Manual
Contents
1. TAN output Figure 4 10 Select All button located above results taable Once the correct company ies are selected the user should hover over the text box and copy the codes to clipboard by either right clicking and selecting Copy or using Control c for Windows users or Command c for Mac users 10 11 results for honda Select All Deselect All Company ID HONDA R amp D INDUSTRY CO LTD BEIJING OFFICE 1190990642 GUANGZHOU GUANG QI HONDA MOTOR SERVICES CO LTD 4401923454 3102930417 12039329950 3501939991 4401930150 44019332 22 4412930 90642 44015 Undo Ctrl Z output Redo Ctrl Shift Z Please select all compa Ctrl X Then you can select the co Copy Ctrl C You should copy Comr Paste Cirle V vou can paste them in v Paste as plain text Ctrl Shift V Delete Figure 4 11 The result IDs are being highlighted Once the information is copied to the clipboard the user can easily paste it into the correct box for the search parameters and submit their query 4 3 Country Code Finding Country Code is virtually the same process as finding Company Code Simply repeat the previous steps but for the Country Search tab 11 Job Management and File Retrieval 9 1 Queuing Once the query has been submitted all running and queued jobs are listed under the Query tab found at the top of the page inside the navigation bar Company2. Enter your Union username this will be used to email you when the query is compelte and to identify your download March 2006 Jj Import O Export Both Figure 6 1 Beginning of Data Selection Page The next field to fill out is Company ID In order to find Honda s company ID navigate to the Company Search tab in the navigation bar Enter Honda in the text box select 2006 in the drop down menu and press the Submit button 14 772 EN OY f Queue ETZSE ESI Data Selection Company Name Substring Honda Submit Year 2006 Figure 6 2 Company Search Tab Query ET ERU ES 12 results for Honda Select All Deselect All Company ID TIANJIN HONDA MOTORCYCLE CO LTD IGUANGZHOU HONDA AUTOMOBILE CO LTD NANHAI HONDA AUTOMOBILE THINGS CO LTD IDONGFENGHONDAENGINECO LTD 44 WUYANG HONDA MOTORS GUANGZHOU CO LTD W ZHAOQING HONDA METAL COLTD DONGFENG HONDA AUTOPARTSCO LID 4413930177 HONDA MIN DONG GENERATOR CO LTD 53501939991 NEW CONTINENT HONDA MOTORCYCLE CO LTD SHANGHAI BRANCH CO LTD 3120930437 Honda Automobile China Co Ltd HONDA MOTORCYCLE RESEARCH DEVELOPMENTCOLTD Honda Motor China Investment Co Ltd E E HIS N e b3 m m 00 m Co SO S S SO SO NO w w w w w w e wj ol ojoj t m D9 m 00 O N HA N
3. 84831090 Transmissior 534002 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 1250 85022000 Generating s 2315 84821000 Bearings bal 78 85022000 Generating s 60392 85022000 Generating s 2409 85022000 Generating s 6655 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 85022000 Generating s 87082990 Parts amp acce 87082990 Parts amp acce 128039 35105 40348 68622 10156 8839 9836 2134 33567 cttdb v1 outputcsv J H I averagePrice atyUnit 325 305185 N ST 2 08333333 KG 120 325843 KG 93 KG 3 14269725 KG 1 8 KG 12 KG 9 2771702 KG 5 53753888 KG 14 1223881 KG 8 55140187 KG 13 9343556 KG 10 7692308 KG 6 01969728 KG 12 2804396 KG 41 111111 KG 16 7833333 KG 13 9349004 KG 0 89135802 KG 9 63601088 KG 1 24 N ST 1 25 N ST 33 7122475 N ST 391 959507 N ST 266 747917 N ST 337 548077 N ST 498 123457 N ST 256 687023 N ST 476 541667 N ST 507 8 N ST 441 95 N ST 317 290323 N ST 266 75 N ST 266 75 N ST 479 528571 N ST 416 666667 N ST 578 75 N ST 2 6 N S
4. SD AFRI Pakistan PK ASIA Russia RU EURO St Lucia LC CARR Qatar QA AFRI Canada CA CANA Malaysia MY ASIA Philippines PH ASIA India IN ASIA Nepal NP ASIA Bangladesh BD ASIA Thailand TH ASIA Belgium BE EURO Figure 6 9 Result File 17 Additional Information If you re having problems with the system please send an email to yanuklit union edu Please try to be as descriptive as you can in your email 7 1 Quick Help e Queries Only 1 query at a time runs from the run queue but there can be many queries submit ted without a problem Please wait about 2 seconds before submitting you next query Down loads are available for 24 hours if the server gets full they may be removed before 24 hours The query result is a zip file containing a CSV file of your output it also contains the SQL code generated for the query and a diagnostic file Country amp Company select This searches based on partial or complete match for either If you leave the field blank you get all the entries for countries or companies e Queue shows you the current status of the batch queue of running jobs jobs waiting to run e Downloads Shows you the downloads that are currently available 18
5. 3 1 06 IMPORT 3 1 06 IMPORT 3 1 06 IMPORT 3 1 06 IMPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT 3 1 06 EXPORT D E productDesc USDAmount aty 87082941 Motor vehicl 1756648 40103100 Endless tran 25 87082955 Baggage cor 10709 87082959 Other body C 186 87089992 Motor vehicl 454874 73181600 Nuts i s nes 9 73181500 Bolts or secre 6 84099199 Parts for oth 27145 84099199 Parts for oth 840244 84099199 Parts for oth 75696 84099199 Parts for oth 915 84099199 Parts for oth 139037 84099199 Parts for oth 140 84099199 Parts for oth 145165 84099199 Parts for oth 298341 84159090 Parts of air c 370 84099199 Parts for oth 1007 84099199 Parts for oth 136353 84099199 Parts for oth 722 84099199 Parts for oth 581090 84213100 Intake air filt 31 84824000 Bearings net 15
6. CA Os t3 J J t3J oO 1105940787 WT EL output Figure 6 3 Company Search Results 6 2 Data Input The results above are all company IDs with the word Hondain them These are the desired results so press the Select All button on the top of the page below the navigation bar This will check all boxes each time a box is checked that value is appended or pulled from the output field accordingly Now mouse over the output box to select all contents Either right click and select Copy or Mac users can press command c control c on Windows on their keyboard to copy the text to the clipboard Navigate back to the Company ID field on the Query page Right click and select Paste or Mac users can press command v control v on Windows on their keyboard to paste the text from the clipboard 940705 1105940781 Comma separated lists may be used Figure 6 4 Company ID Field For the demonstration limit the results of the search to 1000 on the main interface page and press the Query button 15 Figure 6 5 Limit Results and Submit 6 3 Data Retrieval The job appears is the only job in the queue and its running status is denoted by the R in the status column Que E Queue Status chinadb v2 union edu Req d Req d Elap Job ID Username Queue Jobname SessID NDS TSK Memory Time S Time 460 chinadb v2 u chinadb batch DB1407179022 18839 1 1 00
7. Search Country Search Queue Downloads Figure 5 1 Query in the Navigation Bar The figure below is a screenshot of how the queue will appear when there is one job running and two jobs queued for completion Quae Queue Status chinadb v2 union edu Req d Req d Elap Job ID Username Queue Jobname SessID NDS TSK Memory Time 5 Time 460 chinadb v2 u chinadb batch DB1407179022 18839 1 1 90 48 R chinadb v2 0 Retrieved at Mon Aug 4 15 03 43 EDT 2014 Please reload this page for the latest queue status C z Completed E Exiting Figure 5 2 The Queue The output above can be daunting at first but there are only a few things of significance Under the Job column there is a number That number increments with each job submitted to the server to track how many queries have been submitted The next important column is the Status S column It denotes what the current status of all jobs is Possible statuses include Running R Queued Q Completed C and Exiting E A job that is running is one that is currently being processed by the server A job that is queued is one that will run once all jobs above it are out of the queue A completed job typically will not appear in the queue but when completed a job is removed from this output 12 and all pending jobs are moved up in the queue Lastly and exiting job is one that has encountered a problem and has had to exit This is an unusual circumstance and will
8. ZHANG GUAI Guangdong F Joint Capital Japan JP A Guangzhou ZHANG LIU C Guangdong f Joint Capital Jordan JO Huangpu MA YUE Guangdong F Joint Capital Thailand TH Huangpu ZHANG LIU Guangdong F Joint Capital Japan JP A Huangpu JIAO YUE Guangdong FJoint Capital Japan JP A Guangzhou ZHANG LIU G Guangdong F Joint Capital Jordan JO Huangpu ZHANG LIU Guangdong F Joint Capital Jordan JO Huangpu NISHIMOTO Guangdong FJoint Capital United Kingd Shenzhen CHEN JIE REP Fujian Provin Joint Capital S Africa ZA Fuzhou CHEN JIE REP Fujian Provin Joint Capital Japan JP A Fuzhou CHEN JIE REP Fujian Provin Joint Capital Peru PE S Fuzhou CHEN JIE REP Fujian Provin Joint Capital Argentina A Fuzhou CHEN JIE REP Fujian Provin Joint Capital S Africa ZA Fuzhou CHEN JIE REP Fujian Provin Joint Capital Vietnam VN Fuzhou CHEN JIE REP Fujian Provin Joint Capital Panama PA Fuzhou CHEN JIE REP Fujian Provin Joint Capital El Salvador Fuzhou CHEN JIE REP Fujian Provin Joint Capital Nicaragua N Fuzhou CHEN JIE REP Fujian Provin Joint Capital St Lucia LC Fuzhou CHEN JIE REM Fujian Provin Joint Capital Russia RU Fuzhou CHEN JIE REP Fujian Provin Joint Capital Brazil BR S Fuzhou CHEN JIE REP Fujian Provin Joint Capital Guyana GY Fuzhou CHEN JIE REP Fujian Provin Joint Capital Trinidad amp Tc Fuzhou ZHANG LIU Guangdong F Joint Capital Jordan JO Huangpu CHEN JIE REP Fujian Provin Joint Capital United Arab Fuzhou CHEN JIE R
9. 37067 robert worldtradedaily com Access to the servers containing the database shall be limited to the Union campus Access from residential networking guest wireless and the public Internet is not permitted Folders and files generated in your work will use applicable file and directory permissions to prevent access by other users Acknowledgment By my continued use of this interface I agree to follow all the rules and guidelines as presented in addition to the general application of common sense History of the Database In the spring of 2013 Union College purchased a large transactional trade database from a vendor in China The database covers a range of a substantial number of Chinese import and export data from 2000 to 2006 This data includes relevant trade data on each transaction such as the quantity of the item purchased the company and its credentials a unique product identification number and several other attributes When first received the database was over 100 gigabytes in size as a result of poor organization and formatting Because of its size and format the database is difficult to traverse without sufficient hardware and an understanding of data models and database design leading to a need for a user manual The goalis to make this data accessible to both students and faculty chiefly by providing an interface and evaluation tools that would shield users from the underlying complexities of the database and provi
10. 48 R chinadb v2 0 Retrieved at Mon Aug 4 15 03 43 EDT 2014 Please reload this page for the latest queue status Column Name Description Job Name Internal job name given on the query confirmation page when you submit a query R Running Q Queued C Completed E Exiting S Column Figure 6 6 The Queue Tab Once completed an email notification will be sent To download to the results go to the Downloads page and find the desired completed job based on the username and date time submitted T su Available Downloads Legend B Bytes K Kilobytes M Megabytes G Gigabytes Filename Size Date loewj 1407076610 zip 7 06K August 03 2014 10 37 03 loewj 1407077211 zip 844 67K August 03 2014 10 48 12 loewj 1407165468 zip 36 46M August 04 2014 11 21 40 loewj 1407165476 zip 16 41M August 04 2014 11 24 23 loewj 1407165483 zip 20 57M August 04 2014 11 27 24 loewj 1407176620 zip 9 52M August 04 2014 14 26 58 loewj 1407177118 zip 1 86K August 04 2014 14 34 42 loewj 1407179022 zip 23 66K August 04 2014 15 06 26 tay 1407170848 zip 2 37M August 04 2014 12 48 54 Figure 6 7 The Downloads Tab Once downloaded unzip the file Right click the csv comma separated value file and select Open With Select any spreadsheet client such as Microsoft Excel to view the file Done 16 FAVORITES E All My Files o AirDrop
11. 824 020 8418654 4401933222 WUYANG HC NO 82 XING 020 841824 020 8418654 4413930177 DONGFENG XINLIAO DAY 0752 52003 0752 52006 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362227 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362227 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362227 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 36222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 4401933222 WUYANG HC NO 82 XING 020 841824 020 841865 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362227 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362227 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362227 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA
12. 9 7 7 1 QUICK Help 6 us eda ow eee oo 18 Rules and General Guidelines This document describes the rules guidelines and user agreement for access to the China Transac tion Trade Database the database that Union College Union has acquired Described herein are restrictions and regulations on access dissemination and publication of works deriving from the database Non disclosure and Scope Access to the database is limited to Union faculty non Union fac ulty working with Union faculty and students approved by faculty the faculty member approv ing a student supervise their access and use of the data You shall not resell or distribute any of the data without written permission from World Trade Daily Attribution Union faculty non Union faculty working with Union faculty and Union students shall have analytical research publication and co publication rights to works derived from their access to the database such works shall include attribution to the database Minimum attribution General Administration of Customs Chinese Customs Bureau Trans actional Trade Database Compiled by Robert Thompson Beijing Haiguan tongji bianji bu 200u Database Preferred attribution General Administration of Customs Chinese Customs Bureau Transactional Trade Database Beijing Haiguan tongji bianji bu 200u Database and Compiled by Robert Thompson Editor in Chief World Trade Daily 2000 Mallory Lane Suite 130 244 Franklin TN
13. Chinese Transactional Database A User Manual Brian Hazzard Josh Loew August 6 2014 This document is meant to be a user manual and guide for the Chinese Transactional Database While the interface for the database is meant to be easy to use an extra resource is often helpful to under stand the functionality Any problems or questions not addressed in the manual may be sent to the Computer Science Sys tems Administrator Tom Yanuklis at yanuklit union edu Acknowledgements We would like to acknowledge and thank Professors Motahar and Dallas for their support and pa tience while testing the system for us along with Computer Science Systems Administrator Tom Yanuklis and Professor Barr for aiding with implementation of the system We d also like to thank ITS Director Ellen Borkowski as well as college librarian Frances Maloy for funding of our project Contents Rules and General Guidelines 3 4 2 CompanyCode 9 4 3 CountryCode 11 History of the Database 4 5 bM t and File Retrieval 12 Exploring the Interface 5 7 SNR EUN Ma OM SUG oo oe wie ee ee be hae 5 Queuing ee lee nnn 3 2 CompanySearch 5 uu i pine s 33 CountrySearch 5 ampe Luer CHEM 3 4 Queue G 6 1 Data Selection 14 35 Downloads 6 6 2 DataInput 2 144 464 29 9 15 36 Help senes G 63 DataRetrieval 16 Querying the Database 7 7 Additional Information 18 AI QUE 2 2 229
14. E Desktop t loewj y Applications m Documents DEVICES Remote Disc SHARED Eg All TAGS O Red Orange Yellow csv cttdb v1 output cs v G loewj 1407179022 TXT loewj 1407179022 cttdb v1 query sql query diag txt Figure 6 8 Contents of the zip file Al Calibri Body Bu Gleo fx syntheticiD cttdb v1 output csv Qux Search in Format Neutral Calculation EIE Explanatory input 1 Heading 1 Heading 2 Heading 3 Heading 4 L syntheticlID declarationD tradeDirectic HSCode 2 3 5 6 5 9 10 11 12 13 14 15 16 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 A 3573990 3581048 3629221 3629458 3629649 4108424 4151570 4202533 4203771 4205119 4205268 4206329 4206331 4206337 4206339 4209885 4213730 4214880 4215089 4217768 4237796 4269527 4271067 4272691 4272784 4273981 4274086 4274090 4274095 4275196 4276424 4276530 4279168 4279178 4279186 4279280 4279284 4280016 4280469 4280574 4280586 4282961 4282964 4284399 4285892 4286955 4286963 4287168 4288259 4291168 4305405 B c 3 1 06 IMPORT
15. EP Fujian Provin Joint Capital Costa Rica C Fuzhou CHEN JIE RE Fujian Provin Joint Capital Lithuania LT Fuzhou CHEN JIE REP Fujian Provin Joint Capital United State Fuzhou CHEN JIE REP Fujian Provin Joint Capital Sudan SD 4 Fuzhou CHEN JIE REP Fujian Provin Joint Capital Pakistan PK Fuzhou CHEN JIE REM Fujian Provin Joint Capital Russia RU Fuzhou CHEN JIE REP Fujian Provin Joint Capital St Lucia LC Fuzhou CHEN JIE REP Fujian Provin Joint Capital Qatar QA 4 Fuzhou CHEN JIE REP Fujian Provin Joint Capital Canada CA Fuzhou CHEN JIE REP Fujian Provin Joint Capital Malaysia M Fuzhou CHEN JIE REP Fujian Provin Joint Capital Philippines f Fuzhou CHEN JIE REP Fujian Provin Joint Capital India IN AS Fuzhou CHEN JIE REP Fujian Provin Joint Capital India IN AS Fuzhou CHEN JIE REP Fujian Provin Joint Capital Bangladesh Fuzhou Guangdong F Joint Capital Thailand TH Guangzhou Guangdong F Joint Capital Belgium BE Huangpu Ordinary Tra Water Ordinary Tra Water Ordinary Tra Water Ordinary Tra Air Ordinary Tra Water Ordinary Tra Water Ordinary Tra Water Ordinary Tra Water Ordinary Tra Water Processing w Water Ordinary Tra Water Processing w Water Ordinary Tra Air Ordinary Tra Water Ordinary Tra Water Ordinary Tra Air Ordinary Tra Water Ordinary Tra Water Ordinary Tra Water Ordinary Tra Water Ordinary Tra Water Ordinary Tra Water Processing w Water Processing w Water Processing w Water Processing w Water Processing w
16. MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362227 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362222 3501939991 HONDA MIN NO 7 HOUYL 0591 36230 0591 362227 4428930822 NANHAI HONDA AUTOMOBILE THINGS CO LTD 4428930822 NANHAI HONDA AUTOMOBILE THINGS CO LTD contactPersc traderLocatic companyTyp destinationC customsNam tradeMode transportatic acquiringCountry ZHANG GUAI Guangdong F Joint Capital Japan JP A Huangpu ZHANG GUAI Guangdong F Joint Capital Japan JP A Huangpu ZHANG GUAI Guangdong f Joint Capital Japan JP A Huangpu Guangdong FJoint Capital Japan JP A Guangzhou MA YUE Guangdong FJoint Capital Japan JP A Huangpu ZHANG LIU G Guangdong F Joint Capital Jordan JO Huangpu ZHANG LIU C Guangdong f Joint Capital Jordan JO Huangpu ZHANG LIU C Guangdong F Joint Capital Peru PE SA Huangpu JINJI YUAN Tianjin Hexi Joint Capital Vietnam VN Tianjin JINJI YUAN Tianjin Hexi Joint Capital Japan JP A Tianjin ZHANG LIU C Guangdong Ff Joint Capital Dominican R Huangpu NISHIMOTO Guangdong FJoint Capital United Kingd Shenzhen JIAO YUE Guangdong FJoint Capital Japan JP A Guangzhou JINJI YUAN Tianjin Hexi Joint Capital Japan JP A Tianjin JIAO YUE Guangdong f Joint Capital Italy IT EUI Guangzhou
17. T 635 705263 N ST 602 25 N ST 665 5 N ST 783 711538 N ST 489 24 N ST 316 851351 N ST 616 378788 N ST 530 5 N ST 328 2 N ST 889 75 N ST 664 2 N ST 286 159574 N ST 689 75 N ST 689 75 N ST 395 765 N ST 43 4313725 KG 20 9819277 KG companylD M companyNar address phone fax 4401930150 GUANGZHOL HENGSHA HI 020 822777t 020 8227062 4401930150 GUANGZHOL HENGSHA Hl 020 822777 020 8227062 4401930150 GUANGZHOL HENGSHA Hl 020 822777 020 822706 4428930822 NANHAI HONDA AUTOMOBILE THINGS CO LTD 4401930151 DONGFENG HENGSHA HI 020 822777 020 8227934 4401933222 WUYANG HC NO 82 XING 020 841824 020 8418654 4401933222 WUYANG HC NO 82 XING 020 841824 020 8418654 4401933222 WUYANG HC NO 82 XING 020 841824 020 8418654 1203932990 TIANJIN HON WEST OF PIN 022 2833482 022 2833555 1203932990 TIANJIN HON WEST OF PIN 022 2833482 022 2833555 4401933222 WUYANG HC NO 82 XING 020 841824 020 841865 4413930177 DONGFENG XINLIAO DAY 0752 52003 0752 520064 4412930196 ZHAOQING F JIDONG ROA 0758 28251C 0758 283913 1203932990 TIANJIN HON WEST OF PIN 022 2833482 022 2833555 4412930196 ZHAOQING F JIDONG ROA 0758 28251C 0758 283913 4401930150 GUANGZHOL HENGSHA HI 020 822777 020 8227062 4401933222 WUYANG HC NO 82 XING 020 841824 020 8418654 4401930151 DONGFENG HENGSHA HL 020 822777 020 8227934 4401933222 WUYANG HC NO 82 XING 020 841824 020 8418654 4412930196 ZHAOQING F JIDONG ROA 0758 28251C 0758 283913 4401933222 WUYANG HC NO 82 XING 020 841
18. Water Ordinary Tra Water Processing w Water Processing w Water Processing w Water Processing w Water Ordinary Tra Water Ordinary Tra Water Processing w Water Processing w Water Processing w Water Ordinary Tra Water Processing w Water Processing w Water Processing w Water Processing w Water Processing w Water Processing w Water Processing w Water Processing w Water Processing w Water Ordinary Tra Water Processing w Water Processing w Water Processing w Water Processing w Water Processing w Water Ordinary Tra Water Ordinary Tra Water Japan JP ASIA Japan JP ASIA Japan JP ASIA Japan JP ASIA Japan JP ASIA Jordan JO AFRI Jordan JO AFRI Peru PE SAMR Vietnam VN ASIA Japan JP ASIA Dominican Rep DO CARR United Kingdom GB EURO Japan JP ASIA Japan JP ASIA Italy IT EURO Japan JP ASIA Jordan JO AFRI Thailand TH ASIA Japan JP ASIA Japan JP ASIA Jordan JO AFRI Jordan JO AFRI United Kingdom GB EURO S Africa ZA AFRI Japan JP ASIA Peru PE SAMR Argentina AR SAMR S Africa ZA AFRI Vietnam VN ASIA Panama PA SAMR El Salvador SV SAMR Nicaragua NI SAMR St Lucia LC CARR Russia RU EURO Brazil BR SAMR Guyana GY SAMR Trinidad amp Tobago TT CARR Jordan JO AFRI United Arab Emirates AE AFRI Costa Rica CR SAMR Lithuania LT EURO United States US PACI Sudan
19. any Type Select units Minimum Maximum Unit type can be left blank to search only a quantity Minimum Maximum Figure 4 6 The 10th 11th and 12th fields Dollar Range Quantity and Unit Price Dollar Range describes a range between two US dollar amounts that the user wishes to examine Quantity simply describes the quantity range the the user would like to examine Unit price is a normalized way of examining a range of prices _ Query Figure 4 7 The last field Limit Results In this field the user can input a number to limit the amount the results to so that the file size is more manageable 4 2 Company Code Now that we have an understanding as to what is going inside the search parameters how do we get this information While some of it may be the question that you re asking there is definitely infor mation that every user does not know off the top of their head For example many researchers want to know information about a specific company or country s relationship with China Understanding how to input these parameters into the database is vital for information retrieval The process for retrieving both Company and Country Codes are virtually identical To get the company code to put into the query on the main page it is necessary to navigate to the Company Search tab at the top of the page es emnt Figure 4 8 Company Search in the Navigation Bar Once on the Company Search page the use
20. de for tools that extract specific information Exploring the Interface At the top of the page there are six clickable tabs which organize the interface of the site 3 1 Query Figure 3 1 The Query Tab The first of these tabs is the the Query tab where the user inputs their search parameters to specify the information that they want from the database Note Some values may be input as a comma separated list 3 2 Company Search 1 ENSE EETTETSS ET ETZEUR ESI Figure 3 2 The Company Search Tab The second tab is where the user may search for specific country names to input into their query It leads them to a results page where the user can take the Country name and copy and paste it to search 3 3 Country Search Query Company searen KESTE ETSI ETE EJ Figure 3 3 The Country Search Tab The third tab is where the user may search for specific company IDs to input into their query It leads them to a results page where the user can take the company ID and copy and paste it to search UIT ec Figure 3 4 The Queue Tab 3 4 Queue This is where users may view the current job queue and see roughly when their job will be run 3 5 Downloads Query Company Search County Search ETU ESESSPETG Figure 3 5 The Downloads Tab This is where the users may view completed jobs and download them to their computer 3 6 Help Query Company Search Counery Searen ETU ERU ERN Figure 3 6 The Help Tab A q
21. e cases where the two fields are not the same If the two coun tries aren t the same e If the trade direction is exports the acquiringCountry field describes a country or city that is a middle man between two countries The destinationCountry is the ultimate destination point of the exported good e If the trade direction is imports the acquiringCountry field describes a country or city that is like a middle man between two countries The destinationCountry is the original country that China imported the good from Trade Mode Select trade mode T Transportation Mode Select transportation mode xm Figure 4 3 The fifth and sixth fields Trade and Transportation Mode Trade mode describes the context of a trade is it a barter trade a border trade etc This field is the way that the good is traded Transportation mode describes the way the the product is being transported The most common are rail sea or air Company ID Comma separated lists may be used Figure 4 4 The seventh and eigth fields HS code and Company ID HS code stands for Harmonized System code and is a specific product descriptor They are available online See here Company ID can be found using the search tab at the top of the page This field is the type of company it describes whether it is a privately owned publicly owned or something else Company Type Select company type Figure 4 5 The ninth field Comp
22. od is up CTTDB Query done loewj 1407165483 zip Inbox x lE china data union edu 11 27 AM 49 minutes ago 7 to me Hi This is the China Transactional Trade Database server writing to tell you that your job you submitted has completed The following link should be good to download your data from you might be asked for a password to download it http chinadb v2 union edu downloads loewj 1407165483 zip After 24 hours the file will be removed The link is only good when used from on campus or via the VPN If you have any problems please let Tom Yanuklis know tay union edu Thanks CTTDB server Figure 5 3 E mail notification 13 Sample Query and Walk Through 6 1 Data Selection This chapter is intended to provide an example query to demonstrate the capability of some of the search features implemented in the system In the demonstration we will be searching for Honda products traded in March of 2006 The process begins at the Query page After entering a valid Union College username example union edu proceed to enter the date of the desired transaction In this case that will be March of 2006 Next se lect Both under the Trade Direction field IMPORTANT NOTE The only required fields in order to submit a query are Username Date and Trade Direction All others are optional though they may greatly help you specify the information that you want Quay r3 Data Selection Username loewj
23. r should type in either the name or part of the name of the company that they wish to search for along with the year of the data that they are searching Then simply hit the submit button Company Search r L3 Data Selection Company Name Substring Honda Submit Year 2006 Figure 4 9 The name may differ from year to year so it is important to select the year you will be querying The user will then be brought to the results page where they can choose whether to select one or all of the companies by using the check boxes on the left or the SELECT ALL button located above the data table The company ID codes will be automatically generated in the box below the results table Query ETT ES 12 results for Honda Select All Deselect All ompany Name Company ID TIANJIN HONDA MOTORCYCLE CO LTD 1203932990 GUANGZHOU HONDA AUTOMOBILE CO LTD 4401930150 NANHAI HONDA AUTOMOBILE THINGS CO LTD 4428930822 DONGFENG HONDA ENGINE CO LTD 4401930151 WUYANG HONDA MOTORS GUANGZHOU CO LTD 4401933222 ZHAOQING HONDA METAL CO LTD 4412930196 DONGFENG HONDA AUTO PARTS CO LTD 4413930177 HONDA MIN DONG GENERATOR CO LTD 3501939991 NEW CONTINENT HONDA MOTORCYCLE CO LTD SHANGHAI BRANCH CO LTD 3120930437 Honda Automobile China Co Ltd 4401530001 HONDA MOTORCYCLE RESEARCH DEVELOPMENT CO LTD 3118940705 Honda Motor China Investment Co Ltd 105940787
24. rarely be seen A job may be forced to exit if it exceeds the allocated runtime for a job the maximum running time is 48 hours The final column is elapsed time of the running job It prints in HH MM format the time that the current job has been running In order to refresh the output of the queue simply refresh the page There are two methods of retrieving the output of a completed job The first one is via email On the Query page there is a field for username When the submitted job completes an email is sent to example union edu That email includes a download link to the output Competed jobs also appear in the interface under the Downloads tab in the navigation bar Both methods of retrieval link to a Zip file which will contain a csv comma separated value file a sql sequel file and a txt text file The csv can be opened with a spreadsheet client such as Microsoft Excel The other two files are for debugging purposes and unless there is an issue with the output should be ignored It is important to note that there are two circumstances where a completed job will be removed from the server The first and more common circumstance is when the job is 24 hours old A process searches the downloads directory every hour and deletes files that are over 24 hours old The sec ond circumstance is when the server becomes short on space Although it likely will not happen frequently it is possible to loose your job before the 24 hour peri
25. uick reference page where users can get some tips thanks to a small FAQ Querying the Database 4 1 Query In order to retrieve data from the database it s vital to know what exactly to input as parameters Username Enter your Union username this will be used to email you when the query is compelte and to identify your download January gt 2000 Figure 4 1 The first two fields username and date Here the user should put in their Union username so that the system knows who to email the results to Please input usernames in the style of hazzardr and NOT hazardr union edu The date field is the month that you would like information for Just select the month and country you wish to query SImport Export Both Comma separated lists may be used Figure 4 2 The third and fourth fields Trade Direction and Partner Country In the trade direction field the user should specify whether they would like to view imports exports or both If the user selects both there will be identifiers for each element they are searching for differentiating between imports and exports Partner country is the country that China is trading with but there are a few subtleties to be explained In the result file of the query there are two fields to note acquiringCountry and destinationCountry If acquiringCountry and destinationCountry are the same then it is a simple direct trade from one country to another However there ar
Download Pdf Manuals
Related Search