This website uses cookies to ensure you have the best experience. Learn more

Oracle Database Essay

639 words - 3 pages

Discoverer Plus Database
The Air Force is changing in unique way to make the critical mission more obtainable to logistics technicians. The Air Force has evolved into using more web based systems to process transaction, track assets, and obtain pertinent information. Users have become accustomed to working with different types of bases to get the job done. The one database used more by logistics personnel is the Oracle Discoverer Plus database. In this paper will discuss what is Discoverer Plus, we will breakdown some of its function areas like End User layer (EUL), Business Area, and Folders. We will discuss some feature of Discoverer Plus database, and last, we will provide the dated problems of Discoverer’s Plus database.
Discoverer Plus is one of five parts of the Air Force Supply Central Database (AFSCD). According to AFM 23-110 “Discoverer Plus is an oracle database that provides supply technician and analyst with a user ...view middle of the document...


EUL is a part of Discoverer Plus, it is a layer of information used by Oracle Discoverer to hide the complexities and details of the underlying database. EUL provides a user-friendly view into the data, making it easier and faster to create queries because it organizes the data to reflect particular business areas. With the use of EUL the same data can be used for more than one situation.
Another important part of Discoverer Plus in the Business area, this area is a logical grouping of database tables or views that apply to your data condition. Although some users required data may be the same, the exact combination of tables and views for each element or section is usually unique. With the uses of the administrator function an administrator can tailor the grouping of data to provide you with the proper access to the specific data needed for analysis, decision support, and presentation of results. Business areas are further broken down into eight different areas Inventory, Item Detail, Management, Organization, SRD/RID/I&SG, Support, System, and Transaction History.
The EUL also has Folders; Folders are a collection of related items also called data elements within the business area. Folders are similar to records used by Standard Base Supply System, a legacy system still used by supply personnel still today. Folder are created and defined in the EUL using the Administrator function.
Discoverer Plus is a great oracle database program. But, like everything it could use a couple upgrades. The data is a day old, so all the data you pull is not current or up-to-date. Analysts are working on having current data by having transaction updated seconds after transaction are made. Also, connectivity is another dilemma with this program. Application are slow signing on and processing transaction. Without help from network personnel to make sure enough bandwidth is open to accommodate many users of this program, connectivity will continue to be slow and hinder the mission.
References
USAF SUPPLY MANUAL. (January 2009). AFMAN 23-110CD Retrieved from
http://www.e-publishing.af.mil/shared/media/epubs/afman23-110.pdf

Other Papers Like Oracle Database

Database Management Systems Essay

571 words - 3 pages DBMS that we utilize in my workplace is Oracle 10g. Oracle is a type of database management system (DBMS) that stores data in the form of related tables. The primary purpose of our RDBMS is to catalog mapping information. The application that runs on our workstations accesses the Oracle database through PERL scripts, SQL statements, and SQL PLUS queries. A query is a request for information from a database. Our Oracle database contains different

Asignment Essay

3234 words - 13 pages Oracle® Database Concepts 10g Release 2 (10.2) B14220-02 October 2005 Oracle Database Concepts, 10g Release 2 (10.2) B14220-02 Copyright © 1993, 2005, Oracle. All rights reserved. Primary Author: Michele Cyran Contributing Author: Paul Lane, JP Polk Contributor: Omar Alonso, Penny Avril, Hermann Baer, Sandeepan Banerjee, Mark Bauer, Bill Bridge, Sandra Cheevers, Carol Colrain, Vira Goorah, Mike Hartstein, John Haydu, Wei Hu, Ramkumar

Management Paper

1176 words - 5 pages move into actual system configuration. Concurrency in Database Database concurrency controls ensure that transactions occur in an ordered fashion. The main job of these controls is to protect transactions issued by different users/applications from the effects of each other. They must preserve the four characteristics of database transactions: atomicity, isolation, consistency and durability. Control in Database Every Oracle Database

Miss

331 words - 2 pages storage specifications to support our business requirements * consistent coverage across diverse platforms including Oracle, SQL Server, DB2 and Sybase * Maintains data dictionary by revising and entering definitions. * Database Monitoring/Tuning: Lead efforts to develop and improve procedures; for automated monitoring of database availability and performance; Review performance stats and recommend changes for tuning database, server

Database Design

