ALERT

[LAST CHANCE] Data Layer: Modern Business, Defined

Database Repository

Definition - What does Database Repository mean?

A database repository is a logical, but also sometimes physical grouping of data from related but separate databases.

This is usually done when there is a 'higher purpose' for the data, but the data items needed to do this reside on different databases. In these cases a repository is necessary to bring together the discrete data items and operate on them as one.

Techopedia explains Database Repository

Database repositories are usually discussed and implemented in the realm of data warehousing and business intelligence. This usually requires a level of aggregation of data that the lowel-level databases simply cannot provide, thus necessitating the creation of a higher-level structure.

Consider the case of a large bank. Such an institution will likely be composed of several different subsidiaries, not in a physical, geographically-diverse sense, but rather in a functional or lines-of-business sense. There will be the traditional bank account division, in addition to a loans division, a forex and treasury division, an investment banking division, and a custody/ safe deposit division. All these divisions run their own separate information systems, which of course implies separate databases.

However, each division must report its own financials back to the head office. The Chief Financial Officer (CFO) needs to aggregate all the financial data from the various divisions to gauge their profitability, because these feed directly into the bank's overall financial position. You can see that the CFO's office is not really concerned with the operational part of the various databases, he is only really interested in the data that deals with financials. Another thing to note is that he relies completely on the divisions' reporting to inform him as to what decisions to take, he does not have own or generate any data himself.

Enter a data repository. This will likely be another system with its own database, distinct from all the others, that can directly access the relevant data from the other databases and aggregate it into meaningful information for the CFO. However, it is important to remember that the data and information the CFO is looking at may or may not be physically located on the data repository. The repository may simply read direct from the other databases, or, for performance reasons, it may store a local copy of the data it has accessed from the others. The repository will likely include the ability to show performance trends over time, compare and contrast divisions' targets, show deviations over along periods, and so on. Some of these goals are clearly in the context of Business Intelligence. Also, since our CFO is mostly interseted in reporting as opposed to data input and generation, his data repository will likely be a read-only system, or one with minimal writes, in addition to aggregating data going back over a long period. This function starts to cross over into the context of Data Warehousing.

A data repository is thus the logical aggregation of data items from separate databases into one centralized location for a specific purpose that cannot be achieved using the databases themselves.

Techopedia Deals

Connect with us

Techopedia on Linkedin
Techopedia on Linkedin
Tweat cdn.techopedia.com
"Techopedia" on Twitter


'@Techopedia'
Sign up for Techopedia's Free Newsletter!

Email Newsletter

Join thousands of others with our weekly newsletter

Resources
The 4th Era of IT Infrastructure: Superconverged Systems
The 4th Era of IT Infrastructure: Superconverged Systems:
Learn the benefits and limitations of the 3 generations of IT infrastructure – siloed, converged and hyperconverged – and discover how the 4th...
Approaches and Benefits of Network Virtualization
Approaches and Benefits of Network Virtualization:
Businesses today aspire to achieve a software-defined datacenter (SDDC) to enhance business agility and reduce operational complexity. However, the...
Free E-Book: Public Cloud Guide
Free E-Book: Public Cloud Guide:
This white paper is for leaders of Operations, Engineering, or Infrastructure teams who are creating or executing an IT roadmap.
Free Tool: Virtual Health Monitor
Free Tool: Virtual Health Monitor:
Virtual Health Monitor is a free virtualization monitoring and reporting tool for VMware, Hyper-V, RHEV, and XenServer environments.
Free 30 Day Trial – Turbonomic
Free 30 Day Trial – Turbonomic:
Turbonomic delivers an autonomic platform where virtual and cloud environments self-manage in real-time to assure application performance.