Aralin 9/13 · 17 salita · 0 natutunan
Databases and data management
Mga database at pamamahala ng datos
ibalik, i-restore
to bring something, such as data or a system, back to its earlier condition, for example from a backup
We restored the deleted files from last night's backup.
Ibinalik namin ang mga nabura na file mula sa backup kagabi.
It took four hours to restore the service after the crash.
Kasingkahuluganrecoverrevivereestablishrebuildrepairreinstatereturnbring backKasalungatdamagedestroyimpairworsendegradebatayan ng datos, imbakan ng datos
an organized collection of data stored on a computer so that it can be searched, updated and managed easily
All customer orders are stored in a central database.
Nakaimbak ang lahat ng order ng customer sa isang sentral na batayan ng datos.
The database administrator checks the database performance every morning.
Kasingkahuluganrepositorydata storedata bankKasalungatnoneDBMS, sistema sa pamamahala ng batayan ng datos
database management system: software used to create, manage and control access to databases
MySQL and Oracle are two widely used DBMS products.
Ang MySQL at Oracle ay dalawang malawakang ginagamit na DBMS.
The DBMS controls which users can read or change the data.
Kasingkahulugandatabase systemdatabase management systemdata management systemKasalungatfile systemgumawa ng ekstrang kopya, magtabi ng kopya
to make an extra copy of data or files so they can be recovered if the original is lost or damaged
The system backs up the database automatically every night.
Awtomatikong gumagawa ang sistema ng ekstrang kopya ng database tuwing gabi.
Remember to back up your files before you reinstall the operating system.
KasingkahulugansupportcopyduplicatesavepreserveKasalungatdeleteremoveeraserelasyonal na batayan ng datos, relasyonal na database
a database that stores data in tables which are linked to each other by shared values
Our accounting system uses a relational database with over two hundred tables.
Gumagamit ang aming sistema sa accounting ng relasyonal na batayan ng datos na may mahigit dalawandaang talahanayan.
In a relational database, customers and orders are stored in separate but linked tables.
talahanayan, talaan
a set of data in a database arranged in rows and columns, usually about one type of thing
The customer table contains names, phone numbers and addresses.
Nilalaman ng talahanayan ng customer ang mga pangalan, numero ng telepono at address.
We added a new table to store product reviews.
patlang
one piece of information in a record, such as a name or date, usually one column in a table
The email field in the customer form cannot be left empty.
Hindi maaaring iwanang blangko ang patlang ng email sa form ng customer.
We added a new field to record each customer's preferred language.
pangunahing susi
a field whose value is different for every record, used to identify each row in a table
The customer ID is the primary key of the customer table.
Ang ID ng customer ang pangunahing susi ng talahanayan ng customer.
Two records cannot have the same primary key.
banyagang susi, dayuhang susi
a field in one table that refers to the primary key of another table, linking the two tables
The orders table uses customer ID as a foreign key.
Ginagamit ng talahanayan ng mga order ang ID ng customer bilang banyagang susi.
The delete failed because of a foreign key constraint.
kwery, hiling ng datos
a request for specific data from a database, usually written in SQL
This query returns all orders placed in the last thirty days.
Ibinabalik ng kwery na ito ang lahat ng order na ginawa sa nakalipas na tatlumpung araw.
The report is slow because one query takes almost a minute to run.
SQL, wikang pang-kwery na may istruktura
Structured Query Language: the standard language used to create, read and change data in relational databases
Data analysts use SQL every day to pull figures for reports.
Araw-araw na gumagamit ng SQL ang mga data analyst para kumuha ng mga numero para sa mga ulat.
The test checks basic SQL skills such as joining tables.
NoSQL, hindi-relasyonal na batayan ng datos
a type of database that stores data in flexible formats such as documents, rather than in fixed tables
We chose a NoSQL database because the product data has no fixed structure.
Pinili namin ang NoSQL na database dahil walang nakapirming istruktura ang datos ng produkto.
NoSQL databases are often used for real-time apps with large amounts of data.
iskema, balangkas ng batayan ng datos
the structure of a database, describing its tables, fields and the links between them
Any change to the database schema must be reviewed by the lead developer.
Dapat suriin ng lead developer ang anumang pagbabago sa iskema ng database.
The schema shows how customers, orders and products are related.
indeks
a structure in a database that helps find data in a table much faster
Adding an index to the email column made the search ten times faster.
Nang magdagdag ng indeks sa kolum ng email, naging sampung beses na mas mabilis ang paghahanap.
Too many indexes can slow down inserts and updates.
paglilipat ng datos, migrasyon ng datos
the process of moving data from one system, format or storage location to another
The data migration to the new ERP system took three weekends.
Tatlong weekend ang inabot ng paglilipat ng datos sa bagong sistemang ERP.
We tested the data migration carefully to make sure no records were lost.
integridad ng datos
the accuracy, completeness and consistency of data over its whole life
Foreign keys help protect data integrity in the database.
Nakatutulong ang mga banyagang susi para protektahan ang integridad ng datos sa database.
The audit found data integrity problems in the sales records.

