LibreOffice-Suite-Base/C4/Database-Maintenance/Khasi

Time	Narration
00:00	Ngi pdiangsngewbha iaphi sha ka “Spoken tutorial” halor ka “LibreOffice Base”.
00:04	Ha kane ka jinghikai, ngin ia pule kumno ban: Khmih ia ka bit ka biang ka Database Pynkylla ia ka Database Structure Lum ia ki lyngkhot jong ka database bad Ban Backups
00:19	Khmih ia ka bit ka biang ka Database-
00:21	Ha baroh ka jing don jong ka “Base” database, ngin sa donkam ban shim ia ki step ban pynlong ia ka data up-to-data, ba lah ban shaniah bad ba shngain.
00:31	Kane ka kynthup ia ka jingpynkylla ia ka “data structure” bad ban update ia ka “form”s kalong kaba donkam ban buh ia kata kaba kot bad iahap haduh ka sngi ba mynta.
00:41	To ngin ia shim ia ka nuksa jong ka “Library” database jong ngi kaba ngi la shna ha ka jinghikai ba hashwa.
00:48	Kane ka database nyngkong kadon ia ka “table”s ha ka books, member bad books issued.
00:55	Bad ngi shna ia ka nuksa jong ngi kum ka forms, queries bad reports ba kan shong nongrim halor kane ka database structure.
01:03	Hadien, ka “library” lah pynheh ban don ia kiwei ki media kum ki DVDs bad CDs.
01:11	Te, ngi lah pynkylla ia ka “Library database” ban pynlong ia ka structure up-to-date.
01:16	Na ka bynta kane, ngi pyndap ia kawei pat ka table kaba khot “Media”
01:21	Bad ngi buh ia ka jingtip jong ka DVD bad CD ha kane ka “Media” table ba thymmai.
01:28	Ha kane ka rukom, ka database jong ngi kalong kaba lah ban pyndonkam kham bun bad up-to-date namar ba ngi lah ban pynkylla ha kano kano ba ngi donkam.
01:39	Ryngkat bad ka jingpynkylla ia ki “table”, ngin sa donkam ruh ban pynkylla ia ki forms ban pynlong ia ki kiba suk ban pyndonkam.
01:47	Lane ngi lah ban shna ia ki forms ba thymmai ban ngiam lut ki table structures ba thymmai.
01:54	Kum ka nuksa, lada ngi don ia ka “form” ban pyndap ia ki data jong ki book, ngi lah ban pynkylla ia ka ban ai lad ban pyndap ia ki entry na ka bynta ki DVDs bad Cds ruh.
02:08	Hangne ngi lah ban pyndap ia ki opshon buttons ban jied ia ka jait media, kata kadei: books lane DVDs lane CDs.
02:19	Lane, ngi lah ban pyndap ia ka form ba thymmai ban ailad ban pyndap tang ia ki data jong ka DVD bad CD media.
02:28	Ha kajuh ka rukom, ngin sa donkam ban pynkylla lane pyndap ia ka queries ba thymmai bad reports kiba shong nongrim ha ka data structure kaba lah pynkylla.
02:39	Bad teng teng ngin sa donkam ban pynkylla ia ka table structures ba lah don lypa.
02:45	Kum ka nuksa, to ngin shim ia ka “Member” table kaban lis ia baroh ki member ha ka “Library”.
02:53	Ia mynta ka buh tang ia ki kyrteng bad phone number jong ki.
02:58	Mynta, lada ngi donkam ban buh ia ki address bad jingtip jong ka nongbah ba ki sah ruh, ngin sa donkam ban pynkylla ia ka “Member” table structure.
03:09	Na ka bynta kane, ngi lah ban pyndonkam da ka SQl syntax kum ka:
03:15	ALTER TABLE Members ADD Address TEXT, ADD City TEXT
03:22	Te, ka “ALTER TABLE” statement ka pynkylla ia ka table structure bad pyndap da ar tylli ki columns ba thymmai.
03:30	“Address” bad “City” kiban buh ia ka “TEXT” data.
03:36	Leit sha ka ‘hsqldb.org/’ website na ka bynta kham bun ki jingtip ha kaban shna bad pynkylla ia ka table structures.
03:47	Pyndonkam ia ka ‘url’ address kumba la pyni ha ka screen.
03:52	Hadien kane, to ngin peit kumno ngi lah ban buh ia ka “Base” database kaba lah ban shaniah na ka bynta ban pyndonkam.
03:59	Teng teng, ka “Base” ka donkam ia shibun ka memory ban buh ia ki bun tylli ki record barit.
04:08	Kane kadei namar, ka Base ka shim ia khyndiat ka memory kaba ka database ka lah ban donkam.
04:17	Bad, ka data kaba ngi iohi ha ki tables khlem shym da buh thik ha kajuh ka oder kumba kadei ban long.
04:26	Namar ba ngi pyndap ia ki data ha ki tables ha kapor ba iapher, ka jaka ba lah buh ia ki kam don ha ka order kaba biang.
04:36	Ngi lah ban pyndonkam da ka “index”es na ka bynta ka table data, kumba ngi pyndonkam ia ka catalogue na ka bynta ka Library jong ki kot.
04:45	Ka catalogue kam dei ba ka lis ia ki kot, hynrei ka buh ruh ia ki jaka ha kaba la buh ia ki.
04:53	Kumjuh ruh, ngi lah ban shna ia ka table indexes ban pyni thik ia ka jaka ba ka data ka shong.
05:00	Hynrei ki indexes ruh ki shim bun ka memory.
05:04	Bad teng teng, haba pyndam ia ka table data ki data kim dam lut baroh nadong shadong.
05:11	Ki shu dkut ka jingiadei na ka table indexes hynrei ki dang don bad shim ia ka jaka haduh ban da pyndap da ki da ki data ba thymmai kiba kylliang ia ka jaka jong ki.
05:24	Te, kane kadei kadaw kaba ka database ka bam bun ka jaka bad ka size ka heh, watla ka data ba shisha kam dei kaba heh haduh katta.
05:35	Ka “Base” ka ai ia ka rukom kaba biang ban lum lang biang ia ki lyngkhot jong ki data shi jaka kaba khot ka Defragmenting.
05:42	Na ka bynta kane, ngin ia plie ia ka database kaba donkam ban defragment.
05:49	Shisien ba lah don hapoh jong ka ‘LibreOffice’ window, ngin ia nion ha u “Tools” menu bad nangta nion ha u “SQL sub menu”
06:01	Bad type ia ka command ba hapoh ha ka SQL window.
06:07	CHECKPOINT DEFRAG
06:10	Kane ka SQL command ka weng ia ki jingtip ki bym donkam ha ka Base database file.
06:19	Kane kan khang shwa ia ka database, pynbit pynbiang ia ka data bad nangta kan plie biang ia ka database.
06:27	Mynta, ngi lah ruh ban pyndonkam da kawei ka command ha ka SQL window-
06:33	SHUTDOWN COMPACT.
06:36	Ka jingiapher hangne kadei ba kane ka command kam plie biang ia ka database.
06:43	Na ka bynta ki jingtip ba kham bun halor kane ka defragment, leit sha ka ‘hsqldb.org’ Chapter 11.
06:54	Khatduh, to ngin ia kren shaphang ka “Backups” kaban iarap ban buh ia ka database ha ka jaka ba shngain.
07:02	Ngi lah ban duh ia ka database jong ngi lada ka
07:06	Ka computer ka crash, lada duh ka Hard disk drive lane lada shah ktah ha ki Virus.
07:14	LibreOffice kadon ia ka wizard kaba biang ban pynioh biang bad pynduna ia ka jingduh noh ia ka data.
07:20	Hynrei kaba biang tam ban leh kadei ban buh ia ka backups jong ka database man kapor.
07:26	Bad ban shim ia ka backup kalong kaba suk bha.
07:30	Ngin donkam tang ban shna ia ka copy jong ka database file
07:34	Bad buh ia ka ha ka secondary media kum ka external hard disks lane CDs lane DVDs lane flash
07:47	Te, ban shim ia ka backup jong ka “Library database”, leit sha ka jaka ba ka ‘Library.odb’ file kadon.
07:57	Bad nangta, copy bad paste ia ka file ha kawei ka hard disk drive lane ha ka flash drive.
08:08	Mynta, kane kawei ka copy bad ka paste action ka lah biang ban backing up ia baroh kawei ka database
08:17	Ryngkat bad baroh ki data structures, data, forms, queries bad reports ha ka.
08:24	Katno sien ngi donkam ban shim ia ka backups?
08:28	Kane ka shong haduh katno sien ba ka database ka kylla ha ka ba iadei bad ki data lane ka structure jong ka.
08:37	Kaba mut- katno sien la pyndap, update lane pyndam ia ka data.
08:42	Bad katno sien ngi pynkylla ia ka table structure, forms, queries lane reports.
08:49	Te, ngi lah ban buh ia ka backups man ka sngi lane man ka taiew, katkum ba ngi pyndonkam ia ka database.
08:58	Hangne, ka kam na ka bynta jong phi-
09:00	Pynkylla ia ka “Member” table bad pyndap da ar tylli ki columns ba thymmai- “Address” bad “City”.
09:08	Ai ba baroh ar ki column jong ka data kin dei ha ka TEXT.
09:13	Bad ruh, plie ia ka “Members” table ha ka “Data Entry” mode bad thep katto katne ki sample data jong ka address bad city.
09:23	Hadien kane, Defragment ia ka ‘Library database’.
09:27	Khatduh, shim ia ka backup jong ka Library database, buh ia ka ha ka flash drive lane ha kawei ka hard disk drive, lada don.
09:38	Da kane ngi lah poi sha kaba kut jong kane ka jinghikai halor ka “Database Maintenance in LibreOffice Base”.
09:45	Ban kyllum lang, ngi la pule kumno ban:
09:48	* Khmih ia ka bit ka biang jong ka Database
09:50	* Pynkylla ia ka Database Structure
09:54	* Defragment ia ka database
09:56	* Bad shim ia ka Backups.
09:58	“Spoken Tutorial” project kadei shi bynta jong ka “Talk to a Teacher” project,
10:03	La kyrshan ia ka da ka National Mission on Education lyngba ka ICT, MHRD, Sorkar India.
10:10	Kane ka project la pynbit pynbiang da ka http://spoken-tutorial.org.
10:15	Kham bun ki jingtip halor kane kidon haka link harum.
10:20	Ia kane ka script la noh synniang da ka Priya Suresh, DesiCrew Solutions. Bad nga dei u Pdiangburom na Shillong, nga pynkut iane. Khublei shibun ia ka jingsnoh kti lang jong phi.

Contributors and Content Editors

Pdiangburom, PoojaMoolya, Pratik kamble