Computerworld - The explosion of e-business - and the massive amount of data it created - has made data management and organization more important than ever. We often hear the terms database, data warehouse and data mart, but the differences among them aren't always clear. Some experts say that the difference between, say, a data mart and a data warehouse is more conceptual than real. Nonetheless, here are some general rules of thumb to sort out these terms.
In the Beginning . . .
A datum is a raw piece of information that's capable of being moved and stored. In the broadest sense, a database is a collection or aggregation of such data, along with information on how pieces of data relate to one another.
In theory, a database doesn't even require a computer, but it certainly makes its use a lot more scalable and efficient, says Mike Schiff, an analyst at Current Analysis Inc. in Sterling, Va. A pocket address book is certainly a database, but searching contact entries by city or industry requires flipping through each page.
Database management systems, such as those from Microsoft Corp., Oracle Corp. or IBM, act as the underlying vault and retrieval technology.
In addition to storing data, a database management system handles security and access control, says Schiff. Business intelligence tools then access this data for analysis. However, databases rarely exist just to run analytical operations; in general, they're vital to running a business.
Database management systems can be organized in different ways. A relational database stores information in tables and then joins or combines those tables across common fields. A hierarchical database stores data in a tree structure; an order record might have every line item underneath it. An object-oriented database encapsulates both data and business logic.
- 15 Non-Certified IT Skills Growing in Demand
- How 19 Tech Titans Target Healthcare
- Twitter Suffering From Growing Pains (and Facebook Comparisons)
- Agile Comes to Data Integration
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- Who's afraid of the big (data) bad wolf? Survive the big data storm by getting ahead of integration and governance functional requirements This paper provides a detailed review of the best practices clients should consider before embarking on their big data integration projects.
- Understanding big data so you can act with confidence Automating information integration and governance and employing it at the point of data creation helps organizations boost confidence in their big data.
- Integrating and Governing Big Data The end-to-end information integration capabilities of IBM® InfoSphere® Information Server are designed to help organizations understand, cleanse, monitor, transform and deliver data-as well...
- The MDM advantage: Creating insight from big data To help enterprises create trusted insight as the volume, velocity and variety of data continue to explode, IBM offers several solutions designed to...
- Live Webcast Increasing the Value of Your Reports and Dashboards Learn how incorporating other analytical capabilities such as predictive modeling and visualization can increase the value of your reports and dashboards by providing...
- The Software-Defined Data Center: Is your ADC ready? Data center transformation is accelerating beyond virtualization to next-generation cloud architectures and software-defined data centers, bringing new challenges for application performance, scalability and...
- Application Acceleration: Optimize the End-User Experience Watch this on-demand webcast and learn how you can optimize your web content, accelerate performance across any device and browser combination, and offload... All Business Intelligence/Analytics White Papers | Webcasts