डेटाबेस अनुवाद के बारे में: क्या होता है, वे क्या करते हैं और क्या खाते हैं

ऐसा लगता है कि डेटाबेस अफ्रीका डेटाबेस में है , लेकिन प्रामाणिक तकनीकी साहित्य डेटाबेस (जिसे रूसी अनुवादकों ने पारंपरिक रूप से डीबीएमएस - डेटाबेस प्रबंधन प्रणाली के रूप में अनुवादित किया गया है) को पढ़ते हुए , मैंने कभी इस शब्द को नहीं देखा - डीबीएमएस - ने नहीं देखा है (जो बुरी तरह से देखा नहीं गया है) , लेकिन मैं झूठ नहीं बोलता) ।

तो, क्या यह शब्द गढ़ा गया है? और कितने ऐसे करते हैं?

इस प्रकाशन में, मैंने अंग्रेजी बोलने वाले लेखकों द्वारा विभिन्न आईटी साहित्य से तथाकथित "शब्दार्थ क्षेत्र" शब्द डेटाबेस के चारों ओर एकत्र किया है - कौन से डेटाबेस हैं, वे किस चीज से बने हैं और क्या खाते हैं । मुझे ऐसा लग रहा था कि यह सामान्य शब्दावलियों की तुलना में स्पष्ट रूप से अधिक स्पष्ट और विश्वसनीय होगा। बेशक, आप तय करते हैं।

तो चलते हैं।

कौन से हैं?

1980 के दशक के उत्तरार्ध में ऑब्जेक्ट डेटाबेस दिखाई दिए - 1990 के दशक की शुरुआत में और फिर से फैशन से बाहर हो गए।
ऑब्जेक्ट डेटाबेस 1980 के दशक के अंत और 1990 के दशक के प्रारंभ में फिर से आए और गए।

2000 के दशक की शुरुआत में XML डेटाबेस दिखाई दिए , लेकिन केवल संकीर्ण आवेदन मिला। 2000 के दशक की शुरुआत में
XML डेटाबेस दिखाई दिए, लेकिन केवल आला गोद लेने को देखा है।

NoSQL…
There are several driving forces behind the adoption of NoSQL databases…

…JSON. , , XML. , MongoDB, RethinkDB, CouchDB Espresso.
JSON has the appeal of being much simpler than XML. Document-oriented databases like MongoDB, RethinkDB, CouchDB, and Espresso support this data model.

, .
In document databases, joins are not needed for one-to-many tree structures, and support for joins is often weak.

— ,
Query optimizers for relational databases are complicated beasts, and they have consumed many years of research and development effort

2.3 Cypher, . 2.5 .
Example 2-3 shows the Cypher query to insert the lefthand portion of Figure 2-5 into a graph database

OLTP : .
In most OLTP databases, storage is laid out in a row-oriented fashion: all the values from one row of a table are stored next to each other.

, , . .
Many datasets are simply not that big, so it’s quite feasible to keep them entirely in memory, potentially distributed across several machines. This has led to the development of in-memory databases.

, , .
Similar to concurrency control in a multiuser database environment, locking requires that before the value of a global variable can be used or updated, the variable must be «checked out.»

, , , ( ) , . , , GenBank.
Researchers working with genome data often need to perform sequence-similarity searches, which means taking one very long string (representing a DNA molecule) and matching it against a large database of strings that are similar, but not identical. None of the databases described here can handle this kind of usage, which is why researchers have written specialized genome database software like GenBank.

, BitTorrent, .
Many peer-to-peer systems, such BitTorrent, do not have any central database of content.

, , .
This lookup process can be repeated indefinitely to build up a large local database of what is out there.

, .
All of the above applications involve interactions between a person and a remote database full of information.

? ?

, ?
Why should you, as an application developer, care how the database handles storage and retrieval internally?

— , .
Full-text search is arguably a kind of data model that is frequently used alongside databases.

db_set , , , .
Similarly to what db_set does, many databases internally use a log, which is an append-only data file.

SQL Server — .
A restore scenario in SQL Server is the process of restoring data from one or more backups and then recovering the database.

SQL Server CREATE , .
In SQL Server, CREATE statement creates a new database and the files used and their filegroups.

SQL Server ALTER , .
In SQL Server, ALTER statement modifies a database, or the files and filegroups associated with the database.

.
A dropped database can be re-created only by restoring a backup.

SQL Server. , .
Dropping a database deletes the database from an instance of SQL Server and deletes the physical disk files used by the database.

