Talk:Oracle Database: Difference between revisions

Revision as of 08:28, 1 October 2019

Revision as of 08:30, 1 October 2019

Line 23:

|archive = Talk:Oracle Database/Archive %(counter)d

}}

==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

<!-- Template:Unsigned --><small class="autosigned">—&nbsp;Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[User:Oogalook|Oogalook]] ([[User talk:Oogalook#top|talk]] • [[Special:Contributions/Oogalook|contribs]]) 14:52, 24 June 2017 (UTC)</small>

== [[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. [[User:Mel Etitis|Mel Etitis]] ([[User talk:Mel Etitis|<font color="green">&Mu;&epsilon;&lambda; &Epsilon;&tau;&eta;&tau;&eta;&sigmaf;</font>)]] 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.

<!-- Template:Unsigned --><small class="autosigned">—&nbsp;Preceding [[Wikipedia:Signatures|unsigned]] comment added by [[User:Slothie|Slothie]] ([[User talk:Slothie#top|talk]] • [[Special:Contributions/Slothie|contribs]]) 17:47, 18 January 2007 (UTC)</small>

== Edit Request on 31-JAN-2019 ==

Line 230 ⟶ 256:

[[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 ==

Line 275 ⟶ 332:

::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