Application of ISO Standards on SQL Based Programs
Topic: ISO/IEC 9075 standard: "Information technology - Database languages - SQL"
1. Identify and introduce an Australian or International Standard (with IT engineering applications).
Topic: ISO/IEC 9075 standard: "Information technology - Database languages - SQL"
(The report clearly identifies an AS or ISO and introduces the standard in relation to an engineering product or process)
2. Outline what Standards are and explain why they are in use.
(The report introduction outlines what standards are and thoroughly explains why they are in use.)
3. Define the attributes of the chosen Standard and its broad applications.
(The report defines all of the relevant attributes of the chosen standard AND in at least 3 examples shows how it is broadly applied in engineering initiatives.)
4. Describe how the Standard applies to a specific Engineering product, service or system (use an explicit example).
(The report presents a comprehensive, perceptive description of how a specific product, service or system is informed by the relevant standard.)
5. Presentation of a formally structured report, including: a logical flow of the material presented (introduction, outline, applications) clear and coherent writing; appropriate use of section-headers and/or paragraphing.
(The report is structured to present a logical flow of information; the writing is clear and coherent at all times; and section headers/paragraphs are effectively used to organize the document.)
6. At least 5 well-chosen academic references: demonstrating good background research; and appropriate in-text referencing AND adhere to the word limit (1000 words +/- 200).
(The report includes 5+ academic references that follow the Harvard-referencing style, and the in-text citations are made purposefully. AND Adheres to the word limit.)
Outline of the standard
ISO/IEC 9075-1:2016 standard depicts the computed structure utilized in different components of ISO/IEC 9075 for determining the structure of SQL Grammar and outcome after the consequence of handling proclamations in that language where SQL assignment is implemented. ISO/IEC 9075-1:2016 standard additionally states the terms and documentation utilized in different components of the ISO/IEC 9075 standard. ISO/IEC Joint Technical Committee (JTC) 1 for Information Technology created the standard ISO/IEC 9075 for SQL, used throughout the world. The present release, ISO/IEC 9075:2016, includes each of the ISO sections received by INCITS as American National Standards (Lee, 2016).
Various attributes of ISO standard
The various attributes of ISO/IEC 9075 standards are:
? SQL-86 (or SQL-87) standard is the ISO 9075:1987 standard of 1987
? SQL-89 standard is the ISO/IEC 9075:1989 standard of 1989
? SQL-92 standard is the ISO/IEC 9075:1992 standard of 1992
? SQL:1999 standard is the ISO/IEC 9075:1999 standard of 1999
? SQL:2003 standard is the ISO/IEC 9075:2003 standard of 2003
? SQL:2006 standard is the ISO/IEC 9075:2006 standard of 2006
? SQL:2008 standard is the ISO/IEC 9075:2008 standard of 2008
? SQL:2011 standard is the ISO/IEC 9075:2011 standard of 2011
? SQL:2016 standard is the ISO/IEC 9075:2016 standard of 2016
Application of standards
For fulfilling the demands of clients, all the chief users of RDBMS offers – various ways of data access that is the access to SQL assignment to their product. The executions envelop Core SQL, which includes a set of additional standardized features. Standard syntax or implementation of specific syntax are utilised while accessing standardized features. Quintessentially, SQL is the clamp which holds everything together, but it is generally found that office language involves a lot of detours. The executions spread Core SQL, a lot of additional standardized highlights and many, non-standardized highlights. The entrance to standardized highlights may utilize the standard linguistic structure or an explicit usage grammar. SQL is the clasp holding everything together, except typically, there is a lot of alternate routes around the authority language (Larson, 2015). In case an application is found utilizing SQL commands which are specially defined in standard SQL, it would become possible for exchanging the underlying RDBMS with a completely different one, instead of modifying the source code of the ongoing application. In reality, this is quite a tough job, since physical implementations are found offering several additional features which the software engineers love to utilise.
A subsequent perspective can be the preservation of expertise. On the off chance where an engineer understudy is learning SQL assignment, he is in a situation of creating applications which depend on a self-assertive database framework. The circumstance is practically similar to some other prevalent programming language. On the off chance, the one learning Java or C-Sharp can create utilizations of any sort running on a variety of equipment frameworks and even unique equipment models. Database frameworks comprise of numerous segments. The entrance to the information is a significant component; however, by all account, not the only segment. Different parts include: throughput enhancement, physical plan, reinforcement, conveyed databases, replication, 24*7 accessibility. Standard SQL assignment is centred for the most part on information and disregards the operation of DBA undertakings. Indeed, even the CREATE INDEX statement, as a generally utilized improvement procedure isn't a piece of the standard. In any case, the more significant part of the DBA's regular work is profoundly specific to each system and must be done alternately when changing to an alternate RDBMS. Mostly application designers are profited by SQL.
The relational tables in the database consist of various rows and tables, which consist of specified data. This data can be updated, added, created, inserted, and selected with the help of appropriate SQL statements. Various engineering organisations have been authorized with the access of open source and proprietary form of a relational database, which is developed with the assistance of the SQL framework. Significant applications of these are Microsoft SQL Server, SAP HANA, and MySQL. Most of these applications include the extensions of proprietary form for procedural functions. The SQL commands like DML and DDL are used for data security purposes and transactions control needs by the engineering organisations (Birka, 2015). This enhances the efficiency of transaction processing and ensures proper checking of the sales. On the other hand, the security measures provide appropriate authorization of the data by creating appropriate roles in the database.
Application of standard on engineering product
Some remarkable highlights of SQL incorporate the capacity of processing information sets as an alternative of individual units, the programmed route to information, and the utilization of verbalizations that are mind-boggling as well as amazing. Utilized for an assortment of undertakings, for example, questioning knowledge, maintaining database access and its items, ensuring database consistency, refreshing lines in a table, and making, supplanting, adjusting and dropping articles, SQL gives clients a chance to work with information at the legitimate level. Moreover, the SQL upholds the commands that portray the meaning of the relational schemas. With the help of this, the various relations in the database can be deleted and modified. The language provides vivid information about the topple calculus and relational algebra (Jackson, 2016). The embedded SQL are inclined towards the development of the programming languages and provides data, which defines the views. One can also enable integrity checking with substantial assistance from the SQL and operate the various database transactions. These commands offer authorized rights to illustrations and relational database. The open-source versions of this system are the most familiar ones among the engineering products.
The SQL-on-Hadoop query engines are the most advanced version of SQL that assists and organisation with big data architectures. These architectures are built within the framework of Hadoop systems (Petkovic, 2018). This system provides a simpler version of languages and operational programs, which increase the effectiveness of the architecture. The Spark SQL software, which is implemented in this system, supports high-level SQL-based programs and is an effective advanced technology. However, this tool does not help all the functions for the relational operations of the database. Due to its efficient contributions towards the development of data analysis, SQL assignment has been a significant component of the leading engineering facilities.
Birka, A., Hanson, E.N., Huang, W., Nowakiewicz, M. and Papadimos, V., 2015. Real-time analytical processing with SQL server. Proceedings of the VLDB Endowment, 8(12), pp.1740-1751.
Jackson, J., 2016. SQL: Learn Basics of Queries and Implement Easily (SQL programming, SQL 2016, SQL database programming, SQL for beginners, SQL beginners guide, SQL... SQL workbook, SQL guide, MSSQL)(Volume 1). CreateSpace Independent Publishing Platform.
Larson, B., 2016. Microsoft SQL Server 2016 Reporting Services. McGraw-Hill Education.
Lee, K., König, A.C., Narasayya, V., Ding, B., Chaudhuri, S., Ellwein, B., Eksarevskiy, A., Kohli, M., Wyant, J., Prakash, P. and Nehme, R., 2016, June. Operator and query progress estimation in Microsoft SQL server live query statistics. In Proceedings of the 2016 International Conference on Management of Data (pp. 1753-1764). ACM.
Petkovic, D., 2018. 3. Auflage-Microsoft SQL Server 2005: A Beginner's Guide.
Get Top Quality Assignment Help and Score high grades. Download the Total Assignment help App from Google play store or Subscribe to totalassignmenthelp and receive the latest updates from the Academic fraternity in real time.