Talk:Oracle Database

This is the talk page for discussing improvements to the Oracle Database article.
This is not a forum for general discussion of the article's subject.

Put new text under old text. Click here to start a new topic.
New to Wikipedia? Welcome! Learn to edit; get help.

Article policies

Find sources: Google (books · news · scholar · free images · WP refs) · FENS · JSTOR · TWL

Archives: 1: 3 months

This article has not yet been rated on Wikipedia's content assessment scale.
It is of interest to the following WikiProjects:

Please add the quality rating to the {{WikiProject banner shell}} template instead of this project banner. See WP:PIQA for details.

Computing: Software C‑class Mid‑importance

	This article is within the scope of WikiProject Computing, a collaborative effort to improve the coverage of computers, computing, and information technology on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.ComputingWikipedia:WikiProject ComputingTemplate:WikiProject ComputingComputing
C	This article has been rated as C-class on Wikipedia's content assessment scale.
Mid	This article has been rated as Mid-importance on the project's importance scale.
	This article is supported by WikiProject Software (assessed as High-importance).

Databases (inactive)

This article is within the scope of WikiProject Databases, a project which is currently considered to be inactive.DatabasesWikipedia:WikiProject DatabasesTemplate:WikiProject DatabasesDatabases

Individuals with a conflict of interest, particularly those representing the subject of the article, are strongly advised not to directly edit the article. See Wikipedia:Conflict of interest. You may request corrections or suggest content here on the Talk page for independent editors to review, or contact us if the issue is urgent.

Workpage: Talk:Oracle Database/Notes

The workpage contains some guidelines and information related to article development

Very Poorly Summarized

This article clearly shows a lot of dense technical info, but lacks any sort of popularly intelligible summary or overview at the top. The historical blurb following the title is interesting but sheds zero light on the actual use or function of Oracle system. All that the uninitiated (like me) can glean about the software comes from the first line of the Physical and Logical Structures paragraph:

"An Oracle database system—identified by an alphanumeric system identifier or SID—comprises at least one instance of the application, along with data storage. An instance—identified persistently by an instantiation number (or activation id: SYS.V_$DATABASE.ACTIVATION#)—comprises a set of operating-system processes and memory-structures that interact with the storage."

Ok, so it has a database and an application. Like an operating system. Or a video game. Or any other piece of software ever. The two hyphenated asides make one read the sentences about three times to glean even this much, and provide seemingly unimportant details abour naming schemes. From here, the article descends into unapologetic technobabble. The whole thing is so opaque to the common reader that it seems to be an orchestrated effort to conceal Oracle's purpose and function from the public.

Please, if you know what Oracle *is* from some more civilized source, write an Overview section which gives the lowdown on the subject. A paragraph would suffice. Even one sentence would more than double the article's value. I have created an account solely to draw attention to the embarrassing stare of this article.

Thanks,

Oogalook

— Preceding unsigned comment added by Oogalook (talk • contribs) 14:52, 24 June 2017 (UTC)[reply]

Real application clusters

Real application clusters is oracle's clustering technology for databases and highly available applications. The database backend is available from multiple nodes which is further extended to have caches across all the other nodes using Cache fusion. Traditionally the database executes from a single box has disks where the necessary datafiles and redo logs are located. For Real Application Clusters as what its called as an expansion of the acronym RAC which is more well known among the Oracle DBA community is used for providing access to the data stored in this database across multiple physical boxes which could be servers from branded vendors or commodity hardware. RAC works on most platforms and Linux certainly being popular one can use this with Redhat (the EL series) or United linux. APAC has growth in the areas for Miracle linux and Asianux for Asian specific distributions.

This was the text in a separate article. I've removed it to here, and made the page a redirect to Oracle database. If you think that it belongs here, perhaps someone could insert it in the right place (I don't really have the know-how to judge). If you think that it deserves a separate article, then it could be Wikified and replaced. Mel Etitis (Μελ Ετητης) 22:45, 22 Mar 2005 (UTC)

Oracle based on University Ingres?

