|
|archive = Talk:Oracle Database/Archive %(counter)d
}}
== Edit Request on 31-JAN-2019 ==
{{Collapse top|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".
* [http://cs-exhibitions.uni-klu.ac.at/index.php?id=403 Virtual Exhibitions in Informatics, Oracle V2]
* [https://docs.oracle.com/en/database/oracle/oracle-database/18/cncpt/introduction-to-oracle-database.html#GUID-43F9DD5C-8D8C-4E61-A2B4-5C05907D3CEC Brief History of Oracle Database]
As noted in these sources, IBM's System/R and SEQUEL pre-dated Oracle V2, but those were not commercial products.
Thanks [[User:Ccraft us|Ccraft us]] ([[User talk:Ccraft us|talk]]) 13:58, 31 January 2019 (UTC)
<s>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 [https://fr.wikipedia.org/wiki/Oracle_Database French version] of this page as well as the [https://en.wikipedia.org/wiki/Oracle_Exadata 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 [https://en.wikipedia.org/wiki/Multitenancy Multitenancy], [https://en.wikipedia.org/wiki/JSON JSON], [https://en.wikipedia.org/wiki/Analytics Analytics], [https://en.wikipedia.org/wiki/Machine_learning Machine Learning], [https://en.wikipedia.org/wiki/Blockchain Blockchain], and many more, directly within a [https://en.wikipedia.org/wiki/Converged_infrastructure converged infrastructure] to greatly simplify applications' development and deployment.''
Thanks to let me know.
[[User:JFVerrier|JFVerrier]] ([[User talk:JFVerrier|talk]]) 08:23, 29 September 2019 (UTC)JFVerrier
</s> (Struck request duplicated in following paragraph for clarity). [[User:Djm-leighpark|Djm-leighpark]] ([[User talk:Djm-leighpark|talk]]) 09:37, 30 September 2019 (UTC)
{{collapse-bottom}}
{{partly done|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 }}. [[User:Djm-leighpark|Djm-leighpark]] ([[User talk:Djm-leighpark|talk]]) 12:48, 30 September 2019 (UTC)
==Edit Request on Sep 29 2019==
{{request edit|D|[See below]}}
Information to be added or removed:
{{collapsed top|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 [https://www.oracle.com/openworld/on-demand.html?bcid=6087202381001 Video] delivered by Juan Loaiza (Oracle EVP System Technology)
[[User:JFVerrier|JFVerrier]] ([[User talk:JFVerrier|talk]]) 12:17, 30 September 2019 (UTC)JFVerrier
== 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|Oracle Exadata wikipedia]] page.
Thanks to let me know.
[[User:JFVerrier|JFVerrier]] ([[User talk:JFVerrier|talk]]) 08:54, 30 September 2019 (UTC)JFVerrier
== 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|Oracle Exadata wikipedia]] page.
Thanks to let me know.
[[User:JFVerrier|JFVerrier]] ([[User talk:JFVerrier|talk]]) 08:57, 30 September 2019 (UTC)JFVerrier
== 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, <br>
==><br>
[[Concurrency control]]<br>
Data distribution<br>
[[Scalability]]<br>
<br>
Row-level locking, scalability, online backup and recovery, PL/SQL. First version available for Novell Netware 386.<br>
==><br>
Row-level locking<br>
Scalability<br>
Online backup and recovery<br>
[[PL/SQL]]. First version available for [[NetWare|Novell Netware 386]].<br>
<br>
PL/SQL stored procedures, Triggers, Distributed 2-phase commit, Shared Cursors, Cost Based Optimizer <br>
==><br>
PL/SQL stored procedures<br>
Triggers<br>
Distributed 2-phase commit<br>
Shared Cursors<br>
Cost Based Optimizer <br>
<br>
Shared Server, XA Transactions, Transparent Application Failover <br>
==><br>
Shared Server<br>
XA Transactions<br>
Transparent Application Failover <br>
<br>
Recovery Manager, Partitioning. First version available for Linux.<br>
==><br>
Recovery Manager<br>
Partitioning<br>
First version available for Linux<br>
<br>
Native internet protocols and Java, Virtual Private Database <br>
==><br>
Native internet protocols and Java<br>
Virtual Private Database <br>
<br>
Oracle Real Application Clusters (RAC), Oracle XML DB <br>
==><br>
[[Oracle RAC|Oracle Real Application Clusters (RAC)]]<br>
Oracle XML DB<br>
<br>
Advanced Queuing, Data Mining, Streams, Logical Standby <br>
==><br>
[[Oracle Advanced Queuing|Advanced Queuing]]<br>
[[Oracle Data Mining]]<br>
Streams<br>
Logical Standby <br>
<br>
Automated Database Management, Automatic Database Diagnostic Monitor, Grid infrastructure, Oracle ASM, Flashback Database <br>
==> <br>
Automated Database Management <br>
Automatic Database Diagnostic Monitor <br>
Grid infrastructure <br>
Oracle ASM <br>
Flashback Database <br>
<br>
Real Application Testing, Database Vault, Online Indexing, Advanced Compression, Data Guard Fast-Start Failover, Transparent Data Encryption <br>
==> <br>
Real Application Testing <br>
Database Vault <br>
Online Indexing <br>
Advanced Compression <br>
Data Guard Fast-Start Failover <br>
Transparent Data Encryption <br>
<br>
Active Data Guard, Secure Files, Exadata <br>
==> <br>
[[Oracle_Data_Guard|Active Data Guard]] <br>
Secure Files <br>
[[Exadata]] <br>
<br>
Edition Based Redefinition, Data Redaction, Hybrid Columnar Compression, Cluster File System, Golden Gate Replication, Database Appliance <br>
==> <br>
Edition Based Redefinition <br>
Data Redaction <br>
Hybrid Columnar Compression <br>
Cluster File System <br>
Golden Gate Replication <br>
[[Oracle Database Appliance|Database Appliance]] <br>
<br>
Multitenant architecture, In-Memory Column Store, Native JSON, SQL Pattern Matching, Database Cloud Service <br>
==> <br>
[https://docs.oracle.com/database/121/NEWFT/chapter12101.htm#NEWFT245 Multitenant architecture] <br>
[https://docs.oracle.com/database/121/NEWFT/chapter12102.htm#NEWFT504 In-Memory Column Store] ([[Column-oriented DBMS]]) <br>
[https://docs.oracle.com/database/121/NEWFT/chapter12102.htm#NEWFT505 Native JSON] ([[JSON]]) <br>
[https://docs.oracle.com/database/121/NEWFT/chapter12101.htm#NEWFT191 SQL Pattern Matching] <br>
[https://docs.oracle.com/cd/E55822_01/AMAGD/amagd_intro.htm#AMAGD107 Zero Data Loss Recovery Appliance] <br>
Database Cloud Service <br>
<br>
Native Sharding, Zero Data Loss Recovery Appliance, Exadata Cloud Service, Cloud at Customer <br>
==> <br>
[https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-CA4CD6A2-DCE0-4BAF-ADED-58F37DF4902C Native Sharding] <br>
[https://docs.oracle.com/en/cloud/paas/exadata-cloud/csexa/index.html Exadata Cloud Service] <br>
[https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbn/index.html#CSDBN-GUID-450EF945-7107-49AD-A2F7-D50C54F2B5B7 Cloud at Customer] <br>
<br>
Polymorphic Table Functions, Active Directory Integration <br>
==> <br>
Online Database Encryption <br>
[https://docs.oracle.com/en/database/oracle/oracle-database/18/tgdba/tuning-system-global-area.html#GUID-9752E93D-55A7-4584-B09B-9623B33B5CCF In-Memory Indexes for Key-Value Lookups] <br>
[https://docs.oracle.com/en/database/oracle/oracle-database/18/dwhsg/data-warehouse-optimizations-techniques.html#GUID-F7E7DEA6-B225-43E6-97ED-CB3DBE86CD54 Approximate Aggregations] <br>
[https://docs.oracle.com/en/database/oracle/oracle-database/18/lnpls/plsql-optimization-and-tuning.html#GUID-981102A8-5204-4931-B10A-93486304B184 Polymorphic Table Functions] <br>
[https://docs.oracle.com/en/database/oracle/oracle-database/18/dbseg/integrating_mads_with_oracle_database.html#GUID-9739D541-FA9D-422A-95CA-799A4C6F488D Active Directory Integration] <br>
<br>
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. <br>
==> <br>
[https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/tuning-system-global-area.html#GUID-CFADC9EA-2E2F-4EBB-BA2C-3663291DCC25 In-Memory for IoT Streaming] <br>
[https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-indexes.html#GUID-D1285CD5-95C0-4E74-8F26-A02018EA7999 Automatic Index Creation] <br>
[https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/optimizer-statistics-concepts.html#GUID-769E609D-0312-43A7-9581-3F3EACF10BA9 Real-Time Statistics Maintenance] <br>
SQL Queries on Object Stores <br>
[https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/managing-oracle-data-guard-physical-standby-databases.html#GUID-8AAD002C-ED06-4349-8BB5-EC8DB30B2628 Issue DML on Active Data Guard] <br>
<br>
Thanks to let me know.
[[User:JFVerrier|JFVerrier]] ([[User talk:JFVerrier|talk]]) 09:38, 30 September 2019 (UTC)JFVerrier
== 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.
[[User:JFVerrier|JFVerrier]] ([[User talk:JFVerrier|talk]]) 09:59, 30 September 2019 (UTC)JFVerrier
== 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. [[User:Djm-leighpark|Djm-leighpark]] ([[User talk:Djm-leighpark|talk]]) 10:01, 30 September 2019 (UTC)
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,
[[User:JFVerrier|JFVerrier]] ([[User talk:JFVerrier|talk]]) 12:32, 30 September 2019 (UTC)JFVerrier
== 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.
{{collapsed bottom}}
Thanks to let me know.
[[User:JFVerrier|JFVerrier]] ([[User talk:JFVerrier|talk]]) 10:01, 30 September 2019 (UTC)JFVerrier
===Reply 30-SEP-2019===
{{border |[[File:Crystal_Clear_app_help_index.svg|20px]]{{nbsp|2}}'''Clarification requested'''{{nbsp|2}}|display=table |width=1px |style=double |style2=dotted |color=black |lh=1}}
* 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.<ref>{{cite web |title=Template:Request edit |url=https://en.wikipedia.org/wiki/Template:Request_edit/Instructions#Current_requested_edits |website=Wikipedia |language=en |date=15 September 2018 |quote=<u>Instructions for Submitters</u>: 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.}}</ref>
# Reasons should be provided for each change.<ref>{{cite web |title=Template:Request edit |url=https://en.wikipedia.org/wiki/Template:Request_edit/Instructions#Current_requested_edits |website=Wikipedia |language=en |date=15 September 2018 |quote=<u>Instructions for Submitters</u>: If the rationale for a change is not obvious (particularly for proposed deletions), explain.}}</ref>
* In the section of text below titled ''Sample edit request'', the four required items are shown as an example:
{{collapse top|Sample edit request|float=center|width=40%|bg=#DCDCDC}}
<blockquote style="background:white;width:90%; padding:1em; border:1px solid #999;">
{{font|text=1.|font=|size=200%|color=#3b5cff}} Please '''''remove''''' the third sentence from the second paragraph of the ''Sun'' section:<br><br>
:"The Sun's diameter is estimated to be approximately 25 miles in length."<br><br>
----
<br>
{{font|text=2.|font=|size=200%|color=#3b5cff}} Please '''''add''''' the following claim as the third sentence of the second paragraph of the ''Sun'' section:<br><br>
:"The Sun's diameter is estimated to be approximately 864,337 miles in length."<br><br>
----
<br>
{{font|text=3.|font=|size=200%|color=#3b5cff}} Using as the '''reference''':<br><br>
:{{cite book|last1=Paramjit Harinath|first1=|title={{blue|The Sun}}|publisher=Academic Press|date=2019|page=1}}<br><br>
----
<br>
{{font|text=4.|font=|size=200%|color=#3b5cff}} '''Reason''' for change being made:<br><br>
:"The previously given diameter was incorrect."
{{reflist-talk}}
</blockquote>
{{collapsed bottom}}
{{clear}}
*Kindly open a new edit request at your earliest convenience when ready to proceed with all four items from your request. Thank you!
<br>Regards, <span style="font-size:75%;border:2px solid red;border-radius:50px;font-color:#00008b">[[User talk:Spintendo|<span style="color:#00008b;"> <b>Spintendo</b> </span>]]</span> 13:12, 30 September 2019 (UTC)
== Edit Request - 0 on 30-Sept-2019: Add Goal sentence in the first paragrah of the Oracle Database ==
| 