Vol.55 No (Jan. 2014) saccess 6 saccess 7 saccess 2. [3] p.33 * B (A) (B) (C) (D) (E) (F) *1 [3], [4] Web PDF a m

Similar documents
1_26.dvi

2006 [3] Scratch Squeak PEN [4] PenFlowchart 2 3 PenFlowchart 4 PenFlowchart PEN xdncl PEN [5] PEN xdncl DNCL 1 1 [6] 1 PEN Fig. 1 The PEN

IPSJ SIG Technical Report Vol.2011-CE-110 No /7/9 Bebras 1, 6 1, 2 3 4, 6 5, 6 Bebras 2010 Bebras Reporting Trial of Bebras Contest for K12 stud

IPSJ SIG Technical Report Vol.2016-CE-134 No /3/6 1,a) saccess SQL PHP,, saccess, SQL, PHP, Programming Education with Database in Hi

1 4 4 [3] SNS 5 SNS , ,000 [2] c 2013 Information Processing Society of Japan

4) 5) ) ( 1 ) ( 2 ) ( 3 ) ( 4 ) ( 5 ) ( 6 ) )8) ( 1 ) ( 2 ) ( 3 ) ( 200 9) ( 10) 1 2 (

3_23.dvi

Vol. 48 No. 3 Mar PM PM PMBOK PM PM PM PM PM A Proposal and Its Demonstration of Developing System for Project Managers through University-Indus

IPSJ SIG Technical Report Vol.2009-HCI-134 No /7/17 1. RDB Wiki Wiki RDB SQL Wiki Wiki RDB Wiki RDB Wiki A Wiki System Enhanced by Visibl

e-learning e e e e e-learning 2 Web e-leaning e 4 GP 4 e-learning e-learning e-learning e LMS LMS Internet Navigware

自然言語処理16_2_45

IPSJ SIG Technical Report Vol.2016-CE-137 No /12/ e β /α α β β / α A judgment method of difficulty of task for a learner using simple

& Vol.5 No (Oct. 2015) TV 1,2,a) , Augmented TV TV AR Augmented Reality 3DCG TV Estimation of TV Screen Position and Ro

Vol.53 No (Mar. 2012) 1, 1,a) 1, 2 1 1, , Musical Interaction System Based on Stage Metaphor Seiko Myojin 1, 1,a

1 1 CodeDrummer CodeMusician CodeDrummer Fig. 1 Overview of proposal system c

IPSJ SIG Technical Report Vol.2010-NL-199 No /11/ treebank ( ) KWIC /MeCab / Morphological and Dependency Structure Annotated Corp

IPSJ SIG Technical Report Vol.2014-CE-126 No /10/11 1,a) Kinect Support System for Romaji Learning through Exercise Abstract: Educatio

1 Web [2] Web [3] [4] [5], [6] [7] [8] S.W. [9] 3. MeetingShelf Web MeetingShelf MeetingShelf (1) (2) (3) (4) (5) Web MeetingShelf

& Vol.2 No (Mar. 2012) 1,a) , Bluetooth A Health Management Service by Cell Phones and Its Us

IPSJ SIG Technical Report Vol.2014-CE-123 No /2/8 Bebras 1,a) Bebras,,, Evaluation and Possibility of the Questions for Bebras Contest Abs

IPSJ SIG Technical Report Vol.2011-MUS-91 No /7/ , 3 1 Design and Implementation on a System for Learning Songs by Presenting Musical St

IPSJ SIG Technical Report Vol.2009-DPS-141 No.20 Vol.2009-GN-73 No.20 Vol.2009-EIP-46 No /11/27 1. MIERUKEN 1 2 MIERUKEN MIERUKEN MIERUKEN: Spe

[2] OCR [3], [4] [5] [6] [4], [7] [8], [9] 1 [10] Fig. 1 Current arrangement and size of ruby. 2 Fig. 2 Typography combined with printing

60 90% ICT ICT [7] [8] [9] 2. SNS [5] URL 1 A., B., C., D. Fig. 1 An interaction using Channel-Oriented Interface. SNS SNS SNS SNS [6] 3. Processing S

日本感性工学会論文誌