Is the Oracle codebase developed from "University Ingres" or not? I would imagine not, in which case that would be notable in the main argument, because the majority of its compettitors (CA-Ingres, Sybase, SQL Server etc) were. My doubts are really only raised because that on casual inspection Pro*C is remarkably like Ingres ESQL - so is Pro*c developed from ESQL or perhaps ESQL is some kind of industry 'standard' from somewhere? The ESQL page doesn't say where ESQL came from or to which DBMS systems it applies.

Edit Request on 31-JAN-2019

Edit request for references - Partly done

In the section on "History" and/or under the "Releases and Versions" section, please add the following sources as reference for the claim that Oracle Version 2 (released in 1979) was the "first commercially available SQL-Based Relational DBMS".

As noted in these sources, IBM's System/R and SEQUEL pre-dated Oracle V2, but those were not commercial products.

Thanks Ccraft us (talk) 13:58, 31 January 2019 (UTC)[reply]

I'd like to profoundly modify this page because it is way too much overloaded with old information and not up to date ones. It needs to be also more consistent with the French version of this page as well as the Exadata page. The TOC needs to be redone and I'll post a new request shortly.

~~First, would it be possible for me to add the following paragraph to the introduction at the top of the page ?~~

One of the important goal of the Oracle Database is to build cutting edge technologies like Multitenancy, JSON, Analytics, Machine Learning, Blockchain, and many more, directly within a converged infrastructure to greatly simplify applications' development and deployment.

~~Thanks to let me know.~~

~~JFVerrier (talk) 08:23, 29 September 2019 (UTC)JFVerrier~~ (Struck request duplicated in following paragraph for clarity). Djm-leighpark (talk) 09:37, 30 September 2019 (UTC)[reply]

The Citation at the Klagenfurt university has been, embelished, archived and added; I have not done the same for he reference from the Oracle website. Djm-leighpark (talk) 12:48, 30 September 2019 (UTC)[reply]

Edit Request on Sep 29 2019

It is requested that an edit be made to the semi-protected article at D. (edit · history · last · links · protection log)

This template must be followed by a complete and specific description of the request, that is, specify what text should be removed and a verbatim copy of the text that should replace it. "Please change X" is not acceptable and will be rejected; the request must be of the form "please change X to Y".

The edit may be made by any autoconfirmed user. Remember to change the |answered=no parameter to "yes" when the request has been accepted, rejected or on hold awaiting user input. This is so that inactive or completed requests don't needlessly fill up the edit requests category. You may also wish to use the {{ESp}} template in the response. To request that a page be protected or unprotected, make a protection request.

Information to be added or removed:

Edit request

Add the following paragraph to the introduction at the top of the page: One of the important goal of the Oracle Database is to build cutting edge technologies like Multitenancy, JSON, Analytics, Machine_learning, Blockchain, and many more, directly within a converged infrastructure to greatly simplify applications' development and deployment.

   Explanation of issue: This is one of the most important goals of the Oracle Database and it is missing in the article.
   References supporting change: Minute 37:22 from Video delivered by Juan Loaiza (Oracle EVP System Technology)

JFVerrier (talk) 12:17, 30 September 2019 (UTC)JFVerrier[reply]

Edit Request - 1 on 30-Sept-2019: Rename paragraph "Releases and versions"

I'd like to rename paragraph-subheading1 "Releases and versions" as paragraph-heading "Evolution" . This change will match the paragraph name "Evolution" that exists in Oracle Exadata wikipedia page.

Thanks to let me know. JFVerrier (talk) 08:54, 30 September 2019 (UTC)JFVerrier[reply]

Edit Request - 2 on 30-Sept-2019: Move paragraph "Evolution"

I'd like to move paragraph-heading "Evolution" (formerly renamed in Edit Request - 1 on 30-Sept-2019: Rename paragraph "Releases and versions") before paragraph-heading "Use" . This change will match the TOC structure of Oracle Exadata wikipedia page.

Thanks to let me know.

JFVerrier (talk) 08:57, 30 September 2019 (UTC)JFVerrier[reply]

Edit Request - 3 on 30-Sept-2019: Replace lists of features separated by commas by lists

I'd like to replace lists of features separated by commas, by lists, in the table in paragraph-heading "Evolution" (formerly renamed in Edit Request - 1 on 30-Sept-2019: Rename paragraph "Releases and versions"), in column “Marquee Features”, as follows:

