Journal of advanced database management & systems (vol1, issue2) by STM Journals Publication

eISSN: 2393-8730

Advanced Database Management & Systems May - August 2014

STM JOURNALS Scientific

Technical

Medical

(JoADMS)

www.stmjournals.com

STM Publication(s) STM Publication, a strong initiative by Consortium E-Learning Network Private ltd.(Estd. 2006) was launched in the year 2010 under the support and guidance by our esteemed Editorial and Advisory board members from renowned institutes. Objectives of STM Publication(s): ? Scientific, Technical and Medical research promotions. ? Publication of genuine Research/Review, Short Articles and Case Studies through proper review

process. ? Publishing Special Issues on Conferences. ? Preparing online platform for other print Journals. ? Empowering the libraries with online and print Journals in Scientific, Technical and Medical

domains. ? Publishing and distribution of books on various subjects which mainly falls in the category of

Nanotechnology, Scientific and technical writing & Environment, Health and Safety. Salient Features: ? A bouquet of 100+ Journals that fall under Science, Technical & Medical domains. ? Employs Open Journals System (OJS) A Journal Management & Publishing System. ? The first and one of the fastest growing publication website in India as well as in abroad for its quality

and coverage. ? Rapid online submission and publication of papers, soon after their formal acceptance/ finalization. ? Facilitates linking with the other authors or professionals. ? Worldwide circulation and visibility.

Journal of Advanced Database Management & Systems eISSN: 2393-8730 Focus and Scope Covers Systems Analysis and Design ? Semantic Web and Ontologyâ&#x20AC;&#x2122;s ? Knowledge Modeling and Processing ? Sensor data Management ? Temporal, Spatial and High dimensional databases ? Database System and applications ? Data warehousing and data mining, OLAP ? Journal of Advanced Database Management & Systems is published (frequency: three times a year) in India by STM Journals (division of Consortium e-Learning Network Private Ltd. Pvt.) The views expressed in the articles do not necessarily reflect of the Publisher. The publisher does not endorse the quality or value of the advertised/sponsored products described therein. Please consult full prescribing information before issuing a prescription for any products mentioned in this publication. No part of this publication may be reproduced, stored in retrieval system or transmitted in any from without written permission of the publisher. To cite any of the material contained in this Journal, in English or translation, please use the full English reference at the beginning of each article. To reuse any of the material, please contact STM Journals (info@stmjournals.com)

STM Journals (division of Consortium e-Learning Network Private Ltd. ) having its Marketing office located at Office No. 4, First Floor, CSC pocket E Market, Mayur Vihar Phase II, New Delhi-110091, India is the Publisher of Journal. Statements and opinions expressed in the Journal reflect the views of the author(s) and are not the opinion of STM Journals unless so stated. Subscription Information and Order: Cost of Journal: ? National Subscription: Rs. 3750/- per Journal (includes 3 print issues), Single Issue copy purchase Rs.1500/copy ? International Subscription: ? Online Only- $99, Print Only-$149 (includes 3 print issues) ? Online + Print-$199 (includes 3 print issues + online access of published back volumes )

To purchase print compilation of back issues please send your query at info@stmjournals.com Subscription must be prepaid. Rates outside the India includes speed delivery charges. Prices subject to change without notice. Mode of Payment: At par cheque, Demand draft, and RTGS (payment to be made in favor of Consortium E-Learning Network. Pvt. ltd., payable at Delhi/New Delhi. Online Access Policy A). For Authors: In order to provide maximum citation and wide publicity to the authors work, STM Journals also have Open Access Policy, authors who would like to get their work open access can opt for Optional Open Access publication at nominal cost as follows India, SARC and African Countries: INR 2500 or 100 USD including single hard copy of Author's Journal. Other Countries: USD 200 including single hard copy of Author's Journal. B.) For Subscribers: ? Online access will be activated within 72 hours of receipt of the payment (working days), subject to receipt of

correct information on user details/Static IP address of the subscriber. ? The access will be blocked: ? If the user requests for the same and furnishes valid reasons for blocking. ? Due to technical issue. ? Misuse of the access rights as per the access policy.

Advertising and Commercial Reprint Inquiries: STM Journals with wide circulation and visibility offer an excellent media for showcasing/promotion of your products/services and the events-namely, Conferences, Symposia/Seminars etc. These journals have very high potential to deliver the message across the targeted audience regularly with each published issue. The advertisements on bulk subscriptions, gift subscriptions or reprint purchases for distribution etc. are also very welcome. Lost Issue Claims: Please note the following when applying for lost or missing issues: ? Claims for print copies lost will be honored only after 45 days of the dispatch date and before publication of the

