Database, Data System, Data Warehouse What's the Difference?
Database: an organized collection of information or data elements, typically stored in a computer, that can be searched, sorted, reorganized, and analyzed rapidly. The following are database models:
- Flat file: data in one record that cannot be linked to other records (a single table format)
- Hierarchical: data in separate records that are attached to one root (one-to-one relationship)
- Network: data in separate records that can be attached to multiple other records (many-to-many relationship)
- Relational: data in a collection of tables without any hierarchy and that are physically independent
- Object-oriented: data in separate records that can be linked to a variety of data objects like text, graphics, photos, video, and sound
Data system: a collection of computer programs that enable you to store, modify, and extract information from a database. One such data system is the Texas Public Education Information Resource.
Data warehouse: a combination of many different databases across an entire system to present an entire picture. Data are added but never removed. An example of a data warehouse is the Louisiana Educational Accountability Data System.
Sources: Date, C. J. (2003). An Introduction to Database Systems, 8th Ed. Boston, MA: Addison-Wesley. http://www.frick-cpa.com/ss7/Theory_Models.asp
Next Page: SEDL Study on State Data Systems