(. .: «» «» , :
— ALTER DROP ;
— UPDATE DELETE ).

.
If you make a mistake, you can use the snapshot to recover by reverting the database to the snapshot.

(. : , — « » — restore. ( ) - — recover).

, [ ] , .
Reverting is potentially much faster for this purpose than restoring from a backup; however, you cannot roll forward afterward.

(. : , , . « » ).

.
Using one class to read from and write to a database is a form of centralized control.

PHP- Web- .
It [PHP] can be embedded in Web pages to access and present database information.

SQL «-» , .
SQL is the de facto standard language for querying, updating, and managing relational databases.

, ?
How would they feel if that database was suddenly corrupted?

… within_recursive ( ).
… the within_recursive predicate can tell us all the locations in North America (or any other location name) contained in our database.

, .
Instead, each user maintains his own database locally and provides a list of other nearby people who are members of the system.

: .
In order to efficiently find the value for a particular key in the database, we need a different data structure: an index.

SQL Server.
The supported restore scenarios depend on the recovery model of the database and the edition of SQL Server.

— , , , , , .
A recovery model is a database property that controls how transactions are logged, whether the transaction log requires (and allows) backing up, and what kinds of restore operations are available.

SQL Server Database Engine .
For most restore scenarios, it is necessary to apply a transaction log backup and allow the SQL Server Database Engine to run the recovery process for the database to be brought online.

— , SQL Server - () .
Recovery is the process used by SQL Server for each database to start in a transactionally consistent — or clean — state.

— , , , , , .
The desire to hide implementation details is a wonderful reason to create a class whether the details are as complicated as a convoluted database access or as mundane as whether a specific data member is stored as a number or a string.

, , , .
Refactorings that involve class or routine interface changes, database schema changes, or changes to boolean tests, among others, tend to be more risky.

[ ] , . .
A data dictionary is a database that describes all the significant data in a project. In many cases, the data dictionary focuses primarily on database schemas.

…
Errors can include <…> improperly designing database tables…

, .
Code-generating tools tend to focus on database applications, but that includes a lot of applications.

, , .
The architecture should describe a plan for managing scarce resources such as database connections, threads, and handles.

, , , , , . .
The architecture should describe how the system will address growth in number of users, number of servers, number of network nodes, number of database records, size of database records, transaction volume, and so on.

?
Is the database organization and content specified?

, .frm ( ) , .
Consequently, I adopted a design convention that the .frm file (the form file) was allowed only to retrieve data from the database and store data back into the database. It wasn’t allowed to communicate that data directly to other parts of the program.

[] .
They [subsystems] make it easy to change the database design structure without changing most of the program.

« ?» .
A design question like «Will this database framework work?» does not provide enough direction for prototyping.

.
You don’t even need to know the database specifics.

CSS XSL/ XPath, , .
We also touched on CSS and XSL/XPath, which aren’t database query languages but have interesting parallels.

… , .
… data processing was changing from a computer-centered view of information systems to a database-centered view.

, (, ).
The change was to focus on a pool of data on which the computer happened to act (a database-oriented view).

, -, , .
You might also use prebuilt libraries of container classes, scientific functions, user interface classes, and database-manipulation classes.

, , , , , , .
To get Finance the data they need, we may have to cobble together some custom reports, which means bringing in the application developers or database people.

Oracle…
Upgrade thirty-five instances of Oracle databases…

: « ! ».
But Wes says, “That’s not a change! That’s just running a database script.

, , , -.
Before that change request would even come to us, I would expect him to get the nod from the application and database owners, and also the business.

… , .
A declarative query language … hides implementation details of the database engine, which makes it possible for the database system to introduce performance improvements without requiring any changes to queries.

(, , ). , .

: , , ,
:
:

• Code Complete by Steve McConnell
• Computer networks by Andrew Tannenbaum
• मार्टिन क्लेपमैन द्वारा डिजाइनिंग डेटा-गहन अनुप्रयोग
• जीन किम द्वारा फीनिक्स प्रोजेक्ट
• Microsoft SQL प्रलेखन , आदि।

प्रकाशन के बाद पीएस पहले से ही, मेरे सहयोगियों और मुझे पता चला कि डीबीएमएस ने मेरी आंख नहीं पकड़ी क्योंकि यह शब्द थोड़ा पुराना है और डेटाबेस में नए साहित्य में लगभग कभी भी उपयोग नहीं किया गया है। पुराने साहित्य में - हर समय। माफ़ करना।