tailieunhanh - Beginning SQL Server Modeling- P6

Tham khảo tài liệu 'beginning sql server modeling- p6', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | CHAPTER 4 INTRODUCTION TO QUADRANT In this case I ll click the As Original option and a check mark will appear next to the value in the Original column indicating this is the selected value for resolving the conflict see Figure 4-29 . Figure 4-29. After selecting As Original to resolve the conflict The exclamation point next to the Shock Absorbers entity has now changed to an asterisk and if you close the Changes view you will see the same indication in the CarComponents Explorer. The data conflict has been resolved but the change has not yet been committed. You can take this last step of committing this change by using Ctrl S or the File Save Changes menu option which will make the data consistent again. Finally there can be situations where the local copy of the data can become stale because something has changed in the database but the local copy of the data hasn t refreshed since the database change. Suppose the suspension engineering team has decided to go with two shock absorbers per wheel rather than one and they have just changed the Description value for Shock Absorbers to Two for Each Wheel and the corresponding Quantity value from 4 to 8 in the database. This would mean the local copy of the data displayed by Quadrant is stale and no longer matches what is in the database. Figure 4-30 shows the resulting Quadrant view. 101 Download from Wow eBook CHAPTER 4 INTRODUCTION TO QUADRANT Figure 4-30. Stale data in Quadrant after a recent change in the database This situation is resolved by simply refreshing the data from the data store using the F5 refresh key. Figure 4-31 shows the result. Figure 4-31. After using F5 to refresh stale data Using the Quadrant Explorer Query Bar The area immediately above the column titles and below the menu bar in the Explorer window is called the Query Bar. The default entry normally displayed in the Query Bar is the name of the extent or table that is displayed in the Explorer window in the case of this .