2023
Relational databases are complex pieces of software that process and store vast amounts of data.Careful planning is needed to ensure that a database meets the needs of the people who use it and the applications that use it for storing and retrieving data.The ultimate objective is to create a database that satisfies users, meets operational demands, and requires minimal maintenance.As a data systems analyst, you will be a crucial perspective as part of the team that brings a new database to life.In this chapter, we will first explore considerations for database implementation planning.We will then examine some fundamental questions influencing database design, ensuring that the database fits into an organization's strategic architectural direction, and then delve into the artifacts essential for a well-understood database design.With an understanding of how to plan and design a database, we will examine the implementation, testing, and deployment phases that take a database from concept to reality. Planning and DesignThe planning and design phases are vital to creating a dependable, reliable, and operationally viable relational database.Proper planning and design can ensure the database is scalable and secure, in addition to performing well while reducing the risk of data corruption and loss.The planning and design process is iterative, as you might surface a new requirement during planning that influences design.The goal of this phase is a database design consistent with an organization's strategic architectural goals.The design should also align with the organization's overall technology strategy.This phase produces several artifacts, including requirements specifications, a conceptual data model, a logical data model, a physical data model, a data dictionary, and other design documents.These artifacts are vital for database administrators, application developers, and other stakeholders who will end up using the database. Requirements GatheringRequirements gathering is a critical step in the database design process, as it ensures that the database meets the needs of its users and applications.As you start to gather requirements, 10.
Cited by 0Open access
Brown GD · Science and Technology Facilities Council
Cited by 0
Pedersen, Rasmus Brun; id_orcid 0000-0002-8221-682X, Ostermann, Falk, Wagner, Wolfgang · 2023
Cited by 0
Brown GD · Science and Technology Facilities Council
Cited by 0
Geoff Hiten · Certification study companion series · 2025
This second chapter in our Azure SQL automation journey is all about how to deploy Azure SQL services via automated tools. I often joke that the Azure portal is the Fisher-Price version of Azure. It is a visual tool useful for learning, illustrating, and exploring Azure, but it is not the “real” interface. The grown-up version of Azure is accessed via the automation interfaces. When you deploy a resource using the Azure portal, you are simply filling in a form and submitting an automation task. This chapter shows you how to skip the portal “helper” form filler.
Cited by 0
Falk Ostermann, Wolfgang Wagner · Journal of Peace Research · 2023
Abstract The Parliamentary Deployment Votes Database provides data on the voting behaviour of 301 political parties in 1,022 parliamentary votes on military missions between 1990 and 2019 in 21 countries of the Global North. This special data feature introduces the database and presents descriptive statistics and basic patterns on some of its key variables: general, political, and regional characteristics of missions and votes themselves; the level of agreement; and party-political contestation. The number of deployment votes has increased over the course of the 1990s and then fluctuated around a stable annual average of 40 to 50 votes. At the same time, legislative–executive relations in security and defence policy and, as a consequence, the number of deployment votes, continue to differ substantially between countries. Whereas support for military missions has increased over time, the degree of contestation, as measured by an agreement index, differs considerably across the countries under study. Whether a political party supports a military mission depends not only on it being part of a governing coalition or in opposition but also on its political ideology: support is lowest among parties of the Radical Left, increases among green and social-democratic parties and peaks among liberal, conservative and Christian-democratic parties. Radical-right parties are less supportive than centrist parties but more supportive than radical-left parties. Regional peculiarities notwithstanding, this pattern can be found in Western and Eastern Europe, East Asia and North America. The database will be interesting for scholars of the democratic politics of military missions and particularly legislative–executive relations and political parties in security and defence policy, providing the foundations for a comparative analysis of different missions, the ideological foundations of contestation, government–opposition dynamics and legislative–executive relations in security and defence policy.
Cited by 15
Renat M. Khamitov · International Journal of Advanced Studies · 2023
Ubiquitous digitalization and the development of big data technologies require a high level of availability (24/7) of information resources. Ensuring high availability of the database requires a significant amount of work on the design, testing and maintenance of several components and configurations. High availability can be achieved or maximized for the following deployment options: one database instance (with or without read replicas) and several main ones (with or without a coordinator). High availability ensures the smooth operation of the system by eliminating individual points of failure, while disaster recovery focuses on restoring normal operation after a failure or downtime. There are several deployment options because there is no universal solution. Choosing the best option depends on your specific use case and requirements. This article presents the main concepts of ensuring high availability and the most effective patterns for providing highly accessible database deployments. Purpose. definition of effective deployment patterns for database servers to ensure high availability. Methodology. The results of foreign and domestic scientific research are used in the work. The author uses theoretical research methods related to the search and analysis of information to identify connections and obtain unique conclusions. Results. The most effective deployment schemes for ensuring high availability and fault tolerance of databases are highlighted. Practical implications it is advisable to apply the results obtained in the field of DevOps development in order to optimize the process of developing and releasing applications by eliminating a known bottleneck: changes to the database code.
Cited by 0Open access
Falk Ostermann, Cornelia Baciu, Florian Böller et al. · RUCforsk (Roskilde University) · 2021
The Parliamentary Deployment Votes Database (PDVD) includes data on parliamentary votes on the deployment of armed forces. Version 3 of the dataset (V3, July 2021) contains data on 1,022 votes in plenaries and 5,540 party votes for the period between August 1990 and December 2019 in Australia, Belgium, Canada, Croatia, the Czech Republic, Denmark, Finland, France, Germany, Ireland, Italy, Japan, Lithuania, the Netherlands, Romania, Slovakia, South Korea, Spain, Turkey, the United Kingdom and the United States of America. The data consists of two separate datasets, one on parliamentary-level votes (PDVD_v3_votes) and one on party votes (PDVD_v3_party-votes) with accompanying documentation.
Cited by 5Open access
末松 直樹, 宮崎 敏明 · 2014
Cited by 0
Kim Coulter · 2026
Cited by 0
Tao Wen, Fan Jing, Ningning Song et al. · 2023
In view of the problems of high resource allocation, low utilization and high cost based on physical or virtual machine deployment, a database containerization deployment scheme based on Kubernetes container arrangement technology is proposed. In this paper, the key technologies such as high performance, high availability and easy operation and maintenance are studied and demonstrated. The scheme fully investigates the advantages of container technology and the characteristics of database deployment, optimizes the High Availability Scheme of Local PV and Cluster based on the existing functions of Kubernetes.
Cited by 0
Vanyashin, Sasha, Clemencic, Marco, Martelli, Barbara et al. · CERN Document Server (European Organization for Nuclear Research) · 2007
Cited by 0
A. N. Samoilov, A.I. Kostyuk · Proceedings of X All-Russian Scientific Conference "System Synthesis and Applied Synergetics" · 2023
Костюк Андрей ИвановичИнститут компьютерных технологий и информационной безопасности Южный федеральный университет
Cited by 0Open access
N. Guglietta, Brian M. Landry, M. Panlilio et al. · 2008
With limited resources and technical expertise, many local nonprofit organizations (NPOpsilas) are unable to benefit from efficient database solutions which streamline operations and financial management. This paper describes a unique university-industry partnership established to design, develop, and deploy a database solution for a local NPO. A team of students from the University of Virginia combined with professional consultants from FileMaker, Inc., and Soliant Consulting, to address the database needs of computers 4Kids, a nonprofit technology-mentoring program for disadvantaged youth. A database suite was delivered which improved, integrated, and extended the functionality of existing paper and stand-alone databases. Preliminary results of the project indicated that the implementation of such a design, when performed in accordance with recommended systems methodologies, would indeed be advantageous for the nonprofit institution.
Cited by 0
Haoliang Ren, Zengshan Tian, Mu Zhou et al. · 2019
In indoor fingerprint positioning system, Access Point (AP) deployment costs a lot of manpower and time, and the deployment efficiency of existing methods is extremely low due to the complexity and dynamics of indoor environment. In order to solve this problem, this paper proposes an optimal AP depl
Cited by 0Open access
Ariel Afonso, Altigran Soares da Silva, Tayana Conte et al. · 2020
The adoption of Continuous Deployment (CD) aims at allowing software systems to quickly evolve to accommodate new features. However, structural changes to the database schema are frequent and may incur in systems' services downtime. This encompasses the proper maintenance of both schema and source code, including rewrites of all outdated queries that use the same database. Previous solutions try to mitigate the burdening task of manually rewriting outdated queries. Unfortunately, a software team must still interact with some tools to properly fix the affected queries. Moreover, the team still has to locate and modify all the impacted code, which are often error-prone tasks. Thus, a project may not experience CD benefits when changes impact various code regions. In this paper we present an alternative approach, called LESSQL, whose goal is to improve queries' stability in the presence of structural schema changes over time. LESSQL supports queries that are less dependent on the database schema since they do not include the FROM clause. An underlying framework intercepts each LESSQL query and generates a corresponding SQL query for the current schema. It also locates the query attributes in the current schema and generates proper expressions to join the required tables. LESSQL supports unsupervised, supervised and hybrid configurations to process mappings of attributes to a newer schema version. We conducted experiments in the context of a popular open-source project, which experienced many diverse structural schema changes. Experiments outcomes indicate that our approach is effective in significantly reducing the modifications required for applying schema changes, allowing to better reap the benefits of CD. While supervised and hybrid configurations achieved a success rate higher than 95% with a minor query generation overhead, the unsupervised configuration was also successful for certain types of structural schema changes. These results show that LESSQL effectively favours CD and keeps queries running after database schema changes without services interruption.
Cited by 5
Yongshun Cai, Mingchuan Yang, Wei Si et al. · SHILAP Revista de lepidopterología · 2015
Cloud computing virtualization technology has the characteristics of elastic scalability，automatic migration （high availability），automatic recovery （high stability）.Because of the natural complexity of database systems，it makes a big challenge to deploy database systems in cloud computing virtualization environment.On the basis of research and analyzing models of deploying database systems in private cloud environment，the TPC-C benchmark test with database instances running in cloud computing virtual machines was applied.Compared with performance results of same test with database instances running in physical machines，the feasibility of deploying database systems in cloud computing virtualization environment was verified.
Cited by 0Open access
Gasimov, Hikmat · E-resource repository of the University of Latvia (University of Latvia) · 2025
Šis projekts ir veltīts drošas un mērogojamas tīmekļa un datubāzes servera infrastruktūras izveidei mazajiem uzņēmumiem. Izmantojot Apache tīmekļa hostēšanai un MySQL datubāzu pārvaldībai, sistēma atbalsta dinamiskas tīmekļa lietojumprogrammas un nodrošina datu integritāti, izmantojot drošības pasākumus, piemēram, ugunsmūrus, šifrētas paroles un piekļuves kontroli. Automatizētas rezerves kopijas, izmantojot cron uzdevumus, uzlabo datu noturību. Projekts piedāvā lietotāja reģistrāciju, autentifikāciju un atsauksmju iesniegšanu, nodrošinot rentablu risinājumu, kas ļauj mazajiem uzņēmumiem efektīvi pārvaldīt savas darbības tiešsaistē. Atslēgvārdi: tīmekļa serveris, datubāzes serveris, drošība, automatizācija, mazie uzņēmumi
Cited by 0Open access
Sammy Al‐Benna, Yazan Al-Ajam, Lars Steinstraesser · Burns · 2009
Cited by 0
Mata Martinez, Carles, Vathaire, Michel de · RECERCAT (Consorci de Serveis Universitaris de Catalunya)
Cited by 0Open access