Relational Database Management System Essay

The study of computer based Information Systems (IS) is not just limited to traditional computers and servers, but also includes such devices as:

i) Disk : file server, virtual disk server, feature on interest server and so on

Which database management system platform should I use? This is a very common question that developers ask themselves when they work on a project that requires storing and querying data. There are 4 well-known platforms that people may consider; they are: Oracle, Microsoft SQL, Teradata and DB2. This essay will compare and contrast the differences and similarities between these fours platforms.

atabase is a collection of data which describes the activities of one or more organizations in a well-defined structure and the structure of a database is specific and it has a purpose. Database Management System (DBMS) is used to control or organize the data in a database. Database Management System (DBMS) is also used for maintaining large collections of data. Distributed database can be defined as a collection of various databases which can be stored at different computer network locations. In this paper we discuss about Distributed Databases, their advantages and disadvantages.

The flexibility of XML has made it the standard for the formatting and sharing of data via the web. XML data is easily transferable across machines and applications and is not constrained by the operating system of the host machine. This ease of translation enables XML to be transformed into non-XML formats for use with databases and their associated applications.

Why is it so important to have security for an organizations database? One reason will be to secure the organizations personal and confidentiality data information. Oracle has a database security software that enables a regulatory compliance for both oracle and non-oracle databases. Oracle has a powerful and a preventative detective security controls that will include database

Integration of Services: Every client is given the opportunity to access corporate information via the desktop interface eliminating the necessity to log into a terminal mode or another processor. Desktop tools like spreadsheet, power point presentations etc can be used to deal with corporate data with the help of database and application servers resident on the network to produce meaningful information.

My work at Oracle has given me practical insights into the world of storage, the industrial standards, the methods and practices and made me realize the importance of the role that storage technology will play in the future. This is the backbone of new

The company built the first commercial relational database system, and marketed the first products employing SQL (structured query language), now the industry standard (Table 1). Oracle also saw the value of low-cost, client/server systems instead of mainframes, pioneered portable software that today runs on practically all hardware in most computers. In recent years, the company has supported parallel software as the breakthrough that will drive very large database applications. Table 1 illustrates some of the major milestones for the company preceding and during the time of this case.The company 's technology innovations have helped drive the computer industry to where it is today, and has enabled computer users to be more productive and more competitive with systems that cost less but do more. Oracle radically increased it 's sales every year from 1980 to 1989 (Exhibit 1). This focus on software innovation and expansion explains why Oracle 's information management software has been such a leader guiding the world into the Information Age.Table 1. Major milestones for the Oracle Corporation preceding and during the time of this case.

Relational database contains data records that do not have a preset of relationships, permitting the user to define his or her relationship when accessing the data. Since users have much control over the data being accessed, relational databases can perform a variety of tasks. Such as defining the database; querying the database; adding, editing, and deleting data from the database; modifying the structure of the database; securing data from public access; communicating within the network; and exporting and importing data (Murthy, 2008).

The database used should be open and industry standard to allow easy integration with other applications and easy movement of data in the future. The database

Databases allow us to easily store and retrieve data in a purely digital format. The strength of this is that large amounts of data can be stored and retrieved with minimal effort on the part of the user. Opposed to manually flipping through files, one can quickly pull up the requested data through a computer program. Many systems that were conventionally paper and file based have been converted to a digital format which are now stored in one or more databases.

Oracle designs, develops, and supports computer-software products. This software is used for database management and network products, application development productivity tools, and end user applications. The company’s principal product, the oracle relational database-management system, runs on supercomputers, mainframes, microcomputers, and personal computers. The company also offers consulting, support, and system integration services for its customers. Oracle Corporation provides the software that powers the Internet.

The Oracle Financials Cloud can be used by both small and big enterprises. It can be used anywhere, on any device, and at any time but it is also secure and reliable. It provides a comprehensive financial solution such as General Ledger, Assets, Payables, Receivables, Cash Management, Collections, Employee Expenses, Multi-Currency/Multi-GAAP, Invoice Imaging, Consolidation, Intercompany Processing, and Reconciliation that can automatically analyze the transaction processes.

By 1995, a new variation of the traditional two-tier client-server model appeared to solve these problems called the three-tier client-server architecture. This new architecture proposed three layers, each potentially running on a different platform: