About usAbout Reporting in EcommerceReporting ForumsForums SitemapSitemap ArchiveArchive

Site Resources


Welcome to the premier site for Database and Software Programming. We specialize in Data Warehousing, Business Intelligence, Data management and Data Analysis.

Four Guidelines For Enterprise Conceptual Data Model (Ecdm) Entity Selection

Entity-relationship analysis comprises of three major abstractions to describe data. These are entities, relationships and attributes.

Here entities are the distinct things in the enterprise. Relationship is the relation between the entities and attributes are the nature or properties of the entities.

So in a software design scenario we assimilate similar objects in sets and call these sets as entities. We then model all interactions between the objects within the entity sets by relationships or relationship sets. Relationship sets are more difficult to perceive than entity sets. We can see the entities but relationships are always underlying and we cannot see them. This makes data analysis difficult because it is necessary to create models of things that do not physically exist as single objects.

There are two major parts in entity-relationship scenario. They are Conceptual data modeling and physical data modeling.

Free KPIs! No Fooling...

If you are struggling to define your company's key performance indicators (KPIs), here is a useful bit of information. I recently discovered an interesting website dedicated to identifying KPIs for just about every category you can think of. And it is FREE!

IT project management: The cost estimating process

Learn about the cost estimating process in IT project management by reading examples and definitions of cost estimation terms, in this free chapter download.

Chief Compliance Officer: Top three responsibilities of a CCO

Learn the top roles and responsibilities of a Chief Compliance Officer (CCO).

What is Microsoft PerformancePoint Server 2007?

Learn about Microsoft PerformancePoint Server 2007, including the basics monitoring, analysis and planning applications.

Business intelligence basics with Microsoft PerformancePoint Server 2007

Learn how Microsoft PerformancePoint Server 2007 can improve business intelligence (BI) and get familiar with BI basics, in this free book chapter download.

Excess...

Every now and then, I use my blog for something that has nothing to do with BI. Sometimes I use it for humor, sometimes a rant against a pet peeve, and sometimes -- like this time -- for something that I found astonishing.

Sarbanes-Oxley compliance: GRC technology vs. spreadsheets

Learn why Sarbanes-Oxley (SOX) compliance technology, such as GRC management platforms, is better than spreadsheets for meeting Sarbanes-Oxley requirements.

Managing unstructured data in the organization

Learn about the challenges of unstructured textual data in the organization and get expert advice from Bill Inmon, in this free chapter download.

Application design for OLAP servers: Considerations and advice

Before designing applications for your online analytical processing (OLAP) server, read this expert advice.

©2010 DBandSoft.com | Developed By AdHoc Development