Trends in Databases
docx
keyboard_arrow_up
School
University of Maryland, University College *
*We aren’t endorsed by this school
Course
630
Subject
Information Systems
Date
Apr 3, 2024
Type
docx
Pages
7
Uploaded by maddogg91
Trends in Databases
(1) Hybrid Databases: Offers characteristics of in-memory databases and on-disk databases combine in a singular architecture. This concept hinges on a database being highly available, scalable, and reliable to justify its use. Adding horizontal scalability (when the amount of data increases, the system typically adds nodes for data storage and computational power) found in NoSQL DB’s, to
the existing frame work of vertical scalability found in most SQL or relational databases, it presents unique opportunities to solve issues. (
What Is Hybrid Database? List of the Best Hybrid Databases
, 2023)
Advantages Of A Hybrid Database Include:
Performance: Sorting, storing and retrieving frequently accessed data entirely happens in-
memory rather than from disk. This indeed makes the Hybrid Database perform fast. Also, Hybrid Databases make use of optimizers to automatically choose the best execution plan on the basis of statistics and the available indexes in order to improve the overall performance irrespective of the data’s location.
Cost: Hard disk is cheaper than RAM. Thus, the money saved can be utilized to add more
memory in order to increase performance.
Persistence: As the RAM chips can’t get close to the storage density of a physical storage disk, the hard drives are still employed to store the data required for later usage. This assures that the data is not lost in case of power failure.
Flexibility: Hybrid databases gives you the capability to execute transactional (OLTP) and analytical (OLAP) workloads parallelly. This is called as HTAP (Hybrid Transactional and Analytical Processing). HTAP provides better flexibility to the developers while updating the existing software or building new software. This makes hybrid databases highly suitable for real-time, data-driven apps.
Rows and Columns: Hybrid Database allows for both row-based and column-based storage. This helps in optimizing both transactional and analytical queries, thereby resulting in faster searching and reporting. A hybrid storage plan in a unified database gives a highly efficient platform, with all data stored in a manner that optimizes the task at hand.
Deployment: Hybrid Database allows for both cloud-based deployments and on-premise deployments. Cloud-based deployment removes the necessity for continuous management of database and technology by internal IT resources. In the meantime, on-
premise deployment gives better control when required. This indeed helps the businesses to use their resources and staff in a more efficient way.
(
What Is Hybrid Database? List of the Best Hybrid Databases
, 2023)
a.
Multi-cloud which utilizes varying combinations of cloud vendors inside the same
architecture.
b.
Hybrid-cloud combines privately hosted cloud and public cloud services.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
DB’s using the framework:
1.
Altibase Enterprise Hybrid Database
2.
DataStax Hybrid Cloud Database
3.
Orient DB
Construction of hybrid clouds demands a secure connection between computational resources scattered across private and public clouds under different administrative domains. It means that different virtual machines/nodes in sub-networks need to be connected. (Mansouri et al., 2020)
Automation in general has been a trending topic in the CS world, especially in a business sense due to the ability to turn simple day-to-day tasks conducted by humans into tasks that our systems can complete for us as we monitor the completion. In terms of automated database management, we can convert data gathering, monitoring, and processes into automated functions
with little to no human intervention.
How an Autonomous Database Works
An autonomous database leverages AI and machine learning to provide full, end-to-end automation for provisioning, security, updates, availability, performance, change management, and error prevention.
In this respect, an autonomous database has specific characteristics.
It is self-driving
All database and infrastructure management, monitoring, and tuning processes are automated. DBAs can now focus on more important tasks, including data aggregation, modeling, processing,
governance strategies, and helping developers use in-database features and functions with minimal changes to their application code.
It is self-securing
Built-in capabilities protect against both external attacks and malicious internal users. This helps eliminate concerns about cyberattacks on unpatched or unencrypted databases.
It is self-repairing
This can prevent downtime, including unplanned maintenance. An autonomous database can require fewer than 2.5 minutes of downtime per month, including patching.
There are several benefits of an autonomous database.
Maximum database uptime, performance, and security―including automatic patches and fixes
Elimination of manual, error-prone management tasks through automation
Reduced costs and improved productivity by automating routine tasks
Autonomous databases offer many benefits. When you're ready to evaluate the offerings available to your organization, look for the following key features.
Auto-Provisioning
Automatically deploys mission-critical databases that are fault-tolerant and highly available. Enables seamless scale-out, protection in case of a server failure, and allows updates to be applied in a rolling fashion while apps continue to run.
Auto-Configuration
Automatically configures the database to optimize for specific workloads. Everything from the memory configuration, the data formats, and access structures are optimized to improve performance. Customers can simply load data and go.
Auto-Indexing
Automatically monitors workload and detects missing indexes that could accelerate applications. It validates each index to ensure its benefit before implementing it and uses machine learning to learn from its own mistakes.
Auto-Scaling
Automatically scales compute resources when needed by workload. All scaling occurs online while the application continuously runs. Enables true pay per use.
Automated Data Protection
Automatically protects sensitive and regulated data in the database, all via a unified management
console. Assesses the security of your configuration, users, sensitive data, and unusual database activities.
Automated Security
Automatic encryption for the entire database, backups, and all network connections. No access to
OS or admin privileges prevents phishing attacks. Protects the system from both cloud operations
and any malicious internal users.
Auto-Backups
Automatic daily backup of database or on-demand. Restores or recovers a database to any point in time you specify in the last 60 days.
Auto-Patching
Automatically patches or upgrades with zero downtime. Applications continue to run as patching
occurs in a round-robin fashion across cluster nodes or servers.
Automated Detection and Resolution
Using pattern recognition, hardware failures are automatically predicted without long timeouts. IOs are immediately redirected around unhealthy devices to avoid database hangs. Continuous monitoring for each database automatically generates service requests for any deviation.
Automatic Failover
Automatic failover with zero-data loss to standby. It’s completely transparent to end-user applications. Provides 99.995% SLA.
The Future of Autonomous Databases
Data is being generated today at a rate that is fast outpacing how quickly it can be manually managed and processed to efficiently and securely deliver business-critical insights. Because of their intelligent automation capabilities, autonomous databases offer enterprises many advantages over traditional databases. The expectation is that enterprises will increasingly migrate to this database model to enjoy these advantages, maintain a competitive edge, and gain the ability to refocus IT efforts on innovation rather than database management.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
References:
Mansouri, Y., Prokhorenko, V., & Babar, M. A. (2020). An automated implementation of hybrid cloud for performance evaluation of distributed databases. Journal of Network and Computer Applications, 167. https://doi-org.ezproxy.umgc.edu/10.1016/j.jnca.2020.102740
Vasav. (2024, February 23). Emerging Trends In Databases: Multi Model Databases & More. RedSwitches
. https://www.redswitches.com/blog/database-trends/#Hybrid-and-Multi-
cloud-Database-Architectures
What is an autonomous database?
(n.d.). https://www.oracle.com/autonomous-database/what-is-
autonomous-database/
What is hybrid Database? List of the best hybrid databases
. (2023, June 26). Software Testing Help. https://www.softwaretestinghelp.com/hybrid-database/