![]() | This is an archive of past discussions. Do not edit the contents of this page. If you wish to start a new discussion or revive an old one, please do so on the current talk page. |
Archive 1 |
I am trying to rewrite relational database and am soliciting opinions. I am particularly interested in bringing in the practical and popular definitions of the term to counter the current article's domination by the "theoretical" crowd. Ideogram 11:11, 11 June 2006 (UTC)
"Oracle and IBM tend to battle for the mid-range market". While this is true, I would say they also battle for the high-end market - indeed, Oracle, DB/2, and Teradata are pretty much the entire high-end market...unless I'm missing something in the definition here. Afabbro 04:30, 27 May 2007 (UTC)
Yes, "Oracle database" can just be a general term for "a database held on one of Oracle's RDBMS products", but this is an encyclopedia. We should stick to defining "Oracle database" as being the RDBMS application and qualify other uses in an appropriate manner. The intro seems pretty hopelessly mushy right now, and I can't think what it must be like for people who don't already have a clear understanding between the different meanings "database" can have.
For that matter, we could do with moving this to a less ambiguous name, but one step at a time. Chris Cunningham 12:28, 13 July 2007 (UTC)
This talk page seems to have pretty low activity, but I want to go ahead and move this article from Oracle database to something closer to the actual product name, either Oracle RDBMS or simply Oracle Database (with the 2nd word capitalized), preferably the former. I don't see how a database of any brand would refer to the software that manipulates it, rather than the actual entity on disk. From what I can tell, the base product name is simply Oracle, released by SDL who later renamed themselves to Oracle Corporation. I see they have other Oracle _____ products, so Oracle RDBMS seems like the best name to use to refer to this specific product. Mentioning the literal database entity at the beginning of the introduction is confusing.
If you see this comment before I act, please give your opinion. I'm in between class right now, so I'll probably do it later tonight (EST time) or tomorrow. -- DJ Phazer 14:50, 5 September 2007 (UTC)
I'm new to wikipedia, so go easy on me :)
in the fourth paragraph under "Physical and logical structuring" there is a link from user objects to http://en.wikipedia.org/wiki/Object_%28computer_science%29 . As far as I know, database user objects are different from OO Programming objects. Should this link be here, or is it misleading? 75.26.36.92 00:27, 7 November 2007 (UTC)
"1979: Larry Ellison and friends founded..."
According to entry Oracle_Corporation, it was in 1977. The name change in the same year doesn't make sense. —Preceding unsigned comment added by 65.96.133.16 ( talk) 12:24, 7 November 2007 (UTC)
I suggest that 'imprecisely' be changed to 'implicitly', and the rest of the intro reworded accordingly, for the following reasons.
Comments? -- Perey 18:44, 22 August 2005 (UTC)
<<The title of this article — and parts of the article content — perpetuate this confusion.>> muhahahahahaha
yeeah baby —Preceding
unsigned comment added by
59.165.132.154 (
talk)
09:29, 29 December 2007 (UTC)
I'm concerned about the list of Oracle "firsts" not being accurate. I've added a "citation needed" in a couple places. The first on Linux claim might be incorrect, since I'm finding references to IBM DB2 shipping slightly earlier. Similarly, the "shared everything" claim falls down with DB2 for z/OS and Parallel Sysplex data sharing, which appeared years before Oracle's implementation.
Could someone check these out more thoroughly?
-- The "first web database" things a bit suspect as well frankly. What does that even *mean*?. Where all those databases used on the web not webby enough? 203.59.162.212 06:46, 8 June 2007 (UTC)
-- The first proprietary database on Linux claim is incorrect. Informix SE came out on July 23, 1998: http://www.linuxjournal.com/article/3110 Oracle issued a press release saying that the company would support Linux, also in July 1998, but the actual release wasn't until later that year. http://lwn.net/1999/features/1998timeline/ 198.144.202.253 ( talk) 20:41, 6 February 2008 (UTC)
The article gives two different definitions, in paragraphs that are quite close from one another:
iSQL*Plus, a web-browser-based interface to Oracle database DML
and
SQL*Plus, a CLI-based program that allows users to interact with Oracle database(s) via SQL and PL/SQL commands.
Can somebody clarify, please? -- AVM ( talk) 23:01, 27 February 2008 (UTC)
The article states that Standard Edition One "has some additional feature-restrictions" but the link at [26] says "Standard Edition One is an affordable, full-featured database". So, are there any restrictions in One, and if so, which?
Also, IMHO, the description of the various editions should go into more detail. Any expert on the subject?
wr 87.139.81.19 ( talk) 07:35, 30 May 2008 (UTC)
The image Image:Oracle logo.svg is used in this article under a claim of fair use, but it does not have an adequate explanation for why it meets the requirements for such images when used here. In particular, for each page the image is used on, it must have an explanation linking to that page which explains why it needs to be used on that page. Please check
This is an automated notice by FairuseBot. For assistance on the image use policy, see Wikipedia:Media copyright questions. -- 00:51, 1 October 2008 (UTC)
Still learning the guidelines re. copyrighted web sites. Oracle's information page has installation guides for a number of platforms for 10g. Could that be used to update the outdated list in this article? Thanks. Rxmz20 ( talk) 14:39, 19 May 2009 (UTC)
I did some completes (??) installation guide for the latest RDBMS version... why not giving some links on this page ?? —Preceding unsigned comment added by Wwwdjtoniofr ( talk • contribs) 20:44, 5 October 2007 (UTC)
Refering to Oracle Express Edition I believe that user data is limited to 4GB and not 11GB. See http://www.oracle.com/us/products/database/product-editions-066501.html — Preceding unsigned comment added by 94.132.98.109 ( talk) 19:36, 21 January 2012 (UTC)
This piece of code shows that Oracle considers an empty string to be equivalent to null:
set serveroutput on
DECLARE
v_name varchar2(30) not null := ' '; -- a single space is considered an empty string
-- an actual empty string ('') is considered null and gives an error
BEGIN
DBMS_OUTPUT.PUT_LINE('Name is: ['||v_name||']');
v_name := 'EXAMPLE NAME';
DBMS_OUTPUT.PUT_LINE('Name is: ['||v_name||']');
v_name := ' ';
DBMS_OUTPUT.PUT_LINE('Name is: ['||v_name||']');
END; — Preceding
unsigned comment added by
141.146.28.114 (
talk)
09:09, 19 October 2012 (UTC)
Surely, this is not the case. I am unsure which is the first but, amongst others, IBM System R and Logica Rapport were around before Oracle, I believe. Can someone clarify please? Geoff97 18:09, 1 Jan 2004 (UTC)
RSI was started in 1979. There are references to other RDBMSs before that date, which seems to eliminate Oracle as the first. The question is which was the first? See #10 here for a reference to RAPPORT-3 from Logica: [3] Geoff97 10:33, 2 Jan 2004 (UTC)
If you take the strict definition, then there are no RDBMSs, so Oracle wasn't the first. If you take a less strict view and ask what was the first near-RDBMS, that wasn't Oracle either, but we're not sure what was. So, in the statement "and introduced their product Oracle V2 as the first commercial relational database system" I propose to change "the first" to "an early" to make this NPOV. In the bulleted list of firsts towards the end I propose to remove the first RDBMS claim completely. Geoff97 17:49, 2 Jan 2004 (UTC)
I've twice removed an external URL to one single commercial product that IP editor 96.242.234.34 has littered about Wikipedia. Editor has placed product advertisement links in Oracle Database, IBM DB2 database, various other database articles and even in remote sensing. I've left notes on the IP editor's talk page and IP editor has ignored an admonition to cease using Wikipedia to promote one product. Another editor had done similar last month. IP editor then added the reverted link and was reverted. One more revert by IP editor will result in an AIV report. Wzrd1 ( talk) 15:32, 2 May 2014 (UTC)
This article really needs a total rewrite. As a start, it really needs to start with a general overview of how all the components fit together, but in a more comprehensive and less technical manner. For instance, we really don't need to know the exact initialize parameters, though a discussion of what an init parameter is would be good.
I'll give this some thought as I'm thinking of doing something about this article. - Tbsdy lives (formerly Ta bu shi da yu) talk 12:24, 25 December 2009 (UTC)
If anyone can do a rewrite to make this more intelligible, please do but be aware that the RDBMS is no longer anywhere close to being as simple as portrayed in the suggestions above.
For example, the process model illustrated here is long out of date: By the time I retired from the Oracle Server Technologies Division the number of server processes had at least doubled from those shown here. Some notable missing process types are Streams coordinators and slaves. Within the kernel the most important processes are generally those for user sessions, with some special cases when using RAC. For the area that I worked in, RECO processes were often significant for two-phase-commit error recovery. There are some additional new processes that I won't mention because several were added in a major version of the product that might not be released yet. Also, at the time I retired a number of them seemed to be not yet documented.
About the comment at the top of the page saying that the page has too much jargon -- In all honesty, this seems VERY naive. This is a highly technical product, it's not possible to talk about it without using some of its subject-specific vocabulary. This page is in fact very mild in the degree of specialized language that it uses. Perhaps Wikipedia should have separate pages for different classes of readers.
Paul Raveling ( talk) 06:47, 8 September 2010 (UTC)
On Microsoft Windows Server platforms, I think the "process model" is actually implemented as Windows threads (or certainly used to be), and therefore it is less easy to see PMON, SMON etc process architecture from the Windows Task manager (more detailed process monitoring tools will expose the process architecture).
193.35.250.233 ( talk) 10:47, 16 February 2016 (UTC)
Wiki policy is strongly against capitalisation in names and titles. As "Oracle" is known (as a proper name) as "Oracle" rather than "Oracle Database", why should it be capitalised here? Wiki is very much against following "non-sentence" capitalisation for product names, no matter what the product owner calls it. Even terms that are generally treated as proper noun phrases or with strong dependencies on capitalisation (like Software as a Service, SaaS ) often lose their capitals here. Viam Ferream ( talk) 09:50, 14 January 2016 (UTC)
This article has been totally destroyed. It's not at all in the style of an encyclopedia. I see no other option but to restart it from scratch. — Preceding unsigned comment added by Bohan ( talk • contribs) 10:53, 3 March 2017 (UTC)
Some sections go into and list details that don't seem appropiate for a Wikipedia article. For example, the "Physical and logical structures" section contains listings of various internal processes and C data structures. That entire section should be limited to a succinct overview of what the database uses (physical) or represents (logical). We'll leave the process listings to Oracle books.
"Deployment" and "Use" have some overlap and it's not made very clear why they both are around.
"Database options and features" looks a lot like it's just listing every feature in the database; again the encyclopedic value is not quite clear here. Perhaps just summarize some prominent features and source it with a feature list provided in a source.
-- Phiarc ( talk) 17:16, 25 June 2018 (UTC)
Oracle provides the free (as in at no cost) Oracle Instant Client middleware, that enables running Oracle DB clients on various platforms. Isn't that valuable information, worth being quoted in the article? -- johayek ( talk) 08:48, 3 July 2018 (UTC)
Although I just reverted a set of changes marked as minor one suggest that RDBMS be changed to DBMS. It's also to be noted Oracle Corporation supplies/supplied or has stewardship of a number of databases including Oracle NoSQL Database. Any thoughts?. Djm-leighpark ( talk) 17:11, 30 January 2019 (UTC)
RDBMS refers to a database using the relational model, whereas DBMS refers generally to database management systems regardless of the data model types supported by that software. Oracle was originally developed as a relational database management system, but subsequently added a wide variety of other data modeling approaches including Object-Relational (ORDBMS), Graph, Spatial, multi-dimensional (cube structures), key/value, and document. Ccraft us ( talk) 18:08, 30 January 2019 (UTC)
Also note the first sentence refers to Oracle as both "relational" (RDBMS) and "multi-model", which is a conflict in terms. Using the general term Database Management System (DBMS) eliminates that conflict. Ccraft us ( talk) 21:04, 30 January 2019 (UTC)
Regarding the other databases from Oracle, those include MySQL, Oracle NoSQL Database, and TimesTen. Ccraft us ( talk) 03:15, 31 January 2019 (UTC)
I just did a load of reversions to the lead on a technicality that they were marked as minor. But I will also comment is probably unsatisfactory. In my opinion the lede should be in general terms that make sense to a tweleve year old (or your average manager) and not going into technie details the technies can find in the body. And the lede should also be supported by the body. It's more important to say how it is an enterprise level database theat has evolved over time. Probably also need to mention Oracle Corporation also does other database management systems as well. But it's possibly necessary to gain consensus before doing a re-write. I havan't got time to even try at present. Djm-leighpark ( talk) 17:26, 30 January 2019 (UTC)
I will re-submit the changes as a request for edit on the talk page, since I am an employee of Oracle. I will avoid anything that isn't (yet) supported in the body of the article, or possibly provide supporting detail to be placed in the body simultaneously with my suggestions for the lead section. Please reply with your advise if you have suggestions on a better approach. Ccraft us ( talk) 03:51, 31 January 2019 (UTC)
The 1979 version 2 would generally be agreed to be an RDBMS, however was it SQL based? My hazy and possibly recollection from reading some decades ago is the intitial version(s) were not SQL based but simply used the OCI. Of course their may have been an SQL pre-processor. Referring to http://www.dba-oracle.com/t_history_oracle.htm ... and I might prefer to find an alternative reference with no disrespect to that author ... it was 1983 version 3 that first supported the execution of SQL statements and transactions. Djm-leighpark ( talk) 07:09, 26 April 2018 (UTC)
Oracle version 2 was SQL based. Version 2 was released and desupported long before the World Wide Web, so it's difficult to locate online resources to prove this. It's entirely possible a library somewhere has a printed copy of the version 2 manuals, or Larry Ellison might have a copy in his personal collection. I would offer these links to show that Oracle Version 2 was SQL-based:
Oracle was not the first Relational DBMS, but was the first made available as a commercial product and it used the SQL language. Ccraft us ( talk) 11:18, 31 January 2019 (UTC)
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)
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)
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.
— Preceding unsigned comment added by Slothie ( talk • contribs) 17:47, 18 January 2007 (UTC)
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
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
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
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
![]() | This edit request by an editor with a conflict of interest was declined. [See below] |
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 Edit RequestsCan 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) 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 Edit Request on 31-JAN-2019
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.
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.
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
Sample edit request
|
---|
|
Regards,
Spintendo
13:12, 30 September 2019 (UTC)
![]() | This edit request by an editor with a conflict of interest was declined. Wikipedia is not for advertising |
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
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)
Notes
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
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
JFVerrier ( talk) 13:25, 1 October 2019 (UTC)JFVerrier
Wikipedia is not intended to be a 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.
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. Guy ( help!) 09:41, 1 October 2019 (UTC)
JFVerrier ( talk) 13:44, 1 October 2019 (UTC)JFVerrier
The last line in the main article does not appear to follow NPOV. Using words like 'fleecing' suggest underhand dealings by the company. This should be rephrased and citations about legal cases/controversies given. — Preceding unsigned comment added by KimballKinnison ( talk • contribs) 12:10, 25 July 2020 (UTC)
This article was the subject of a Wiki Education Foundation-supported course assignment, between 6 September 2020 and 7 December 2020. Further details are available
on the course page. Student editor(s):
LBJJames.
Above undated message substituted from Template:Dashboard.wikiedu.org assignment by PrimeBOT ( talk) 05:47, 17 January 2022 (UTC)
![]() | This is an archive of past discussions. Do not edit the contents of this page. If you wish to start a new discussion or revive an old one, please do so on the current talk page. |
Archive 1 |
I am trying to rewrite relational database and am soliciting opinions. I am particularly interested in bringing in the practical and popular definitions of the term to counter the current article's domination by the "theoretical" crowd. Ideogram 11:11, 11 June 2006 (UTC)
"Oracle and IBM tend to battle for the mid-range market". While this is true, I would say they also battle for the high-end market - indeed, Oracle, DB/2, and Teradata are pretty much the entire high-end market...unless I'm missing something in the definition here. Afabbro 04:30, 27 May 2007 (UTC)
Yes, "Oracle database" can just be a general term for "a database held on one of Oracle's RDBMS products", but this is an encyclopedia. We should stick to defining "Oracle database" as being the RDBMS application and qualify other uses in an appropriate manner. The intro seems pretty hopelessly mushy right now, and I can't think what it must be like for people who don't already have a clear understanding between the different meanings "database" can have.
For that matter, we could do with moving this to a less ambiguous name, but one step at a time. Chris Cunningham 12:28, 13 July 2007 (UTC)
This talk page seems to have pretty low activity, but I want to go ahead and move this article from Oracle database to something closer to the actual product name, either Oracle RDBMS or simply Oracle Database (with the 2nd word capitalized), preferably the former. I don't see how a database of any brand would refer to the software that manipulates it, rather than the actual entity on disk. From what I can tell, the base product name is simply Oracle, released by SDL who later renamed themselves to Oracle Corporation. I see they have other Oracle _____ products, so Oracle RDBMS seems like the best name to use to refer to this specific product. Mentioning the literal database entity at the beginning of the introduction is confusing.
If you see this comment before I act, please give your opinion. I'm in between class right now, so I'll probably do it later tonight (EST time) or tomorrow. -- DJ Phazer 14:50, 5 September 2007 (UTC)
I'm new to wikipedia, so go easy on me :)
in the fourth paragraph under "Physical and logical structuring" there is a link from user objects to http://en.wikipedia.org/wiki/Object_%28computer_science%29 . As far as I know, database user objects are different from OO Programming objects. Should this link be here, or is it misleading? 75.26.36.92 00:27, 7 November 2007 (UTC)
"1979: Larry Ellison and friends founded..."
According to entry Oracle_Corporation, it was in 1977. The name change in the same year doesn't make sense. —Preceding unsigned comment added by 65.96.133.16 ( talk) 12:24, 7 November 2007 (UTC)
I suggest that 'imprecisely' be changed to 'implicitly', and the rest of the intro reworded accordingly, for the following reasons.
Comments? -- Perey 18:44, 22 August 2005 (UTC)
<<The title of this article — and parts of the article content — perpetuate this confusion.>> muhahahahahaha
yeeah baby —Preceding
unsigned comment added by
59.165.132.154 (
talk)
09:29, 29 December 2007 (UTC)
I'm concerned about the list of Oracle "firsts" not being accurate. I've added a "citation needed" in a couple places. The first on Linux claim might be incorrect, since I'm finding references to IBM DB2 shipping slightly earlier. Similarly, the "shared everything" claim falls down with DB2 for z/OS and Parallel Sysplex data sharing, which appeared years before Oracle's implementation.
Could someone check these out more thoroughly?
-- The "first web database" things a bit suspect as well frankly. What does that even *mean*?. Where all those databases used on the web not webby enough? 203.59.162.212 06:46, 8 June 2007 (UTC)
-- The first proprietary database on Linux claim is incorrect. Informix SE came out on July 23, 1998: http://www.linuxjournal.com/article/3110 Oracle issued a press release saying that the company would support Linux, also in July 1998, but the actual release wasn't until later that year. http://lwn.net/1999/features/1998timeline/ 198.144.202.253 ( talk) 20:41, 6 February 2008 (UTC)
The article gives two different definitions, in paragraphs that are quite close from one another:
iSQL*Plus, a web-browser-based interface to Oracle database DML
and
SQL*Plus, a CLI-based program that allows users to interact with Oracle database(s) via SQL and PL/SQL commands.
Can somebody clarify, please? -- AVM ( talk) 23:01, 27 February 2008 (UTC)
The article states that Standard Edition One "has some additional feature-restrictions" but the link at [26] says "Standard Edition One is an affordable, full-featured database". So, are there any restrictions in One, and if so, which?
Also, IMHO, the description of the various editions should go into more detail. Any expert on the subject?
wr 87.139.81.19 ( talk) 07:35, 30 May 2008 (UTC)
The image Image:Oracle logo.svg is used in this article under a claim of fair use, but it does not have an adequate explanation for why it meets the requirements for such images when used here. In particular, for each page the image is used on, it must have an explanation linking to that page which explains why it needs to be used on that page. Please check
This is an automated notice by FairuseBot. For assistance on the image use policy, see Wikipedia:Media copyright questions. -- 00:51, 1 October 2008 (UTC)
Still learning the guidelines re. copyrighted web sites. Oracle's information page has installation guides for a number of platforms for 10g. Could that be used to update the outdated list in this article? Thanks. Rxmz20 ( talk) 14:39, 19 May 2009 (UTC)
I did some completes (??) installation guide for the latest RDBMS version... why not giving some links on this page ?? —Preceding unsigned comment added by Wwwdjtoniofr ( talk • contribs) 20:44, 5 October 2007 (UTC)
Refering to Oracle Express Edition I believe that user data is limited to 4GB and not 11GB. See http://www.oracle.com/us/products/database/product-editions-066501.html — Preceding unsigned comment added by 94.132.98.109 ( talk) 19:36, 21 January 2012 (UTC)
This piece of code shows that Oracle considers an empty string to be equivalent to null:
set serveroutput on
DECLARE
v_name varchar2(30) not null := ' '; -- a single space is considered an empty string
-- an actual empty string ('') is considered null and gives an error
BEGIN
DBMS_OUTPUT.PUT_LINE('Name is: ['||v_name||']');
v_name := 'EXAMPLE NAME';
DBMS_OUTPUT.PUT_LINE('Name is: ['||v_name||']');
v_name := ' ';
DBMS_OUTPUT.PUT_LINE('Name is: ['||v_name||']');
END; — Preceding
unsigned comment added by
141.146.28.114 (
talk)
09:09, 19 October 2012 (UTC)
Surely, this is not the case. I am unsure which is the first but, amongst others, IBM System R and Logica Rapport were around before Oracle, I believe. Can someone clarify please? Geoff97 18:09, 1 Jan 2004 (UTC)
RSI was started in 1979. There are references to other RDBMSs before that date, which seems to eliminate Oracle as the first. The question is which was the first? See #10 here for a reference to RAPPORT-3 from Logica: [3] Geoff97 10:33, 2 Jan 2004 (UTC)
If you take the strict definition, then there are no RDBMSs, so Oracle wasn't the first. If you take a less strict view and ask what was the first near-RDBMS, that wasn't Oracle either, but we're not sure what was. So, in the statement "and introduced their product Oracle V2 as the first commercial relational database system" I propose to change "the first" to "an early" to make this NPOV. In the bulleted list of firsts towards the end I propose to remove the first RDBMS claim completely. Geoff97 17:49, 2 Jan 2004 (UTC)
I've twice removed an external URL to one single commercial product that IP editor 96.242.234.34 has littered about Wikipedia. Editor has placed product advertisement links in Oracle Database, IBM DB2 database, various other database articles and even in remote sensing. I've left notes on the IP editor's talk page and IP editor has ignored an admonition to cease using Wikipedia to promote one product. Another editor had done similar last month. IP editor then added the reverted link and was reverted. One more revert by IP editor will result in an AIV report. Wzrd1 ( talk) 15:32, 2 May 2014 (UTC)
This article really needs a total rewrite. As a start, it really needs to start with a general overview of how all the components fit together, but in a more comprehensive and less technical manner. For instance, we really don't need to know the exact initialize parameters, though a discussion of what an init parameter is would be good.
I'll give this some thought as I'm thinking of doing something about this article. - Tbsdy lives (formerly Ta bu shi da yu) talk 12:24, 25 December 2009 (UTC)
If anyone can do a rewrite to make this more intelligible, please do but be aware that the RDBMS is no longer anywhere close to being as simple as portrayed in the suggestions above.
For example, the process model illustrated here is long out of date: By the time I retired from the Oracle Server Technologies Division the number of server processes had at least doubled from those shown here. Some notable missing process types are Streams coordinators and slaves. Within the kernel the most important processes are generally those for user sessions, with some special cases when using RAC. For the area that I worked in, RECO processes were often significant for two-phase-commit error recovery. There are some additional new processes that I won't mention because several were added in a major version of the product that might not be released yet. Also, at the time I retired a number of them seemed to be not yet documented.
About the comment at the top of the page saying that the page has too much jargon -- In all honesty, this seems VERY naive. This is a highly technical product, it's not possible to talk about it without using some of its subject-specific vocabulary. This page is in fact very mild in the degree of specialized language that it uses. Perhaps Wikipedia should have separate pages for different classes of readers.
Paul Raveling ( talk) 06:47, 8 September 2010 (UTC)
On Microsoft Windows Server platforms, I think the "process model" is actually implemented as Windows threads (or certainly used to be), and therefore it is less easy to see PMON, SMON etc process architecture from the Windows Task manager (more detailed process monitoring tools will expose the process architecture).
193.35.250.233 ( talk) 10:47, 16 February 2016 (UTC)
Wiki policy is strongly against capitalisation in names and titles. As "Oracle" is known (as a proper name) as "Oracle" rather than "Oracle Database", why should it be capitalised here? Wiki is very much against following "non-sentence" capitalisation for product names, no matter what the product owner calls it. Even terms that are generally treated as proper noun phrases or with strong dependencies on capitalisation (like Software as a Service, SaaS ) often lose their capitals here. Viam Ferream ( talk) 09:50, 14 January 2016 (UTC)
This article has been totally destroyed. It's not at all in the style of an encyclopedia. I see no other option but to restart it from scratch. — Preceding unsigned comment added by Bohan ( talk • contribs) 10:53, 3 March 2017 (UTC)
Some sections go into and list details that don't seem appropiate for a Wikipedia article. For example, the "Physical and logical structures" section contains listings of various internal processes and C data structures. That entire section should be limited to a succinct overview of what the database uses (physical) or represents (logical). We'll leave the process listings to Oracle books.
"Deployment" and "Use" have some overlap and it's not made very clear why they both are around.
"Database options and features" looks a lot like it's just listing every feature in the database; again the encyclopedic value is not quite clear here. Perhaps just summarize some prominent features and source it with a feature list provided in a source.
-- Phiarc ( talk) 17:16, 25 June 2018 (UTC)
Oracle provides the free (as in at no cost) Oracle Instant Client middleware, that enables running Oracle DB clients on various platforms. Isn't that valuable information, worth being quoted in the article? -- johayek ( talk) 08:48, 3 July 2018 (UTC)
Although I just reverted a set of changes marked as minor one suggest that RDBMS be changed to DBMS. It's also to be noted Oracle Corporation supplies/supplied or has stewardship of a number of databases including Oracle NoSQL Database. Any thoughts?. Djm-leighpark ( talk) 17:11, 30 January 2019 (UTC)
RDBMS refers to a database using the relational model, whereas DBMS refers generally to database management systems regardless of the data model types supported by that software. Oracle was originally developed as a relational database management system, but subsequently added a wide variety of other data modeling approaches including Object-Relational (ORDBMS), Graph, Spatial, multi-dimensional (cube structures), key/value, and document. Ccraft us ( talk) 18:08, 30 January 2019 (UTC)
Also note the first sentence refers to Oracle as both "relational" (RDBMS) and "multi-model", which is a conflict in terms. Using the general term Database Management System (DBMS) eliminates that conflict. Ccraft us ( talk) 21:04, 30 January 2019 (UTC)
Regarding the other databases from Oracle, those include MySQL, Oracle NoSQL Database, and TimesTen. Ccraft us ( talk) 03:15, 31 January 2019 (UTC)
I just did a load of reversions to the lead on a technicality that they were marked as minor. But I will also comment is probably unsatisfactory. In my opinion the lede should be in general terms that make sense to a tweleve year old (or your average manager) and not going into technie details the technies can find in the body. And the lede should also be supported by the body. It's more important to say how it is an enterprise level database theat has evolved over time. Probably also need to mention Oracle Corporation also does other database management systems as well. But it's possibly necessary to gain consensus before doing a re-write. I havan't got time to even try at present. Djm-leighpark ( talk) 17:26, 30 January 2019 (UTC)
I will re-submit the changes as a request for edit on the talk page, since I am an employee of Oracle. I will avoid anything that isn't (yet) supported in the body of the article, or possibly provide supporting detail to be placed in the body simultaneously with my suggestions for the lead section. Please reply with your advise if you have suggestions on a better approach. Ccraft us ( talk) 03:51, 31 January 2019 (UTC)
The 1979 version 2 would generally be agreed to be an RDBMS, however was it SQL based? My hazy and possibly recollection from reading some decades ago is the intitial version(s) were not SQL based but simply used the OCI. Of course their may have been an SQL pre-processor. Referring to http://www.dba-oracle.com/t_history_oracle.htm ... and I might prefer to find an alternative reference with no disrespect to that author ... it was 1983 version 3 that first supported the execution of SQL statements and transactions. Djm-leighpark ( talk) 07:09, 26 April 2018 (UTC)
Oracle version 2 was SQL based. Version 2 was released and desupported long before the World Wide Web, so it's difficult to locate online resources to prove this. It's entirely possible a library somewhere has a printed copy of the version 2 manuals, or Larry Ellison might have a copy in his personal collection. I would offer these links to show that Oracle Version 2 was SQL-based:
Oracle was not the first Relational DBMS, but was the first made available as a commercial product and it used the SQL language. Ccraft us ( talk) 11:18, 31 January 2019 (UTC)
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)
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)
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.
— Preceding unsigned comment added by Slothie ( talk • contribs) 17:47, 18 January 2007 (UTC)
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
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
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
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
![]() | This edit request by an editor with a conflict of interest was declined. [See below] |
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 Edit RequestsCan 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) 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 Edit Request on 31-JAN-2019
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.
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.
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
Sample edit request
|
---|
|
Regards,
Spintendo
13:12, 30 September 2019 (UTC)
![]() | This edit request by an editor with a conflict of interest was declined. Wikipedia is not for advertising |
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
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)
Notes
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
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
JFVerrier ( talk) 13:25, 1 October 2019 (UTC)JFVerrier
Wikipedia is not intended to be a 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.
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. Guy ( help!) 09:41, 1 October 2019 (UTC)
JFVerrier ( talk) 13:44, 1 October 2019 (UTC)JFVerrier
The last line in the main article does not appear to follow NPOV. Using words like 'fleecing' suggest underhand dealings by the company. This should be rephrased and citations about legal cases/controversies given. — Preceding unsigned comment added by KimballKinnison ( talk • contribs) 12:10, 25 July 2020 (UTC)
This article was the subject of a Wiki Education Foundation-supported course assignment, between 6 September 2020 and 7 December 2020. Further details are available
on the course page. Student editor(s):
LBJJames.
Above undated message substituted from Template:Dashboard.wikiedu.org assignment by PrimeBOT ( talk) 05:47, 17 January 2022 (UTC)