Logical Database Design

30 09 2008

Because of the differences in intent and purpose between operational systems and BI applications, different database design techniques have been devised for BI target databases. These highly denormalized designs store aggregated and summarized data in a multidimensional fashion. Logical database designs are documented as physical data models with technical meta data.

Aggregation and summarization are probably the most significant contributors to good BI application performance. If most business analysts need to see their data summarized, these totals should be precalculated and stored for quick retrieval. It is important to discuss the level of granularity with the business representative, as well as with other business analysts who will be using the BI target databases, since they will expect the database design to allow them to drill down to a certain level of detail.

Multidimensional database designs support the quick retrieval of a wide range of data. Two popular multidimensional design techniques are the star schema and the snowflake schema, both described below.

taken from; Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications



A Mission Greater than Earning a Paycheck

29 09 2008

Can a modern corporation thrive in a capitalistic world and be profitable while doing the right thing, even if it means that short-term profits are not always the first goal? I believe that Toyota’s biggest contribution to the corporate world is that of providing a real-life example that this is possible.

Throughout my visits to Toyota in Japan and the United States, in engineering, purchasing, and manufacturing, one theme stands out. Every person I have talked with has a sense of purpose greater than earning a paycheck. They feel a greater sense of mission for the company and can distinguish right from wrong with regard to that mission. They have learned the Toyota Way from their Japanese sensei (mentors) and the message is consistent: Do the right thing for the company, its employees, the customer, and society as a whole. Toyota’s strong sense of mission and commitment to its customers, employees, and society is the foundation for all the other principles and the missing ingredient in most companies trying to emulate Toyota.

When I interviewed Toyota executives and managers for this book, I asked them why Toyota existed as a business. The responses were remarkably consistent. For example, Jim Press, Executive Vice President and C.O.O. of Toyota Motor Sales in North America and one of two American Managing Directors of Toyota, explained:

The purpose of the money we make is not for us as a company to gain, and it’s not for us as associates to see our stock portfolio grow or anything like that. The purpose is so we can reinvest in the future, so we can continue to do this. That’s the purpose of our investment. And to help society and to help the community, and to contribute back to the community that we’re fortunate enough to do business in. I’ve got a trillion examples of that.

This is not to say that Toyota does not care about cutting costs. Shortly after World War II, Toyota nearly went bankrupt, which led to the resignation of the company founder—Kiichiro Toyoda. Toyota pledged to become debt-free. Cost reduction has been a passion since Taiichi Ohno began eliminating wasted motions on the shop floor. Often this led to removing a worker from a line or cell, to be placed in another job so one less worker had to be hired in the future. Toyota now has a rigorous “Total Budget Control System” in which monthly data is used to monitor the budgets of all the divisions down to the tiniest expenditure.

I asked many of the Toyota managers I interviewed if cost reduction is a priority and they just laughed. Their answers amounted to “You haven’t seen anything until you’ve experienced the cost-consciousness of Toyota—down to pennies.” Yet cost reduction is not the underlying principle that drives Toyota. For example, Toyota would no sooner fire its employees because of a temporary downturn in sales than most of us would put our sons and daughters out on the street because our stock investments went bad. Toyota executives understand their place in the history of the company. They are working within a long-term philosophical mission to bring the company to the next level. The company is like an organism nurturing itself, constantly protecting and growing its offspring, so that it can continue to grow and stay strong. In this day and age of cynicism about the ethics of corporate officers and the place of large capitalistic corporations in civilized society, the Toyota Way provides an alternative model of what happens when you align almost 250,000 people to a common purpose that is bigger than making money. Toyota’s starting point in business is to generate value for the customer, society, and the economy.

taken from; The Toyota Way:14 Management Principles from the World’s Greatest Manufacturer



BI Target Databases

28 09 2008

