How does query processing in relational systems differ from the processing of low-level query languages for network and hierarchical systems?
What will be an ideal response?
In first generation network and hierarchical database systems, the low-level procedural query
language is generally embedded in a high-level programming language such as COBOL, and it
is the programmer’s responsibility to select the most appropriate execution strategy. In
contrast, with declarative languages such as SQL, the user specifies what data is required
rather than how it is to be retrieved. This relieves the user of the responsibility of determining,
or even knowing, what constitutes a good execution strategy and makes the language more
universally usable
You might also like to view...
The ________ is a PowerPoint tool that lists information in a presentation that you might want to remove before making the presentation public
Fill in the blank(s) with correct word
When using the BPA to generate a report and problems are found, analysis of each role yields a report that shows four levels of severity.
Answer the following statement true (T) or false (F)