next issue as per the frequency. ? Tracking id for the speed post will be provided to all our subscribers and the claims for the missing Journals will

be entertained only with the proofs which will be verified at both the ends. ? Claims filed due to insufficient (or no notice) of change of address will not be honored. ? Change of Address of Dispatch should be intimated to STM Journals at least 2 months prior to the dispatch

schedule as per the frequency by mentioning subscriber id and the subscription id. ? Refund requests will not be entertained.

Legal Disputes All the legal disputes are subjected to Delhi Jurisdiction only. If you have any questions, please contact the Publication Management Team: info@stmjournals.com; Tel : +91 0120-4781211.

Publication Management Team Chairman Mr. Puneet Mehrotra Managing Director STM Journals, Consortium eLearning Network Pvt. Ltd.(CELNET) Noida ,India

Group Managing Editor Dr. Archana Mehrotra Director CELNET, Delhi, India

Internal Members Puneet Pandeya Manager Associate Editors Gargi Asha Jha Nupur Anand

Monika Malhotra Assistant Manager Assistant Editors Priyanka Aswal Aditya Sanyal Anupama Garg Sona Chahal Himani Pandey

External Members

Dr. Bimlesh Lochab Industrial Tribology Machine Dynamics & Maintenance Engineering Centre (ITMMEC) Indian Institute of Technology Delhi, India.

Dr. Rajiv Prakash School of Materials Science and Technology, Institute of Technology, Banaras Hindu University, Varanasi, India.

Prof. S. Ramaprabhu Alternative Energy Technology Laboratory, Department of Physics, Indian Institute of Technology, Chennai, India.

Dr. Rakesh Kumar Assistant Professor, Department of Applied Chemistry, BIT Mesra, Patna, India.

STM Journal (s) Advisory Board

Dr. Baldev Raj

Prof. Bankim Chandra Ray

Chairman, National Institute of Technology Puducherry, India. Former Director, Indira Gandhi Centre for Atomic Research, India.

Professor and Head, Department of Metallurgical and Materials Engineering National Institute of Technology, Rourkela, India.

Dr. Hardev Singh Virk Professor Emeritus, Eternal University, Baru Sahib, India.

Dr. Baskar Kaliyamoorthy Associate Professor, Department of Civil Engineering National Institute of Technology Trichy, India.

Prof. D. N. Rao Professor, Department of Biochemistry, AIIMS, New Delhi, India.

Prof. Jugal Kishore Professor, Department of Community Medicine, Maulana Azad Medical College, New Delhi, India.

Dr. Ashish Runthala

Dr. Pankaj Poddar

Lecturer, Biological Sciences Group, Birla Institute of Technology & Science, Pilani Rajasthan, India.

Scientist, Physical & Materials Chemistry Division, National Chemical Laboratory, Pune, India.

Dr. Nandini Chatterjee Singh Associate Professor, National Brain Research Centre, Manesar, India.

STM Journal (s) Advisory Board

Dr. Priyavrat Thareja

Dr. Rakesh Kumar

Head, Materials and Metallurgical Engineering Department, PEC University of Technology, Chandigarh, India.

Assistant Professor, Department of Applied Chemistry, BIT Mesra, Patna, India.

Dr. Shankargouda Patil

Dr. Shrikant Balkisan Dhoot

Asst. Prof., Department of Oral Pathology, KLE Society's Institute of Dental Sciences, Bangalore, India.

Head Research & Development, Nurture Earth R&D Pvt Ltd MIT Campus, Beed bypass road, Aurangabad, India.

Prof. Subash Chandra Mishra

Prof. Sundara Ramaprabhu

Professor, Metallurgical & Materials Engineering Department, NIT, Rourkela, India.

Professor, Department of Physics Indian Institute of Technology Madras, India.

Prof. Yuwaraj Marotrao Ghugal Professor and Head Department, Govt. College of Engineering Station Road, Osmanpura, Aurangabad, India.

Editorial Board

Niusvel Acosta Mendoza Researcher at Advanced Technologies Application Center (CENATAV) Cuba.

José María Luna Ariza Department of Computer Sciences and Numerical Analysis Campus Universitario de Rabanales. University of Córdoba, Spain.