1. 1 DBMS Unix (USP ) ( )[3] 20 UNIX [2] KISS UNIX 1. 2 (Tukubai ) Unix OS Unix USP Tukubai Tukubai 1. 3 Unix SQL Tukubai usp Tukubai Open usp Tukubai

The copyright of this material is retained by the Information Processing Society of Japan (IPSJ). The material has been made available on the website

Vol.54 No (July 2013) [9] [10] [11] [12], [13] 1 Fig. 1 Flowchart of the proposed system. c 2013 Information

258 5) GPS 1 GPS 6) GPS DP 7) 8) 10) GPS GPS ) GPS Global Positioning System

1 UD Fig. 1 Concept of UD tourist information system. 1 ()KDDI UD 7) ) UD c 2010 Information Processing S

IPSJ SIG Technical Report Vol.2011-EC-19 No /3/ ,.,., Peg-Scope Viewer,,.,,,,. Utilization of Watching Logs for Support of Multi-

Vol.57 No (Mar. 2016) 1,a) , L3 CG VDI VDI A Migration to a Cloud-based Information Infrastructure to Support

Vol. 42 No. SIG 8(TOD 10) July HTML 100 Development of Authoring and Delivery System for Synchronized Contents and Experiment on High Spe

Vol.53 No (Aug. 2012) BibTEX 1 2,a) , bole BibTEX BibTEX 1 BibTeX Literature Management System Based on BibTEX for L

Publish/Subscribe KiZUNA P2P 2 Publish/Subscribe KiZUNA 2. KiZUNA 1 Skip Graph BF Skip Graph BF Skip Graph Skip Graph Skip Graph DDLL 2.1 Skip Graph S

Vol. 48 No. 4 Apr LAN TCP/IP LAN TCP/IP 1 PC TCP/IP 1 PC User-mode Linux 12 Development of a System to Visualize Computer Network Behavior for L

E MathML W3C MathJax 1.3 MathJax MathJax[5] TEX MathML JavaScript TEX MathML [8] [9] MathSciNet[10] MathJax MathJax MathJax MathJax MathJax MathJax We

1 Fig. 1 Extraction of motion,.,,, 4,,, 3., 1, 2. 2.,. CHLAC,. 2.1,. (256 ).,., CHLAC. CHLAC, HLAC. 2.3 (HLAC ) r,.,. HLAC. N. 2 HLAC Fig. 2

Bulletin of JSSAC(2014) Vol. 20, No. 2, pp (Received 2013/11/27 Revised 2014/3/27 Accepted 2014/5/26) It is known that some of number puzzles ca

大学における原価計算教育の現状と課題

( )

IPSJ SIG Technical Report Vol.2012-CG-148 No /8/29 3DCG 1,a) On rigid body animation taking into account the 3D computer graphics came

A B C B C ICT ICT ITC ICT

A Study of Effective Application of CG Multimedia Contents for Help of Understandings of the Working Principles of the Internal Combustion Engine (The

IPSJ SIG Technical Report Vol.2014-EIP-63 No /2/21 1,a) Wi-Fi Probe Request MAC MAC Probe Request MAC A dynamic ads control based on tra

07九州工業大学.indd

1., 1 COOKPAD 2, Web.,,,,,,.,, [1]., 5.,, [2].,,.,.,, 5, [3].,,,.,, [4], 33,.,,.,,.. 2.,, 3.., 4., 5., ,. 1.,,., 2.,. 1,,

17 Proposal of an Algorithm of Image Extraction and Research on Improvement of a Man-machine Interface of Food Intake Measuring System

e-learning station 1) 2) 1) 3) 2) 2) 1) 4) e-learning Station 16 e-learning e-learning key words: e-learning LMS CMS A Trial and Prospect of Kumamoto

MDD PBL ET 9) 2) ET ET 2.2 2), 1 2 5) MDD PBL PBL MDD MDD MDD 10) MDD Executable UML 11) Executable UML MDD Executable UML

01-全体表紙.PDF

IPSJ SIG Technical Report Vol.2014-GN-90 No.16 Vol.2014-CDS-9 No.16 Vol.2014-DCC-6 No /1/24 1,a) 2,b) 2,c) 1,d) QUMARION QUMARION Kinect Kinect

DPA,, ShareLog 3) 4) 2.2 Strino Strino STRain-based user Interface with tacticle of elastic Natural ObjectsStrino 1 Strino ) PC Log-Log (2007 6)

