Capterra Glossary
Database Design
Database design is the process of creating organized data sets into a useable model. The database management professional must follow a set of guidelines to classify and sort the data. There are different models that a company can base its design on, and the model type will define the way that the data is categorized. Typically, these include models like object-oriented, hierarchical, entity-attribute-value, or star schema. There are three phases to the design process: conceptual, logical and physical design.
What Small and Midsize Businesses Need to Know About Database Design
A thorough database design can help a SMB analyze their collected data in several ways while also reducing the time it takes to manage data. This presents benefits like enhanced reliability, better cost saving automation, and improved resource management. A SMB may implement database design to better manage their inventory which can streamline their order management process.
Related Terms
- Synchronous
- Software as a Service (SaaS)
- Intranet
- Security Orchestration, Automation and Response (SOAR)
- Identity and Access Management (IAM)
- Managed Service Provider (MSP)
- Haptics
- WAN (Wide-Area Network)
- Service-oriented Architecture (SOA)
- Augmented Reality (AR)
- Chief Information Officer (CIO)
- Security Information and Event Management (SIEM)
- Platform as a Service (PaaS)
- Service-Level Agreement (SLA)
- Scalability
- Data Center
- Authorization
- Multitenancy