tailieunhanh - Beginning SQL Server Modeling- P9

Tham khảo tài liệu 'beginning sql server modeling- p9', 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ả | CH APTER 6 SQL SERVER MODELING SERVICES - THE FOLDER PATTERN your manufacturer not only made cars but also toasters and lawnmowers. Then you could also define a ToasterComponent type and a LawnMowerComponent type with corresponding ToasterComponents and LawnMowerComponents tables. If the manufacturer had a single QC department that covered all manufacturing lines then you would have the seed for developing a QC model and application that this department could use for managing its operations across different lines. If the manufacturer decided that each line should have its own QC department say for instance they were made in different plants then the folder pattern of SSMod could be applied to allow each QC department to view and manage the QC data of its respective line but not be distracted with data for the other lines. Corporate headquarters would of course have access to all QC data if that was how the IT department was asked to structure the system. In the next chapter which covers the security services provided by SQL Server Modeling Services you ll use this basic scenario as the basis of an exercise to illustrate how security can be used to expose or hide data. 161 Download from Wow eBook Download from Wow eBook C H A P T E R 7 SQL Server Modeling Services - Security Security is an essential component of enterprise applications. Since SQL Server Modeling SSMod is part of the broader .NET framework developers have access to a wide range of services and technologies some of which provide their own security options. Applications and users can query a SQL Server database through Entity Data Modeling EDM LiNq ODBC and other systems including non-Microsoft platforms. The Modeling Services framework supports granular rowlevel and claims-based security built on the folder pattern discussed in the previous chapter. It should be clear however that a wide range of other security facilities is available depending on which .