Microsoft Word - toyoshima-deim2011.doc

1 Table 1: Identification by color of voxel Voxel Mode of expression Nothing Other 1 Orange 2 Blue 3 Yellow 4 SSL Humanoid SSL-Vision 3 3 [, 21] 8 325

JavaScript Web JavaScript BitArrow BitArrow ( 4 ) Web VBA JavaScript JavaScript JavaScript Web Ajax(Asynchronous JavaScript + XML) Web. JavaScr

IPSJ SIG Technical Report Secret Tap Secret Tap Secret Flick 1 An Examination of Icon-based User Authentication Method Using Flick Input for

IPSJ SIG Technical Report Vol.2012-HCI-149 No /7/20 1 1,2 1 (HMD: Head Mounted Display) HMD HMD,,,, An Information Presentation Method for Weara

IPSJ SIG Technical Report Vol.2012-CE-116 No /10/14 Kinect 1,a) 1,2,b) 1,c) 1,d) Kinect KineX Kinect,, Kinect, KineX Program Input using Kinect

知能と情報, Vol.30, No.5, pp

HASC2012corpus HASC Challenge 2010,2011 HASC2011corpus( 116, 4898), HASC2012corpus( 136, 7668) HASC2012corpus HASC2012corpus

3_39.dvi

,,,,., C Java,,.,,.,., ,,.,, i

IPSJ SIG Technical Report Vol.2017-CLE-21 No /3/21 e 1,2 1,2 1 1,2 1 Sakai e e e Sakai e Current Status and Challenges on e-learning T

ID 3) 9 4) 5) ID 2 ID 2 ID 2 Bluetooth ID 2 SRCid1 DSTid2 2 id1 id2 ID SRC DST SRC 2 2 ID 2 2 QR 6) 8) 6) QR QR QR QR

DEIM Forum 2009 B4-6, Str

/ p p

( ) [1] [4] ( ) 2. [5] [6] Piano Tutor[7] [1], [2], [8], [9] Radiobaton[10] Two Finger Piano[11] Coloring-in Piano[12] ism[13] MIDI MIDI 1 Fig. 1 Syst


3D UbiCode (Ubiquitous+Code) RFID ResBe (Remote entertainment space Behavior evaluation) 2 UbiCode Fig. 2 UbiCode 2. UbiCode 2. 1 UbiCode UbiCode 2. 2

評論・社会科学　８４号（よこ）（Ｐ）／３．金子

IPSJ SIG Technical Report Vol.2011-DBS-153 No /11/3 Wikipedia Wikipedia Wikipedia Extracting Difference Information from Multilingual Wiki

1 p.27 Fig. 1 Example of a koto score. [1] 1 1 [1] A 2. Rogers [4] Zhang [5] [6] [7] Löchtefeld [8] Xiao [

ActionScript Flash Player 8 ActionScript3.0 ActionScript Flash Video ActionScript.swf swf FlashPlayer AVM(Actionscript Virtual Machine) Windows

Vol.53 No (July 2012) EV ITS 1,a) , EV 1 EV ITS EV ITS EV EV EV Development and Evaluation of ITS Information Commu

IPSJ SIG Technical Report Vol.2014-CE-127 No /12/7 1,a) 2,3 2,3 3 Development of the ethological recording application for the understanding of


(a) 1 (b) 3. Gilbert Pernicka[2] Treibitz Schechner[3] Narasimhan [4] Kim [5] Nayar [6] [7][8][9] 2. X X X [10] [11] L L t L s L = L t + L s

IPSJ SIG Technical Report Vol.2014-CE-123 No /2/8 Bebras 1 2,a) 3,b) Bebras Consideration of figures in Bebras Contest MAIKO SHIMABUKU 1 YUKIO I

08-特集04.indd

IPSJ SIG Technical Report Vol.2009-DPS-141 No.23 Vol.2009-GN-73 No.23 Vol.2009-EIP-46 No /11/27 t-room t-room 2 Development of

Web ( ) [1] Web Shibboleth SSO Web SSO Web Web Shibboleth SAML IdP(Identity Provider) Web Web (SP:ServiceProvider) ( ) IdP Web Web MRA(Mail Retrieval

Appropriate Disaster Preparedness Education in Classrooms According to Students Grade, from Kindergarten through High School Contrivance of an Educati

[8] Inoue[9] Web [10] [11] [12] [1] c 2014 Information Processing Society of Japan 2

ICT Web Web ICT Web 2. 新 学 習 指 導 要 領 の 理 念 と 教 育 の 情 報 化 の 意 義 2-1 新 学 習 指 導 要 領 の 理 念 ICT 2

第６２巻　第１号　平成２４年４月／石こうを用いた木材ペレット

はじめに

1 Web Web 1,,,, Web, Web : - i -

IPSJ SIG Technical Report iphone iphone,,., OpenGl ES 2.0 GLSL(OpenGL Shading Language), iphone GPGPU(General-Purpose Computing on Graphics Proc

2 3 2 JavaScript 2. 1 Q1 1, % % Q Q Q1: 0 0.0% 7.3% 8 2.9% 1, % % 92.6% Q2: 9 3.3% 31.6% %

1: A/B/C/D Fig. 1 Modeling Based on Difference in Agitation Method artisoc[7] A D 2017 Information Processing

1: ( 1) 3 : 1 2 4

2. Twitter Twitter 2.1 Twitter Twitter( ) Twitter Twitter ( 1 ) RT ReTweet RT ReTweet RT ( 2 ) URL Twitter Twitter 140 URL URL URL 140 URL URL

TCP/IP IEEE Bluetooth LAN TCP TCP BEC FEC M T M R M T 2. 2 [5] AODV [4]DSR [3] 1 MS 100m 5 /100m 2 MD 2 c 2009 Information Processing Society of

20mm 63.92% ConstantZoom U 5

% 95% 2002, 2004, Dunkel 1986, p.100 1

Tf dvi

1) , 215, 1441, , 132, 1237, % College Analysis 2-4) 2

B HNS 7)8) HNS ( ( ) 7)8) (SOA) HNS HNS 4) HNS ( ) ( ) 1 TV power, channel, volume power true( ON) false( OFF) boolean channel volume int

Web Web Web Web 1 1,,,,,, Web, Web - i -

Transcription:

Vol.55 No.1 2 15 (Jan. 2014) 1,a) 2,3,b) 4,3,c) 3,d) 2013 3 18, 2013 10 9 saccess 1 1 saccess saccess Design and Implementation of an Online Tool for Database Education Hiroyuki Nagataki 1,a) Yoshiaki Nakano 2,3,b) Midori Nobe 4,3,c) Susumu Kanemune 3,d) Received: March 18, 2013, Accepted: October 9, 2013 Abstract: In this paper we propose saccess, a web-based tool for database education. It focuses on database learning activity in general education. By using saccess, students can study the basic concepts of relational operations of some tables, such as projection, selection, and join. Students can see the source table and result table of the operation. In this paper we will show the requirements of tools for database education in general education, explain the design and implementation of saccess and discuss the advantage of saccess through the experiments. Keywords: database education, general education in computer science, relational database, online tool for education 1. saccess POS 1 Okayama University, Okayama 700 8530, Japan 2 Kobe High School of Science and Technology, Kobe, Hyogo 651 0072, Japan 3 Osaka Electro-Communication University, Neyagawa, Osaka 572 8530, Japan 4 Neyagawa High School, Neyagawa, Osaka 572 0832, Japan a) nagataki@cc.okayama-u.ac.jp b) info@nakano.ac c) midori@mbox.kyoto-inet.or.jp d) kanemune@acm.org [1] [2] saccess 2 3 4 saccess 5 c 2014 Information Processing Society of Japan 2

Vol.55 No.1 2 15 (Jan. 2014) saccess 6 saccess 7 saccess 2. [3] p.33 *1 1 2.1 B (A) (B) (C) (D) (E) (F) *1 [3], [4] Web PDF http://www.mext.go.jp/ a menu/shotou/new-cs/youryou/1304427.htm (G) (H) 2.2 25 1 [4] 1 2 [3] 2.1 2 2.1 (A) (H) 1 2 3 3 2 3 10 2 2 2. (3) 3. (3) (3) 1 [4] p.127 *1 Fig. 1 Description about database education in the culliculum guidelines. c 2014 Information Processing Society of Japan 3

