IEEE Organizations related to Structured Query Language

Back to Top

No organizations are currently tagged "Structured Query Language"



Conferences related to Structured Query Language

Back to Top

No conferences are currently tagged "Structured Query Language"


Periodicals related to Structured Query Language

Back to Top

No periodicals are currently tagged "Structured Query Language"


Most published Xplore authors for Structured Query Language

Back to Top

Xplore Articles related to Structured Query Language

Back to Top

SQL-PL4OCL: An Automatic Code Generator from OCL to SQL Procedural Language

2017 ACM/IEEE 20th International Conference on Model Driven Engineering Languages and Systems (MODELS), 2017

Design models are widely spread as core artifacts in software engineering. Yet, a key problem is how to fulfill correctly these blueprint specifications when code components are developed. The best possible scenario occurs when a source modeling language can be perfectly linked to a target language of election. Namely, a well defined mapping bridges the gap between the source and ...


On Apriori-Based Rule Generation in SQL — A Case of the Deterministic Information System

2016 Joint 8th International Conference on Soft Computing and Intelligent Systems (SCIS) and 17th International Symposium on Advanced Intelligent Systems (ISIS), 2016

We have proposed a framework named Rough Non-deterministic Information Analysis (RNIA), and developed two software tools, RNIA in Prolog and getRNIA in Python. In order to handle big data sets, we newly employ SQL and PHP. This paper reports the current state of the software tool in SQL, which is the preliminary version for NIS-Apriori in SQL.


Migration of a relational databases to NoSQL: The way forward

2016 5th International Conference on Multimedia Computing and Systems (ICMCS), 2016

NoSQL databases are designed to solve data processing problems in volume. Growth data today pushes us to think about new concepts and approaches for converting data from a source database to a NoSQL database. This paper describes some approaches, methods of migration, database reverse engineering, and offers a migration approach from a relational database to a Document- oriented database NoSQL ...


Experience of a didactic tool as a support in the learning of relational algebra

2017 Twelfth Latin American Conference on Learning Technologies (LACLO), 2017

In this paper we present some preliminary results and conclusions about the experience of using a tool designed and developed as a support for the teaching of relational algebra. Through the tool you can design queries in relational algebra, check their operation and performance, step by step, visually. The experiences were applied to an introductory course of databases in the ...


Secured Data Storage and Retrieval Techniques for Effective Handling of Transport Data

2017 Second International Conference on Recent Trends and Challenges in Computational Models (ICRTCCM), 2017

In this paper, we propose new techniques for the secure storage of transport data consisting of vehicles, registrations and payments in the e-Services Web Portal of Transport Department. For this purpose, new secure and effective storage techniques are proposed in this paper in order to store the data efficiently and to retrieve them fast. The proposed techniques have been tested, ...


More Xplore Articles

Educational Resources on Structured Query Language

Back to Top

