Talk:Oracle Database: Difference between revisions

Content deleted Content added
JFVerrier (talk | contribs)
No edit summary
Remove NAS 348 Global Climate Change assignment details
 
(22 intermediate revisions by 16 users not shown)
Line 1:
{{talkheaderTalk header}}
{{WikiProject banner shell|class=C|
{{WPBS|collapse=no|1=
{{WikiProject Computing|class=C|importance=mid |software=yes|software-importance=high}}
{{WPDATABASE|class=CWikiProject Databases|importance=High}}
}}
{{COI editnotice}}
{{tmbox
<!-- | small = {{{small|}}} -->
| type = content
| style = background:#fffaef; border: 1px solid #c0c090;
| class = wpb-outside<!--don't display inside banner shells-->
| image = none
|text= <br/>'''Workpage:''' [[Talk:Oracle Database/Notes]]'''<br/><br/>
<small>''The workpage contains some guidelines and information related to article development''</small>
}}
{{COI editnotice}}
{{to do|inner= [[Talk:Oracle Database/Notes]] contains some guidelines and information related to article development}}
{{User:MiszaBot/config
|archiveheader = {{talk archive navigation}}
Line 23 ⟶ 15:
|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;">&nbsp;<b>Spintendo</b>&nbsp;</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 ==
 
== version 23.x ==
==Add Goal sentence in the first paragraph==
{{request edit|D|Wikipedia is not for advertising}}
 
Information to be added: Please add the following claim as the last sentence of the first paragraph :<br>
 
"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."<br>
 
<br>
right after<br>
<br>
"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] "<br>
 
 
Explanation of the change: This is one of the most important goals of the Oracle Database and it is missing in the article.<br>
<br>
 
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]]) 15:55, 30 September 2019 (UTC)JFVerrier
 
:Why is this goal important? Who (other than Oracle employees) say so? Why are those technologies cutting edge? Who says so? - [[User:MrOllie|MrOllie]] ([[User talk:MrOllie|talk]]) 16:04, 30 September 2019 (UTC)
 
::Thanks [[User:MrOllie|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.
::[[User:JFVerrier|JFVerrier]] ([[User talk:JFVerrier|talk]]) 17:40, 30 September 2019 (UTC)JFVerrier
 
===Reply 30-SEP-2019===
{{tq|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,{{efn|A ''purpose'' is just another way of saying a ''goal''.}} 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, <span style="font-size:75%;border:2px solid red;border-radius:50px;font-color:#00008b">[[User talk:Spintendo|<span style="color:#00008b;">&nbsp;<b>Spintendo</b>&nbsp;</span>]]</span> 18:19, 30 September 2019 (UTC)
{{notelist-talk}}
 
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
[[User:JFVerrier|JFVerrier]] ([[User talk:JFVerrier|talk]]) 20:00, 30 September 2019 (UTC)JFVerrier
 
 
===Reply 01-OCT-2019===
I suggest adding the following claim as the last sentence of the first paragraph :
<br>
"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|polyglot persistence]]: <br>
* [https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/introduction-to-oracle-database.html#GUID-A42A6EF0-20F8-4F4B-AFF7-09C100AE581E Relational data]<br>
* [https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/introduction-to-oracle-database.html#GUID-AB84D6C9-4BBE-4D36-992F-2BB85739329F Multitenancy]<br>
* [https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/introduction-to-oracle-database.html#GUID-8F1E6C26-A65A-4D62-B236-BFE3DA6CD43F Sharding] <br>
* [https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/topics-for-database-administrators-and-developers.html#GUID-8BD6B3E1-F917-47E5-93EB-0542E636EA34 Analytics]<br>
* [https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/topics-for-database-administrators-and-developers.html#GUID-764C5ADD-EF6F-4C4C-99AC-F3304E0F8EB6 Machine Learning]<br>
* [https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/concepts-for-database-developers.html#GUID-96C373BA-E82B-4F32-87AF-C6F46BFDC33F XML]<br>
* [https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/concepts-for-database-developers.html#GUID-41DDC7DF-75E8-417B-A160-173D594F3356 JSON]<br>
* [https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/concepts-for-database-developers.html#GUID-F3C48565-B360-40F2-A201-239D614139B5 Spatial and Graph]<br>
* [https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/concepts-for-database-developers.html#GUID-9DC67BF2-1624-4F2D-A839-AEC6D334F72F Text]<br>
* [https://docs.oracle.com/en/database/other-databases/nosql-database/19.3/concepts/data-models.html Key-Value Store]<br>
* [https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/concepts-for-database-developers.html#GUID-E918382E-0E0A-444C-ABD3-BCC6EFC0AB38 Large Objects]
<br>
right after<br>
<br>
"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] "<br>
 
Explanation: <br>
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.<br><br>
References supporting change: <br>
Minute 37:22 from [https://www.oracle.com/openworld/on-demand.html?bcid=6087202381001 Video] delivered by Juan Loaiza (Oracle EVP System Technology) and links for each technology in the text above pointing to the official Oracle documentation.
[[User:JFVerrier|JFVerrier]] ([[User talk:JFVerrier|talk]]) 08:36, 1 October 2019 (UTC)JFVerrier
 
the version I downloaded and installed identifies as "23.0.0".
: I suggest the Oracle website is the best place for marketing claims, not Wikipedia. <b>[[user:JzG|Guy]]</b> <small>([[user talk:JzG|help!]])</small> 09:17, 1 October 2019 (UTC)
this article mentions the initial version as "23.2.0".
what am I missing? [[User:Erwindon|Erwindon]] ([[User talk:Erwindon|talk]]) 23:16, 21 May 2023 (UTC)
 
:With 23.2.0, the .2 is a "release update" version, which is basically a patch version. It's a little more than a normal patch, because sometimes they add new features in the release update. [[Special:Contributions/57.140.28.12|57.140.28.12]] ([[User talk:57.140.28.12|talk]]) 16:19, 30 May 2024 (UTC)
:: I don't think that what we say in this paragraph is marketing, as all references are technical information and sourced directly from the official documentation website which is the legal single source of what the product is about.
:: I find it weird and shocking that you completely wiped out almost the entire previous content of the Oracle Database page without even asking anyone; this right after I was trying to add valuable information. This content was there since years and provided by valuable people.
:: If you apply the same recommendations as these, there are probably hundreds of Wikipedia pages you will have to fix.
:: In addition, the references number 4 and 5 are from the Oracle website, so why are you keeping them in the introduction?
:: I don't see any logic in all this.
[[User:JFVerrier|JFVerrier]] ([[User talk:JFVerrier|talk]]) 13:25, 1 October 2019 (UTC)JFVerrier
 
== Why two initial versions listed for v5 ==
== Purpose of Wikipedia ==
 
Why are two initial versions listed for v5
Wikipedia is not intended to be a [[WP:HOWTO|How-To]] guide or technical manual. Much of the technical content would be fine at Wikibooks but not here - virtually all of it was drawn from Oracle publications either on its own website or sponsored. I realise that Oracle's website is a nightmare, and finding things like platform support by version is often a challenge, but we're here to describe things for a lay audience, not to provide a technical reference.
 
5.0.22 (5.1.17) [[User:GrandPoohBah|GrandPoohBah]] ([[User talk:GrandPoohBah|talk]]) 00:41, 2 March 2024 (UTC)
We could do with sections on Oracle engineered systems, RAC and the like, but drawn from reliable independent sources and describing them, not telling people how to specify and use them. <b>[[user:JzG|Guy]]</b> <small>([[user talk:JzG|help!]])</small> 09:41, 1 October 2019 (UTC)