SQL or Structured Query Language originated in IBM in the 1970s. IBM had created a new database software called System R, and they designed SQL (originally “SEQUEL”) to manage the information stored in System R. [1] Simply put, SQL is a programming language that is used to access and manipulate the data stored in databases. SQL has the power to populate,modify or delete information in tables, as well as modify the structure of the database itself. [2,3] There are five main elements within the SQL programming language: clauses, expressions, predicates, queries and statements. Clauses are a part of the statements and queries, which control transactions or retrieve data respectively. Predicates specify conditions, and expressions will produce scalar values or tables. Varying combinations of these commands are necessary for use in database management systems. [1] The American National Standard Institute (ANSI) and the International Standards Organization (ISO) have both deemed SQL as the standard language in relational database communication. Many companies will choose to purchase software with SQL already built into it, such as MySQL a software produced by Oracle. MySQL is often used in conjunction with other web programming languages like Python, and can therefore be applied in a myriad of ways. [2]
SQL is used to manage information stored in a variety of databases, which effectively can be found almost everywhere these days. For this reason among many learning to use and understand SQL is very important. Using SQL allows a data scientist to first understand what exactly they’re looking at. Knowing what the data is about, how its structured etc. is imperative for proper data manipulation and to actually get helpful information out of that data. Additionally, SQL is necessary for the management and manipulation of large datasets. Companies like Amazon are collecting, storing and analyzing millions of data points every day. Without SQL a task as large as that would be arguably impossible. Big companies collect data for ad placements, market research, stock information and a variety of other things. The sheer amount of data collected is huge, and without proper analysis the information that comes from that is useless. [4]
Works Cited
[1] “Web Hosting Services, VPS Servers and Domain Names by NTC Hosting.” NTC Hosting, www.ntchosting.com/encyclopedia/databases/structured-query-language/.
[2] Brooks, Chad. “What Is SQL?” Business News Daily, Businessnewsdaily.com, 22 Jan. 2014, www.businessnewsdaily.com/5804-what-is-sql.html.
[4] Onyango, Francis. “5 Reasons Every Aspiring Data Scientist Must Learn SQL.” Medium, Analytics Vidhya, 1 July 2019, medium.com/analytics-vidhya/5-reasons-every-aspiring-data-scientist-must-learn-sql-2bab007a8d76.
Comments:
Varsha:https://ae-410-510-ay19-20.blogspot.com/2020/02/b5-databases-in-construction-firms.html
You did a good job highlighting not only the importance of databases in the construction industry, but also for AEC productivity in general. Information is power is this industry, and I agree that although hard copy record-keeping is still popular amongst contractors efficiency could be greatly improved with a more digital approach.
You did a good job highlighting not only the importance of databases in the construction industry, but also for AEC productivity in general. Information is power is this industry, and I agree that although hard copy record-keeping is still popular amongst contractors efficiency could be greatly improved with a more digital approach.
Madeleine: https://ae-410-510-ay19-20.blogspot.com/2020/02/b5-walker-elders-databases-in-design.html
I never associated Augmented Reality applications with a need for databases, but after reading your post that actually makes so much sense! There's a lot of data to be interpreted and stored in such an application and it is imperative that there is a database to help organize the process.Though I agree that collaboration tools in the construction industry would be helpful, I do think that getting people to want to learn and use them could be tricky. Great post!
I never associated Augmented Reality applications with a need for databases, but after reading your post that actually makes so much sense! There's a lot of data to be interpreted and stored in such an application and it is imperative that there is a database to help organize the process.Though I agree that collaboration tools in the construction industry would be helpful, I do think that getting people to want to learn and use them could be tricky. Great post!
Manon: https://ae-410-510-ay19-20.blogspot.com/2020/02/b-5-relational-database-theory.html
This post was very informative! I personally was tasked with writing specifically about SQL, and found it very helpful to read your post about the specifics regarding the actual database contents. I didn't realize there were so many different qualifications associated with one piece of data within a table and your post did a good job explaining that.
This post was very informative! I personally was tasked with writing specifically about SQL, and found it very helpful to read your post about the specifics regarding the actual database contents. I didn't realize there were so many different qualifications associated with one piece of data within a table and your post did a good job explaining that.
3 comments:
Isabel,
Understanding SQL and implementing well organized and easy to used SQLs is essential to the future of databases. More and more data is being obtained and processed to get more accurate models and predictions but in order for all that information to be useful, it needs to be understood. I think you outline that aspect very well.
Isabel,
I am not a coder myself, so I found this brief synopsis of what SQL is and where it came from to be very useful. While I don’t understand the ins and outs of coding, I do recognize the importance of being able to store, retrieve, and analyze data efficiently and securely. Thanks for the info!
Isabel, I am glad to read something focusing on SQL. I always have interest in learning new programming languages, and I believe SQL is a very useful language to learn. Almost, if not all corporations seek engineers who are proficient in SQL due to the many reasons you have listed, so with the information shared in your description I am excited to look into learning it for myself!
Post a Comment