• We did not send an email asking for donations - please read this post.

help&discuss: how to study DB

LINUX_Knight

New Member
Joined
Mar 28, 2019
Messages
5
Reaction score
1
Credits
0
me : i am from china , a student .
question; how to study DB ,which DB should i learn.
 


JulienCC

Active Member
Joined
Oct 7, 2019
Messages
235
Reaction score
207
Credits
0
Hello,

Lets talk about books again ^^ : Database System Concepts (Avi Silberschatz · Henry F.Korth · S. Sudarshan)

Here are some keywords you won't hear about in most online tutorials :

Normalization/Denormalization. When designing DB structure you will probably face a common problem : reducing redudancy of data (meaning the same data is stored only once and in one place) makes the request to get complexe views of data really complicated. So you will, at some point, have to put duplicated version of data here and there to improve performance and request readability.

Hash Table and Binary Tree : Two concept of general computing science that are used a lot in DB engines indexes to improve performance. Hash Tables will hold "numeric equivalent" of string data, which will allow the engine to look for a value with a single number (this is way faster than using a string which is one number per character at least). Binary Tree are a way of ordering numerical values to increase search performance.

You can find plenty of information about this online.

Have fun !
 

captain-sensible

Well-Known Member
Joined
Jun 14, 2019
Messages
2,913
Reaction score
1,970
Credits
18,126
really simple set up no MySQl server, i.e no installation of xamp ,wamp just use php and sqlite3
you can fire up php internal server, you can install sqlitebrowser to look with a gui into db
 
$100 Digital Ocean Credit
Get a free VM to test out Linux!

Linux.org Hosting Donations
Consider making a donation

Members online


Top