Database paper Essay Example | Topics and Well Written Essays - 1750 words

Database paper - Essay Example Prevention of unauthorized access and efficient solutions for failure recovery are also provided by a database server. For enterprise grid computing Oracle Database is the first database designed to manage information and applications in the most flexible and cost effective way. Huge pools of industry-standard, modular storage and servers are created by enterprise grid computing. Each and every new system can be quickly provisioned from the pool of components with the help of this architecture. When required capacity can be easily added or reallocated from the resource pools so there is no need for peak workloads. The database consists of two structures: logical and physical. The logical structures including table spaces, segments, and extents, dictate how the physical space of a database is used. The physical structure is determined by the operating system files that constitute the database. The physical storage of data can be controlled without affecting the access to logical storage structures due to the reason that the physical and logical structures are separate (Michele, 2005). The figure represents the components of Oracle application server 10 g. In computing, the Oracle Application Server 10g (the "g" stands for grid), consists of an integrated, standards-based software platform. Database recovery is made possible with the help of transaction management. Backup and logging are the main features that help to recover the database. Oracle makes use of techniques that are typically more superior for managing recovery than other database systems. The discretionary control over access to objects based on privileges helps to achieve authorization and security. Referential integrity between tables helps to achieve consistency and integrity. General Review of Oracle A database system helps user to transform the data into information and also gives the user access to their data. Oracle is one example of such a database system. Creating, updating and extracting of information are made possible with the help of a database system. A database system has some key advantages like speed, accuracy and accessibility. Each item is stored in its own field in Oracle. The field's name defines its contents. A field has little or no importance until it is used within the context of other fields. In Oracle a record is a complete unit of data made of a person, thing or event. A collection of fields forms a record. Each and every field in a record has a different name. The requirement analysis of a business must identify all the fields in an Oracle database design project. There are a number of characteristics of Oracle. There is a complex relationship between objects and queries are based on these complex relationships between objects. Oracle allows complicated transaction based updates and provides update tools that make use of them. It is purely centralized. Oracle can be used to handle a very wide range of problems as it is a general purpose tool. It helps to perform complex analysis on data where the relationship between elements of data is non-trivial. Making complex queries about the relations between objects is one of the major strengths of Oracle. Linking the data in multiple tables is made very easy with its help. It enables to define relationships between the tables when data is stored in two or more tables. Data is represented in tables with values in columns within rows (Craig, 2008). Oracle generally