Vol.55 No.1 2 15 (Jan. 2014) 2.3 2.2 25 4 4 5 1 A-1 A-2 2 2 2 (3) / 1 (A) (B) (C) (B) (F ) (F )(G) (E) (D) (E) 2 (A)(B)(C)(D)(E)(F )(G) (H) 3 (H) 2 [3] pp.33 34 *1 Fig. 2 Relation between commentary to the curriculum guidelines and the learning topics shown in Section 2.1. RDB D RDB 4 A-1 Microsoft Excel A-2/B/C 3 Microsoft Access MS-Access 3 4 2.1 2.3.1 Excel Excel RDB A-1 Excel 1 1 (E) (G) (H) (F) RDB Excel LOOKUP RDB 2.3.2 MS-Access MS-Access Excel RDB 1 MS-Access 3 MS-Access A-2 C MS-Access (F) B (F) MS-Access Table 1 1 Learning topics of database exercises in Information Study textbook of Japanese high school. (A B) (C D) (E) (F) (G) (H) A-1 Excel 4 A-2 MS-Access 4 B MS-Access 4 C MS-Access 3 D 2 c 2014 Information Processing Society of Japan 4

Vol.55 No.1 2 15 (Jan. 2014) MS-Access 2.4 PC 10 PC MS-Office Excel MS-Access Excel MS-Access MS-Access MS-Access 2.5 RDB DBMS [5] 1 MS-Access DBMS SQL DBMS RDB RDB 2.6 1. 2. 3. 2.1 RDB 1 1 4. 5. Web Web 3. saccess saccess c 2014 Information Processing Society of Japan 5

Vol.55 No.1 2 15 (Jan. 2014) 3.1 saccess 2.1 (A) (G) saccess saccess saccess 5. Web Web saccess saccess saccess 2. saccess 3.2 saccess RDB 2.3 RDB 2. RDB 3.3 saccess RDB saccess RDB saccess saccess 3.3.1 saccess 2 saccess CSV CSV 1 RDB 1 CSV CSV 1 2 1 1 saccess CSV 3.3.2 3 1 (A) (B) (C) CSV (A) (B) (C) 3.3.3 CSV 4 4 5 5 1 c 2014 Information Processing Society of Japan 6

Vol.55 No.1 2 15 (Jan. 2014) Fig. 3 3 saccess Screenshot of database selection/registration phase on saccess. Fig. 4 4 Screenshot of database operation phase on saccess. 6 3.4 4 7 1 2 1 4 2 1 c 2014 Information Processing Society of Japan 7

Vol.55 No.1 2 15 (Jan. 2014) Table 2 2 saccess query commands. 1 Fig. 5 5 Screenshot of data table display/modification mode. 2 Fig. 6 6 Command block: an example. 7 Fig. 7 Command block list. 1 1 3.3.4 saccess 2.1 (G) saccess CSV 4 CSV CSV 3.4 saccess RDB saccess 2 1 saccess / c 2014 Information Processing Society of Japan 8

Vol.55 No.1 2 15 (Jan. 2014) 3.5 2.6 3. 2.1 saccess saccess (C) (G) (F) (C) 3.3.2 [6] (C) saccess 2. (A) (B) saccess CSV (C) (A) (B) (H) 4. 4.1 saccess PHP *2 Web PHP Web PHP 5.3 Web JavaScript CSS Cookie Internet Explorer Safari Web JavaScript saccess 2.6 5. 4.2 saccess *2 http://php.net/ 8 Fig. 8 Internal command processing of saccess. SQLite *3 SQLite MySQL PostgreSQL RDB saccess SQLite 3 PHP5 CSV CSV SQL create table insert SQLite CSV CSV 4.3 saccess SQL 8 saccess SQL saccess 5. saccess *3 http://www.sqlite.org/ c 2014 Information Processing Society of Japan 9

Vol.55 No.1 2 15 (Jan. 2014) MS-Access 5.1 2012 10 11 1 Web 2 saccess saccess 5.2 saccess MS-Access 1 POS 2 5 10 1 90 1 2 1 180 90 6 3 saccess 3 MS-Access saccess 3 98 MS-Access 3 113 1 saccess 5.2.1 saccess MS-Access 3 1 2 1 3 4 5 1 4 2 5 5.2.2 10 JAN JAN saccess 3 Table 3 Example questions of database operation in the practice. 1 2 2 70 3 70 70 13 4 5 70 c 2014 Information Processing Society of Japan 10

