Oracle Database

In: Computers and Technology

Submitted By compoperations
Words 624
Pages 3
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 friendly ad hoc data retrieval tool. It gives the user capability of retrieving, organizing, and displaying data when they want it, in the way they want it” (USAF 2009). Discoverer Plus also gives user the choice of creating their own queries from scratch with the help of a friendly wizard. In addition a number of standard ad hoc queries are provided to each user under their user-ids. Although standard ad hoc queries contain a predefined set of data, they also have flexibility of applying conditions, change sort order, and modifying the display. Discoverer Plus is also invaluable to Air Staff, Headquarter, and supply managers as it help makes important decisions with the deep-rooted analytical function. 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…...

Similar Documents

Oracle

...object_id AND w.lock_type(+) = h.lock_type AND w.lock_id1(+) = h.lock_id1 AND w.lock_id2 (+) = h.lock_id2 AND w.session_id = s1.sid (+) AND h.session_id = s2.sid (+) AND s1.paddr = p1.addr (+) AND s2.paddr = p2.addr (+) ORDER BY w.last_convert DESC; -- alternate example: SELECT s.username, s.sid, s.serial#, s.osuser, k.ctime, o.object_name object, k.kaddr, DECODE(l.locked_mode, 1, 'No Lock', 2, 'Row Share', 3, 'Row Exclusive', 4, 'Shared Table', 5, 'Shared Row Exclusive', 6, 'Exclusive') locked_mode, DECODE(k.TYPE, 'BL','Buffer Cache Management (PCM lock)', 'CF','Controlfile Transaction', 'CI','Cross Instance Call', 'CU','Bind Enqueue', 'DF','Data File', 'DL','Direct Loader', 'DM','Database Mount', 'DR','Distributed Recovery', 'DX','Distributed Transaction', 'FS','File Set', 'IN','Instance Number', 'IR','Instance Recovery', 'IS','Instance State', 'IV','Library Cache Invalidation', 'JQ','Job Queue', 'KK','Redo Log Kick', 'LA','Library Cache Lock', 'LB','Library Cache Lock', 'LC','Library Cache Lock', 'LD','Library Cache Lock', 'LE','Library Cache Lock', 'LF','Library Cache Lock', 'LG','Library Cache Lock', 'LH','Library Cache Lock', 'LI','Library Cache Lock', 'LJ','Library Cache Lock', 'LK','Library Cache Lock', 'LL','Library Cache Lock', 'LM','Library Cache Lock', 'LN','Library Cache Lock', 'LO','Library Cache Lock', 'LP','Library Cache......

Words: 1277 - Pages: 6

Database

...DSS 630 Database Management Systems Theory and Practice COURSE EXPECTATION FORM Course Description: The implementation of technology such as bar codes and scanners enable organizations to accumulate large volumes of data. Further, as the technology to collect data gets cheaper and more simplified, business organizations gather and process a huge amount of data and information. Thus, data management has become a key function for many organizations. Managers need high-quality information to manage change in a turbulent, global environment. Business organizations use information systems to store and retrieve data, the raw material in knowledge-based economies. This repository of data is organizational memory. Databases are an important component of the organizational memory. Thus, information systems professionals should develop a comprehensive understanding of data management principles to fully utilize the organizational role of information technology. This course provides core skills of data management for the relational database management systems. This course will review the theoretical concepts and applications of a modern relational database management system. In addition to a basic theoretical presentation of the database design concepts, students will be required to design and develop a database application using a modern fourth generation language system. This course teaches students data modeling and......

Words: 1374 - Pages: 6

Database

