The term embedded database is used to describe two different database structures: connecting multiple databases, or an embedded database in another application or tool. While the initial description seems to imply that these two structures are quite different, they are not. In fact, they have many of the same structures.
man holding computer
A database is a collection of data from a variety of different sources organized in a structure. The database itself is made up of a series of semi-independent data tables. Each table contains specific information, usually on a per-table basis. The database can create links between separate tables, based on common elements, information, or programming logic. Queries can be written to create reports by accessing all the different tables in the database.
Connecting multiple databases into an integrated database is a very complex task. Connections between different databases need to be made and tested from a variety of perspectives to ensure the logic is sound. Different databases may also exist in different formats or programs. This adds complexity, but can be achieved using advanced programming logic and powerful features.
A common example of an integrated database is LexisNexis®. This tool provides access to content from a wide range of public sources, published information, and online information. Files remain with the original source, but complex logic allows users to identify documents that exist in multiple databases with a single tool. The time savings achieved with this method is a great benefit to users, as this type of survey usually takes several days to complete.
There is a wide variety of software that can be modified to work with an embedded database. The complexity of the work required depends on the language in which the software is written and the organization of the database. An excellent example of this type of software is a website content management software program. This type of software publishes information on the Internet from the database that contains all the different files, texts and images.
Using an integrated database, the content management tool can populate the site with current and relevant data from the accounting system, images from the document sharing tool, and sound files from the press office. Although this work is complex, significant savings can be achieved by not creating duplicate copies of the same database tables for each different purpose. The actual data stays in one place and is available to multiple applications as needed.
