Storage And Access Control Of Food Safety Database

With increasingly worse of domestic food problem, people urgently need to a method to get yielding and sales information of food and achieve the digitization of food traceability. In the process of building a food safety traceability platform, the designer divided the main users of platform into four kind of users which includes end-users, business users, regulators user and administrator. In four kind of users, the number of business users who provide the data are large, and their authority need often changes due to the promotion and the change of scope of business. Existing role-based access control can only modify user permissions to achieve the purpose by manually modifying the user’s role. Considering the number of enterprise users, this method is difficult to meet the requirements. This article will explore how to resolve this problem.Meanwhile business users and platform document exchange using XML. But XML and relational databases have a huge difference in the structure and organization of data. How to efficiently store XML into a relational database in the circumstances of protecting sensitive informationin to also is important issues of this article.In terms of the issues that the business users need of authority often change, this paper presents an innovative RBAC model which based on user characteristics and time constraint. The model modifies the user and role mapping mechanism of the traditional RBAC model. According to user attributes, we match the user and the role.In the model, by defining a set of rules, the rules can dynamicly match user’s characteristic attributes and the role. Meanwhile, in order to resolve the role of the problem of time for dynamic matching authorization, time constraints is added to this model. The problem of consistency between the user and role is also discussed uderauthorization problem under the time constraints. The most important feature of this model is that the role can match the dynamic characteristic attributes of the user.XML for relational database storage problems, put forward a law-relational mapping XML Schema elements with sensitive test. The use of XML structure and content of the rules stored in XML Schema, by custom mapping rules, the XML Schema simple type element and complex type elements mapped to corresponding relational schema. In the process of transformation, while the distinction between handling of sensitive information to prevent disclosure of sensitive informationIn terms of the issues that how to efficiently store XML into a relational database, this paper presents a method of transfroming XML Schema into relation database model before checking the sensitive elements.By using the XML structure and contents rules which existing XML Schema,some rules are defined to transfrom the simple type and complex type into relation database model. For preventing information leakage, in the process of transforming, we protect sensitive information by distinguishing between general information and sensitive information.