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

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]

Reply 01-OCT-2019

I suggest adding the following claim as the last sentence of the first paragraph :
"The Oracle Database integrates in a secure, highly efficient and available converged infrastructure the following technologies to simplify applications' development and deployment by avoiding polyglot persistence:

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:
The current introduction in the page mainly focuses on traditional RDBMS functionalities and does not sufficiently show the big evolution of the system towards ease of application development, integrated in the database during the past four years.

References supporting change:
Minute 37:22 from Video delivered by Juan Loaiza (Oracle EVP System Technology) and links for each technology in the text above pointing to the official Oracle documentation. JFVerrier (talk) 08:36, 1 October 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]