X
Software Functionality Revealed in Detail
We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.
Get free sample report

Compare Software Solutions
Visit the TEC store to compare leading software solutions by funtionality, so that you can make accurate and informed software purchasing decisions.
Compare Now
 

 star schema


The Necessity of Data Warehousing
An explanation of the origins of data warehousing and why it is a crucial technology that allows businesses to gain competitive advantage. Issues regarding

star schema  the star schema. A star schema consists of facts (actual business facts) and dimensions (ways of looking at the facts). One simple way to look at a star schema is that it is designed such that the maximum amount of information can be derived from the fewest number of table reads. Another way to reduce the amount of data being read is to pre-define aggregations (summaries of detail data, such as monthly total sales) within the star, since most queries ask questions like how many were sold last month?

Read More


Software Functionality Revealed in Detail

We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.

Get free sample report
Compare Software Solutions

Visit the TEC store to compare leading software by functionality, so that you can make accurate and informed software purchasing decisions.

Compare Now

Documents related to » star schema

The User's Undying Quest for Exploring and Discovering Info - Part 2


Part 1 of this blog series depicted the differences and some subtle similarities between the well-established enterprise applications giant, SAP, and up-and-coming vendor Endeca Technologies. The article ended with the new fundamentals for the future of enterprise applications that were outlined at the Endeca Discover 2009 conference. Part 2 of this blog series explores how

star schema   Read More

Business Intelligence Status Report


Spurred by government mandates for more business transparency, business intelligence has emerged to extract information from ERP systems. How has BI emerged? What does the terminology surrounding it mean, and what is its current state of affairs?

star schema   Read More

Best Practices for a Data Warehouse on Oracle Database 11g


Companies are recognizing the value of an enterprise data warehouse (EDW) that provides a single 360-degree view of the business. But to ensure that your EDW performs and scales well, you need to get three things right: the hardware configuration, the data model, and the data loading process. Learn how designing these three things correctly can help you scale your EDW without constantly tuning or tweaking the system.

star schema   Read More

Are Data Warehouses as Dead as the Dodo? (Part 2: 1010data and Illuminate)


Although information analysis continues to be vital for insights into a company’s health and future, the traditional data warehouse structure may already be past its best-before date, due to major and radical transformations in the market. It may just be a matter of “Evolve or Die”. . . Indeed, in my last blog post Are Data Warehouses as Dead as the Dodo? (LiveDashBoard and QlikView)

star schema   Read More

Tired Of Losing Your Oil Derricks?


Asset management maven iVita announced both its newest software release, Commander 3.0, and a partnership with wireless specialist PinPoint. PinPoint’s wireless technology will tell iVita where a company’s capital assets are. iVita will tell the company what to do with them.

star schema   Read More

Choosing the right way of migrating MySQL databases


This white paper examines the use cases of database migration and challenges that accompany it. The main attention is devoted to solutions used to remove the complexity and bottlenecks of database migration. This white paper introduces Devart's Schema and Data Compare tools tailored to facilitate any database migration tasks and reduce time and effort.

star schema   Read More

Optimizing the Development Process


One of the most formidable IT challenges that companies must solve is the extreme cost of the development process. Don’t let your data warehouse development project become part of the 50 percent that’s abandoned—and don’t lose time and money. Learn how to optimize your development process and improve the performance of your database management systems through a complete examination and debugging of your database schema.

star schema   Read More

Thinking Radically about Unstructured Data: Interview with Ron Carrière, CEO of Cirilab


Being able to manage unstructured text is no longer a “nice to have,” as companies and individual users alike have to deal with increasing amounts of unstructured text, work with it, and gain knowledge by interpreting it. Cirilab is a company that provides software products to search, retrieve, and categorize information from unstructured text sources. Read this interesting interview with Ron

star schema   Read More

Getting an Update from BigMachines at Dreamforce 2010


Many recent TEC articles have talked about quote-to-order (Q2O) or configure, price, quote (CPQ) solutions that facilitate business-to-consumer (B2C) and business-to-business (B2B) sales, thus helping companies sell more products and services faster. A number of thriving vendors provide on-demand product configurator, pricing and quoting, proposal generator, and B2B

star schema   Read More

Oracle Further Orchestrates Its SOA Forays Part Four: SOA and Web Services


The battle for the dominance in service-oriented architecture (SOA) and Web services has nonetheless so far largely been a war of words without the clear winner yet (and not any time soon), as many underlying Internet-based standards have emerged only recently.

star schema   Read More