OCC's data warehouse will be the sum of its marts

The Office of the Comptroller of the Currency has created an information architecture to help it build a data warehouse, one data mart at a time, over the next several years. The warehouse has to be built as a multimart environment, the office's senior data analyst Vance Kane said. "We have different lines of business—financial institutions, human resources. To have one database warehouse is fantasyland from my perspective," he said.

The Office of the Comptroller of the Currency has created an information architecture
to help it build a data warehouse, one data mart at a time, over the next several years.


The warehouse has to be built as a multimart environment, the office’s senior data
analyst Vance Kane said. “We have different lines of business—financial
institutions, human resources. To have one database warehouse is fantasyland from my
perspective,” he said.


Yet, OCC did not want “independent islands of information” either, added
information services director Charles Wright.


Unless the office’s plan combined the disparate data, it would not make any
improvement over the legacy database systems OCC now has. So the office is planning a data
warehouse that links data marts customized to meet the needs of particular user groups.


OCC will build the various data marts over several years. “We can’t wait and
roll out the data warehouse all at one time. It has to be done incrementally,” Wright
said.


To achieve its goal, OCC assembled a data architecture plan that requires that the
office standardize information before entering it in a data mart. For example, OCC chose
one day to be the basic time measure, Kane said. Though one day may be too small a measure
for data that is updated quarterly, OCC needed a measure that would work for everyone, he
said.


If queried on the same question, each data mart must give the same answer based on the
time period given, Kane said. In the past, two databases would give different answers
because they were using different units of measurement or were basing the answer on
different assumptions.


But with the caveat, “based on time period given,” OCC has the leeway to keep
to the standard even though one data mart may not be as up-to-date as another, Kane said.


To get the data into the same format, OCC set up what it calls a data warehouse staging
area. It is here that the office converts and standardizes data for inclusion in a data
mart, Kane said.


“The warehouse environment is the factory for the data mart,” he said.


So far, OCC has built one data mart for its U.S. and Foreign Branches Division and has
begun work on a second for its Country Exposure and Transfer Risk Division.


Before the data mart, the U.S. and Foreign Branches Division had to go to four
different systems get the same data, and field examiners lacked access altogether,
division director Jose Tuya said.


“We are a small, self-contained unit but have all these sources of data; we made
an ideal test case,” Tuya said.


OCC has settled on Microsoft SQL Server and IBM DB2 software for its data marts. Users
will access data housed on Compaq 1850R, ProLiant 6500 and ProLiant 7000 servers running
Microsoft Windows NT.


“The first data mart is using SQL Server, but for data marts targeted at a larger
audience we would use DB2,” Kane said.


The selection of front-end software is a good example of OCC’s effort to meet
users’ needs. For the first data mart, OCC used BusinessObjects decision support
software from Business Objects Inc. of San Jose, Calif.


But OCC economists may want software that will provide more sophisticated statistical
analyses, Kane said. One possibility is the Statistical Analysis System from SAS Institute
Inc. of Cary, N.C., he said.


The data mart documentation and source data definitions are stored in a warehouse
repository, separate from the front-end software, Kane said. Keeping the information used
by all data marts separate from the front-end software will reduce retyping and give the
office the freedom to use other software for future data marts, he said.


The office also wants the flexibility to change part or all the equipment and software.


“It could be conceivable that we may need a larger platform than SQL Server or
DB2. From talking to other organizations, [we know] data warehouses tend to grow very
fast,” Kane said.


One likely change will be to make the data marts accessible via an intranet. Using an
intranet looks and feels similar to browsing the Internet, and most people like the
Internet, Kane said.


For now, OCC will wait for Web server software products on the market to mature a bit.
Web software, in general, is behind client-server software in the capabilities it offers,
Kane said.


It is possible that the move to an intranet will delay the debut of a mart for
OCC’s Country Exposure and Transfer Risk Division.


The first mart, for the U.S. and Foreign Branches Division, has its users concentrated
in the Northeast, and the second mart’s users are spread throughout the country, said
Frank Carbone, a senior adviser in the International Banking and Finance Division.


Setting up a data warehouse, “sounds easy, but as you work your way into it, there
are stumbling blocks,” Kane said.


X
This website uses cookies to enhance user experience and to analyze performance and traffic on our website. We also share information about your use of our site with our social media, advertising and analytics partners. Learn More / Do Not Sell My Personal Information
Accept Cookies
X
Cookie Preferences Cookie List

Do Not Sell My Personal Information

When you visit our website, we store cookies on your browser to collect information. The information collected might relate to you, your preferences or your device, and is mostly used to make the site work as you expect it to and to provide a more personalized web experience. However, you can choose not to allow certain types of cookies, which may impact your experience of the site and the services we are able to offer. Click on the different category headings to find out more and change our default settings according to your preference. You cannot opt-out of our First Party Strictly Necessary Cookies as they are deployed in order to ensure the proper functioning of our website (such as prompting the cookie banner and remembering your settings, to log into your account, to redirect you when you log out, etc.). For more information about the First and Third Party Cookies used please follow this link.

