CHOOSING THE MOST APPROPRIATE QUERY LANGUAGE TO USE OUTER JOINS FOR DATA EXTRACTION IN DATALOG MODE IN THE DEDUCTIVE DATABASE SYSTEM DES

Q: How can I download an article?

To download an article from SID, first log in to the site, search for the article title, and click on the 'Download Article' option.

Q: How can I download an ISI article?

To download an ISI article on SID, enter the keyword or article title in the search bar, view the relevant results, click on the desired article, and select the 'Download Article' option.

Q: How can I access the SID database?

To access the SID database, visit SID.ir, create an account, and log in to access scientific resources.

Q: Is downloading articles from SID free?

Some articles on SID are available for free, while others require payment. Details are specified on the article's page.

RANJBAR HASSANI MAHMOOD ABADI MAHDI; FARAAHI AHMAD

مرکز اطلاعات علمی Scientific Information Database (SID) - Trusted Source for Research and Academic Resources

Journal Paper

Paper Information

Journal: SIGNAL AND DATA PROCESSING Year:2018 | Volume:15 | Issue:1 (SERIAL 35) Page(s): 139-150

Download Full-Text

Persian Verion

View:

601

Download:

Cites:

Information Journal Paper

Title

CHOOSING THE MOST APPROPRIATE QUERY LANGUAGE TO USE OUTER JOINS FOR DATA EXTRACTION IN DATALOG MODE IN THE DEDUCTIVE DATABASE SYSTEM DES

Author(s)

RANJBAR HASSANI MAHMOOD ABADI MAHDI | FARAAHI AHMAD | Issue Writer Certificate

Keywords

DEDUCTIVE DATABASEQ1

DESQ1

DATALOG MODEQ1

OUTER JOINSQ1

DATA EXTRACTIONQ1

Abstract

DEDUCTIVE DATABASE systems are DESigned based on a logical data model. Data (as opposed to Relational Databases Management System (RDBMS) in which data stored in tables) are saved as facts in a DEDUCTIVE DATABASE system. Datalog Educational System (DES) is a DEDUCTIVE DATABASE system that DATALOG MODE is the default mode in this system. It can extract data to use OUTER JOINS with three query languages (Datalog, SQL and RA) in default mode. In 2004, system DES was DESigned and implemented by Fernando S´ aenz-P´ erez from Department of Artificial Intelligence and Software Engineering, Complutense University, Madrid, Spain. In a paper, this researcher introduced OUTER JOINS of system DES in 2012. The most important objective of present research is to complement and extend the paper authored by mentioned researcher. Therefore, in prior research, choosing the most appropriate query language has not been investigated to use OUTER JOINS for DATA EXTRACTION in DATALOG MODE in DES system. In this study, by considering two parameters (cost of writing a query and memory usage of a query) choosing the most appropriate query language has been investigated to use OUTER JOINS for DATA EXTRACTION in DATALOG MODE in Deductive system DES. Cost of writing a query parameter is considered in this study to decrease the query typing time, but other parameters are related to the query processing are not considered. If the processing time of the three query languages is assumed identical, after entering the query in the system DES, the idea of the present study (reduction of the typing time) can lead to the reduction of the response time. Also, there are two hypotheses in this study as follows: 1) it is assumed that the user is fluent in all three query languages and wants to access the given data quickly through the most appropriate query language. 2) In the present study, the simplicity or difficulty of a query language is not considered. The results of the research show that one language cannot be appropriate for all queries; therefore, for every different query the most appropriate query language must be chose to use outer joints. In the current research, the most appropriate query language is the one in which, in comparison with other two query languages, the user will need to use less buttons of the keyboard to press in order to fulfill the query. The decrease in the number of buttons pressed by the user will decrease the time consumed to fulfill the query and, therefore, it will lead to a faster access to data.

Cites

No record.

References

No record.

Cite

APA: Copy

RANJBAR HASSANI MAHMOOD ABADI, MAHDI, & FARAAHI, AHMAD. (2018). CHOOSING THE MOST APPROPRIATE QUERY LANGUAGE TO USE OUTER JOINS FOR DATA EXTRACTION IN DATALOG MODE IN THE DEDUCTIVE DATABASE SYSTEM DES. SIGNAL AND DATA PROCESSING, 15(1 (SERIAL 35) ), 139-150. SID. https://sid.ir/paper/160907/en

Vancouver: Copy

RANJBAR HASSANI MAHMOOD ABADI MAHDI, FARAAHI AHMAD. CHOOSING THE MOST APPROPRIATE QUERY LANGUAGE TO USE OUTER JOINS FOR DATA EXTRACTION IN DATALOG MODE IN THE DEDUCTIVE DATABASE SYSTEM DES. SIGNAL AND DATA PROCESSING[Internet]. 2018;15(1 (SERIAL 35) ):139-150. Available from: https://sid.ir/paper/160907/en

IEEE: Copy

MAHDI RANJBAR HASSANI MAHMOOD ABADI, and AHMAD FARAAHI, “CHOOSING THE MOST APPROPRIATE QUERY LANGUAGE TO USE OUTER JOINS FOR DATA EXTRACTION IN DATALOG MODE IN THE DEDUCTIVE DATABASE SYSTEM DES,” SIGNAL AND DATA PROCESSING, vol. 15, no. 1 (SERIAL 35) , pp. 139–150, 2018, [Online]. Available: https://sid.ir/paper/160907/en

Related Journal Papers