Data slicing technology under Oracle

oracle| data

Oracle Data slicing technology author: Stream Side home: http://liulee.myrice.com
Oracle's Oracle Enterprise 8.0.5 has won the favor of customers with its superior performance, and it provides developers with great flexibility with rich inline functions, pl/sql support, multi-platform, application server integration, etc. In Oracle's user rights assignment, only insert,update,select,delete,execute such as tables, functions, synonyms, views, packages, and so on are provided, and no field-level permission settings are provided (in fact, The field-level permission setting for large databases has a security benefit, but it has a certain impact on performance, so for large mis systems, data fragmentation is unavoidable. Generally, a typical MIS database platform design is this: the allocation of user rights through the Oracle Temporary system table is implemented: 1, in the need to fragment the table (CUSTOMER) To establish related fields, such as sgrant_num number (20) and the Department Sunit _id varchar (10), 2, creates a dynamic view of the table CUSTOMER_PV select * from CUSTOMER A where Cd_warehouse. SUNIT_ID is null or exists (SELECT * from CUSTOMER B where a.sunit_id = b.sunit_id and (b.sgrant_num >= to_number (SUB STR (USERENV (' Client_info '), 1,)) and (B.sgrant_num <= to_number (SUBSTR ("USERENV"), 11, 10))) 3, login in user When the system modifies the user environment client_info the fragment number; 4. In this way, there is no fragmentation problem for the designer, and for the end user, the organization fragment number of the user can be defined to constrain the data that the user can access. Principle Diagram Advantages: 1, automatically completed by the server, no impact on the design, 2, fast, no significant impact on the vast numbers of data, disadvantages: 1, can only be based on the organization (or other) longitudinal fragmentation, not flexible; 2. Technical implementation is complex, and primary table changes will directly affect the view (requires regeneration); 3. Once the organizational structure changes, the fragmentation needs to be reset.


※ Respect the author's hard work, please let me know before reprint, thank you! ※· [Back Home] * [Enter discussion version] [Write to me] * [Quick Return]