UNIT 7 RESEARCH ASSIGNMENTDIFFERENCES BETWEEN PROCEDURAL
UNIT 7 RESEARCH ASSIGNMENT
DIFFERENCES BETWEEN PROCEDURAL AND DECLARITIVE LANGUAGES
1. What are the advantages of a declarative language as opposed to a procedural language? The programs are very concise, which makes it easy even for programmers to obtain solutions. An analyst can execute a query to get the desired information. An analyst can write acceptable web pages with simple HTML and CSS commands. Another advantage of the declarative programming model is that repetitive required code that indicates how to solve things is provided in the computer system behind the scenes. This code can be made highly efficient and can incorporate the best ideas from computing. The declarative language can take advantage of parallel execution in queries, and bulk INSERTs, UPDATEs, and DELETEs. 2. What advantages might a procedural language have over a declarative language? Procedural language is used for developing simple applications. The languages that use the procedural programming are Pascal and C languages. Some of the benefits of the procedural programming are: easy to read program code, easily maintainable program code as various procedures can be debugged in isolation, code is more flexible as you can change a specific procedure that gets implemented across the program.
3. Why do you think cross joins are allowed as a legitimate join? What uses can you see for joins? When you include multiple data sources in a query, you use joins to limit the records that you want to see, based on how the data sources are related to each other. You also use joins to combine records from both data sources, so that each pair of records from the sources becomes one record in the query results. I think that a cross-join would be optimized in the library, so that less data was sent over the network and then merged, so that data didn 't need to be combined.
Works Cited
(n.d.). Retrieved from
DIFFERENCES BETWEEN PROCEDURAL AND DECLARITIVE LANGUAGES
1. What are the advantages of a declarative language as opposed to a procedural language? The programs are very concise, which makes it easy even for programmers to obtain solutions. An analyst can execute a query to get the desired information. An analyst can write acceptable web pages with simple HTML and CSS commands. Another advantage of the declarative programming model is that repetitive required code that indicates how to solve things is provided in the computer system behind the scenes. This code can be made highly efficient and can incorporate the best ideas from computing. The declarative language can take advantage of parallel execution in queries, and bulk INSERTs, UPDATEs, and DELETEs. 2. What advantages might a procedural language have over a declarative language? Procedural language is used for developing simple applications. The languages that use the procedural programming are Pascal and C languages. Some of the benefits of the procedural programming are: easy to read program code, easily maintainable program code as various procedures can be debugged in isolation, code is more flexible as you can change a specific procedure that gets implemented across the program.
3. Why do you think cross joins are allowed as a legitimate join? What uses can you see for joins? When you include multiple data sources in a query, you use joins to limit the records that you want to see, based on how the data sources are related to each other. You also use joins to combine records from both data sources, so that each pair of records from the sources becomes one record in the query results. I think that a cross-join would be optimized in the library, so that less data was sent over the network and then merged, so that data didn 't need to be combined.
Works Cited
(n.d.). Retrieved from
Cited: (n.d.). Retrieved from http://www.cs.cornell.edu/info/projects/nuprl/cs611/fall94notes/cn2/subsection3_1_2.html (n.d.). Retrieved from http://www.databasejournal.com/sqletc/article.php/1408491/Beginning-SQL-Programming-Pt-2.htm