Contrary to the data-in philosophy (data entry) of operational systems, the data-out philosophy (reporting and querying) of BI applications includes the following design considerations.

  • BI target databases are designed for simplified, high-performance data retrieval, not for efficiency of data storage and maintenance (which are important design considerations for operational databases).

  • Eliminating or minimizing data redundancy is not a goal in designing BI target databases. If a choice must be made, data redundancy is favored over complexity, but the redundancy must be controlled. Redundant data must be consistent and reconcilable.

  • Basic assumptions for designing BI target databases are listed below.

    - Data is stored in such a manner that it is readily accessible in ways that are of interest to the business people.

    - The design is driven by access and usage.

    - A normalized design is not necessarily intuitive for a business person and could therefore become quite complex.

    - No BI data can be invented! All data in the BI target databases must exist in or be derivable from current internal or external operational data sources.

A key decision for all BI applications is whether or not, and at what level, to store summarized data in the BI target databases. The database administrator and the lead developer may decide to store both detailed data and summarized data, either together in the same BI target database or in different BI target databases. This database design decision must be based on access and usage requirements.

taken from; Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications



Telling Ourselves

27 09 2008

At the height of the dot-com craze, at an “Internet boot camp” near Silicon Valley, a thousand people gathered in a ballroom to learn how to become Internet entrepreneurs. PowerPoint presentation after PowerPoint presentation told the audience how to do it. But the real action was between presentations. During the coffee breaks, participants could go to booths, lined up as if going to confession, to tell their stories to and receive feedback from specialists on the “elevator pitch,” the two-minute compact story used to talk your way in the door of a new career. The waiting lines were long.

In one of those lines was Roy Holstrom, a fifty-three-year-old mechanical engineer. A victim of his manufacturing firm’s last wave of downsizing, Roy had quickly come to the conclusion, in the spirit of Groucho Marx, that he did not want to join any corporation that would have him. He had spent his severance time in the library, searching for patents without a home. After months of research, he had found the needle in a haystack—a solar energy device—and had tracked down the inventor, proposing that they join forces. Now he was at boot camp, hoping to find capital or advisory board members. And to get those, he knew he needed to get the story just right. He was in line for a second round of coaching on his pitch.

People devote considerable energy to developing their stories—what key experiences marked their path; what meanings they attribute to those experiences; and, more importantly, what common thread links old and new.[23] Precisely for that reason, some academics argue that interviewing people about why and how they are changing is a flawed approach. Interviews, the argument goes, just yield a self-presentation: the cleaned-up identity a person puts on for the outside world. They can never unearth the “truth” because, as any good social psychologist will tell us, people can’t resist embellishing their stories, making themselves look braver and smarter than they really are and coming up with logical explanations for events that are really random. So our stories never reflect objective reality.

That is why revising our stories is a fundamental tool for reinventing ourselves. One of the central identity problems that has to be worked out during a career transition is deciding on the story that links the old and new self. Until that is solved, the external audience to whom we are selling our reinvention remains dubious, and we too feel unsettled and uncertain of our own identity. To be compelling, the story must explain why we must reinvent ourselves, who we are becoming, and how we will get there. Early versions are always rough drafts. They get floated to friends, families, and new contacts, whose reactions prompt revisions. Since often we don’t know exactly where we are going or what the critical events along the way will be, the story will necessarily go through many iterations before it is finalized.

At the very start of a transition, when all we have is a long laundry list of possible selves, it unsettles us that we have no story. We are disturbed to find so many different options appealing, and we worry that the same self who once chose what we no longer want to do, might again make a bad choice. One person in transition out of the finance world put it plainly: “It concerns me that I’ve opened the array of possibilities so broadly. I want to make sure I’m going in the right direction, that whatever I end up doing is really satisfying. But when I see the different types of opportunities I am considering, I wonder if I know what really is my identity. How do I define myself, and how do others define me?” Julio Gonzales, who had been miserable for years as a heart surgeon, worried about making a change that would threaten his family’s financial security. If medicine had been such a misguided choice, how could he know that a different choice would not be equally misguided? To act with assurance—to take a chance on ourselves—we have to make a convincing internal pitch.

