Какова наилучшая архитектура проектирования баз данных в SQL server для нескольких ERP-решений ?
Question : What is best Database Design Architecture in SQL Server For Multiple ERP Solutions ? I Already looked at AdventureWorks Database Schema of Microsoft, it looks cool but many inheritance and i didnt fit with it. What i mean by question that i want to design an ERP Solutions plus Car Rent System, Hospital System and Hotel System and so on of any Commercial Solutions. so i decide to make a database Schemas inside SQL Server, for example : Examples Of Schema that i guessed dbo.schema for default tables such as ErrorHandling, BuildVersion .. HR Schema for human resources Inventory Schema for inventory and sales systems Accounting Schema for Accounting system. and so on ... so the tables will look like that : every tables inside it's schema system - Inventory.Sales Inventory.Purchases Inventory.Reports Inventory.OrderHeader Inventory.OrderDetail Car.Contracts Car.OpenedContracts Car.ClosedContracts Car.Types Car.etc..>> Accounting.Transcations Accounting.CostCenters Accounting.AccountL1 Accounting.AccountL2 and so on .. 1-But.. i also wanna make my databases like this structure: -- Year Databases to reset it every beginning of year and start new one. ERPYear012016 ERPYear012017 ERPYear012018 -- General Database that contains Static Items ( Car types, Persons ) ERPGeneral01 -> For example Company number one ERPGeneral02 -> company number 2 But I found this ideas will make my database too large because each system will be more than 100 + Tables ? does this make cost performance to be slow in Query and affect the database itself ? 2-Or should i Make Every System Standalone ? for example : CarYear012016 CarYear012015 InventoryYear012016 InventoryYear012017 does this make performance great rather than only one database contains everything ? Because not all our Customers/clients will purchase all packages, some customers need only Car System Package... that's why i need to know the best way to make Great Performance and good design ? I Need Good Deisgn High Performance Fast Query Also i wanna put this notes: if i make standalone database for each system like Car System : CarYear012016 CarYear012017 i can here insert many schemas as i can for car system, and that make database good to understand for example . Contracts Schema Car Types Schema Rent Schema is this good >? i don't know. The Main Questions Is Which Approach Is good in design and Performance ? First One : Insert All ERP Systems inside Years Databases ( 2015,2016,..) ? Second Approach : insert Every ERP in single Database ( Car2016,Car2017,Inventory2016) ?
Что я уже пробовал:
Я попробовал подход AdventureWorks, но он, похоже, не может четко вписаться в ERP-решение, потому что я хочу добавить базы данных Years. ТАК ЧТО, ПОЖАЛУЙСТА, СКАЖИТЕ МНЕ ХОРОШИЙ ПОДХОД .