Register Login

International Journal of Sustainable Infrastructure for Cities and Societies

Search
PDF

Published

2023-08-10

Issue

Vol. 8 No. 9 (2023): IJSICS-SEPTEMBER

Section

Articles

How to Cite

Bao, D. Q., & Chi, N. K. (2023). Database Optimization Techniques for Enterprise Systems: Strategies for Enhancing Performance, Scalability, and Reliability in Large-Scale, Mission-Critical Architectures. International Journal of Sustainable Infrastructure for Cities and Societies, 8(9), 24–35. Retrieved from https://vectoral.org/index.php/IJSICS/article/view/142

Database Optimization Techniques for Enterprise Systems: Strategies for Enhancing Performance, Scalability, and Reliability in Large-Scale, Mission-Critical Architectures

Dang Quoc Bao

Department of Computer Science, Dai Hoc Dong Nai, Duong Pham Van Thuan, Phuong Tan Mai, Bien Hoa, Dong Nai, 810000, Vietnam.

Nguyen Kim Chi

Department of Computer Science, Dai Hoc Kinh Te - Tai Chinh, Duong Hoang Dieu 2, Phuong Linh Trung, Quan Thu Duc, Ho Chi Minh City, 700000, Vietnam.

Abstract

This research explores advanced database optimization techniques essential for enhancing performance, efficiency, and speed in enterprise systems amidst the surge of big data. By examining methods such as indexing, query optimization, database normalization, hardware adjustments, and the use of materialized views, the study aims to provide a comprehensive understanding of how to achieve optimal database performance. The research includes both theoretical and practical dimensions—covering various databases like relational, NoSQL, and in-memory types—through literature review, case studies, and real-world applications. Key objectives focus on identifying effective indexing techniques, comparing SQL and NoSQL query optimizations, assessing the role and limitations of normalization, and evaluating the impact of hardware configurations on performance. Findings indicate that well-optimized databases significantly improve application performance, reduce operational costs, enhance scalability, and provide a competitive edge in data management. The study concludes with practical recommendations for database administrators and organizations to implement these optimization techniques effectively.

Browse

Information

Make a Submission

Make a Submission
Submission Guidelines for the Journal of Quarterly Journal of Emerging Technologies and Innovations (IJSICS) General Guidelines:

  1. Article Types: We accept a variety of article types including Original Research Articles, Review Papers, Short Reports, and Opinion Pieces.

  2. Language: Manuscripts must be written in English, and should be clear, concise, and free of jargon.

  3. Length: There is no strict word limit, but Original Research Articles should generally be between 4,000 and 10,000 words, including references.

  4. Formatting: Manuscripts should be submitted as a single Word or LaTeX document, formatted in double-spaced 12-point font.

  5. Abstract: An abstract of 250-300 words is required for all submissions, summarizing the key objectives, methods, findings, and implications of the research.

Manuscript Structure:

  • Title Page: Must include the title, author names, affiliations, and contact information for the corresponding author.

  • Introduction: Provide background, state the problem, and outline objectives.

  • Methods: Detail the methods and tools used in your research.

  • Results: Present the findings of your study.

  • Discussion: Interpret results, discuss their impact, and suggest future research directions.

  • Conclusion: Summarize the main points of the paper.

  • References: Citations should be formatted according to the APA/IEEE styles.

Ethical Guidelines:

Authors must ensure that their research adheres to ethical standards and that informed consent has been obtained for any human or animal subjects involved.

Plagiarism:

The Journal of Computational Social Dynamics uses plagiarism detection software. Any manuscript found to include plagiarized content will be rejected.

Peer Review Process:

All submissions undergo a double-blind peer review process. Authors can expect initial feedback within six to eight weeks.

Submission Process:
  1. Prepare your manuscript according to the guidelines.
  2. Submit your manuscript through our online portal.
  3. After submission, you will receive a confirmation email with a manuscript ID for tracking purposes.
Revisions:

If revisions are requested, authors must resubmit the revised manuscript within the specified timeframe.

Publication Fees:

The journal has a nominal publication fee, waived for authors who lack funding. Details are available on our website.

For any questions or concerns, please contact the editorial office at editorial@vectoral.org. Thank you for considering the IJSICS as a venue for your research.

Published by Vectoral Publishing, the International Journal of Sustainable Infrastructure for Cities and Societies maintains high standards in peer-review and scientific inquiry. Authors who wish to submit manuscripts should adhere to the guidelines detailed on our website, www.vectoral.org/QJETI. Vectoral Publishing does not bear any responsibility for the accuracy of information or for any outcomes related to the use of the research published. For editorial correspondence and submissions, please reach out to editorial@vectoral.org.