Until we have a story, others view us as unfocused. It is harder to get their help. Equally important is having a good story to tell others, putting it into the public sphere even before it is fully formed. By making public declarations about what we seek and what common thread binds our old and new selves, we clarify our intentions and improve our ability to enlist others’ support. Like Roy Holstrom’s elevator pitch, this is partially a problem of self-marketing. We need someone to take a chance on us since, by definition, we are moving into a new and unproven realm. Potential employers or coworkers come to know (and therefore, trust) us when they know our story and can accept it as legitimate. Sometimes it takes many rehearsals before it comes out just right. What happens in the retelling is not just a more polished story; we finally settle on a narrative that can inform the next step.

When stuck in the morass of the transition period, we hope desperately for a defining moment that will impel us to quick and decisive action. We wait for an epiphany when the clouds part and everything clarifies. But the causal sequence is really the other way around: Insight is an effect, not a cause; our diffuse hopes and dissatisfactions jell when we are getting close, the result of having struggled and floundered in the transition. There is not much we can do to manufacture the turning points that lend dramatic form to our stories. But when events happen that serve our purposes, we can weave them into the fabric of our reinvention narratives to use them to explain—to ourselves as much as to others—why we are changing.

[23]Gergen, Realities and Relationships.

taken from; Working Identity: Unconventional Strategies for Reinventing Your Career



Meta Data Repository Analysis Activities

26 09 2008
  1. Analyze the meta data repository requirements.

    Work with the business representative to determine and prioritize the meta data requirements for your specific BI project. Indicate which of the meta data components are mandatory, important, and optional. If a meta data repository already exists, determine which meta data components need to be added, if any. Update the latest version of the application requirements document (revised during or after prototyping).

  2. Analyze the interface requirements for the meta data repository.

    Whether a meta data repository is licensed or built, it must accept meta data from different sources. Business meta data will have to be extracted from CASE tools, word processing documents, or spreadsheets. Technical meta data will have to be extracted and merged from database management system (DBMS) dictionaries, ETL tools, data-cleansing tools, OLAP tools, report writers, and data mining tools.

  3. Analyze the meta data repository access and reporting requirements.

    Populating a database is meaningless unless the content can be accessed, queried, and reported. This is as true for meta data as it is for business data. Identify the meta data access requirements, security requirements, and help function requirements. Evaluate alternative display modes, such as Portable Document Format (PDF), Hypertext Markup Language (HTML), SQL, canned queries, or proprietary meta data repository reporting software. A context-sensitive help tutorial would be a beneficial feature to include.

  4. Create the logical meta model.

    Draw the logical meta model as an E-R model to explicitly show the relationships between meta data objects, even if you plan to implement the meta data repository as an OO database.

  5. Create the meta-meta data.

    While the logical meta model shows the meta data repository requirements at a glance, the meta-meta data describes the required meta data components in detail.

taken from; Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications



Windows of Opportunity

25 09 2008

Julio Gonzales, like many of his fellow students in a one-year midcareer master’s program, approached the end of his sabbatical with a mix of anxiety and anticipation. That year had given all the students a chance to design experiments, to make new connections, and to step back from daily routines. A lot had happened in that year, enough to raise awareness of the problems, but in many cases, not enough to point to good solutions. Time had run out. When Julio and his peers started the program, a year had seemed like an eternity. But major transitions often require two or three years. Now the questions burning in their minds were: “Can I take an interim step? If I do that, how do I protect myself from falling back into the same old, same old? How long do I have before inertia sets in?”

These are very good questions. In a series of studies on the introduction of new technologies (for instance, software engineering tools or graphics software), MIT researchers discovered a windows of opportunity effect.[20] They found that managers have only a discrete time period in which to effect a real change after introducing a new technology. After that period, use of the technology tended to “congeal,” freezing unresolved problems in the technology and fixing its use in a specific organizational context, at least until the next crisis. Adaptation to new technologies was rarely a smooth, continuous process. Rather, it occurred in fits and stops; whatever changes did not get made at first were put off for much later, usually not until the consequences of those latent problems accumulated to provoke a crisis, opening the next window for change. Research on leaders newly taking charge of organizations shows the same effect: New leaders have a fixed time period in which to make changes; after that, it gets harder.[21]

