Talk:Oracle Database/Notes: Difference between revisions

Content deleted Content added
Ccraft us (talk | contribs)
Ccraft us (talk | contribs)
Line 31:
* 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 ⟶ 50:
 
'''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.