Concurrency control, data distribution, and scalability,
==>
Concurrency control
Data distribution
Scalability

Row-level locking, scalability, online backup and recovery, PL/SQL. First version available for Novell Netware 386.
==>
Row-level locking
Scalability
Online backup and recovery
PL/SQL. First version available for Novell Netware 386.

PL/SQL stored procedures, Triggers, Distributed 2-phase commit, Shared Cursors, Cost Based Optimizer
==>
PL/SQL stored procedures
Triggers
Distributed 2-phase commit
Shared Cursors
Cost Based Optimizer

Shared Server, XA Transactions, Transparent Application Failover
==>
Shared Server
XA Transactions
Transparent Application Failover

Recovery Manager, Partitioning. First version available for Linux.
==>
Recovery Manager
Partitioning
First version available for Linux

Native internet protocols and Java, Virtual Private Database
==>
Native internet protocols and Java
Virtual Private Database

Oracle Real Application Clusters (RAC), Oracle XML DB
==>
Oracle Real Application Clusters (RAC)
Oracle XML DB

Advanced Queuing, Data Mining, Streams, Logical Standby
==>
Advanced Queuing
Oracle Data Mining
Streams
Logical Standby

Automated Database Management, Automatic Database Diagnostic Monitor, Grid infrastructure, Oracle ASM, Flashback Database
==>
Automated Database Management
Automatic Database Diagnostic Monitor
Grid infrastructure
Oracle ASM
Flashback Database

Real Application Testing, Database Vault, Online Indexing, Advanced Compression, Data Guard Fast-Start Failover, Transparent Data Encryption
==>
Real Application Testing
Database Vault
Online Indexing
Advanced Compression
Data Guard Fast-Start Failover
Transparent Data Encryption

Active Data Guard, Secure Files, Exadata
==>
Active Data Guard
Secure Files
Exadata

Edition Based Redefinition, Data Redaction, Hybrid Columnar Compression, Cluster File System, Golden Gate Replication, Database Appliance
==>
Edition Based Redefinition
Data Redaction
Hybrid Columnar Compression
Cluster File System
Golden Gate Replication
Database Appliance

Multitenant architecture, In-Memory Column Store, Native JSON, SQL Pattern Matching, Database Cloud Service
==>
Multitenant architecture
In-Memory Column Store (Column-oriented DBMS)
Native JSON (JSON)
SQL Pattern Matching
Zero Data Loss Recovery Appliance
Database Cloud Service

Native Sharding, Zero Data Loss Recovery Appliance, Exadata Cloud Service, Cloud at Customer
==>
Native Sharding
Exadata Cloud Service
Cloud at Customer

Polymorphic Table Functions, Active Directory Integration
==>
Online Database Encryption
In-Memory Indexes for Key-Value Lookups
Approximate Aggregations
Polymorphic Table Functions
Active Directory Integration

Active Data Guard DML Redirection, Automatic Index Creation, Real-Time Statistics Maintenance, SQL Queries on Object Stores, In-Memory for IoT Data Streams, and many more.
==>
In-Memory for IoT Streaming
Automatic Index Creation
Real-Time Statistics Maintenance
SQL Queries on Object Stores
Issue DML on Active Data Guard

Thanks to let me know.

JFVerrier (talk) 09:38, 30 September 2019 (UTC)JFVerrier[reply]

Edit Request - 4 on 30-Sept-2019: Rename paragraph "Oracle Database Deployment"

I'd like to rename paragraph-heading "Oracle Database Deployment" as paragraph-heading " Oracle Database Use Cases" .

Thanks to let me know.

JFVerrier (talk) 09:59, 30 September 2019 (UTC)JFVerrier[reply]

Edit Requests

Can I respectfully suggest people with WP:COI please use Template:Request edit when making edit requests to this article identified as mid-high importance by WikiProjects when they will usually be evaluated by specialists in this area. Also please appreciate the volunteers in this area often do not appreciate using their volunteer time to fix the issue from paid professionals. As with level 0 backups and restores of databases it is often better to practice and get success on small examples before moving into the 10 Terrabyte range. Thankyou. Djm-leighpark (talk) 10:01, 30 September 2019 (UTC)[reply]