Dr. H.S. Behera Asstistant Professor Dept. of Computer Science & Engineering Veer Surendra Sai University of Technology,Odisha, India.

Yahui chang Associate Professor Department of Computer Science and Engineering, National Taiwan Ocean University, Taiwan.

Dr. S. Nickolas Associate professor at National institute of technology tiruchirappalli. India.

Shaoxu Song Assistant Professor School of Software, Tsinghua University Beijing, China.

Sebastián Ventura Associate Professor Department of Computer Science and Numerical Analysis. University of Córdoba. Spain.

Jenq Haur Wang Assistant ProfessorDepartment of Computer Science and Information Engineering National Taipei University of Technology Taiwan.

Director's Desk

STM JOURNALS

I take the privilege to present the print version for the Volume 1 Issue (2) of Journal of Advanced Database Management & Systems. The intension of JoADMS is to create an atmosphere that stimulates creativeness, research and growth in the area of advanced database. The development and growth of the mankind is the consequence of brilliant Research done by eminent Scientists and Engineers in every field. JoADMS provides an outlet for Research findings and reviews in areas of advanced database found to be relevant for National and International recent developments & research initiative. The aim and scope of the Journal is to provide an academic medium and an important reference for the advancement and dissemination of Research results that support high level learning, teaching and research in the domain of advanced database. Finally, I express my sincere gratitude and thanks to our Editorial/ Reviewer board and Authors for their continued support and invaluable contributions and suggestions in the form of authoring write ups/ reviewing and providing constructive comments for the advancement of the journals. With regards to their due continuous support and co-operation, we have been able to publish quality Research/Reviews findings for our customers base. I hope you will enjoy reading this issue and we welcome your feedback on any aspect of the Journal.

Dr. Archana Mehrotra Director STM Journals

Journal of Advanced Database Management & Systems

Contents

1. An Improved SentiWordNet for Opinion Mining and Sentiment Analysis Soumya Vaidya, Mohamed Rafi

2. Comparison of Education in Europe on Specialty Information Technologies and Computer Science Zhangisina G., Murzalina G., Munalbaeva N.

3. NoSQL Databases- Analysis, Techniques, and Classification Manoveg Saxena, Zakir Ali, Vinod Kumar Singh

4. Applying the XML-based Technique to Support Keyword Search in Graph Data Ya-Hui Chang, Si-Yen Zhuang

5. An Empirical Study on Evaluating Graph Based Clustering for HD Data Using Attribute Selection V. Hemapriya, K. P. N. V. Satya Sree, K. V. Narasimha Reddy

Journal of Advanced Database Management & Systems ISSN: 2393-8730 (online) Volume 1, Issue 2 www.stmjournals.com

An Improved SentiWordNet for Opinion Mining and Sentiment Analysis Soumya Vaidya*, Mohamed Rafi Computer Science and Engineering Department, University B D T College of Engineering, Davanagere, Karnataka, India Abstract Opinion Mining and Sentiment Analysis is an emergent research area, spanning over multiple disciplines such as data mining, text mining, etc. Opinion mining is an art of extracting the opinions from the huge set of opinion set or reviews. Sentiment analysis is a type of natural language processing for tracking the mood of the public about a particular product or topic. The existing works of opinion mining used Sentiwordnet as a lexical resource. The major drawback of this existing Sentiwordnet is non-determination of score count, i.e., it doesnâ&#x20AC;&#x2122;t provide the details of number of positively, negatively and neutrally scored words. This information is necessary because without the knowledge of score count if the further data mining techniques are applied, it may give inaccurate results. To facilitate the opinion mining task, this work focus on design of Improved Sentiwordnet so that it can produce the count of scored words by distinguishing them into positive, negative and neutral words. Experiments are conducted on standard movie review and product review datasets. This work also make use of Stanford POS tagger for tagging the dataset. The counted words can be used to improve the results comparatively better.

Keywords: Opinion mining, sentiment analysis, POS tagging, scoring using improved SentiWordNet

Journal of Advanced Database Management & Systems ISSN: 2393-8730 (online) Volume 1, Issue 2 www.stmjournals.com

Comparison of Education in Europe on Specialty Information Technologies and Computer Science Zhangisina G.1*, Murzalina G.1, Munalbaeva N.2 1

Department of Information Security, KazNTU named after K.I. Satpaeva, Kazakhstan, Almaty 2 Information Science, KazGosGenPU

