Blog 5 - SQL

This assignment required students to read about databases with a particular topic in mind. Each group had a separate topic to explore. I will be reading and discussing about Structured Query Languages (SQL) using information found online.

First, a SQL is a means of communicating with a database and has been adopted by the American National Standards Institute (ANSI) as the standards. Various commands of SQL are present in the different database systems but the simple ones are capable of doing almost everything a user needs ("Sqlcourse - Intro" 2019).

Relational database management systems present data in tabular format. Searching, creating, populating, updating, and deleting are basic functions in SQL that most people will do with a table whether or not it is through using SQL.

Why is using SQL important? Well, most things can be represented as points of data and a large compilation of data into big data can be daunting to use and maintain. However,

SQL is able to perform functions across the entire database meaning that as long as the user has some idea of what they are looking for, they can use a combination of functions to narrow down the data until they find what they want ("Sqlcourse - Intro" 2019). This is why it is important to design a database properly. Proper management of a database using SQL prevents any hiccups in the future and provides better user experience.

After reading Nick Maloney’s post, I interpreted his idea of BIM using “massive amount of data in order to perform their intended functions” as manipulating the elements and their properties in the model and having Revit show the user what the model looks like on the front-end of the software.

It is even more important to companies who provide a service such as insurance or social media. These types of companies can have records of millions of people and they can have actuaries who can determine how much people should pay for insurance or marketers to personalize advertisements on social media.

While SQL may not be a necessary skill to have in the near future, being able to maneuver through data in a table has been a useful skill since the creation of spreadsheets.


Sources:
Maloney, Nick. 2019. "B5 - What Is SQL And Why Is It Important?". Ae-410-510-Ay18-19.Blogspot.Com. https://ae-410-510-ay18-19.blogspot.com/2019/02/b5-what-is-sql-and-why-is-it-important.html.

"Sqlcourse - Intro". 2019. Sqlcourse.Com. http://www.sqlcourse.com/intro.html.


Comments on colleagues’ posts:
Blas Andres Rodriguez Vieira
With the advent of big data being used in most companies, it is becoming more important to be able to manipulate data. When we were freshmen/sophomores, we were taught how to use MatLab and Excel but I feel like it will no longer enough in the coming years. Thankfully, the freshmen now are learning programing languages that I feel like it is incredibly useful when learning SQL.

Nana Lin Rasmussen
I think that the tabular method is very easy for beginners whereas more networks of data can be trickier to learn about. I didn’t feel like I was able to handle the database assignment in this class but I feel more confident now that I know how simple it can be.

Yicheng Li
It looks like you have experience with MySQL. What do you think of the usefulness of SQL in the job market today? I don’t have any experience with big data so if you think this is useful then I might be inclined to pick up some SQL.

B5 - SQL (What is is and why important?)

Talking about databases, SQL is the standard language for relational database management. SQL stands for Structured Query Language and it is the standard language used to communicate with a database according to ANSI (American National Standards Institute). The language is based on statements that are used to perform tasks, among which the most common is updating data, or retrieve data from the database. The most common databases that use SQL are: Oracle, Sybase, Microsoft SQL Server, Microsoft Access, among others. Among all these databases, it is common to see specific commands and proprietary extensions;  the standards of SQL commands such as “Select”, “Insert”, “Update”, “Delete”, “Create” and “Drop” can be used to accomplish almost anything that it is needed to do on big databases across any SQL platform. Allowing this language to also allow the program to communicate between each other.

               SQL is important because it is high on demand due to the advancements of technology which make Big Data common. Traditional spreadsheet can be used to manage small-medium sized sets of information; however, this tool is not useful when big data is being managed. SQL comes in to play an important role to be able to manage records of 1 million datapoints or more. This allows you to perform any data related activity with millions of rows of data at high speed and an efficient way. As a result, across all the fields SQL has come to be in high demand. Currently, companies across all the fields are searching for individuals who are skilled in SQL making this language the most required for job positions nowadays.

               SQL is an excellent and essential tool for programmers, however due to the  advancements in technology this language has been coming across other people making it important for everybody to not only understand it but also be able to use it. Almost any business has come digitized which means that data is stored in enormous databases and to be able to manage them you need SQL and as companies strive to accomplish more with their information, they will require more people to be skilled to access and analyze this big data.

Comments on others post

Alec Silverstone

I do understand your point on how we use databases everyday in our lives. Therefore, it is clear your point of how data is created during design and construction process. I think that the use a database is important to be able to utilize that data in an intelligent manner. The proper use of this data not only facilitates the work but also decrease the errors in communication between contractors, engineers and architects.

Weiyi Tang

Your example on the systems used for energy control is precise. Being an electrical engineer, I have seen how this controls work on the field and through the years the biggest goal for controls in building has been to decrease the energy consumption. Before the approach was to decrease the use of each element by separate. But since the boom of the big data analysis, buildings have come to use central databases to understand the behavior of the building and only use energy when and where is needed.

Jenny Fretta

I have been using object-oriented databases before and I agree with you. I believe that the data is connected in a more intuitive way and it allows people to understand better why the information is stored that way. I like your example of object-oriented database, it is really clear to understand how it will properly work.

Citation

• ·        “What Is Structured Query Language (SQL)? - Definition from Techopedia.” Techopedia.com, www.techopedia.com/definition/1245/structured-query-language-sql.
  
• ·        Heller, Martin. “What Is SQL? Structured Query Language Explained.” InfoWorld, InfoWorld, 28 Aug. 2017, www.infoworld.com/article/3219795/sql/what-is-sql-structured-query-language-explained.html.
  
• ·        SQLCourse. “What Is SQL?” SQLCourse - Lesson 1: What Is SQL?, 20 Aug. 2000, www.sqlcourse.com/intro.html.
  
• ·        Babu, Amarendra. “Structured Query Language - Importance of Learning SQL.” {Coding}Sight, 6 Nov. 2018, codingsight.com/structured-query-language-importance-of-learning-sql/.

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.