Welcome to DaDBm DBMS Blog – the Blog about Oracle, database management systems and IT trends
Most of articles will be dedicated to Oracle database. I’ll cover Oracle database features and DBA strategy, data design and database management.
Below you can see the entire list of my articles / posts. To find a specific post please use Categories, Tags or simply Search. Feel free to comment if your feedback is constructive. Suggestions and ideas are welcome.
This is my personal Blog and the views expressed on these pages are mine.
All content provided here is for informational purposes only.
This web Blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle, its affiliates or other companies.
For wishes and hello’s use Guest Book.
For any other inquires use Contact Form.
SAP HANA was introduced as SAP In-Memory High Performance Analytic Appliance for Real-Time Business Intelligence and Business Analytical applications with the main goal to accelerate analytical functions throw in-memory database and dedicated software and hardware.
SAP HANA is a combination of hardware and software, and it is delivered as an optimized appliance in cooperation with SAP’s partners (IBM, HP, Hitachi, SUSE, etc.). The core part of SAP HANA is the new SAP in-memory database, which is a hybrid in-memory database that combines row-based, column-based, and object-based database technology.
SAP HANA is the next logical step in SAP in-memory computing. Read more »
To help you plan ahead the Oracle database upgrades and patching, below is an Oracle Database Releases roadmap, showing their lifetime support stages (Premier + Extended) for the latest releases.
Oracle Support Notes
- Ensure to maintain Oracle releases that are under Oracle Premium Support (black bars on the chart) or Extended Support (red bars on the chart)
- Extended Support is typically for three years following the expiration of Premier Support and only for the Terminal Patch Set release
- After end of Premium + Extended Support no new patches are released by Oracle + lower SLAs apply for the corresponding database release
- To receive Extended Support, you must:
- Continue to pay the support fee for Premier Support
- Purchase Extended Support on top of Premier Support fee (unless the fee is waived (usually for the 1st year)
- Most ULA/PULA contracts include Extended Support fee
- Enable Extended Support for your Support Identifier (SI) on MOS
Big Data application requirements are usually very extensive and might not fit into one database technology. The list of these requirements can be huge and specific. Some general ones are below:
• Handling huge amounts of unstructured data
• Combination from search and analytical type of queries
• Denormalized data patterns
• Support for high volume writes and read volumes that are not always predictable
• High availability
• No downtime deployments
Perhaps that is the reason why NoSQL solutions are very much application and situation specific based on every product in corresponding category functionality and features. Usually no one NoSQL database matches all the application requirements like usual General-Purpose RDBMS systems. It depends a lot on the application architecture and what NoSQL database fits better you have to decide.
The NoSQL databases have specific characteristics to showcase and they perform best if used for that purpose. So you cannot use a Key-Value store when you need a Graph or Document database for example, while Relational database systems (RDBMS) are all quite compatible.
Then what NoSQL database to choose? Read more »
NoSQL (Not only SQL) term covers different database technologies that were developed to handle huge unstructured data volumes and the frequency in which this data is accessed as well as performance and processing needs. NoSQL is NOT a database that we used to think. In my understanding NoSQL is a range of technologies, approaches and even projects directed to realization of unstructured – so-called Big Data models – that have considerable differences to traditional Relational Database Management Systems (RDBMS). The main goal of NoSQL storage systems is to resolve unstructured data manipulation issues that are not efficiently managed by RDBMS. Note, I’m not saying RDBMS can not manage the same unstructured stuff. On the contrary, with new features the modern RDBMS can do more and more in the Big Data area but obviously not as efficient as some NoSQL solutions.
In practice, “NoSQL” means non-relational database, but this concept of NoSQL does not disclaim SQL language completely often however querying these databases in data-model specific way. Anyway, the underlying query execution strategy is usually very different from the way a traditional RDBMS would use.
Many of the NoSQL platforms allow for RESTful interfaces to the data, while others offer query APIs. NoSQL storage systems are often used in combination with Hadoop Distributed File System that enables large scale computations on clustered servers.
Important to mention that NoSQL databases are not General-Purpose Database Management Systems, but they are very specific to application use cases. Also, NoSQL engines are not compatible to each other and NOT to the General-Purpose DBMSs.
See below some common attributes of noSQL databases:
• Specialized databases for various scenarios
• They manage Unstructured Data (Big Data)
• Often as pure data stores offering just standard APIs for developers
• Non-Relational data model is optimized for the type of data being stored
• Underlying query execution done in data-model specific way
• Usually do NOT support ANSI SQL and ACID standards
• Usually do NOT support transactions and data consistency across entire DB
• Usually optimized for high performance data loads and reads
• Data Updates are often slow
• Table Joins are usually NOT supported
• Usually do NOT include comprehensive Database Manageability features
The data in NoSQL DB engines are represented in a view of hash-tables, tries, documents etc. Based on this representation approach they are divided into four major categories or types: Key-Value Stores, Document Databases, Column Stores and Graph databases. See their description below:
Read more »
Below are major technology announcements or highlights that came from the Oracle OpenWorld conference 2019. Most of them are round Oracle Cloud (OCI), Oracle Autonomous database, Exadata and Linux
Redwood – New User Experience Design
If you navigate to www.oracle.com or cloud.oracle.com you see the new Oracle look & feel called „Redwood“. In future all Oracle Presence will follow this new Modern UX Design, including GUI of Cloud & On-Premises.
Connectivity between OCI & Azur Cloud
Oracle announces close partnership with Microsoft in the area of Oracle Cloud Infrastructure & Microsoft Azure by introducing High Speed Interconnect between OCI & Azur Clouds:Read more »