Blog 5- SQL - What is it and why important

SQL is an abbreviation of Structured Query Language. The main function of the SQL language is to establish contacts and communicate with various databases. According to ANSI (American National Standards Institute), SQL is used as the standard language for relational database management systems. SQL Server is a relational database management system (DBMS) developed and promoted by Microsoft. SQL Server is a relational database management system (DBMS) developed and promoted by Microsoft. It was originally developed by Microsoft, Sybase and Ashton-Tate. And in 1988 launched the first OS/2 version. Microsoft SQL Server has been updated in recent years. In 1996, Microsoft introduced SQL Server 6.5; in 1998, SQL Server 7.0 and users met; SQL Server 2000 was introduced by Microsoft in 2000, and the latest version is released in 2017. SQL SERVER 2017.

The characteristics of SQL are:

1. The real client/server architecture.

2. Graphical user interface makes system management and database management more intuitive and simple.

3. A wealth of programming interface tools provide users with more choices for programming.

4. Support for Web technologies makes it easy for users to publish data from a database to a Web page.

5. Supports XML (Extensive Markup Language), supports OLE DB and multiple queries, and supports distributed partitioned views.

The advantages of SQL mainly include:

1, easy to use

MySQL is a high-performance, relatively simple database system that is less complex than the setup and management of some larger systems. MySQL databases are favored by Web developers for their ease of use and productivity capabilities.

2, reliability and safety

MySQL's InnoDB transactional storage engine follows the ACID model with improved data protection capabilities, including point-in-time recovery and auto-commit. InnoDB provides additional data integrity by supporting foreign key constraints, preventing inconsistencies between tables. MySQL is fully networked and its database is accessible from anywhere on the Internet, so you can share the database with anyone, anywhere. And MySQL has access control to control who can't see your data.

3, opening

MySQL can be used under an open source license, allowing free use and modification of source code. MySQL is fully networked and its database is accessible from anywhere on the Internet, so you can share the database with anyone, anywhere. And MySQL has access control to control who can't see your data.

Why do we have to design a database? Because when the database is more complicated (such as large amount of data, many tables, and complex business relationships), we can save data storage space by using SQL, which can ensure the integrity of the data and facilitate the opening of the database application system. However, if the SQL design is not appropriate, it will lead to data redundancy, waste of storage space and abnormalities in data update and insertion. SQL is like the memory system of the human brain. Without SQL, there is no memory system. Computers will not develop so quickly. The application of SQL has penetrated into every aspect of life and work. The development of SQL reflects the level of information development in a country, and many of the development of computer software is based on SQL.

Reference:

“Amazon Aurora -Relational Database Built for the Cloud- AW”, Juil 26,2018, https://aws.amazon.com/rds/mysql/what-is-mysql/

Tim R. Ford,“How NoSQL, Relational Databases Do (and Don't) Help Companies Meet GDPR Requirements”, Apr 27, 2018,

https://www.itprotoday.com/no-sql/how-nosql-relational-databases-do-and-dont-help-companies-meet-gdpr-requirements

Chad Brooks,“What is SQL?”, Business News Daily Senior Writer, Jan 21, 2014, https://www.businessnewsdaily.com/5804-what-is-sql.html

Comment：

Tyler Madden

   I agree with the articles of Ozorhon, Karatas and Demerkesen you quoted, in a building database, a cost-based project management service can reduce the time and money spent on software, but the lack of customization that attain With the in House services. I have to admit that databases are important in today's society. Database technology is an important technical tool for scientific research and decision management.

Alec Silverstone 

    As you said, databases are very popular and important in our lives. In the information society, fully and effectively managing and utilizing various types of information resources is a prerequisite for scientific research and decision management. Database technology is the core part of various information systems such as management information systems, office automation systems, and decision support systems. In a construction company, implementing a database system to manage project data is a good way to increase productivity.

Weiyi Tang

   I really like your example of database application, analyzing the natural light going through a glass curtain wall. This is a clear introduction to the role of the database in real life. The database brings convenience to the inquiry, creation, modification and maintenance of the daily information processing.