ADO.NET provides a distinct Connected and Disconnected layer for data access via the Web, allowing for the unpredictability of internet connections. It is optimized for SQL, being a Microsoft product, and has extensive XML support. In that respect it may act as a bridge between traditional RDBMS systems and XML, which is a material concern for Web-DBMS implementations (Barik & Ramesh, 2011). ADO.NET is feature-rich and has many uses, but the trade-off here is a relatively steep learning curve and complex customization.

Oracle’s Fusion Middleware is a much more sprawling collection of enterprise-level resources that provides a number of distinct applications and frameworks at the web, middle, and data tiers. At the core of the middle tier is the WebLogic server. It is Java-based and runs a number of open standard technologies. There are a number of additional components in the collection, but of particular relevance in relation to ADO.NET is the Service-Oriented Architecture (SOA) Suite. It acts as an incrementally-available bridge between heterogenous systems.

As complex and comprehensive as the Oracle suite is, of course there are trade-offs. Successfully implemented, it is an efficient solution that can incorporate multiple different systems and flow information effectively across the solution. However, developers and resources are relatively scant compared to Microsoft ADO.NET; beyond that, it is a much bigger capital and operational investment than ADO.NET.

These two may be in consideration where Web-DBMS data access is concerned. Neither is an actual programming language. Rather, they should be viewed as middle-tier solutions that enable data access in a Web environment. The scale to which these solutions will be deployed is a primary consideration for which to consider. ADO.NET is a more concise product that functions well within an existing Microsoft ecosystem, whereas Fusion Middleware is a much broader set of tools more suited to an enterprise environment. That isn’t to say Fusion Middleware cannot be suited to smaller environments.

References

Barik, P. K., & Ramesh, D. B. (2011). Design and development of virtual distributed database for web-based library resource sharing network for Orissa technical and management institutions. International Journal of Information Dissemination and Technology, 1(1), 51.

Connolly, T., & Begg, C. (2015).  Database Systems – Database Systems: A Practical Approach to Design, Implementation, and Management (6th ed.). London, UK: Pearson.

Oracle. (n.d.). Oracle Fusion Middleware. Retrieved from https://www.oracle.com/technetwork/middleware/fusion-middleware/overview/index.html