Creation and Searching of Database with 10 Billion Data



1) A Bookcode number is a 10 digit number, example


2512345299




2) This mean that it can contain 10 billion number from


0000000000 to 9999999999



3) This article is about to create a database that can retrieve any data inside this database instantly.



4) For time being, only the database from


2400000000 to 2599999999


are created.




5) Where


2400000000 to 2499999999


are for magazine and book use.




6) While


2500000000 to 2599999999


are for daily newspaper use.



7) For creating this database, a small program called “A Thousand Folders Making Program” is created first.



8) This program will create new sub folders, name 000 to 999 in any folder.

​


9) Example of this program is as shown below :





10) To use this program, first the user input the front two digit, in this case 25.

​


11) Second, input the 3rd and 4th two digits, in this case 18 as shown below : ​





12) Then press “Confirm” button.

​


13) If successful, a massage will pop up as below : ​





14) This mean the program already created one thousand folders from 000 to 999 in location


\25\18\



15) Example of result is as shown below :



\25\18\000, \25\18\001, ………., \25\18\998, \25\18\999




16) Each of this subfolder will store one thousand Bookcode number (Excel and image files).



17) Example, the Excel file name


2518125458.xlsx


will store in below location



\25\18\125\2518125458.xlsx

​



9) Another example, the Excel file name


2377256964.xlsx


will store in below location


\23\77\256\2377256964.xlsx




10) This mean that each time this program created one thousand folders, it indirectly created one million storage area for Bookcode number, with two million files inside it. Since one Bookcode number consist of one Excel file and one image file. ​





Make Newspaper and e-News into one



www.bookcodesb.com