Nathalie Gaumont, a thirty-nine-year-old French nutritionist and M.B.A., came to understand the windows-of-opportunity effect. In the heat of the moment, she informally accepted an attractive job offer from a former boss. It was the perfect offer, according to Susan Fontaine’s logic of CV progression. Nathalie would move up a big notch in prestige and responsibility, moving from heading a European group to overseeing operations worldwide. The new firm, Nomad, was moving up economically, while her current employer was losing market share. But as a senior nutritionist for the European division of a major U.S. food company, she was already feeling burned out; the new job meant even more responsibility, more hours, and more international travel. The one thing she knew was that she wanted less of all that. And the new job offered only an incremental change. Approaching forty, she wondered whether the time was “now or never” to make a sweeping change in her life. But could she pass up a concrete offer that promised at least some change to her professional life?

Reason told her to go for it.

I figured there would be more opportunities for growth—lateral moves, taking on other brands. I can’t go any higher at Packard and stay in Europe. And, the company is not doing so well; it’s losing market share worldwide. Now I have a staff job and report to a vice president rather than a division head. I’m getting further and further removed from upper management and am losing visibility. I’m spending a lot of time on regulatory issues, lobbying work, when I’d prefer to be closer to the heart of the business. The downside at Nomad is that I’d be reporting to someone based in Japan. The areas Nomad wants to develop are in Latin America and Asia-Pacific. I already travel more than I want to, but at least it’s within Europe. At Nomad, I’d have two or three big trips each month. I’ve tried to ask how much, but the answer is always that it would be up to me. And I just found out the job will not be based in the city, as I thought. That means a long commute each day.

It was confusing. Nathalie had had little time for any activity outside her job, much less time to devote to any kind of concerted job search.

My job has been very intense. I’m very committed and passionate about it. I work every weekend. Two or three times a week I’m on an airplane. I just endure; I’m a good soldier. I let people put stuff on my back. I have a hard time saying no. But I feel that I’m caught in a spiral. Am I going to keep going in circles? Here is change coming to me on a silver platter. It isn’t perfect, but it’s an escape hatch. I know myself. If I stay here, despite all good intentions, I will easily fall right back into the routine.

Two unexpected events made her question her decision to take the new job. A close friend died, at the age of fifty, from liver cancer. Before she died, she advised Nathalie to get out of the rut and pressure of her business life. Then, a necessary surgical procedure resulted in a one-month medical leave. Nathalie suddenly had time to think through what she really wanted. Jolted by her friend’s untimely death, on medical leave she started considering things she never before found time for.

This month, I’ve had some ideas but they are not precise. I’m interested in doing a thesis on the sociology of eating behaviors, to understand the real barriers to healthy eating. When I was younger, I went to an arts high school and joined a dance company. But then I gave that up when I thought I’d go to medical school. I’ve been wondering about going back to something in the health field. I think I’d be happy in a medical setting dealing with real people rather than with dossiers and projects. I wonder if I can transfer my business school skills to a health-related NGO like Doctors without Borders.

Realizing that the proposed job change would only delay the serious thinking she needed to do, Nathalie decided to decline the “perfect offer” in order to buy some time to pursue a true career shift. Then, true to her own predictions, she got caught right back in the routine. Two years later, she was still at the first company, still not sure how to move out. Maybe she was not yet ready for change, or maybe one month was not enough time to build momentum. Or maybe failing to start something new in the window right after her leave kept her stuck.

Nathalie’s story is a cautionary tale. Windows of opportunity open and close back up again. We go through periods when we are highly receptive to major change and periods when even incremental deviations are hard to tolerate.[22] What we do in the period immediately following a time-out determines whether we will be able to use that experience to effect real change or whether, instead, old routines will reassert themselves, leaving basic problems unresolved until urgency builds the next time around.

[20]Marcie J. Tyre and Wanda Orlikowski, “Windows of Opportunity,” Organization Science 5, no. 1 (1994); Connie J. G. Gersick, “Making Time: Predictable Transitions in Task Groups,” Academy of Management Journal 32, no. 2 (1989): 274–309.

