best data modeling books

this scenario, users can comment on images, articles, and other resources. All comments are included in the comment set. If you only use Manual References, I cannot tell which type of resources the comment belongs to, pictures? Article ?. So we have DBRef. DBRefFormat: {$ ref: , $ Id: , $ Db: } $ Ref: Set Name; $ id: referenced id; $ db: Database Name; optional parameter. It can be seen that the structure of DBRef is more complex than that of Manual References, which occupies a l

Brief introduction The business environment is changing rapidly, and so is the type of business data. A successful Data warehouse solution is based on flexible design that adapts to changing business data. The architecture of data Warehouse and the modeling of warehouse

example, each system has customer data. When establishing a data warehouse application for a bank, the data in the above production system should be converted to the data warehouse. From the perspective of the entire bank, its data model is no longer oriented to individual

Data modeling of Enterprise Architect 8 (CREATE TABLE) ---------- 1. We create a view of the database modeling 1.1 The New Diagram window, select Extended on the left select from and select data types in the right diagram modeling. 1.2 Open the Diagram window, you can choose

Recently, I saw an article in my blog "converting the Document Forwarding process custom data modeling. I am going to raise this topic for discussion and discussion, with the main purpose of improving. My general requirements are as follows: Developing a complex enterprise multi-user management information system (MIS) does not involve the development of functions such as

Introduction: The first two blog posts (Database DesignStep by step (5)-understand user requirements and database designIn step by step (6) -- extract business rules), we analyze database requirements, focusing on two topics: 1. understanding user requirements; 2. Extracting business rules. After the requirement analysis is complete, we will enter the conceptual data modeling stage. This article uses the "B

Qlikview Data Modeling --- Concatenation, qlikviewThis Blog introduces how to avoid loops and synthetic keys through Concatenation (Concatenation) fact tables:The Modeling in Qlikview is usually very simple. Generally, we only need to rename the names of some sub-segments to prevent or establish automatic association between tables.But sometimes we can't solve th

This Blog introduces how to avoid loops and synthetic keys through Concatenation (Concatenation) fact tables:The modeling in Qlikview is usually very simple. Generally, we only need to rename the names of some sub-segments to prevent or establish automatic association between tables.But sometimes we can't solve the problem by simply renaming it. For example, we have multiple fact tables and multiple associations with other tables, which usually pr

"MATLAB data analysis and Mining practice" is the teddy technology in the field of data mining more than 10 years of experience summarized with the South China Normal University, Hanshan Teachers College, Guangdong Engineering, Canton technicians and other senior lecturers to build the peak of the joint effort. The whole book is based on practice and practicality, both in depth and breadth, and in practice