...display the minimum, maximum, sum, and average salary for each job type. Resave lab_04_04.sql as lab_04_05.sql. Run the statement in lab_04_05.sql. SELECT job_id, ROUND(MAX(salary),0) "Maximum",                 ROUND(MIN(salary),0) "Minimum",                 ROUND(SUM(salary),0) "Sum",                 ROUND(AVG(salary),0) "Average"  FROM   employees         GROUP BY job_id;  6. Write a query to display the number of people with the same job. SELECT job_id, COUNT(*)  FROM   employees   GROUP BY job_id;  Generalize the query so that the user in the HR department is prompted for a job title. Save the script to a file named lab_04_06.sql.� SELECT job_id, COUNT(*)  FROM   employees  WHERE  job_id = '&job_title'  GROUP BY job_id;  Oracle Database 10g: SQL Fundamentals I A - 12 Practice 4: Solutions (continued) 7. Determine the number of managers without listing them. Label the column Number of  Managers. Hint: Use the MANAGER_ID column to determine the number of managers. SELECT COUNT(DISTINCT manager_id) "Number of Managers"  FROM   employees;   8. Find the difference between the highest and lowest salaries. Label the column DIFFERENCE.� SELECT   MAX(salary) - MIN(salary) DIFFERENCE  FROM     employees;  If you have time, complete the following exercises:� 9. Create a report to display the manager number and the salary of the lowest-paid employee for that manager. Exclude anyone whose manager is not known. Exclude any groups where the minimum salary is......

Words: 569 - Pages: 3

Oracle

...in complete cohesiveness once this has been implemented. Some of the advantages that the relational model includes: • Conceptual simplicity: A simple model that simplifies data requirement of the client. • Design implementation. This model advocated structural and data independence. If changes are made to the data it will not affect the accessibility of data. • Ad hoc capability of query implementation: This model provides a simple method to implement and manipulate data. Purpose of the entity – relationship model The entity – relationship model is a conceptual level model that facilitates database design. From the vantage point of acme global the ER model will provide great assistance in visual representations. They will be able to understand the required data of their clients. The ER model will also increase all productivity with the integration of relational database model. Overall your client’s solution and file design will be implemented in a safe and simple model. Essential components of an ER Model • Entity: Object that exists and that can be distinguished from other objects. • Attributes: The properties related to a particular entity are known as attributes. • Relationship: The term defines how two or more entities are related to each other. There are variations of relationships exist in ER model. o One to one relationship: Only one ins...

Words: 252 - Pages: 2

Oracle

...Morningstar ® Document Research ℠ FORM 10-K ORACLE CORP - ORCL Filed: June 28, 2011 (period: May 31, 2011) Annual report with a comprehensive overview of the company The information contained herein may not be copied, adapted or distributed and is not warranted to be accurate, complete or timely. The user assumes all risks for any damages or losses arising from any use of this information, except to the extent such damages or losses cannot be limited or excluded by applicable law. Past financial performance is no guarantee of future results. Table of Contents UNITED STATES SECURITIES AND EXCHANGE COMMISSION Washington, D.C. 20549 FORM 10-K x ANNUAL REPORT PURSUANT TO SECTION 13 OR 15(d) OF THE SECURITIES EXCHANGE ACT OF 1934 For the fiscal year ended May 31, 2011 OR ¨ TRANSITION REPORT PURSUANT TO SECTION 13 OR 15(d) OF THE SECURITIES EXCHANGE ACT OF 1934 For the transition period from to Commission file number: 000-51788 Oracle Corporation (Exact name of registrant as specified in its charter) Delaware (State or other jurisdiction of incorporation or organization) 54-2185193 (I.R.S. Employer Identification No.) 500 Oracle Parkway Redwood City, California (Address of principal executive offices) 94065 (Zip Code) (650) 506-7000 (Registrant’s telephone number, including area code) Securities registered pursuant to Section 12(b) of the Act: Title of each class Common Stock, par value $0.01 per share The NASDAQ......

Words: 95668 - Pages: 383

Database