Allow All Cookies

Manage Consent Preferences

Strictly Necessary Cookies - Always Active

We do not allow you to opt-out of our certain cookies, as they are necessary to ensure the proper functioning of our website (such as prompting our cookie banner and remembering your privacy choices) and/or to monitor site performance. These cookies are not used in a way that constitutes a “sale” of your data under the CCPA. You can set your browser to block or alert you about these cookies, but some parts of the site will not work as intended if you do so. You can usually find these settings in the Options or Preferences menu of your browser. Visit www.allaboutcookies.org to learn more.

Sale of Personal Data, Targeting & Social Media Cookies

Under the California Consumer Privacy Act, you have the right to opt-out of the sale of your personal information to third parties. These cookies collect information for analytics and to personalize your experience with targeted ads. You may exercise your right to opt out of the sale of personal information by using this toggle switch. If you opt out we will not be able to offer you personalised ads and will not hand over your personal information to any third parties. Additionally, you may contact our legal department for further clarification about your rights as a California consumer by using this Exercise My Rights link

If you have enabled privacy controls on your browser (such as a plugin), we have to take that as a valid request to opt-out. Therefore we would not be able to track your activity through the web. This may affect our ability to personalize ads according to your preferences.

Targeting cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.

Social media cookies are set by a range of social media services that we have added to the site to enable you to share our content with your friends and networks. They are capable of tracking your browser across other sites and building up a profile of your interests. This may impact the content and messages you see on other websites you visit. If you do not allow these cookies you may not be able to use or see these sharing tools.

If you want to opt out of all of our lead reports and lists, please submit a privacy request at our Do Not Sell page.

Save Settings
Cookie Preferences Cookie List

Cookie List

A cookie is a small piece of data (text file) that a website – when visited by a user – asks your browser to store on your device in order to remember information about you, such as your language preference or login information. Those cookies are set by us and called first-party cookies. We also use third-party cookies – which are cookies from a domain different than the domain of the website you are visiting – for our advertising and marketing efforts. More specifically, we use cookies and other tracking technologies for the following purposes:

Strictly Necessary Cookies

We do not allow you to opt-out of our certain cookies, as they are necessary to ensure the proper functioning of our website (such as prompting our cookie banner and remembering your privacy choices) and/or to monitor site performance. These cookies are not used in a way that constitutes a “sale” of your data under the CCPA. You can set your browser to block or alert you about these cookies, but some parts of the site will not work as intended if you do so. You can usually find these settings in the Options or Preferences menu of your browser. Visit www.allaboutcookies.org to learn more.

Functional Cookies

We do not allow you to opt-out of our certain cookies, as they are necessary to ensure the proper functioning of our website (such as prompting our cookie banner and remembering your privacy choices) and/or to monitor site performance. These cookies are not used in a way that constitutes a “sale” of your data under the CCPA. You can set your browser to block or alert you about these cookies, but some parts of the site will not work as intended if you do so. You can usually find these settings in the Options or Preferences menu of your browser. Visit www.allaboutcookies.org to learn more.

Performance Cookies

We do not allow you to opt-out of our certain cookies, as they are necessary to ensure the proper functioning of our website (such as prompting our cookie banner and remembering your privacy choices) and/or to monitor site performance. These cookies are not used in a way that constitutes a “sale” of your data under the CCPA. You can set your browser to block or alert you about these cookies, but some parts of the site will not work as intended if you do so. You can usually find these settings in the Options or Preferences menu of your browser. Visit www.allaboutcookies.org to learn more.

Sale of Personal Data

We also use cookies to personalize your experience on our websites, including by determining the most relevant content and advertisements to show you, and to monitor site traffic and performance, so that we may improve our websites and your experience. You may opt out of our use of such cookies (and the associated “sale” of your Personal Information) by using this toggle switch. You will still see some advertising, regardless of your selection. Because we do not track you across different devices, browsers and GEMG properties, your selection will take effect only on this browser, this device and this website.

Social Media Cookies

We also use cookies to personalize your experience on our websites, including by determining the most relevant content and advertisements to show you, and to monitor site traffic and performance, so that we may improve our websites and your experience. You may opt out of our use of such cookies (and the associated “sale” of your Personal Information) by using this toggle switch. You will still see some advertising, regardless of your selection. Because we do not track you across different devices, browsers and GEMG properties, your selection will take effect only on this browser, this device and this website.

Targeting Cookies

We also use cookies to personalize your experience on our websites, including by determining the most relevant content and advertisements to show you, and to monitor site traffic and performance, so that we may improve our websites and your experience. You may opt out of our use of such cookies (and the associated “sale” of your Personal Information) by using this toggle switch. You will still see some advertising, regardless of your selection. Because we do not track you across different devices, browsers and GEMG properties, your selection will take effect only on this browser, this device and this website.