Thanks for driving me through the Wikipedia processes but you understood that I am brand new to this exercise. My intention is only to provide accurate technical information to the audience despite the fact that I have a COI. I am following your recommendations and will now create edit request using the right template. I understand that this is a lot of work for both of us, but what can we do?

With my kindest regards, JFVerrier (talk) 12:32, 30 September 2019 (UTC)JFVerrier[reply]

Edit Request - 5 on 30-Sept-2019: Update content in paragraph "Database Cloud Services"

I'd like to add in paragraph-subheading1 “Database Cloud Services” the following sentences at the last place: Oracle Cloud provides a set of data management services built on self-driving Oracle Autonomous Database technology to deliver automated patching, upgrades, and tuning, including performing all routine database maintenance tasks while the system is running, without human intervention.

Bulleted list item

Oracle Autonomous Data Warehouse (ADW) provides you an easy-to-use, fully autonomous data warehousing environment that scales elastically, delivers fast query performance and requires no database administration.

Bulleted list item

Oracle Autonomous Transaction Processing (ATP) delivers a self-driving, self-securing, self-repairing database service that can instantly scale to meet demands of mission critical transaction processing and mixed workload applications.

Thanks to let me know.

JFVerrier (talk) 10:01, 30 September 2019 (UTC)JFVerrier[reply]

Reply 30-SEP-2019

Clarification requested

To expedite your request, please provide the following information:

Please state each specific desired change in the form of verbatim claim statements which can then be added to the article (if approved) by the reviewer.
The exact location where the desired statements are to be placed should be given.
Exact, verbatim descriptions of any text or references to be removed should also be given.^[1]
Reasons should be provided for each change.^[2]

In the section of text below titled Sample edit request, the four required items are shown as an example:

Sample edit request

1. Please remove the third sentence from the second paragraph of the Sun section:

"The Sun's diameter is estimated to be approximately 25 miles in length."

2. Please add the following claim as the third sentence of the second paragraph of the Sun section:

"The Sun's diameter is estimated to be approximately 864,337 miles in length."

3. Using as the reference:

Paramjit Harinath (2019). The Sun. Academic Press. p. 1.

4. Reason for change being made:

"The previously given diameter was incorrect."

References

^ "Template:Request edit". Wikipedia. 15 September 2018. Instructions for Submitters: Describe the requested changes in detail. This includes the exact proposed wording of the new material, the exact proposed location for it, and an explicit description of any wording to be removed, including removal for any substitution.

^ "Template:Request edit". Wikipedia. 15 September 2018. Instructions for Submitters: If the rationale for a change is not obvious (particularly for proposed deletions), explain.

Kindly open a new edit request at your earliest convenience when ready to proceed with all four items from your request. Thank you!

Regards, Spintendo 13:12, 30 September 2019 (UTC)[reply]

Edit Request - 0 on 30-Sept-2019: Add Goal sentence in the first paragrah of the Oracle Database

Add Goal sentence in the first paragraph

It is requested that an edit be made to the semi-protected article at Oracle Database. (edit · history · last · links · protection log)

This template must be followed by a complete and specific description of the request, that is, specify what text should be removed and a verbatim copy of the text that should replace it. "Please change X" is not acceptable and will be rejected; the request must be of the form "please change X to Y".

The edit may be made by any autoconfirmed user. Remember to change the |answered=no parameter to "yes" when the request has been accepted, rejected or on hold awaiting user input. This is so that inactive or completed requests don't needlessly fill up the edit requests category. You may also wish to use the {{ESp}} template in the response. To request that a page be protected or unprotected, make a protection request.

Information to be added: Please add the following claim as the last sentence of the first paragraph :

"One of the important goal of the Oracle Database is to build cutting edge technologies like Multitenancy, JSON, Analytics, Machine_learning, Blockchain, and many more, directly within a converged infrastructure to greatly simplify applications' development and deployment."

right after

"Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a proprietary multi-model database[4] management system produced and marketed by Oracle Corporation." It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads. The latest generation, Oracle Database 19c, is available on-prem, on-cloud, or in a hybrid-Cloud environment. 19c may also be deployed on Oracle Engineered Systems (e.g. Exadata) on-prem, on Oracle (public) cloud or (private) cloud at customer.[5] At Openworld 2017 in San Francisco, Executive Chairman of the Board and CTO, Larry Ellison announced the next database generation, Oracle Autonomous Database.[6] "

Explanation of the change: This is one of the most important goals of the Oracle Database and it is missing in the article.

References supporting change: Minute 37:22 from Video delivered by Juan Loaiza (Oracle EVP System Technology)

JFVerrier (talk) 15:55, 30 September 2019 (UTC)JFVerrier[reply]

Why is this goal important? Who (other than Oracle employees) say so? Why are those technologies cutting edge? Who says so? - MrOllie (talk) 16:04, 30 September 2019 (UTC)[reply]

Thanks MrOllie, you are asking questions that could be asked for many if not all of the sentences I can read on this article.

For example, take the very first opening sentence that says "Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is a proprietary multi-model database[4] management system produced and marketed by Oracle Corporation."

Regarding "commonly referred to as ORACLE RDBMS or simply Oracle": who say so?

Regarding multi-model a reference number 4 here is given to an Oracle document. So that is said by Oracle employees no?

Why this went through and mine would not ?

This is exactly the same reasoning, no?

Sorry to ask but I am very new to this world and would sincerely like to add value to this article.

Would the following be better?

"The Oracle Database builds many technologies like Multitenancy, JSON, Analytics, Machine_learning, Blockchain, and many more, directly within a converged infrastructure to simplify applications' development and deployment." and making a reference to the video I refered too originally? at minute 37:22 https://www.oracle.com/openworld/on-demand.html?bcid=6087202381001

Thanks to let me know.

JFVerrier (talk) 17:40, 30 September 2019 (UTC)JFVerrier[reply]

Reply 30-SEP-2019

One of the important goal [sic] of the Oracle Database is to build cutting edge technologies like Multitenancy, JSON, Analytics, Machine_learning, Blockchain, and many more, directly within a converged infrastructure to greatly simplify applications' development and deployment. This claim statement has several issues, 2 of which MrOllie mentioned. Another issue is that this appears to be a statement of the company's goals. Describing the object of a company's ambitions or efforts, as well as descriptions of its aims and its desired results, are ultimately not the purpose of the article.

The article is meant primarily to be an accounting of what the company has done — i.e., what it has produced, sold, and encountered as an institution existing in a business marketplace. The realm of the real, or actual, is what Wikipedia deals in, as in what actually occurred during a business's existence. The realm of ideas — such as hopes, desires, goals and aspirations are not the purpose of a Wikipedia page assigned to cover a business.

Now one could say that instead of meaning to write "goals", what was actually meant was to merely describe what the "purposes" of the Oracle database is,^[a] and then to list the technologies used by the company, in order to imply that the company's tech does what it's supposed to do....One of the important goal(s) of the Oracle Database is to build cutting edge technologies like Multitenancy...to greatly simplify applications' development is really just saying "The goal of the company is to deliver efficient technology such as project X, a project which carries out its duties efficiently", which is a nice roundabout way of complimenting and thereby promoting the company's products twice in one sentence, which is also not the purpose of the article. Regards, Spintendo 18:19, 30 September 2019 (UTC)[reply]

Notes

^ A purpose is just another way of saying a goal.

Absolutely agree with you. The thing is that all these technologies are already there in the database. So I should rephrase this to list what is in there currently. Will do it soon. Thanks JFVerrier (talk) 20:00, 30 September 2019 (UTC)JFVerrier[reply]

[1] "Template:Request edit". Wikipedia. 15 September 2018. Instructions for Submitters: Describe the requested changes in detail. This includes the exact proposed wording of the new material, the exact proposed location for it, and an explicit description of any wording to be removed, including removal for any substitution.

[2] "Template:Request edit". Wikipedia. 15 September 2018. Instructions for Submitters: If the rationale for a change is not obvious (particularly for proposed deletions), explain.

[3] A purpose is just another way of saying a goal.

[1]

[2]

[a]