[21]John J. Gabarro, The Dynamics of Taking Charge (Boston: Harvard Business School Press, 1986).

[22]Daniel J. Levinson, The Seasons of a Man’s Life (New York: Knopf, 1985).

taken from; Working Identity: Unconventional Strategies for Reinventing Your Career



Fancy watches and jewelries

25 09 2008

Do you want to have classy hand watches but you don’t have enough money to buy them? Do you ever think to buy used or preowned classy hand watches but you don’t know where to find them? Your question has an answer now. The answer is Gray & Sons. Gray & Sons is an online store that sells fancy used or preowned hand watches.

The collections that this company has is varies, almost all of well known of luxury hand watches are provided. You can find Rolex watches, Cartier watches, Patek Philippe watches, Omega watches and many more. You can choose one that really suits you. You don’t have to worry about the price because once again, these watches are all used and preowned. If you want to find more complete collection of these watches you can go to their official website. For example Rolex homepage can be visited at rolex.com.

Besides those fancy hand watches this website also sell jewelry. The collection is also various, the website divide this jewelry into some categories. Some of them are, bracelets and bangles, earrings, necklaces, rings and pendants. If you are interested in this stuff you can just go to the website and make an order. The homepage is grayandsons.com. For those who have watches from above mentioned brands that seek for the original bands can also fin them in this website. As we know to find original band for luxurious watches is rather difficult, more over we have to match the bands available with the type of the watches we have. Many bands from different brands are available, I bet you can find yours here. This website is dedicated for you that really praise the style. Not just watches and jewelry, you will find something that you will not find in other place,it is pride.



Meta-Meta Data

24 09 2008

Since meta data is the contextual information about business data, meta-meta data is the contextual information about meta data. Many components of meta-meta data are similar to those of meta data. For example, every meta data object should have components that cover name, definition, size and length, content, ownership, relationship, business rules, security, cleanliness, physical location, applicability, timeliness, volume, and notes. The meta-meta data for a meta data object might look like this:

  • Name: Entity

  • Relationship: related to one or many tables

  • Security: read by all, updated by the data administrator

  • Ownership: the data administrator

  • Origin: ERWIN CASE tool

  • Physical location: MDRSYSENT table

  • Cleanliness: 2 percent missing data

  • Timeliness: last updated on November 1, 2002

  • Volume and growth: 2,391 rows, growth rate 1 percent annually

taken from; Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications



Stepping Back

23 09 2008

The French phrase reculer pour mieux sauter literally means “stepping back to better leap forward.” It expresses how much we need perspective to arrive at the novel recombination of existing elements that defines an invention or creation.[17] Jane Stevens, a thirty-two-year-old with an M.B.A. in finance, knew something was wrong in her life but could not put her finger on it. Awareness clicked during a solo, ten-hour drive to a college friend’s wedding. Five years earlier, while working on her master’s degree in international development, Jane had gotten a dream offer, a project with a young firm doing pioneering lending work in Latin America. The project led to a country-manager role, then a position as regional director creating institutions that served the needs of craftspeople known as “microentrepreneurs.”

I was doing something I really believed in, using a business model that works, and the results were spectacular. But I had stopped feeling fulfilled. Being in consulting was no longer gratifying. And the calculus of my professional and personal lives was changing. I was on the road all the time and wanted to put down some roots. I was not developing my own life and knew I had to invest in myself differently to have a family. And I was working very long hours for nonprofit wages.

All these things lurked in the back of her mind, but Jane had not had the time or psychological distance to analyze all these elements in tandem. “I was in cognitive dissonance for six months, caught between the growing realization that I wasn’t happy and my belief in the vision of my firm.” During the ten hours in the car, however, she put together the pieces in a way that led to an obvious conclusion. After that, things happened very quickly. Two weeks later, at her five-year M.B.A. reunion, she reconnected with two former classmates who had acquired a group of firms in the telecommunications industry. By the end of the weekend, they told her they had a new company and they wanted her to run it. A week later, she accepted their formal offer.

