More Requirements for the Case Study

In the process of writing the application, suppose I get a new requirement to support both Oracle and SQL Server databases. Both of these systems are based on SQL (Structured Query Language), the common standard that makes it easier to use databases. Yet, even though this is a common standard at the general level, there are still differences in the details. I know that in general, when executing queries on these databases, I will use the following steps:

1.
Format the CONNECT command.

2.
Send the database the CONNECT command.

3.
Format the SELECT command.

4.
Send the database the SELECT command.

5.
Return the selected dataset.

The specific implementations of the databases differ, however, requiring slightly different formatting procedures.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.223.190.215