Physical Data Model
Definition: A physical data model (a.k.a. database design) is a representation of a data design which takes into account the facilities and constraints of a given database management system. A complete physical data model will include all the database artifacts required to create relationships between tables or achieve performance goals, such as indexes, constraint definitions, linking tables, partitioned tables or clusters. The physical data model can usually be used to calculate storage estimates and may include specific storage allocation details for a given database system.
What This Means: The physical database model is the actual design for a specific software application or a data repository. Each application will have its own physical data model that should be consistent with the education agency’s logical data model (possibly NEDM) and with the agency’s metadata standards as documented and referenced in its Information Systems Architecture.
Need another definition?
Please select from the menu above
- A-V
- Abstract
- Acceptable Use Policy
- Account Name
- Accountability Reports
- Action Reports
- Actionable Data
- Active Only
- Ad Hoc Query
- Administration Manual
- Administrator Security Role
- Adware
- After Action Review
- Agent
- Algorithm
- American Productivity and Quality Center (APQC)
- Anti-Adware
- Anti-Spyware
- Anti-Virus Software
- API (Application Programming Interface)
- Application
- Application Layer
- ASCII
- ASP (Application Service Provider)
- Assessment
- Associated Link
- Asynchronous
- ATM
- Atomic
- Attribute
- Audit Report
- Audit Trail
- Authentication
- Authoritative Data Source
- Authoritative Provider
- Authorization
- AYP (Adequate Yearly Progress)
- Back Office
- Back-Up
- Balanced Scorecard
- Bandwidth
- Batch
- Beta Testing
- BI (Business Intelligence)
- Big Data
- BIOS
- Bits Per Second (or bps)
- Blog
- Bluetooth
- Boolean Data
- Bread Crumbs
- Broadband
- Browser (or Web browser)
- Business Continuation Plan
- Business Rule Logic
- Business Rules
- Cable Categories
- Cache
- CAD
- CD-ROM
- CD-RW
- Certification
- Certify
- Change Data Capture (CDC)
- Change Implications
- Change Order
- Change Type
- Choreography
- Chromebook
- Client/Server
- Cloud
- COBOL
- Code
- Collection
- Collection Burden
- Collection Item
- Collection Method
- Collection Name
- Collection Number
- Collection Set
- Collection Type
- Collection Window Closing Date
- Collection Window Opening Date
- Column
- Column Description
- Column Format
- Committee
- Common Core State Standards
- Common Data Definition
- Common Elements
- Community of Interest
- Community of Practice
- Compliance Report
- Computer Security
- Confidential Data
- Confidentiality
- COTS (Commercial Off-the-Shelf)
- CourseWalk
- Coverage Period End Date
- Coverage Period Start Date
- CRM (Customer Relationship Management)
- Cross-Collection Clean-Up Window Closing Date
- Cross-Collection Clean-Up Window Opening Date
- Crosswalk
- Crosswalking
- CSV (Comma Separated Value)
- Curriculum
- Cyber-Safety
- Cycle Time
- D3M (Data-Driven Decision Making)
- D3M Framework
- Dashboard
- Data Access And Management Policy
- Data Architecture
- Data Backup
- Data Dictionary
- Data Governance
- Data Governance
- Data Grid View
- Data Length
- Data Management
- Data Manipulation Language (DML)
- Data Model
- Data Object
- Data Quality
- Data Quality Rules
- Data Source
- Data Steward
- Data Store, Database, Data Warehouse, Data Mart, Anaylsis Database
- Data Type
- Database
- Database Software Title
- Database Software Version
- Database/Instance Name
- DataSpecs
- DBA (Database Administrator)
- DBMS (Database Management System)
- Decision Dupport System
- Default Value
- Detail Level
- DHCP
- Dial-Up Service
- Dictionary Element
- Digital
- DIMM
- Directory Service
- Disaster Prevention and Recovery
- Display Name
- Distance Learning
- Domain Name Service
- DOS
- Download
- DPI
- DSL
- Due Date
- DV Tape
- DVD
- DVD-R
- DVD-RAM
- DVD-RW
- Early Warning System
- Ed-Fi
- EDEN (Education Data Exchange Network)/EDFacts
- EDFacts
- EDFacts Shared State Solution (ES3)
- EDI (Electronic Data Interchange)
- Editor Security Role
- Effective Date
- Element
- Element Categorization
- Element Name
- Element Type
- Email
- Email Attachment
- Encryption
- Enterprise
- Entity Relationship Diagram
- Environment
- ERP (Enterprise Resource Planning)
- ESP Administrator Security Role
- ESP Staff Application Role
- Ethernet
- ETL (Extract, Transform, Load)
- Event
- Expansion Card
- Expected Number of Respondents
- Expiration Date
- Extensibility
- Extension
- External Researcher
- External Source
- Fail Over
- FAQ
- FEP (Fluent English Proficient)
- FERPA (Family Educational Rights and Privacy Act)
- Field Name
- Field Name(s) to associate with Rule
- File Server Name
- File Sharing
- Filter
- Firewall
- Firewire
- Flash Drive
- Flat Panel Display
- Flipped Learning
- For-profit and nonprofit education management organizations (EMOs)
- Format
- Formula
- Front-End Processor
- FTP
- Fuzzy Logic
- Gap Analysis
- GHz
- GIF
- Gigabit
- Gigabyte (GB)
- GIS
- Google
- GPS (Global Positioning System)
- Growth Model
- GUI
- GUID (Globally Unique Identifier)
- Hard Drive
- HDTV
- Home Page
- Honeypot
- Horizontal Interoperability
- Hot Back-Up Site
- Hotspot
- HP
- HTML (HyperText Markup Language)
- HTTP (HyperText Transfer Protocol)
- HTTPS (HyperText Transfer Protocol Secure)
- Identity Management
- Identity theft
- IEP (Individualized Education Plan)
- IM
- IMAP
- Inbox
- Incident response
- Index
- Indicator
- Information Systems Architecture (ISA)
- Information technology
- Infrasturcture
- Inkjet Printer
- Insecure Network Services
- Integrated Notification System
- Internet
- Internet Service Provider (ISP)
- Internet Tools CD
- Internet2
- Interoperability
- Intrusion Detection
- IP
- IP Address
- ISDN (Integrated Services Digital Network)
- ISInsight
- ISO 9000
- IT
- IT Roadmap
- Item Dictionary
- Item List
- Item Number
- Kbps
- Kerberos password
- Key Data Element Code (KEY)
- Keychain drive
- Kilobyte (KB)
- Knowledge Management
- KPI (Key Performance Indicator)
- Lagging Indicator
- LAN (Local Area Network)
- Laser Printer
- LCD
- LDAP (Lightweight Directory Access Protocol)
- LEA (Content Area Specialist Application Role)
- LEA (Local Education Agency)
- LEA Data Staff Application Role
- Leading Indicator
- Legacy System
- Level 1, 2, 3 Support
- Level 1, 2, 3, Business Rules
- Link
- Link Description
- Link Notes
- Link URL
- Linux
- Liquidity
- List of Field Names
- Listserv
- Logical Data Model
- Login
- LoginID
- Longitudinal Data
- Longitudinal Data System
- Longitudingal Data Store
- MAC Address
- Machine Language
- Magneto-Optical (MO) Drive
- MailID
- Mainframe
- Malcolm Baldrige National Quality Award
- Malware
- Mandate
- Mapping
- Master
- Master Person Index (MPI)
- Max Value
- Max Yield Data
- Mbps
- Megabyte (MB)
- Metadata
- MHz (MegaHertz)
- Middleware
- MIME type
- Min Value
- Mobile Learning
- Modem
- Month Collected
- Month Reported
- Moobilenet, MoobilenetX
- MOOC – Massive Open Online Course
- MOTS (Modified Off-the-Shelf)
- MP3
- MPEG-1, MPEG-2, MPEG-3, MPEG-4
- Multimedia
- NAM
- NAR
- National Transcript Center (NTC)
- NCES (The National Center for Education Statistics)
- NCES Category Name
- NCES Domain Name
- NCES Element ID
- NCES Element Number
- NCES Option Set
- NCES Related Categories
- NCES Section Name
- NCLB (No Child Left Behind)
- NEDM (National Education Data Model)
- Nest Level
- Netiquette
- Network
- Network Security
- Network Topology
- Newsgroup
- NIC
- NOC
- NOS
- NRP (Network Resource Planning)
- NSF
- OCR
- ODBC (Open Database Connectivity)
- ODS (Operational Data Store)
- Office
- Official Data
- OLAP (Online Analytical Processing)
- Open Architecture
- Open Email Relay
- Open Source
- Open Source
- Open Standards
- Operating System Patches
- Option
- Option Set
- Order
- OS (Operating System)
- OS X
- Other Documentation
- Output
- Output Item
- Output or Report Name
- Packets
- Parent
- Password
- PCS
- PDA
- PDBMI (Performance-Based Data Management Inititative)
- PDF
- Periodicity
- Personal Information
- PESC (Postsecondary Electronic Standards Council)
- Pharming
- Phishing
- Phone
- Physical Computer Security
- Physical Data Model
- Pilot Program
- Platform
- Platform Dependent
- Podcasting
- Politimetrics
- POP
- Portal
- Portlet
- Post
- PPM 200-45
- PPP
- Precision
- Presentation Layer
- Primary Key
- Primary Key Order
- Privacy Restriction
- Process Management
- Profile Report
- Prompt
- Protocol
- Provide
- Proxy Server
- Publish
- Pull Technology
- Push Technology
- RAID (Redundant Array of Independent Disks)
- RAM
- Rank
- Read Only Security Role
- Real Time
- Relational Database/RDS (Relational Data Store)
- Reliability
- Remote Access
- Repeatable
- Report
- Report Manifest
- Report Manifest ID
- Report Number
- Report Set
- Reporting Data Store
- Repository
- Repository Description
- Repository Name
- Repository Table
- Repository Type
- Request
- Required
- Response
- RFI
- RFP (Request for Proposals), RFO (Request for Offers), RFI (Request for Information)
- Risk Mitigation
- ROM
- RSS
- RSS (Really Simple Syndication)
- RTF
- Rule Description
- Rule Detail Message/Description
- Rule ID
- Rule Name
- Rule Official Message/Summary Description
- Sandbox
- Scanner
- SCED (School Codes for the Exchange of Data)
- Schema Name
- School Content Area Specialist Application Role
- School Data Staff Application Role
- School Improvement Grant (SIG)
- Scope
- Scorecard
- SCORM (Sharable Content Object Reference Model)
- SCSI
- SEA (State Education Agency)
- Search Dictionary
- Section Number
- Security
- Security Alerts
- Server
- Server Process Identifiers (SPID)
- Session Layer
- Severity
- SGML
- SharePoint
- Short Name
- SIF (Schools Interoperability Framework)
- SIF Element Description
- SIF Element Name
- SIF Implementation Specification
- SIF Object Name
- SIF Task Force
- SIF Version
- SIF Work Group
- SIF_Ack
- SIF-certified
- SIF-complaint
- SIFA (Schools Interoperability Framework Association)
- SIFA University
- SIMM
- Single Sign-On
- SIS (Student Information System)
- Site License
- Six Sigma
- SLA
- SMTP
- SOA (Service Oriented Architecture)
- SOAP (Simple Object Access Protocol)
- Social Media
- Software
- Software as a Service (SaaS)
- Software Patches
- Source
- Source Code
- Spam
- Spam Filtering
- SPARC
- Specifications
- SPED (Special Education)
- SPEEDE/ExPRESS
- Spyware
- SSL
- Staging Data Store
- Standards
- State Alias
- State Content Area Specialist Application Role
- State Data Staff Administrator Application Role
- State Number
- State Report Manager (SRM)
- Statistical Report
- Status
- Storage Location
- Structured Query Language (SQL)
- Student Identifier
- Student Record
- Student Transcript
- Support
- Synchronous
- System
- System Redundancy
- T1 Line
- Table Description
- Table Field
- Table Name
- Table Title
- Table Type
- Target Audience
- TCO
- TCP
- TCP/IP (Transmission Control Protocol/Internet Protocol)
- Telecommute
- Terabyte
- Test Environment
- Thin Client
- TIFF
- Time Per Respondent
- Title I
- Title III
- Trailing Indicator
- Transactional Data
- Transactional Data Store
- Transactional Software
- Transactional Software
- Transformation Rules
- Tree View
- Trigger
- Trojan
- UI (User Interface)
- Unix
- Unofficial Data
- Update Schedule
- Upload
- Upload Template
- UPS
- URL
- USB
- USB Keychain
- User Acceptance Testing (UAT)
- Value-Added Model
- Version
- Vertical Interoperability
- Vertical Reporting Choreography
- Video Conference
- Virtualization
- Virus
- VLAN
- VoIP (Voice Over IP)
- VPN
- VRAM
- VRML
- VSAM (Virtual Storage Access Method)
- Vulnerability Scanning