Innovative Research on Intelligent Enterprise Management Mode under the Background of Smart City

Table 1

Differences between traditional databases and data warehouses.

	Traditional database	Database
Data content	Current value (live up to 6 months)	Backup, synthesis, and calculation
Data organization	Application-oriented operation (E-R diagram)	Subject-oriented
Data characteristics	Dynamic with log	Relatively stable
Data structure	Complex and easy to operate	Simple and easy to analyze
Access frequency	High	Middle and bottom
Access results	Record layer access	Aggregate access
Access method	Transaction access mode	Periodic report-style specific queries
Data manipulation	Add, delete, and modify	Inquire
Visit feature	Highly repetitive operation	Strong randomness
Corresponding time	Second level	Seconds to minutes
Scale	Several GB	Up to 100 GB