Click here to Skip to main content
15,513,143 members
Home / Discussions / Database
   

Database

 
GeneralRe: how a data base file works Pin
Calin Negru21-Aug-22 10:59
Calin Negru21-Aug-22 10:59 
AnswerRe: how a data base file works Pin
Eddy Vluggen21-Aug-22 2:30
professionalEddy Vluggen21-Aug-22 2:30 
GeneralRe: how a data base file works Pin
Calin Negru21-Aug-22 3:53
Calin Negru21-Aug-22 3:53 
GeneralRe: how a data base file works Pin
Eddy Vluggen21-Aug-22 5:03
professionalEddy Vluggen21-Aug-22 5:03 
GeneralRe: how a data base file works Pin
Calin Negru21-Aug-22 6:47
Calin Negru21-Aug-22 6:47 
GeneralRe: how a data base file works Pin
Eddy Vluggen21-Aug-22 6:57
professionalEddy Vluggen21-Aug-22 6:57 
GeneralRe: how a data base file works Pin
Calin Negru21-Aug-22 10:20
Calin Negru21-Aug-22 10:20 
GeneralRe: how a data base file works Pin
Eddy Vluggen22-Aug-22 9:04
professionalEddy Vluggen22-Aug-22 9:04 
Calin Cali wrote:
it doesn`t what? (no explicit question in my post)
Use the hierarchy that the OS provides. Databases are not files and folders, but lists of stuff called tables.

Calin Cali wrote:
If you ask me it`s not a DB job to abstract the idea of files
I did not ask, I merely explained it. Any DB has tables and abstracts you away from the FileSystem.

Calin Cali wrote:
A DB usually is concerned with how the data is kept within a (single) file.
A single entity; SQL Server allows for multiple files on multiple drives, but still represents your DB as a single file. You do not even have to care on what drive your record gets stored, that's a problem for the database.

Calin Cali wrote:
Although interesting you DB marginal example bears no relevance to how stuff usually works in a DB. Thanks for the discussion.
This is the basic for every database, from SQLite to Oracle Big Grin | :-D

Calin Cali wrote:
does saving data to a DB resemble with saving data do a file. to some extent yes. but a DB is much more than that
A database file IS a file. You are comparing it in your mind with a text file; that has to be rewritten every time the size changes - that's not efficient enough!

Imagine a text file, a list of names for example. First, you add unused space. If the user now adds a record, you overwrite that space and no need to change the size (and cause fragmentation on disk).

If I'm a db, I store your list of names in alphabetical order. But you have place-names in that list too. So I make another file, where I save those placenames in alphabetical order with their primary key. That allows for quicker lookups. We call those indexes.

Now, please, explain me how "stuff" usually works in a db?


--edit
My bad, I should have explained it more clearly. It's a good question that helps you understand the difference between storing on the OS and in the DB. Most store where they're told to Big Grin | :-D

Feel free to ask; maybe I can learn to respond without feeling attacked Thumbs Up | :thumbsup:
Bastard Programmer from Hell Suspicious | :suss:
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

GeneralRe: how a data base file works Pin
Eddy Vluggen22-Aug-22 9:22
professionalEddy Vluggen22-Aug-22 9:22 
QuestionOLE DB provider Pin
suren ramakrishnan18-Aug-22 22:16
suren ramakrishnan18-Aug-22 22:16 
AnswerRe: OLE DB provider Pin
Richard MacCutchan18-Aug-22 22:31
mveRichard MacCutchan18-Aug-22 22:31 
AnswerRe: OLE DB provider Pin
RedDk19-Aug-22 14:14
RedDk19-Aug-22 14:14 
QuestionReplacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik7-Aug-22 5:00
Nick Katditsik7-Aug-22 5:00 
AnswerRe: Repacing back-end MS-ACCESS with SQL SERVER Pin
Mycroft Holmes7-Aug-22 13:44
professionalMycroft Holmes7-Aug-22 13:44 
GeneralRe: Repacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik8-Aug-22 6:42
Nick Katditsik8-Aug-22 6:42 
AnswerRe: Repacing back-end MS-ACCESS with SQL SERVER Pin
Richard Deeming7-Aug-22 22:50
mveRichard Deeming7-Aug-22 22:50 
GeneralRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik17-Aug-22 6:07
Nick Katditsik17-Aug-22 6:07 
GeneralRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
Craig Robbins17-Aug-22 7:53
Craig Robbins17-Aug-22 7:53 
AnswerRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
CHill6017-Aug-22 8:00
mveCHill6017-Aug-22 8:00 
GeneralRe: Replacing back-end MS-ACCESS with SQL SERVER Pin
Nick Katditsik17-Aug-22 20:46
Nick Katditsik17-Aug-22 20:46 
QuestionHow would you... (synchronization between 2 databases) Pin
Joan M6-Aug-22 8:18
professionalJoan M6-Aug-22 8:18 
AnswerRe: How would you... (synchronization between 2 databases) Pin
Gerry Schmitz6-Aug-22 9:06
mveGerry Schmitz6-Aug-22 9:06 
GeneralRe: How would you... (synchronization between 2 databases) Pin
Joan M6-Aug-22 13:08
professionalJoan M6-Aug-22 13:08 
AnswerRe: How would you... (synchronization between 2 databases) Pin
Mycroft Holmes6-Aug-22 13:48
professionalMycroft Holmes6-Aug-22 13:48 
Questionsql query problem Pin
pitwi28-Jul-22 0:06
pitwi28-Jul-22 0:06 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.