... | CHRISTON-QUAO PRECIOUS ESINAM CHINAERO |PROFILE |Highly proficient database management individual with excellent database management skills and high understanding on | | |query languages and most Object oriented programming languages. Excellent communication skills, Demonstrated | | |effective project planning skills. Exceptional problem solving skills with a strong sense of customer and management | | |focus and commitment to meeting deadlines. Confident, team focused and an effective relationship builder, indebt | | |knowledge of RDBMS developer tool such as oracle developer tools, SAP R/3. Adequate knowledge of office automation | | |software such as Microsoft office etc. Adequate knowledge of package implementation of integrated system. | |PROFESSIONAL SKILLS |Operating Systems: Windows 95, 98, 2000, NT,XP,2003 | | |TECHNICAL SKILLS: | | |Experience with SQL Server ,MS/SQL Server, ,SAP R/​3, Oracle 9i, 10g | | |Experience performing......

Words: 443 - Pages: 2

Oracle

...The History of Oracle | Founded in August 1977 by Larry Ellison, Bob Miner, Ed Oates and Bruce Scott, Oracle was initially named after "Project Oracle" a project for one of their clients, the C.I.A, and the company that developed Oracle was dubbed "Systems Development Labs", or SDL.   Although they may not have realized it at the time, these four men would change the history of database management forever. In 1978 SDL was renamed Relational Software Inc (RSI) to market their new database.  1979 - Oracle release 2 The first commercial RDBMS was built using PDP-11 assembler language. Although they created a commercial version of RDBMS in 1977, it wasn't available for sale until 1979 with the launch of Oracle version 2. The company decided against starting with version 1 because they were afraid that the term "version 1" might be viewed negatively in the marketplace.  USA Air Force and then CIA were the first customers to use Oracle 2. In 1982 there was another change of the company’s name, from RSI to Oracle Systems Corporation so as to match its popular database name.  The current company name comes from a CIA project that Larry Ellison had previously worked on code named Oracle. 1983 - Oracle release 3 The Oracle version 3 was developed in 1983. This version was assembled using C programming language and could run in mainframes, minicomputers, and PCs or any hardware with a C compiler. It supported the execution of SQL statements and transactions. This version also......

Words: 1424 - Pages: 6

Oracle

...COMPANY PROFILE Oracle Corporation REFERENCE CODE: C0CB6D9E-4EFE-4621-B998-73B241B46317 PUBLICATION DATE: 23 May 2014 www.marketline.com COPYRIGHT MARKETLINE. THIS CONTENT IS A LICENSED PRODUCT AND IS NOT TO BE PHOTOCOPIED OR DISTRIBUTED. Oracle Corporation TABLE OF CONTENTS TABLE OF CONTENTS Company Overview..............................................................................................3 Key Facts...............................................................................................................3 SWOT Analysis.....................................................................................................4 Oracle Corporation © MarketLine Page 2 Oracle Corporation Company Overview COMPANY OVERVIEW Oracle Corporation (Oracle or “the company”) is a provider of enterprise software, computer hardware products and services. The company operates in more than 145 countries across the world. Oracle is headquartered in Redwood Shores, California and employed 120,000 people as of May 31, 2013. The company recorded revenues of $37,180 million during the financial year ended May 2013 (FY2013), an increase of 0.2% over FY2012. The increase in revenues was due to an increase in Oracle’s software business revenues. The operating profit of the company was $14,684 million in FY2013, an increase of 7.1% over FY2012. The net profit was $10,925 million in FY2013, an increase of 9.5% over FY2012. KEY FACTS Head Office Oracle......

Words: 3160 - Pages: 13

Oracle Database Trends

...Research projectDatabase TrendssUBMITTED BYAndrew HoPatrick TchissamboFlavio baptista | | | PROFESSOR TAHEREH DANESHI | Summary page Our project is about database trends. We started the project by identifying aims and goals such as understanding what database is.We calculated in detail and understood and researched on database understood database used by ORACLE. INTRODUCTION The definition of a database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of records well, but be accessed easily. In addition, new information and changes should also be fairly easy to input. In order to have a highly efficient database system, you need to incorporate a program that manages the queries and information stored on the system. This is usually referred to as DBMS or a Database Management System. Besides these features, all databases that are created should be built with high data integrity and the ability to recover data if hardware fails. (What is a Database?, 2010) AIM The aim of the study is many folded such as, understanding database, go in detail and understand and research on database, understand the technology used by ORACLE, derive conclusions on the development in the field of database. LIMITATIONS This study is descriptive in nature and the research is done on published secondary materials. Logical conclusions are made based on our......

