answersLogoWhite

0


Best Answer

The index between relations databases is the common thread which ties them together. So if you have a column in each database called 'idnum' and IDNUM:001 in the first database corresponds with data in IDNUM:001 in the second database, the two databases are relational and IDNUM is their index.

User Avatar

Wiki User

16y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do relational databases use indexes?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Is Excel an example of a relational database?

No. It is a spreadsheet application. You can do simple databases in it, but it is not designed to create complex databases like relational databases. To do that you would use an actual database application.


What has the author Chao-Chih Yang written?

Chao-Chih Yang has written: 'Relational databases' -- subject(s): Relational databases


Who uses a relational database?

Anyone can use a relational database. All sorts of people use them, from private individuals to people in all sorts of businesses and organisations and other places. There are millions of relational databases in existence.


What has the author David Maier written?

David Maier has written: 'The theory of relational databases' -- subject(s): Database management, Relational databases


What is the importance of relational database?

Importance of relational database----------------------------------------------Relational databases can be considered as stores of information grouped together logically. Relational databases are used in all data related jobs. Especially in today's world of information, relational databases have increased importance, since they are used to store, manage, and retrieve data in a managed, organised and logical way. More information on relational databases, and their importance, can be found in detail here: http://tinyurl.com/relationaldatabase


Database management the origin and its growth in sql?

E. F. Codd introduced the term in his seminal paper "A Relational Model of Data for Large Shared Data Banks", published in 1970. In this paper and later papers he defined what he meant by relational. One well-known definition of what constitutes a relational database system is Codd's 12 rules. However, many of the early implementations of the relational model did not conform to all of Codd's rules, so the term gradually came to describe a broader class of database systems. Relational databases, as implemented in relational database management systems, have become a predominant choice for the storage of information in new databases used for financial records, manufacturing and logistical information, personnel data and much more. Relational databases have often replaced legacy hierarchical databases and network databases because they are easier to understand and use, even though they are much less efficient. As computer power has increased, the inefficiencies of relational databases, which made them impractical in earlier times, have been outweighed by their ease of use. However, relational databases have been challenged by Object Databases, which were introduced in an attempt to address the object-relational impedance mismatch in relational database, and XML databases. http://en.wikipedia.org/wiki/Relational_... http://en.wikipedia.org/wiki/Relational_...


What has the author Stefan Stanczyk written?

Stefan Stanczyk has written: 'Theory and practice of relational databases' -- subject(s): Relational databases, Database management


What kind of database exist?

The two major commercial classes of database are; relational and non-relational. Example of non-relational databases include Informix c-isam and dbisam. The main relational databases are; MS SQL Server, Sybase, Oracle, Progress, mySQL.


What operating system does relational database use?

Relational databases can be run on almost all modern operating systems, including Windows, Linux, FreeBSD, and Mac OS X.


Compare contrast relational databases object-relational databases and object-oriented databases Site an example or scenario where each type is best used?

A relational database is structure to recognize relations among information, and stores the information in tables. An object-oriented database focuses on presenting the information in the form of objects, to be used for object-oriented programming. Object-relational databases are a hybrid of the two, keeping relations stored but still keeping the object-type data. Relational databases are best for presentation of the data itself, while object-oriented databases are better for deriving new information from given information.


Example of ralational databases?

Microsoft Access is a relational database.


What is the main limitation of network databases?

Overhead associated with maintaining indexes.