Future Databases and Performance Tuning Essay

Exclusively available on Available only on IvyPanda® Made by Human No AI

The current state

The first issue that arises with modern databases is the framework they are built on. Many database-backed applications use an Object Relational Mapping (ORM) framework, which affects the database performance (Yan et al., 2017). ORMs are used in application construction that correlates with database management systems (DBMSs) (Yan et al., 2017). It seems to ease the application development through abstracting persistent data instead of embedding SQL queries, but it also lowers the performance (Yan et al., 2017). Hiding specific query processing details leaves the programmer unaware of how the database works, making it more challenging to optimize the system. Thus, the following problem needs to be addressed in future databases.

Alternative databases

One of the possible solutions starts to arise with alternative database technologies such as NoSQL and Hadoop appearing. The cloud database platforms are also projected to provide a more significant workload without performance costs. Even general-purpose databases are now enabled to support several data models with extended capabilities such as in-memory storage and data virtualization. The future databases are expected to go even further and support a broader range of workloads and functions such as stream processing and secondary functionality.

Database performance tuning

The changes necessary for developing future databases require discovering the patterns in modern ones and improving them. The system’s functional components need to be in tune to provide a qualitative change (Zimniak et al., 2015). Since the database workload continually adapts, the information about modifications in the structure and intensity is essential in forecasting the effectiveness of future databases (Zimniak et al., 2015). The workload information can be reached through audit trails, sequences of dynamic performance views, and traces of user applications analysis.

The following data collection allows the analysts to evaluate the intricate patterns to predict the future workload levels and adapt the database. One of the essential features to be taken into account is estimating future query execution time that predominantly affects the monitoring and scheduling of query processes (Zimniak et al., 2015). The information about the possible workload levels can then be used to automate performance improvement or change the future database design (Zimniak et al., 2015). The following information about the past workloads can be collected from a database management system.

Real-Time Database Analytics

However, due to a large amount of information needed to be processed, a database’s analytics and tuning present a complex and irregular problem. Today there appear to be no visible patterns for database assessment. Many database operations processes remain unclear because of this. The following issue of the inability to identify all the intricate periodic patterns will be solved in the future databases.

Future database development predicts the appearance of real-time analytics. The current issue of complex database assessment process creates the demand for modern real-time analytics on transactional data. The hybrid systems require a more convenient technology for analysis. The following technology of the future would allow not only to increase the speed and simplicity of data transfer and sharing but also enable real-time targeting, fraud detection, and recommendations. This can significantly impact the future and make the maintenance of a database system much more manageable.

Enhanced data management

The future databases will soon evolve to manage completely disparate data sources to increase the system’s functionality. The present-day data pools are already quite massive with merging updating data from the internet. However, such a vast amount of information constrains its analysis. Modern data scientists develop new data architectures to make it easier to manage and orchestrate the data flow pipelines (Zheng, 2018). The new solutions are essential to solve the issue and organize evolving disparate data sources. Hybrid transactional databases are one of the possible future databases untangling the problem (Zheng, 2018).

Future database

Overall, future databases would develop systems, which utilize a broader amount of diversified data in real-time (Zheng, 2018). New technology will also emerge with the introduction of databases. Extensive data analysis would be needed as the system more and more intricate. Data analysts and statisticians will have a significant role in developing the system and giving market insights. Even now, many companies sponsor the innovations in the data industry to use them in e-commerce and media portals and make critical business decisions (Zheng, 2018). Future databases would go further than that and make precise predictions about the future based on the ongoing data analysis

References

Yan, C., Cheung, A., Yang, J., & Lu, S. (2017). Proceedings of the 2017 ACM on Conference on Information and Knowledge Management (pp. 1299-1308). Web.

Zheng, X. (2018). Database as a service-current issues and its future. arXiv 1. Web.

Zimniak, M., Getta, J.R. & Benn, W.(2015). Vietnam Journal of Computer Science ,2, 201–211. Web.

More related papers Related Essay Examples
Cite This paper
You're welcome to use this sample in your assignment. Be sure to cite it correctly

Reference

IvyPanda. (2022, September 24). Future Databases and Performance Tuning. https://ivypanda.com/essays/future-databases-and-performance-tuning/

Work Cited

"Future Databases and Performance Tuning." IvyPanda, 24 Sept. 2022, ivypanda.com/essays/future-databases-and-performance-tuning/.

References

IvyPanda. (2022) 'Future Databases and Performance Tuning'. 24 September.

References

IvyPanda. 2022. "Future Databases and Performance Tuning." September 24, 2022. https://ivypanda.com/essays/future-databases-and-performance-tuning/.

1. IvyPanda. "Future Databases and Performance Tuning." September 24, 2022. https://ivypanda.com/essays/future-databases-and-performance-tuning/.


Bibliography


IvyPanda. "Future Databases and Performance Tuning." September 24, 2022. https://ivypanda.com/essays/future-databases-and-performance-tuning/.

If, for any reason, you believe that this content should not be published on our website, please request its removal.
Updated:
This academic paper example has been carefully picked, checked and refined by our editorial team.
No AI was involved: only quilified experts contributed.
You are free to use it for the following purposes:
  • To find inspiration for your paper and overcome writer’s block
  • As a source of information (ensure proper referencing)
  • As a template for you assignment
Privacy Settings

IvyPanda uses cookies and similar technologies to enhance your experience, enabling functionalities such as:

  • Basic site functions
  • Ensuring secure, safe transactions
  • Secure account login
  • Remembering account, browser, and regional preferences
  • Remembering privacy and security settings
  • Analyzing site traffic and usage
  • Personalized search, content, and recommendations
  • Displaying relevant, targeted ads on and off IvyPanda

Please refer to IvyPanda's Cookies Policy and Privacy Policy for detailed information.

Required Cookies & Technologies
Always active

Certain technologies we use are essential for critical functions such as security and site integrity, account authentication, security and privacy preferences, internal site usage and maintenance data, and ensuring the site operates correctly for browsing and transactions.

Site Customization

Cookies and similar technologies are used to enhance your experience by:

  • Remembering general and regional preferences
  • Personalizing content, search, recommendations, and offers

Some functions, such as personalized recommendations, account preferences, or localization, may not work correctly without these technologies. For more details, please refer to IvyPanda's Cookies Policy.

Personalized Advertising

To enable personalized advertising (such as interest-based ads), we may share your data with our marketing and advertising partners using cookies and other technologies. These partners may have their own information collected about you. Turning off the personalized advertising setting won't stop you from seeing IvyPanda ads, but it may make the ads you see less relevant or more repetitive.

Personalized advertising may be considered a "sale" or "sharing" of the information under California and other state privacy laws, and you may have the right to opt out. Turning off personalized advertising allows you to exercise your right to opt out. Learn more in IvyPanda's Cookies Policy and Privacy Policy.

1 / 1