Words: 3078 - Pages: 13

Oracle

...Israel Garcia Professor Neil Librock Finance 3300 21 October 2014 Oracle Corporation Most widely known for their Java software, the #1 development platform, Oracle is the so called leader in database software. Their business expands, however, from software to hardware with products such as storage equipment, servers, operating systems, virtualization software, middleware, and many more. It was founded in 1977 and today it is headquartered in our very own Golden state in Redwood City. We look first at measures of financial leverage, which is important because debt can increase or decrease returns to shareholders. Financial leverage is usually measured by the ratio of long-term debt to total long-term capital. Oracles long-term debt ratio for 2014 is 33%, an increase from 29% in 2013. This number tells us that for every dollar in the form of long-term capital, 33 cents is in the form of debt. This measure, however, ignores Oracle’s short-term debt. To take short-term debt into account we measure its total debt ratio, in this case Oracle’s total debt ratio is 47%. Ultimately, these numbers tell us that Oracle is financed 47% with long-term and short-term debt and 53% with equity. We want equity here to be higher than debt since the less money the company borrows, the less interest it pays. Next, we take a look at Oracle’s liquidity ratios. Liquid assets can be converted into cash quickly, which is why it is important to measure to see how quickly a company can bring......

Words: 652 - Pages: 3

Oracle for Dummies

...™ Everything Easier! Making cle 11g Ora ® Learn to: • Set up and manage an Oracle database • Maintain and protect your data • Understand Oracle database architecture • Troubleshoot your database and keep it running smoothly Chris Zeis Chris Ruel Michael Wessler www.it-ebooks.info www.it-ebooks.info Oracle 11g ® FOR DUMmIES ‰ www.it-ebooks.info www.it-ebooks.info Oracle 11g ® FOR DUMmIES by Chris Zeis, Chris Ruel, and Michael Wessler ‰ www.it-ebooks.info Oracle® 11g For Dummies® Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030-5774 www.wiley.com Copyright © 2009 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or......

Words: 106399 - Pages: 426

Oracle

...Oracle Systems Corporation is a database management software company that found success in the 1980’s from being an innovator in multiplatform software development. Oracle’s business strategy focused on building its technical expertise and customer service to provide performance standards that could not be matched by competitors. Oracle adopted a first mover competitive advantage when it was the first company to deliver multiple-interface software along with a range of accounting applications - all at record-setting speeds. An incentive-driven sales force was established in order to market to large corporations that would benefit the most from its software. In return, Oracle saw growth rates as sales increased by nearly 700 million dollars from 1988 to 1990. Oracle’s key successes and risk factors can both be traced to their marketing and R&D costs, as well as expanding licensing agreements with hardware manufacturers and value-added resellers (VARs). The first mover advantage that Oracle established with its software allowed the company to venture into a wide arrange of services such as maintenance, consulting, and systems integration before its competitors. These services created a company that could specialize in both product quality and customer service. This instant expansion also came with its own set of problems. Customer satisfaction dropped due to an inability of the sales force to adapt to new territories and new software was being criticized for a number of...

Words: 580 - Pages: 3

Oracle

...Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6 This article describes the installation of Oracle Database 11g Release 2 (11.2) (64-bit) on Oracle Linux 6 (64-bit). The article is based on a server installation with a minimum of 2G swap, with both SELinux and the firewall disabled. The following package groups were included for this installation. * Base System * Base * Debugging Tools * Directory Client * Hardware monitoring Client * Large Systems Performance * Network file system client * Performance Tools * Perl Support * Servers * Server Platform * System administration tools * Desktops * Desktop * Desktop Platform * Fonts * General Purpose Desktop * Graphical Administration Tools * X Windows System * Applications * Internet Browser * Development * Development Tools An example of this type of Linux installations can be seen here. Alternative installations may require more packages to be loaded, in addition to the ones listed below. Note. At the time of writing Oracle have not certified any of their database products on OL6 or RHEL6, so you shouldn't use these operating systems for anything important until the certification is complete. * Download Software * Unpack Files * Hosts File * Set Kernel Parameters * Setup * Installation * Post Installation Download Software Download......

Words: 1320 - Pages: 6

Oracle

...Oracle 11g PL/SQL New Features PL/SQL "continue" keyword - This will allow a "C-Like" continue in a loop, skipping an iteration to bypass any "else" Boolean conditions. A nasty PL/SQL GOTO statement is no longer required to exit a Boolean within a loop. Oracle professional Jurgen Kemmelings has an excellent PL/SQL example of the PL/SQL continue clause in-action: begin for i in 1..3 loop dbms_output.put_line(’i=’||to_char(i)); if ( i = 2 ) then continue; end if; dbms_output.put_line(’Only if i is not equal to 2′); end loop; end; Disabled state for PL/SQL - Another 11g new feature is a "disabled" state for PL/SQL (as opposed to "enabled" and "invalid" in dba_objects). Easy PL/SQL compiling - Native Compilation no longer requires a C compiler to compile your PL/SQL. Your code goes directly to a shared library. Source: Lewis Cunningham Improved PL/SQL stored procedure invalidation mechanism - A new 11g features will be fine grained dependency tracking, reducing the number of objects which become invalid as a result of DDL. Scalable PL/SQL - The next scalable execution feature is automatic creation of "native" PL/SQL (and Java code), with just one parameter for each type with an "on/off" value. This apparently provides a 100% performance boost for pure PL/SQL code, and a 10%-30% performance boost for code containing SQL. Mark Rittman Enhanced PL/SQL warnings - The 11g PL/SQL compiler will issue a......

Words: 269 - Pages: 2

Hp Oracle

...manajemen database informasi pada suatu bisnis perusahaan sangatlah dibutuhkan dalam dunia saat ini. Hal ini diperlihatkan pentingnya pengelolaan informasi yang berkelanjutan sehingga memudahkan dalam pengambilan keputusan. Untuk itu perlu adanya Gudang data yang memudahkan dalam penggunaan bisnis perusahaan. Dengan hal ini diketahui gudang data mengelola lebih dan informasi yang lebih lanjut, sementara pengguna bisnis secara konsisten mengharapkan suatu respon permintaan yang cepat. Tapi, mendapatkan keseimbangan yang benar dari server, penyimpanan, jaringan dan perangkat lunak cerdas untuk memenuhi kebutuhan bisnis kritis ini dapat menjadi tantangan. Tuntutan untuk informasi lebih lanjut pada waktu yang tepat membutuhkan pendekatan alternatif , suatu pendekatan yang mempercepat penyebaran tanpa mengorbankan skalabilitas, kehandalan, dan keamanan. Dengan ini penulis memberikan suatu pemberian solusi akan data warehouse dari Oracle. HP Oracle Database Machine memberikan performa ekstrim untuk data skala besar gudang pertanyaan mengenai pra-konfigurasi sistem, berdasarkan Oracle yang mana memimpin pasar database dan server standar industri, penyimpanan dan komponen jaringan dari HP. Dengan kecepatan, handal, aman sistem yang dapat dengan mudah memberi skala untuk memenuhi integrasi data yang kompleks, pelaporan, analisis dan penggalian data untuk aplikasi yang paling menuntut organisasi hari ini. Kertas memperkenalkan Anda kepada seorang baru keluarga produk Oracle,......

Words: 1793 - Pages: 8