e-Activity Use the Oracle Database Administrator\'s Guide (or other resources wh

Question

e-Activity

Use the Oracle Database Administrator's Guide (or other resources which you can find on the Internet) to research a concept, principle, or architecture associated with Oracle%u2019s distributed database architecture. Prepare to discuss.

Use the Internet to locate information on MySQL Cluster, and MySQL or Microsoft SQL Server programming APIs. Prepare to discuss.

From the first e-Activity, describe one concept, principle, or architecture associated with Oracle%u2019s distributed database architecture.

From the second e-Activity, summarize one feature, component, or benefit of MySQL Cluster, and how you could apply it to solve a business problem.

Explanation / Answer

1) Oracle is a distributed archutecture. A distributed database system allows applications to access data from local and remote databases. In a homogenous distributed database system, each database is an Oracle Database. In a heterogeneous distributed database system, at least one of the databases is not an Oracle Database. Distributed databases use a client/server architecture to process information requests.

A homogenous distributed database system is a network of two or more Oracle Databases that reside on one or more machines. An application can simultaneously access or modify the data in several databases in a single distributed environment. .

For a client application, the location and platform of the databases are transparent. You can also create synonyms for remote objects in the distributed system so that users can access them with the same syntax as local objects.

An Oracle Database distributed database system can incorporate Oracle Databases of different versions. All supported releases of Oracle Database can participate in a distributed database system. Nevertheless, the applications that work with the distributed database must understand the functionality that is available at each node in the system. A distributed database application cannot expect an Oracle7 database to understand the SQL extensions that are only available with Oracle Database.

In a heterogeneous distributed database system, at least one of the databases is a non-Oracle Database system. To the application, the heterogeneous distributed database system appears as a single, local, Oracle Database. The local Oracle Database server hides the distribution and heterogeneity of the data.

The Oracle Database server accesses the non-Oracle Database system using Oracle Heterogeneous Services in conjunction with an agent. If you access the non-Oracle Database data store using an Oracle Transparent Gateway, then the agent is a system-specific application. For example, if you include a Sybase database in an Oracle Database distributed system, then you need to obtain a Sybase-specific transparent gateway so that the Oracle Database in the system can communicate with it.

A database server is the Oracle software managing a database, and a client is an application that requests information from a server. Each computer in a network is a node that can host one or more databases. Each node in a distributed database system can act as a client, a server, or both, depending on the situation.

2)
MySQL Cluster enables users to meet the database challenges of next generation web, cloud, and communications services with uncompromising scalability, uptime and agility.

it provides the following benifits:

- Auto-sharding for Write-scalability

- 99 percent avilability

- SQL & NoSQL APIs

- Real-time Performance

- Multi-site Clusters with Geographical Replication

3) asp.net is one of the web oriented programming language where C# is used. It can connects to oracle APIs

In addition to basic Oracle client connectivity software, .NET applications require the use of what is known as a managed data provider(where "managed" refers to code managed by the .NET framework). The data provider is the layer between the .NET application code and the Oracle client connectivity software. In almost every case, the best performance is achieved by using a provider optimized for a specific database platform instead of the generic .NET OLE DB data provider.

Oracle, Microsoft, and third-party vendors all offer .NET data providers optimized for Oracle. Oracle and Microsoft make their Oracle data providers available for free. (Microsoft's provider for the .NET Framework 1.1 is included in the framework, but it still requires Oracle client software installation.) In this article, we will use of the Oracle Data Provider for .NET (ODP.NET), which is included with the Oracle Database or as a separate download.

ODP.NET provides standard ADO.NET data access, while exposing Oracle database-specific features, such as XML DB, data access performance optimizations, and Real Application Clusters connection pooling.

4) sql is better

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.