SQL stands for Structured Query Language. It is the language for
relational database management systems, or RDBMS. SQL is used for tasks
involving databases such as updating information, adding information, removing
information, and linking information among many other tasks. SQL has been
certified by the American National Standards Institute (ANSI) and the
International Organization for Standardization (ISO) and has been adopted as
the standard for database editing and organizational languages. Many different
software companies such as Oracle and Microsoft have their own version of SQL
in which to use for their own database needs. If a database is considered to be
where all of the data is stored, then SQL is what allows that data to be
interacted with. This is important because storing information in a table is
incredibly easy. It is just rote data input and organization. However, what
makes a database very useful is the ability to find, select, and filter that
data from the database which is what SQL allows a user to do.
The main challenge
present when using SQL is interoperability. An SQL developed for one database
system may not be fully compatible if the same SQL would then be used for a
different database system. This is mainly due to differences in programmer
syntax and programmer style but there are several other reasons why these
compatibility issues arise. Some of these reasons are the complexity and size
of the SQL standard means that most developers and programmers do not support
the entire standard, some guidelines are not specified in SQL standards
relating to important functions which leaves these functions open to individual
interpretation and implementation, and certain developers may be unwilling to
include backwards compatibility in their program language, among others.
**Edit**
Comment 1: http://ae-510-ay15-16.blogspot.com/2016/02/b5-sql-group-b-kai-waechter.html
Comment 2: http://ae-510-ay15-16.blogspot.com/2016/02/b5-group-b-dianna-vogel.html
**Edit**
Comment 1: http://ae-510-ay15-16.blogspot.com/2016/02/b5-sql-group-b-kai-waechter.html
Comment 2: http://ae-510-ay15-16.blogspot.com/2016/02/b5-group-b-dianna-vogel.html
Sources:
Hello Mark,
ReplyDeleteIn my research of SQL I also noticed that the biggest issue with SQL is interoperability. The fact that the same code cannot be used from one database to another is a substantial issue that exists, and one that limits the language as a whole. I think it also makes it difficult for new users to interact within a databases that they did not originally start programming for as one programmers code can be entirely different in style when compared to another.