Applications of SQL for Informetric Data Processing

Wolfram, Dietmar

doi:10.29173/cais314

Cited by 4 publications

(5 citation statements)

References 9 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Total 1083 1588 In the end, each article selected for this study had 3 sets of keywords assigned by three different classes of metadata creators. The data was stored in a MySQL database and preliminary informetrics analysis was done using SQL scripts as suggested by Wolfram (2005). Descriptive statistics and basic informetric data were collected to provide a good picture of the scope of the collected data.…”

Section: Journal Name Number Of Articles Number Of Postsmentioning

confidence: 99%

See 1 more Smart Citation

Tagging Practices on Research Oriented Social Bookmarking Sites

Kipp

2013

CAIS/ACSI

View full text Add to dashboard Cite

This paper examines the tagging practices evident on CiteULike, a research oriented social bookmarking site for journal articles. Tagging practices were examined using standard informetric measures for analysis of bibliographic information and term use. Additionally, tags were compared to author keywords and descriptors assigned to the same article.Résumé : Cette communication examine les pratiques d'étiquetage par mots-clés qui sont utilisés sur CiteULike, un service d'étiquetage social, pour les articles de périodiques. Ces pratiques de marquage ont été examinées en utilisant les mesures informétriques habituellement utilisées pour l'analyse d'information bibliographique et d'utilisation de mots-clés. En outre, les étiquettes ont été comparées aux mots-clés utilisés par les auteurs et aux descripteurs attribués à ces mêmes articles.

show abstract

Section: Journal Name Number Of Articles Number Of Postsmentioning

confidence: 99%

“…An interesting measure for examining term usage in tagging is the measure of user vocabulary length, most often used to analyse search query logs. (Wolfram 2005) This data represents all the tags used by a specific user in the data set. The largest user vocabulary length in the data set was 62, the smallest 1 and the median 2.…”

mentioning

confidence: 99%

Tagging Practices on Research Oriented Social Bookmarking Sites

Kipp

2013

CAIS/ACSI

View full text Add to dashboard Cite

show abstract

“…An interesting measure for examining term usage in tagging is that of user vocabulary length, most often used to analyse search query logs (Wolfram 2005). This measure represents all tags used by a specific user in a specific context (e.g., all tags used by a user for a particular article).…”

Section: Citation Analysis 19mentioning

confidence: 99%

User, Author and Professional Indexing in Context: An Exploration of Tagging Practices on CiteULike / Le contexte de l'indexation des usagers, des créateurs et des professionnels : une exploration des pratiques d'étiquetage social sur CiteULike

Kipp¹

2011

Canadian Journal of Information and Library Science

View full text Add to dashboard Cite

This paper examines the context of online indexing from the viewpoint of three different groups: users, authors, and intermediaries. User, author and intermediary keywords were collected from journal articles tagged on CiteULike and analyzed. Descriptive statistics, informetric measures, and thesaural term comparison shows that there are important differences in the context of keywords from the three groups.

show abstract

“…These systems are modelled to maintain a large quantum of information. Fetching a bulk quantity of the same type of data is very effective in databases [3]. However, the user needs to master the database architecture completely in building the queries.…”

Section: Introductionmentioning

confidence: 99%

“…SQL is comprehensively employed in industry and is supported by major DBMS. In addition, most of the languages used in accessing relational database systems [3] are formed because of SQL models. Only people who have the technical understanding or knowledge of these languages can have access to the information [4] in the database.…”

Section: Introductionmentioning

confidence: 99%

An Approach for Building Natural Language Database using Pattern Matching Technique

Nartey¹,

Amavi²,

Nyameamah³

2019

IJCA

View full text Add to dashboard Cite

Information assumes a vital aspect of our lives. One of the main supplies of information is databases. There is a blooming interest in databases by researchers and its innovation is growing rapidly. This has subsequently resulted in an influence on the utilization of computers assiduously. Furthermore, most Information Technology (IT) related applications stores, retrieves, organizes, accesses and analyzes information from databases. For instance, retrieval of information from database involves the understanding of database languages like Structured Query Language (SQL). Nonetheless, not everyone is capable of scripting SQL queries, as they may not know of the structure of SQL makeup of the database. The aforementioned issues triggered the building of systems where non-expert users compose their questions in their natural language and obtain the results in the form of a database. The natural language interface to the database (NLIDB) was developed to query relational databases in their natural language instead of working with SQL, an idea provoked to form a new kind of management system. The existing approaches to NLIDBs are challenged with some weaknesses, which include non-intelligent, slow response time and inability to interact with user queries. This paper presents an intelligent NLIDB that uses a chatbot as the natural language interface and a Synthetic Intelligence Markup language (SIML) as the Knowledge-base. The Chatbot is utilized to capture keywords in the user's utterances stored in the knowledge base. The proposed NLIDB structure is based on pattern matching technique employed to communicate with users, manages complications and uncertainties for building natural language queries associated with SQL. Experimental results show that the proposed method gave a promising result on user satisfaction and task completion as compared with existing approaches.

show abstract

Applications of SQL for Informetric Data Processing

Cited by 4 publications

References 9 publications

Tagging Practices on Research Oriented Social Bookmarking Sites

Tagging Practices on Research Oriented Social Bookmarking Sites

User, Author and Professional Indexing in Context: An Exploration of Tagging Practices on CiteULike / Le contexte de l'indexation des usagers, des créateurs et des professionnels : une exploration des pratiques d'étiquetage social sur CiteULike

An Approach for Building Natural Language Database using Pattern Matching Technique

Contact Info

Product

Resources

About