Why sql is the preferred method of data retrieval in dbms

Assignment Help Database Management System
Reference no: EM131357849

Assignment: Database Design Discusion Post

Data Retrieval

Part 1:

Discuss why SQL is the preferred method of data retrieval in a database management system.

Part 2: Respond to two peer discusions

Peer 1 Bill

SQL, structure query language, was introduced to Database Management Systems in the late 1970s as Oracle. One of the reasons that SQL is preferred is because of its legacy and its most important aspect of the language is communicating with relational databases. In the earlier days, it was a race to improve databases management software as data requirements evolved. As systems in these days were more of a flat database, it was only time that made them to become more revolutionary as to require a need to navigate in a more multi-dimensional mean. SQL is able to support and manipulate databases that is comprised of large amounts of data.

Peer 2 Ted

SQL is the preferred method because when the DBM draft the SQL statement he/she can give step by step introduction as to which table or tables to look for, what attributes to retrieve from the table, and which rows on the table or table to look at as well. Plus the SQL keywords work across various platforms such as, MS Access, Oracle, MySQL Workbench, SQL Server, etc. By using SQL you cut down on the processing and the latency of your database, because you tell it exactly where to look instead of your software going through every row one at a time. This would be cumbersome if your database holds millions of records. Also, if you use a SQL query a lot you can save that query for future use so you don't have to keep creating it for certain users.

Reference no: EM131357849

Questions Cloud

How does this fda regulation protect consumers : 1. How does this FDA regulation protect consumers? 2. Why did the company voluntarily change its product name? 3. What effect did this regulation have on the company and on consumers?
Expected long run growth rate-what is the price of the stock : A share of common stock has just paida dividend of $2.50 (D0). If the expected long run growth rate for this stock is 4 percent per year, and if investors require a 12 percent rate of return, what is the price of the stock?
Grand challenges approach to developing countries : Compare the 21th-century gates Grand Challenges approach to developing countries health with that of the turn the 10th-century inventions of the Rockefeller/ carriage approach in the united states.
Evaluate economic problems and opportunity costs : In this Assignment, you will evaluate economic problems and opportunity costs to make informed economic decisions to effectively use scarce resources. You will also examine factors that affect production possibilities to determine the maximum poss..
Why sql is the preferred method of data retrieval in dbms : Discuss why SQL is the preferred method of data retrieval in a database management system. Also, if you use a SQL query a lot you can save that query for future use so you don't have to keep creating it for certain users.
What is company cost of preferred stock : Bosio Inc.'s perpetual preferred stock sells for $97.50 per share, and it pays an $8.50 annual dividend. If the company were to sell a new preferred issue, it would incur a flotation cost of 4.00% of the price paid by investors. What is the company's..
Cross-prce elasticity between good : Suppose that the cross-prce elasticity between good X and y is .25 and that the price of good y increases. Which of the following statement is true?
What is the component cost of debt : Castro Chemical Company sold a noncallable bond several years ago that now has 20 years to maturity. This bond has a 9.25% annual coupon, paid semiannually, sells at a price of $1,075, and has a par value of $1,000. If the firm's tax rate is 40%, wha..
Determine the least-squares regression equation : City government has collected the following data on annual sales tax collections and new car registrations: Determine the following: The least-squares regression equation

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd