Unlock instant, AI-driven research and patent intelligence for your innovation.

Model building method and device

A model building and model technology, applied in computer security devices, instruments, computing, etc., can solve problems such as high development costs and difficulty in adapting to business scenarios

Active Publication Date: 2021-02-02
BEIJING XIAODU INFORMATION TECH CO LTD
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, VBAC technology usually requires humans to understand and maintain the correspondence between roles and data views, and then manually create data views, which leads to problems such as high development costs and difficulty in adapting to complex business scenarios.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Model building method and device
  • Model building method and device
  • Model building method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment approach 1

[0065] figure 1 It is a flow chart of the model building method according to Embodiment 1 of the method of the present invention. see figure 1 , in this embodiment, the method includes:

[0066] S11: Determine the dimension table record corresponding to the role.

[0067] S12: Establish a data view according to the dimension table records.

[0068] S13: Associating the role with the data view to establish a data access model.

[0069] The present invention is directed to a star-structured database model. Such as figure 2 As shown, the database model includes fact tables and dimension tables.

[0070] The main feature of the fact table is that it contains numerical information (facts), and these numerical information can be summarized to provide relevant units as historical data. Each fact table contains an index composed of multiple parts. The index contains as a foreign key The primary key of the dependency dimension table.

[0071] The dimension table can be regarde...

Embodiment approach 2

[0074] image 3 is a flow chart of the model building method according to Embodiment 2 of the method of the present invention. see image 3 , in this embodiment, the method includes:

[0075] S21: Obtain the first mapping relationship table.

[0076] Wherein, the first mapping relationship table is used to store the mapping relationship between roles and dimension table records.

[0077] S22: Determine the dimension table record corresponding to the role according to the first mapping relationship table.

[0078] S23: Establish a data view according to the dimension table records.

[0079] S24: Associating the role with the data view to establish a data access model.

[0080] Since the mapping relationship between the role and the dimension table record is directly constructed in the present invention, the dimension table record corresponding to the role can be found efficiently and conveniently.

Embodiment approach 3

[0082] Figure 4 It is a flow chart of the model building method according to Embodiment 3 of the method of the present invention. see Figure 4 , in this embodiment, the method includes:

[0083] S31: Obtain a first mapping relationship table.

[0084] Wherein, the first mapping relationship table is used to store the mapping relationship between roles and dimension table records.

[0085] S32: Determine the dimension table record corresponding to the role according to the first mapping relationship table.

[0086] S33: Find the fact table containing the dimension table records.

[0087] S34: Establish a data view for the fact table according to the dimension table records.

[0088] S35: Associating the role with the data view to establish a data access model.

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the present invention provides a method and device for establishing a model, and relates to the technical field of computer applications. Wherein, the model building method includes: determining a dimension table record corresponding to a role; establishing a data view according to the dimension table record; associating the role with the data view to establish a data access model. In the technical solution provided by the present invention, the data view of the role is established according to the dimension table record corresponding to the role. Therefore, the mapping relationship between the primary key of the dimension table and the foreign key of the fact table can be used to automatically establish the data view so as to be able to Adapt to complex business scenarios.

Description

technical field [0001] The present invention relates to the field of computer application technology, and more specifically, to a model building method and device. Background technique [0002] When multiple users share a database and have permission to modify the database, there must be extremely serious security risks. If no appropriate control measures are taken, each user can access or even deliberately destroy data after successfully entering the database server. . Therefore, it will be a serious challenge to ensure the security and reliability of data shared by multiple users. [0003] Therefore, a data access control technology needs to be introduced, and a relatively mature technology in the field of data access control includes, for example, RBAC (Role-Based Access Control, role-based access control) technology. In RBAC technology, permissions are associated with roles, and users get the permissions of these roles by becoming members of appropriate roles. The exi...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F21/62G06F21/60
CPCG06F21/604G06F21/6227G06F2221/2141
Inventor 罗哲
Owner BEIJING XIAODU INFORMATION TECH CO LTD