Content deleted Content added
Some thoughts on lede. |
|||
| (5 intermediate revisions by 2 users not shown) | |||
Line 5:
===Proposed lede ===
'''Oracle Database''' (or simply 'Oracle') is an [[Enterprise software|enterprise-level]] [[database management system]] (DBMS) developed and marketed by [[Oracle Corporation]]. Version 2.3 in 1979 was the first commercially available [[relational database management system]] (RDBMS) incorporating the [[SQL]] Structured Query Language. The product has been continuously been developed to achieve [[high availability]], accelerated performance, data security, access security, data consistency that are required for enterprises with [[very large database]]s (VLDB) and with multiple users accessing the database. Oracle has been developed to incorporate [[multi-model database]] and [[Cloud computing]] features. <s>Oracle's latest generation product is known as the Oracle Autonomous Database, which was introduced at Oracle Open World in 2017<ref>https://www.forbes.com/sites/oracle/2017/10/02/larry-ellison-introduces-a-big-deal-the-oracle-autonomous-database/</ref>, including Oracle Autonomous Data Warehouse (ADW), and Oracle Autonomous Transaction Processing (ATP) database.</s>
<s>The Oracle database is used for Online Transaction Processing (OLTP), analytics, data warehousing (DW) and mixed (OLTP & DW) database workloads. While Oracle was originally designed for OLTP workloads, Oracle Version 7.1 (released in 1994) added the ability to also process Data Warehouse workloads by paralleling SQL queries. Individual Oracle databases can be devoted to either OLTP or DW workloads, or workloads can be combined into a single database. In addition, OLTP applications that include reporting capabilities can use the same Parallel Query feature normally used for Data Warehouses to generate those reports faster.</s>
===Comments===
Line 15 ⟶ 17:
* I am thinking of a neat way of trying to say where people say 'Oracle' or 'Oracle DBMS' they are usually referring to this product, despite the fact Oracle also has stewardship of over 5 other databases! I've gone back to saying Simply Oracle.[[User:Djm-leighpark|Djm-leighpark]] ([[User talk:Djm-leighpark|talk]]) 00:02, 1 February 2019 (UTC)
* I've tried a rewrite .. this cures some things and introduces others.[[User:Djm-leighpark|Djm-leighpark]] ([[User talk:Djm-leighpark|talk]]) 00:02, 1 February 2019 (UTC)
* I'm starting to understand the process. I am still apprehensive about editing your text directly, even in this work page. Maybe I will add some comments and let you incorporate those into the text as you see fit. [[User:Ccraft us|Ccraft us]] ([[User talk:Ccraft us|talk]]) 14:51, 1 February 2019 (UTC)
* Added 2nd paragraph in the lede outlining Oracle's support for OLTP workloads, DW workloads, and mixed OLTP/DW workloads. [[User:Ccraft us|Ccraft us]] ([[User talk:Ccraft us|talk]]) 20:40, 4 February 2019 (UTC)
* As written the first strike out is too promotional. The second paragraph strike out is also too detailed for the lede (even the remaining lede is too detailed). Don't worry editing my text on the workpage. Even the existing lede is too detailed. This is all my opinion, others opinion may be different.[[User:Djm-leighpark|Djm-leighpark]] ([[User talk:Djm-leighpark|talk]]) 23:01, 4 February 2019 (UTC)
* A thought in passing. I again will comment on my views about what should be it in the lede. In my opinion It is needs to suitable for say a person in a call center or accounts who hears there system runs on an Oracle database and looks it up on Wikipedia. That means minimum technicality. It doesn't need to satisfy softies/technies as they are expected to read the index. What may be useful is a paragraph differential how Oracle Databases uses the term database in the sense MySQL and SQL Server use 'Server'; whilst those products use database in a sense somewhat akin to an Oracle Database Schema; this being a useful point to have in the lede.[[User:Djm-leighpark|Djm-leighpark]] ([[User talk:Djm-leighpark|talk]]) 17:26, 7 February 2019 (UTC)
{{talk-reflist}}
== Article Body ==
===Major Capabilities of Oracle===
Line 31 ⟶ 41:
* Availability
* Reliability
* Security
'''Data Modeling Capabilities''' started with the relational model, but have expanded over the years to include other data modeling techniques. Data modeling refers to the ability of the database to ensure data integrity. The ways in which you can model data have expanded since the 1970's, and Oracle has incorporated those capabilities into the product. One of the latest is the concept of a key/value data store, which is simply a 2 column table with a key and a value, where the value is a complex structure. Oracle supports XML and JSON in that structure, and Oracle ensures the integrity of the XML/JSON contained in the value column. The full range of modeling capabilities Oracle supports are: Relational, Graph, Object-Oriented, Document (also known as "key/value" using XML or JSON), Queue, Spatial, and Multi-Dimensional.
Line 49 ⟶ 60:
'''Reliability''' is a major factor that resulted in user adoption of Oracle originally, and continues to be a reason why users stay with Oracle and continue to build new applications on Oracle. There are some features of the Oracle software that drive reliability, but it's also a factor of Oracle Corporation and how they operate by producing quality code and providing the appropriate support for the product. This is another topic that might be difficult to capture in a Wikipedia article.
'''Security''' is an absolutely critical capability of any database. Oracle started as a CIA project, and Oracle has long included features to address security such as encryption, data redaction, data masking, and something called Database Vault.
Now that I've written out these points, I'm thinking that "performance" and "reliability" are probably 2 topics that can't easily be included in the article. It's probably best to let Oracle make those points themselves.
| |||