Recent

Author Topic: Whats is the better pratice to model DataBase.  (Read 2459 times)

Almir Lima

  • New member
  • *
  • Posts: 27
    • iSoft Tecnlogia Digital
Whats is the better pratice to model DataBase.
« on: March 08, 2018, 02:09:35 pm »
Hi, everybody.
Whats is the better pratice to model DataBase.

More tables or mor fields in tables?

Why?
Today better than yesterday.

Handoko

  • Hero Member
  • *****
  • Posts: 2683
  • My goal: build my own game engine using Lazarus
Re: Whats is the better pratice to model DataBase.
« Reply #1 on: March 08, 2018, 02:18:08 pm »
I'm not a database expert, but I ever knew database normalization:
https://en.wikipedia.org/wiki/Database_normalization#Normal_forms

GetMem

  • Hero Member
  • *****
  • Posts: 3254
Re: Whats is the better pratice to model DataBase.
« Reply #2 on: March 08, 2018, 02:30:31 pm »
In theory more tables and less, but related columns. This is the so called database normalization. The model assumes infinite computer power, which unfortunately is never true, so in reality use less tables with lots of columns. Ideally you should start with a perfectly normalized database and watch how miserably fails as data grows, but then you have to rewrite the whole thing and it hurts.  Don't do it.

Windsurfer

  • Sr. Member
  • ****
  • Posts: 341
    • Windsurfer
Re: Whats is the better pratice to model DataBase.
« Reply #3 on: March 08, 2018, 02:39:32 pm »
GetMem is absolutely right. Usually normalise to level 4 (fourth normal form) and then go back to level 3 and take into account any small optimisations that may be worthwhile.

valdir.marcos

  • Hero Member
  • *****
  • Posts: 535
Re: Whats is the better pratice to model DataBase.
« Reply #4 on: March 08, 2018, 06:31:03 pm »
There is a large biography you could learn from.
I will suggest you some of the same books I always suggest to my students start from:

The Manga Guide to Databases | Illustrated
by Mana Takahashi and Shoko Azuma
Jan 15, 2009

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design (3rd Edition)
by Michael J. Hernandez
Feb 14, 2013

Database Design and Relational Theory: Normal Forms and All That Jazz (Theory in practice)
Author: C. J. Date
Apr 27, 2012

SQL and Relational Theory: How to Write Accurate SQL Code
Author: C. J. Date
Jan-2012



Database Systems: Design, Implementation, & Management 12th Edition
by Carlos Coronel, Steven Morris
Jan 26, 2016

Database Systems: Introduction to Databases and Data Warehouses
by Nenad Jukic and Susan Vrbsky
Jun 2, 2016

Project Management Analytics: A Data-Driven Approach to Making Rational and Effective Project Decisions (FT Press Project Management)
by Singh Harjit
2015-11-16

Database Reliability Engineering: Designing and Operating Resilient Database Systems
by Laine Campbell and Charity Majors
Oct 26, 2017

Almir Lima

  • New member
  • *
  • Posts: 27
    • iSoft Tecnlogia Digital
Re: Whats is the better pratice to model DataBase.
« Reply #5 on: March 10, 2018, 03:12:00 pm »
Thanks for replying
Today better than yesterday.