Jane was lucky. A relatively short time-out allowed her to break frame; it also enhanced the probability that when something new “drifted by,” she would have courage enough to go for it. For others, like Brenda Rayport, the realization that one has been stuck for quite a while in an ill-fitting career provokes a desire for a longer moratorium, a break from active decision making and job hunting. Like so many other people we have seen so far, Brenda only knew what she didn’t want to do and that she needed time. When she got married and moved to Chicago, she used the move as an excuse to step back.

The big decision wasn’t moving to Chicago. It was deciding not to go back to my firm in a comparable position. I could have done that, and they encouraged me to, but I really didn’t want to. I was headhunted by everybody for jobs close to what I had done before. But I didn’t want to be part of a company. It was too similar. I didn’t see any advantage to it. The problem was, I didn’t have a forward trajectory, I couldn’t see where I was going. I really wanted a time-out at that point.

I did know that I wanted to be part of a community, so I started getting involved in Jewish activities and arts organizations. This broke me of the need to have an institutional affiliation. I learned how to listen more to myself, to reflect on what I wanted to do and what I enjoyed doing. I included being successful and making money in “enjoy doing,” but I had to figure out how to put the pleasure back in to a money-making job.

I thought I wanted to work in education. I volunteered in the public schools. I wanted to see what it’s like to teach, to work with eightand nine-year-olds. An ongoing dialogue with my husband helped me see that wasn’t it. He urged me look at what I did back in my twenties, what I fell in love with when I left school. I had loved being an editor. I remember having enormous discussions with him, often pretty anguished ones. I felt editing was women’s work. I thought it was a submissive, or subordinate, kind of helping work. I really fought that. I was trying to reposition myself as a kind of market maker.

He would say to me, “Where’s the scarcity, Brenda? Is there a scarcity of people who are making deals? Is there a scarcity of people who can put together bulleted lists? No, there’s a scarcity of people who can really bring out the best in the people and make great products.” That dialogue allowed me to start working as a freelance editor, which was really only a step. I thought it would lead to something else, but I didn’t know what. I knew I would be meeting lots of interesting people, that I would be developing a skill again. It was important to me to be able to get in doors and to reestablish a network.

By this time, I had developed a pretty strong point of view about the publishing business. High-quality authors were the scarce commodities. And I thought that being an editor at a publishing house had become a very passive job. It’s become totally P&L-oriented, which is neither a creative nor an innovative way to be involved in a business. And with the “disintermediation” that’s happening in the business, all of the power was accruing to people other than acquisitions editors—people outside the publishing houses, like agents. Slowly, it began to dawn on me that being an agent might be the absolute best option. I could have more reach than I had ever imagined. I could be true to who I was, and not just by being a deal maker. I mean, there are literary agents who are deal makers, who are very transactional and extremely focused on their relationships with publishers and who do not serve the interests of their authors particularly well. But I knew that that would not be how I would operate. I would stay true to being relational, being concerned about the content of books, being absolutely an authors’ agent, because the publishers don’t have as much power as they used to have. And I knew this would be a very good selling line to authors.

It is hard for people to achieve the objectivity they need to question and change their daily routines while they are still actively immersed in them. Time-out periods—sometimes as short as Jane’s ten-hour drive, other times as long as Brenda’s multiyear moratorium—help people make changes by providing a space for reflective observation.[18] Stepping back makes room for insights we have been incubating but cannot yet articulate. It helps us see the coexistence—and incompatibility—of old and new. Changes in the habitual rhythm of our work or halts in our normal productive activity can work as triggers, waking us up from our daily routines and refocusing our attention on change.[19] In a time-out, attention shifts away from everyday pressures, creating the space needed to reconsider the future.

Brenda’s first reaction to a trigger—the menace of a caricature—was to overcompensate for the void she felt by putting her career at the bottom of her list of priorities. But stepping back led her to a more creative solution, in which she combined the best of all worlds.

