« previous next »

Author Question: Explain the relationships among native DBMS libraries, ODBC, OLE DB, ADO, and ADO.NET and why each ... (Read 63 times)

Pineappleeh

  • Hero Member
  • *****
  • Posts: 585
on: Jul 7, 2018
Explain the relationships among native DBMS libraries, ODBC, OLE DB, ADO, and ADO.NET and why each led to the development of the next.
 
  What will be an ideal response?

Question 2

Which of the following statements about Subtype objects is not true?
 
  A) Subtypes can be Inclusive (an object may be more than one subtype).
  B) Subtypes can be Exclusive (an object may only be one of the subtypes).
  C) Subtypes can be Nested.
  D) All relations between the parent and subtype are 1:N.


af

  • Sr. Member
  • ****
  • Posts: 356
Reply #1 on: Jul 7, 2018
Answer to Question 1

All of these provide means of data access. Native DBMS libraries are the least abstract and are DBMS-specific access methods. Due to the large numbers of data sources that developers have to deal with, learning that many DBMS libraries was cumbersome. ODBC developed as a more abstract means of data access that shielded developers from having to learn multiple native DBMS libraries. One shortcoming of ODBC, however, was that it can only access data from sources that have a table-like structure. Therefore, OLE DB was developed as a means of accessing data from a much broader range of data source types. OLE DB is an object-oriented interface that is suitable for use by many object-oriented languages. Many developers, however, use languages such as Visual Basic and scripting languages that cannot access OLE DB. ADO was therefore developed to further abstract OLE DB and provide access to OLE DB functionality to programming languages that cannot directly access OLE DB. ADO has been followed by ADO.NET, which is part of Microsoft's .NET initiative. It extends the functionality of ADO.

Answer to Question 2

D


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

Automated pill dispensing systems have alarms to alert patients when the correct dosing time has arrived. Most systems work with many varieties of medications, so patients who are taking a variety of drugs can still be in control of their dose regimen.

Did you know?

Ether was used widely for surgeries but became less popular because of its flammability and its tendency to cause vomiting. In England, it was quickly replaced by chloroform, but this agent caused many deaths and lost popularity.

Did you know?

There are 60,000 miles of blood vessels in every adult human.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

Synapomorphies reveal the relationships among tetrapods Synapomorphies reveal the relationships among tetrapods
Phylogenies showing the relationships of some Old World primates Phylogenies showing the relationships of some Old World primates
Relationships in Dyads and Triads Relationships in Dyads and Triads
Human Relations: The Art and Science of Building Effective Relationships Human Relations: The Art and Science of Building Effective Relationships
Long-term relationships, especially those who are married, having a child Long-term relationships, especially those who are married, having a child
Construction of genomic libraries Construction of genomic libraries
Video: Muscle cell structures - actin, myosin and titin filaments

For a complete list of videos, visit our video library