633 words - 3 pages amount ordered by the customer. (Wallack, 2009) Type of Database Architecture Wal-Mart Uses Wal-Mart’s software is provided by Teradata and Wal-Mart also used NCR’s Teradata Relational Database System alongside its Oracle based architecture database. This has allowed Wal-Mart to know what their customers wants and needs are, and how many of a certain item sales each month. The database then creates an order form or automatically orders

Visual Basic Database Tutorials

708 words - 3 pages . * Oracle and Visual Basic using ADO We can interface with Oracle databases very easily from within Visual Basic. However, it is slightly different from how we normally use ADO with a SQL database. This tutorial shows you how to still use ADO but in a way that it will work with and Oracle back end. * Generating your own VB reports with Control Break concepts Control Break concepts allow you to break apart and display fields from a sorted

Sql Server 2008 Week 1

798 words - 4 pages could not be used. * Pages in APEX can display at most 200 items and forms cannot handle more than 200 database items. Compare this to the Oracle Database where tables can have up to 1000 columns. Pages must be designed to work around this limitation, for example by using multiple pages, tabular forms, or Ajax for on-demand updates. * APEX applications are created using Oracle's own tools and only can be hosted in an Oracle database

Apps

2172 words - 9 pages ORACLE Apps DBA How to confirm if Apps Listener is Up and Running ? execute below command lsnrctl status APPS_$SID (replcae SID with your Instance Name) How to compile Invalid Objects in database ? You can use adadmin utility to compile or you can use utlrp.sql script shipped with Oracle Database to compile Invalid Database Objects. How to compile JSP in Oracle Applications ? You can use ojspCompile.pl perl script shipped with

Unit 1 Research Paper

1627 words - 7 pages provides an integrated, modular environment for database development and administration of IBM DB2 for Linux, UNIX and Windows. * Enables you to create and manage heterogeneous database environments to help increase productivity. * Includes a SQL compatibility feature to help simplify and reduce the risk of database migration. For applications running on comparable Oracle databases, requires few or no code changes to run on DB2. Future

Questions to Ask an Oracle Developer

1981 words - 8 pages current role, do you work in all these phases yourself or are you usually involved with one particular phase? General Oracle Database and PL/SQL Questions: • Do you have any experience with Autonomous Transactions in Oracle database? The purpose is to complete (commit/rollback) a transaction in a called procedure irrespective of the transaction state in the calling procedure. • Have you ever encountered a situation with Mutating Tables and what

Computer Science

684 words - 3 pages connected SQL Azure database. A data definition language or data description language (DDL) is syntax similar to a computer programming language for defining data structures especially database schemas. Schema objects do not have a one-to-one correspondence to physical files on disk that store their information. However, Oracle databases store schema objects logically within atablespace of the database. The data of each object is

Related Essays

Data Management Essay

831 words - 4 pages 1. Introduction Enterprise database system (EDS) is the key factor for any successful medium to large business organization. An efficient, reliable and secured EDS enables business organizations to be productive and profitable. In this competitive business world, any large organization survivable largely depends on an efficient EDS. There is currently a lot of EDS available in the market such as Oracle. 2. Oracle Oracle is one of the

Creating Data Guard Essay

3410 words - 14 pages DataGuard : Step-by-Step Instructions for Creating a Physical Standby DatabaseThis is a featured page DataGuard : Step-by-Step Instructions for Creating a Physical StandbyDatabase (By Wissem EL KHLIFI) Step-by-Step Instructions for Creating a Physical Standby Database using SQL commands 1. General Overview : The purpose of this document is to create a step by step guideline for using the Oracle Dataguard a High available mechanism. I

Town Of Eden Bay Essay

1059 words - 5 pages fast food and a few tanks of gas. For the next eight years, Ellison bounced from job to job, working as a technician for Fireman's Fund and Wells Fargo bank. As a programmer at Amdahl Corporation, he participated in building the first IBM-compatible mainframe system. For more than three and a half decades, Oracle has been the leader in database software. And as it has further developed technologies and acquired best-in-class companies over the

Database Systems Essay

812 words - 4 pages the data to manipulate. The best example of this type of database is a single user editing a database on their personal workstation through a program like Microsoft Access. Two-tier architecture systems are more common to today’s computer users. Systems of this type utilize GUI interfaces that interact with the user to access the database through server based applications like Oracle and SQL server. The N-tier architecture separates the