Being an agent gives me a complete career and a complete life. There’s no trade-off. Sure, I get busy and, of course, on any given task, I have to decide what comes first, my job or my life. My life is more enjoyable all around. It’s not just about work versus personal life. It’s about “What’s my voice? Can I be creative? Am I just a corporate drone? Do I just exist as a thank-you in people’s prefaces? Am I a writer?” If someone were to draw that cartoon of me now, what would I tell the artist about myself? Lots: arts boards, philanthropy, a dog, a great marriage, a Jewish faith, Pilates, dance class. . . .

[17]Koestler, The Act of Creation.

[18]According to a U.S. national poll conducted by Bruskin and Associates, close to seven out of ten people with incomes of more than $40,000 per year fantasize about taking a few months off, and one out of five thirty-five- to thirty-nine-year-olds fantasize about it daily. Reported in Hope Dlugozima, James Scott, and David Sharp, Six Months Off: How to Plan, Negotiate, and Take the Break You Need without Burning Bridges or Going Broke (New York: Henry Holt, 1996), 2.

[19]Nancy Staudenmayer, Marcie J. Tyre, and Leslie Perlow, “Time to Change: Temporal Shifts as Enablers of Organizational Change,” Organizational Science, forthcoming (fall 2002).

taken from; Working Identity: Unconventional Strategies for Reinventing Your Career



Meta Data Repository Challenges

22 09 2008

Good ideas are often hard to implement. Providing a meta data repository is a good idea but also quite a challenging one, regardless of whether the decision is made to license (buy) a commercially available product or to build a repository from scratch.

Technical Challenges

Building a meta data repository is not a trivial task. It is a project in itself, with its own project plan, its own development steps, and its own staff. All the technology challenges that apply to databases and applications can surface on meta data repository projects.

Licensing a meta data repository product is an alternative to building one, but the “plain vanilla” versions of commercially available meta data repository products often do not meet all the meta data requirements of a BI decision-support environment. Therefore, licensing a meta data repository product still necessitates extensive analysis of the requirements in order to select the right product, as well as a considerable implementation effort to enhance it.

Enhancing licensed software comes with its own challenges. The source code for the product may not be available. The vendor may insist on incorporating the requested enhancements for a price and at his or her own speed. The time and effort required for product maintenance increase because the enhancements must be reapplied to the new releases and versions of the licensed meta data repository product.

Staffing Challenges

Meta data should be “living” documentation stored in a database, that is, in the meta data repository. Storing meta data as paper documents is guaranteed to turn it into “shelfware” within months, if not weeks. This means that, at a minimum, one meta data administrator must be dedicated full-time to managing the meta data repository content and the software. If a meta data repository is being built as part of the BI project, a staff of one person will not be enough. The meta data repository effort will require an analyst, a data modeler, a database designer, and one or more developers.

Budget Challenges

Although many BI experts think of meta data as the “glue” of the BI decision-support environment, most organizations allocate little or no money for creating and maintaining a meta data repository. They still regard meta data as systems documentation for technicians, rather than a navigation tool for business people. The pain of access frustration and data confusion must often reach an intolerable level before organizations include meta data as a mandatory and standard deliverable of their BI projects.

Usability Challenges

Using a meta data repository should be completely intuitive. Business people should be able to click on an icon and immediately get the requested information about a table or column, a chart or report, or even a business query. More complex inquiries against the meta data repository should be handled with built-in or customized macros.

Unfortunately, many meta data repository products are still designed by technicians for technicians rather than for business people. Some of these products still have a cryptic meta data language, lack sophisticated reporting capabilities, are not context sensitive, and require an understanding of the meta model that describes the meta data objects and their relationships.

Political Challenges

Building an enterprise-wide meta data solution is difficult because departmental differences must be reconciled and cross-departmental politics must be resolved. These disputes, although totally predictable, are rarely taken into account when the project plan is created. As a result, projects are delayed while these issues are addressed or pushed up to business executives and steering committees. This gives the impression that BI projects are difficult, controversial, tiresome, draining, slow, and generally undesirable work.

taken from; Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications