Indexes are used to quickly locate data without having to search every row in a database table every time a database table is accessed. An index is a copy of selected columns of data from a table, called a database key that can be searched very efficiently that also includes a low-level disk block address or direct link to the complete row of data it was copied from.
I use many Flat Files, with fixed-length records, and "text" fields, working in tandem with Perl SDBM binary files of key/value pairs tied to Perl program hash tables. These key/value pairs offer persistent, instantaneous, random access to Flat File records. For random access, the file pointer is first set to a single record location byte offset, where the offset is the number of bytes to seek to from either TOP of file or END of file. Then the record is read into memory. Once in memory, the contents of the record can be changed/modified and written back out to the Flat File, overwriting the existing data stored in that record.
nice video. tomorrow is my exam on web designing, circuit, history of computer technology, programming and database. I didn't know anything about database management. the video really helped. thanks
Thanks for the explanation. The only con I see is that to generate an index you first need to scan the whole thing. But I guess its pro as that you only have to scan once.
What I've understood is that an index is used to find specific records of data quickly. The index is a separate, independent data structure that you can look through regarding a specific value, such as the company number in your example. The index structure for all the company numbers appears to be ordered. This way, someone can go through the values in order so they can quickly find the specific company number they are looking for. Once they've found the number, the index will point to the specific record in the database that it is referring to. The index structure is also nice because you can easily realize when you've exhausted your search for the company number you're looking for because if you stumble upon a different value, that means your search is over.
Create index not give that much fast...in my table i use more trim(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX AS is it slow the execution time ? if this is the pblm give any suggesstion
i think the index is incomplete, it should be a tuple (element, place) no? so the systeme knows where to locate it, like the word for example (word, page, line, column) so the reader will go directly to the word?
It needs to include the element in question and a pointer to the location, yes. The pointing or locating is normally done on the physical (i.e. disk block) level, so it is not exactly correct to think of the index as a tuple, but I can see where it would be useful to think of it as such. In any case, you are certainly correct that it does no good unless it provides a mechanism for going from element to its location in the underlying table.
You can download my example PERL source code here (fully functional GUI application program) in PDF format. Click on the "Original File" link on that page to see the PDF file in a PDF viewer for download. I use Joint Database Technology as the Database (Flat File databases and SDBM databases working in tandem). The binary SDBM databases are used for indexing to the records in the Flat File. en.wikipedia.org/wiki/File:KJV_Bible_SDBM.pdf Also see the wikipedia page: en.wikipedia.org/wiki/Dbm for screen shots of this GUI application DB user-interface I guess this qualifies as a type of ISAM/NoSQL DB Access, and may be considered an Embedded Database?
Indexes are used to quickly locate data without having to search every row in a database table every
time a database table is accessed. An index is a copy of selected columns of data from a table, called a database key that can be searched very efficiently that also includes a low-level disk block address or direct link to the complete row of data it was copied from.
thanks
The analogy helped me a lot to understand and now I don't think I will forget this concept. Thanks a lot!
To skip the intro go to 2:39.
Wow that was awsome....explained with such a simple example..thanks a lot
I use many Flat Files, with fixed-length records, and "text" fields, working in tandem with Perl SDBM binary files of key/value pairs tied to Perl program hash tables. These key/value pairs offer persistent, instantaneous, random access to Flat File records. For random access, the file pointer is first set to a single record location byte offset, where the offset is the number of bytes to seek to from either TOP of file or END of file. Then the record is read into memory. Once in memory, the contents of the record can be changed/modified and written back out to the Flat File, overwriting the existing data stored in that record.
This is brilliant. Will keep this approach in mind for the next major project I am having. (Y)
Thank you Brian, great intro and great description. Very helpful!
nice video. tomorrow is my exam on web designing, circuit, history of computer technology, programming and database. I didn't know anything about database management. the video really helped.
thanks
awsome explanation. Thanks!
thank you so much for this valuable helpful video
thank you so much, I have a test tomorrow and I didn't know why not just sort instead of indexing.. hopefully I'll go good
Very good info, cheers.
Great video. Clear and concise!
Thank you for explaining this 🙏 Helped me
Thanks for the good introduction
Easy to understand. Thanks.
Thanks for the explanation. The only con I see is that to generate an index you first need to scan the whole thing. But I guess its pro as that you only have to scan once.
Thank you for an interesting intoro to the indexing concept.
Excellent explanation of Index. Thanks.
Very well explained. Thank you
Thanks GOAT of index
Thanks @Brian! A good intro to indexing.
Very nice explanation.
thank u ...good explanation
excellent explanation 👌 thank you
Great explanation, very clear, just what I was looking for right now. Thanks a lot
Very well explained, thank you very much.
Thank you so much .
Nice video. thank you brother
x1.5 speed is a must for this one. Good video though! thanks man.
Thank you for the explanation🙂
Good job Brian!
Excellent explanation! Thank you!
It helps a lot. Thanks
What I've understood is that an index is used to find specific records of data quickly. The index is a separate, independent data structure that you can look through regarding a specific value, such as the company number in your example. The index structure for all the company numbers appears to be ordered. This way, someone can go through the values in order so they can quickly find the specific company number they are looking for. Once they've found the number, the index will point to the specific record in the database that it is referring to. The index structure is also nice because you can easily realize when you've exhausted your search for the company number you're looking for because if you stumble upon a different value, that means your search is over.
Thanks for the video!! It was very helpful!
excellent mate!
dope explaination
thanks Brian 👍
very helpful
Thank you
Useful info starts at 4:46.
Very well explained !
thanks, it was very helpful!
Thanks!!!
Nice video.. Indexing got indexed in my mind :p
thanks . very good lecture
well explained!
Thank you sir!
Watched this 4 years ago, now a developer came across it again.
Thanks. Well done!
Thank you, helped a lot
Great explanation, thanks :)
thank you Brian!
Perfect
Create index not give that much fast...in my table i use more trim(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX
AS is it slow the execution time ? if this is the pblm give any suggesstion
i think the index is incomplete, it should be a tuple (element, place) no? so the systeme knows where to locate it, like the word for example (word, page, line, column) so the reader will go directly to the word?
It needs to include the element in question and a pointer to the location, yes. The pointing or locating is normally done on the physical (i.e. disk block) level, so it is not exactly correct to think of the index as a tuple, but I can see where it would be useful to think of it as such. In any case, you are certainly correct that it does no good unless it provides a mechanism for going from element to its location in the underlying table.
Great! and Thanks!
Thank you.
Thanks good video on dbms indexing but very long.
Thanks, helpful
You can download my example PERL source code here (fully functional GUI application program) in PDF format. Click on the "Original File" link on that page to see the PDF file in a PDF viewer for download. I use Joint Database Technology as the Database (Flat File databases and SDBM databases working in tandem). The binary SDBM
databases are used for indexing to the records in the Flat File.
en.wikipedia.org/wiki/File:KJV_Bible_SDBM.pdf
Also see the wikipedia page: en.wikipedia.org/wiki/Dbm
for screen shots of this GUI application DB user-interface
I guess this qualifies as a type of ISAM/NoSQL DB Access, and may be considered an Embedded Database?
Warning!! You might need to use 1.5x speed.
really helpful, thanks!!
How is the index table sorted if it has characters instead of numbers? Great Video!
It can be indexed/sorted alphabetically. My suggestion
What data structure is used for index ?
Wait, can't we use ORDER BY column1 DESC, column2 ? Kind of confused...
Yes. The point is that ordering a huge database takes a lot of time. By having it already ordered (with indexes) you speed things up!
jump to 3:45
gooood
Hey :) I need your help with these 3 topics :) Sequential Access Method, Indeks Sequential Access Method, Direct Access Method.
search, youtube, whats a database index
5:49 i am looking for a girlfriend
Thank you, very nice example and explanation
thank you very much!