IEEE-USA E-Books

  • SQL-PL4OCL: An Automatic Code Generator from OCL to SQL Procedural Language

    Design models are widely spread as core artifacts in software engineering. Yet, a key problem is how to fulfill correctly these blueprint specifications when code components are developed. The best possible scenario occurs when a source modeling language can be perfectly linked to a target language of election. Namely, a well defined mapping bridges the gap between the source and the target language. Otherwise, manual encoding of the system design is cumbersome and error prone. In this setting, we introduce a SQL-PL code generator for OCL expressions that, in contrast to other proposals, is able to map OCL iterate and iterator expressions thanks to our use of stored procedures. More in detail, our source language is the Object Constraint Language (OCL), which nowadays is an ISO standard used to express constraints and queries in a textual notation on UML models. Our target language is the procedural language (PL) extension to the Structured Query Language (SQL). SQL is a special-purpose programming language designed for managing data in relational database management systems (RDBMS). The purpose of PL for SQL is to combine database language and procedural programming language. Although SQL is also an ISO standard, different RDBMS implement certain syntactic variations to the standard SQL notation. Thus, we had to adapt the implementation of our mapping to each of them. As implementation targets we selected MariaDB, PostgreSQL, and MS SQL Server. MariaDB and PostgreSQL were selected because they are open source and widely used by developers. MS SQL server was selected to be able to compare evaluation time from open source to commercial RDBMS. A variety of applications arises for a mapping from OCL to SQL expressions. Among others, there are three prominent types. These are i) evaluation of OCL expressions (analysis queries and metrics) on large model's instances, ii) identification of constraints during data modeling that have to be checked as integrity constraints on actual data; iii) automatic code generation from models. Indeed, our implementation was used as a key component of a toolkit that automatically generated ready-to-deploy web applications for secure data management from design models. Our component mapped and evaluated OCL constraints specified within authorization policies. Our code generator is defined recursively over the structure of OCL expressions and it is implemented in the SQL-PL4OCL tool that is publicly available at [1]. The seminal work of the mapping presented here can be found in [2], [3]. The key idea that enables the mapping from OCL iterator expressions to iterative stored procedures remains the same, but the work detailed in [4] introduces a novel mapping from OCL expressions to SQL-PL stored procedures. In the novel mapping we have taken design decisions which have facilitated the recursive definition of the code generator and simplified its definition. These decisions have also helped to significantly decrease the time required for the evaluation of the code generated. Regarding semantics, the new mapping is able to deal properly with the three-valued evaluation semantics of OCL. In addition, our original work and implementation was intended only for the procedural extension of MySQL, while our new definition eased the implementation of the mapping into other relational database management systems. In turn, we can now evaluate the resulting code using different RDBMS, which permits us to widen our discussion regarding efficiency in terms of evaluation-time of the code produced by SQL-PL4OCL tool.

  • On Apriori-Based Rule Generation in SQL — A Case of the Deterministic Information System

    We have proposed a framework named Rough Non-deterministic Information Analysis (RNIA), and developed two software tools, RNIA in Prolog and getRNIA in Python. In order to handle big data sets, we newly employ SQL and PHP. This paper reports the current state of the software tool in SQL, which is the preliminary version for NIS-Apriori in SQL.

  • Migration of a relational databases to NoSQL: The way forward

    NoSQL databases are designed to solve data processing problems in volume. Growth data today pushes us to think about new concepts and approaches for converting data from a source database to a NoSQL database. This paper describes some approaches, methods of migration, database reverse engineering, and offers a migration approach from a relational database to a Document- oriented database NoSQL (MongoDB). The approach based on the achievement of a data model, from which we proceed to the migration of schema and data mapping, while ensuring the integrity constraints between collections.

  • Experience of a didactic tool as a support in the learning of relational algebra

    In this paper we present some preliminary results and conclusions about the experience of using a tool designed and developed as a support for the teaching of relational algebra. Through the tool you can design queries in relational algebra, check their operation and performance, step by step, visually. The experiences were applied to an introductory course of databases in the Engineering in Software Development, of the Autonomous University of Baja California Sur (UABCS). Some theoretical references are presented that support the proposal and make a description of the application context. Finally, the results of the use and conclusions obtained are presented.

  • Secured Data Storage and Retrieval Techniques for Effective Handling of Transport Data

    In this paper, we propose new techniques for the secure storage of transport data consisting of vehicles, registrations and payments in the e-Services Web Portal of Transport Department. For this purpose, new secure and effective storage techniques are proposed in this paper in order to store the data efficiently and to retrieve them fast. The proposed techniques have been tested, using Tamil Nadu Transport Department Data of India and found that the proposed techniques are more efficient with respect to the consumption of time, memory and increase in security. The major advantages of the proposed System are that it increases the availability and security of data, provides fast access from anywhere at any time and helps to make online payments.

  • Comparison of SQL, NoSQL and NewSQL databases for internet of things

    The Internet of Things (IoT) in all its essentiality is a collection of sensors bridged together tightly. The present day development in the technology industry has thus elevated the emphasis of large amounts of data. IoT is expected to generate and collect an enormous amount of data from varied locations very quickly. The concerns for features like storage and performance factors are coercing the databases to outperform themselves. Traditional relational databases have time and again proved to be efficient. NoSQL and more recently NewSQL databases having gained an impetus are asserted to perform better than the classic SQL counterpart. This paper compares the performance of three databases each from the said technologies; SQL (MySQL), NoSQL (MongoDB) and NewSQL (VoltDB) respectively for sensor readings. The sensor data handled ranges in vast (MB to GB) size and tested against: single write, single read, single delete and multi write operations.

  • A review on elaborative approach for transmutation of XML entities for recommendation based system

    The concept of extensible markup language has evolved through time from SGML to the current XML, with more frequent use of web technologies. In any recommendation system, which is based on user defined rules, and gets its data from Rule ML where data is read and used by xml writer. The concept of enabling fast data processing can be served by SQL. At times it becomes necessary to directly save the data from xml file into SQL format, to enable database processing of data of xml directly. Although multiple ways existed for this task, but this paper is an effort to recognize the entities of xml file use it in tree structure and then use that grilled data for the purpose of data in SQL.

  • Lessons Learned in the Development of a Computable Phenotype for Response in Myeloproliferative Neoplasms

    Determining response status in patients with myeloproliferative neoplasms is a complex problem requiring the integration of both structured and unstructured data elements from disparate information systems. By applying multiple techniques, a collaborative team of informatics professionals and research personnel were able to determine which elements were amenable to automated extraction and which required expert adjudication. With this knowledge in mind, we were able to build a system that joins together programmatically- derived and manually-abstracted data elements to facilitate response assessment - an important end point in clinical and translational research in this disease area.

  • An interactive clinician-friendly query builder for decision support during ECG interpretation

    Decision support tools assist clinicians every day in healthcare by supporting decision making at the point of care. For example, decision support tools can help clinicians reduce misdiagnoses during the interpretation of the Electrocardiogram (ECG), by providing a reference to ECG background, causes, features, waves and segment data. As a potential solution to these problems an ECG interpretation clinical decision support tool (CDSS) was constructed. The prototype consisted of a web based user interface connected to a SQL database of thirty-eight identified ECG diagnostic interpretations. Benefits and risks of using a clinician friendly web based query-builder interface to perform SQL queries on the database against traditional ECG interpretation methods were identified. Ethical reasons for using the web based decision support system software to assist ECG interpretation are discussed. Potential benefits in using the ECG interpretation CDSS across computer /tablet/smart-phone devices to assist the clinician's diagnosis decision making process are identified.

  • Use of 'Basic SQL-The Online Beginner's Guide' Site to Give Hands on Experience of SQL to Students

    'Basic SQL-The Online Beginner's Guide' is a site developed for studying the Relational Database Management System (RDBMS). Structured Query Language (SQL) is a standard language for RDBMS which is used for storing, manipulating and retrieving the data. In the current study, we consider how the use of this site helped the students to improve their knowledge about SQL. Here two group post test method is considered to carry the experiment with learning objectives (LOs): To select the appropriate relation to write the query for the given problem statement (LO1), to create and insert the appropriate the sample data in the relation (LO2) and to write the query for given problem statement (LO3). The result shoed that experimental group performed better as compare to the control group in the post-test. From the feedback, it is found that 100% students liked this site for studying RDBMS.



Standards related to Structured Query Language

Back to Top

No standards are currently tagged "Structured Query Language"