Abstract In this paper the author works on the definition and comparison of computer science in Europe. It is also important that the author writes about the change needed in teaching in Kazakhstan, as computer science is considered very important in today's world. This article describes the modern European education in the field of computer science in high schools considering the leading European universities (Oxford and Berlin Technical Universities) with different educations systems. Nevertheless, no matter how unique each system, there are several positive features, which can be emulated by Kazakhstan Universities and studied computer science and management bodies for the further improvement of higher education in the country and training graduates in Kazakhstan's Universities. Comparisons of education in Europe on specialty information technologies and computer science are considered in this paper.

Keywords: European education, educational systems, Oxford, Berlin Technical Universities, Computer science.

Journal of Advanced Database Management & Systems ISSN: 2393-8730 (online) Volume 1, Issue 2 www.stmjournals.com

NoSQL Databases- Analysis, Techniques, and Classification Manoveg Saxena1, Zakir Ali2, Vinod Kumar Singh3* 1

Heinz Nixdorf Institute, University of Paderborn, Germany 2 Bundelkhand University, Jhansi, U.P., India 3 S.R. Group of Institutions, Jhansi, U.P., India

Abstract In recent years in big data and real-time web applications, NoSQL database solutions are gaining popularity in handling massive increase in size of data storage. The design of traditional relational database management systems makes it difficult for them to take advantage of virtually unlimited processing power and economical storage available via cloud computing. In contrast to this NoSQL databases support dynamic schemas, autosharding, automatic replication and integrated caching capabilities prominently among many other features making it suitable to be used as storage mechanism in cloud computing environments. Due to the big number of available storage solutions classification of NoSQL databases based on various criteria is analyzed. To cope with this look, I discuss techniques common to NoSQL datastores and analyze four prominent solutions (MongoDB, SimpleDB, Riak, and Bigtable).

Keywords: NoSQL, RDBMS, MapReduce, BigTable, MongoDB

Journal of Advanced Database Management & Systems ISSN: 2393-8730 (online) Volume 1, Issue 2 www.stmjournals.com

Applying the XML-based Technique to Support Keyword Search in Graph Data Ya-Hui Chang*, Si-Yen Zhuang Department of Computer Science and Engineering, National Taiwan Ocean University, Keelung, Taiwan Abstract Graphs have been important and proper structures to represent data with complex relationships in the Web, and keyword search provides a convenient way to querying graphs. Some researchers considered to return r-cliques as answers for keyword search in graph databases. Such concepts can retrieve meaningful information effectively, but the existing approach is computationally expensive. In this paper, we propose to utilize the efficient technique originally designed for keyword search in XML data to help identify answers. The main idea is first transforming the input graph into a tree, and then applying the efficient ELCA technique on the transformed tree to find the subtrees which consist of closely-related matches. The specially-designed SRE and SRE* algorithms are then applied on these subtrees to identify r-cliques. We have proposed several strategies for transforming graphs into trees and designed a series of experiments to examine their performance. Experimental results show that our approaches perform very well in terms of efficiency and recall. Keywords: Keyword search, Graph database, ELCA

Journal of Advanced Database Management & Systems ISSN: 2393-8730 (online) Volume 1, Issue 2 www.stmjournals.com

An Empirical Study on Evaluating Graph Based Clustering for HD Data Using Attribute Selection V. Hemapriya*, K. P. N. V. Satya Sree, K. V. Narasimha Reddy Department of CSE, VNITSW, Guntur, AP, India

Abstract An attribute subset selection can be showed as a process of identifying and eliminating or removing a number of irrelevant and surplus attributes (features) because irrelevant attributes do not give predictive accuracy and the surplus attributes provide the information that is already present in the other attributes. Attribute selection involves identifying a subset of the most useful attributes that produces the similar results as the final set of results. An attribute (feature) selection algorithm may be evaluated from two points of view. First one concerns the time required to get the subset of attributes and the second one concerns quality of the subset of attributes. Based on these criteria, graphbased clustering for attribute selection algorithm, GRACE is proposed. This algorithm works in two steps. In the first step, attributes are divided into clusters by using graphtheoretic clustering methods. In the second step, most similar attributes that are strongly related to the object classes are selected from each cluster from a subset of attributes. Attributes in different clusters are relatively independent. To ensure the efficiency of this algorithm, the authors implemented the minimum spanning tree clustering method.

Keywords: Graph-based clustering, filter method, attribute subset selection