如何设计初始数据库架构？ [英] How to Design initial database architecture?

问题描述

我有一个初始启动项目。我想为这个项目设计数据库。我对数据库架构设计不是很了不起，这对项目初始数据库设计的重要步骤是什么？

i have one initial start-up project. i want to design database for this project. i am not great with database architecture design so,

what are important step for initial database design for project?

推荐答案

数据库设计取决于应用程序数据的使用和流程。



考虑以下参数并选择正确的数据库，它可能是RDBMS，Flat或Hadoop



1.数据类型

2.数据量

3.交易和安全级别

4.数据分发架构与您的应用程序

5.成本/预算

6.可扩展性



如果你使用RDBMS系统，几点



1.识别主数据

2.规范化它们并创建正确的表结构

3.识别系统的主要实体及其依赖项，大多数这些表涉及交易

4.仔细规范化，过多的规范化会降低其性能

5。如果您有很多报告，请为报告单独提供数据库并从事务数据库中提取报告数据，尽管ATL类型的工作



希望这有助于

Database Design depends upon on the application data usage and flow.

Consider below parameters and choose the right database, it may RDBMS, Flat or Hadoop

1. Type of data
2. Volume of data
3. Transactions and security level
4. Data distribution architecture with your application
5. Cost/Budget
6. Scalability

If you go with RDBMS System, few points

1. Identify the Master data
2. Normalize them and create right Table structure
3. Identity the main Entity of the system and its depend items, mostly these tables involve in transaction
4. Normalize them carefully, too much normalization reduce its performance
5. If your have lot of reports, have separate DB for reports and extract report data alone from Transaction DB though ATL kind of jobs

Hope this helps

本教程值得研究： http：// arcanecode.com/2007/04/24/sql-server-2005-compact-edition-important-component/ [ ^ ]。

This tutorial is worth studying: http://arcanecode.com/2007/04/24/sql-server-2005-compact-edition-important-component/[^].

这篇关于如何设计初始数据库架构？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！