) Petshop4.0 Database:. Net petshop 4.0 distributed database design overview

Library As the storage center of application data, it plays a very important role in the system. When the number of users increases rapidly, databases tend to become the bottleneck of the system. Using distributed databases is the first choice. After a distributed database is used, each part of the data is managed by a dedicated server, which reduces the pressure on the database server.
. Netpetshop4.0 uses four databases:
Mspetshop4
Mspetshop4orders
Mspetshop4profile
Mspetshop4services
Its Mspetshop4 is used to manage basic data information such as products and categories. There are six tables in total.
Aspnet_sqlcachetablesforchangenotification
Category
Inventory
Item
Product
Supplier
Division Aspnet_sqlcachetablesforchangenotification is used in combination with. Net cache processing. Other tables are basic data tables and they have corresponding models in petshop4.0.
Mspetshop4orders is used for order management. There are three tables.
Lineitem
Orders
Orderstatus
Minute Do not store order details, basic order information, and order status data.
Mspetshop4profile is used for configuration management. There are three tables.
Account
Cart
Profiles
Minute Do not store basic account information, shopping cart information, and user configuration information.
Mspetshop4services is a database for user membership management that comes with. net2.0. The database contains a large number of data tables and is not listed here.
Connect By dividing the data of a complete system by functions, each part of the data is stored in an independent database server, is a typical distributed database mode. This method not only improves the reusability of databases and applications, but also disperses the pressure on database servers. Program Solve the database bottleneck.