Vol.55 No.1 2 15 (Jan. 2014) Table 4 4 Exercises of database operation in the practice. 1 4 JAN 2 4 JAN 3 2012/4/2 4 2012/4/11 5 6 12 7 8 9 10 9 saccess MS-Access % Fig. 9 The percentages of corrected answers per exercise: comparison of saccess with MS-Access. 10 saccess Fig. 10 Distributions of numbers of corrected answers: saccess. 5 Table 5 Classification of exercises in Table 4. 1 2 3 4 5 6 7 8 9 10 3 MS-Access MS-Access 4 5 1 4 1 5 10 2 4 9 10 11 MS-Access Fig. 11 Distributions of numbers of corrected answers: MS- Access. 8 10 5.3 9 5 saccess MS-Access 1 1 10 saccess 7.18 MS-Access 5.91 10 saccess 11 MS-Access saccess 4 9 10 4 1 4 1 1 4 5 c 2014 Information Processing Society of Japan 11

Vol.55 No.1 2 15 (Jan. 2014) MS-Access 1 3 1 2 6. 3 4 saccess 5 saccess 9 10 saccess 6.2.2 6.2.3 5. saccess Web Web Web saccess [11] 6.1 saccess 2.6 1. saccess 2. 3. saccess 2.1 saccess 2. saccess RDB saccess RDB 3.2 saccess 3. 3.5 saccess 1 saccess 6.2.4 4. 90 6.2 6.2.1 saccess 2 1 24 A/B/C 5.1 A [9], [10] 6.2.2 MS-Access 3 1 2 42% c 2014 Information Processing Society of Japan 12

Vol.55 No.1 2 15 (Jan. 2014) saccess 1 2 3 1 2 JAN 6 10 MS-Access MS-Access MS-Access 1 2 saccess MS-Access saccess 2. 3. MS-Access saccess 6.2.3 saccess MS-Access saccess saccess 4 saccess 4. MS-Access MS-Access 5 MS-Access saccess MS-Access saccess 1 6.2.4 12 MS-Access MS-Access 1 12 Query by Example [7] MS-Access 1 1 MS-Access MS-Access RDB MS-Access [8] MS-Access 12 MS-Access Fig. 12 Screenshot of query interface on MS-Access. c 2014 Information Processing Society of Japan 13

Vol.55 No.1 2 15 (Jan. 2014) saccess 7. saccess 2013 4 saccess MS-Access saccess saccess saccess *4 saccess saccess (H) JSPS 24700871 (ISSEP 06), pp.59 70 (2006). [2] (2009) http://www.cec.or.jp/ict/pdf/houkoku all.pdf. [3] (2010). [4] (2009). [5] Excel Access 24 pp.207 208 (2000). [6] 5 (2012) http://www.zenkojoken.jp/ 05chiba/%E5%88%86%E7%A7%91%E4%BC%9A/?action=common download main&upload id=617. [7] Zloof, M.M.: Query-by-Example: A data base language, IBM Systems Journal, Vol.16, No.4, pp.324 343 (1977). [8] McMaster, K., Sambasivam, S. and Anderson, N.: Relational algebra programming with microsoft access databases, Interdisciplinary Journal of Information, Knowledge, and Management, Vol.6, pp.73 83 (2011). [9] Vol.51, No.10, pp.1961 1973 (2010). [10] 2012 No.1, pp.2 6 (2012). [11] Vol.2012-CE-117, No.11, pp.1 6 (2012). 2002 2005 2009 2013 2011 [1] Antonitsch, P.K.: Database as a tool of general education, Proc. International Conference in Informatics in Secondary Schools - Evolution and Perspectivs *4 http://saccess.eplang.jp/ c 2014 Information Processing Society of Japan 14

Vol.55 No.1 2 15 (Jan. 2014) 1988 1990 1990 IBM 1993 1994 2004 2008 2011 2013 1984 2009 2006 2011 1987 1989 2004 2004 2009 2013 ACM IEEE Computer Society c 2014 Information Processing Society of Japan 15

2024 © docsplayer.net プライバシー | 利用規約 | フィードバック