ChannelDB2

Blog Posts

Radim Kolar

How well DB2 Express C scale?

Posted by Radim Kolar on March 15, 2010 at 4:32pm

Radim Kolar

Porting LIMIT and OFFSET SELECT clauses to DB2

Posted by Radim Kolar on February 28, 2010 at 11:30am — 1 Comment

david t

Transforming Data as You Replicate

Posted by david t on March 8, 2010 at 1:15pm

Dan Galvin

Client Optimization vs. pureQuery API

Posted by Dan Galvin on February 10, 2010 at 4:18pm — 1 Comment

david t

A Look at Distributing Data

Posted by david t on February 15, 2010 at 4:23pm

Blogs from PlanetDB2.com

My Favorite DB2 9 for z/OS BI Feature

A lot of the consulting work that I do relates to the use of DB2 for z/OS as a data server for business intelligence (BI) applications. DB2 9 for z/OS delivered a number of new features and functions that are particularly attractive in a data warehousing context, including index compression, index-on-expression, instead-of triggers, the INTERSECT and EXCEPT set operators, and the OLAP functions RANK, DENSE_RANK, and ROW_NUMBER. That's all great stuff, but my fav…

DB2 10 Top 10 for 2010 countdown: #8 and #7

Here's the second installment of the Top 10 of DB2 10 in 2010. Read on and I hope you enjoy.
Continue

What is Production Data?

I received an interesting e-mail recently that made me stop and think a bit... so I thought I'd blog about it. Basically, the e-mail posed the question in the title of this blog entry – “What is production data?”

The e-mail read as follows:


I'm looking for a one paragraph definition of "production data". What do you think of this: "Production data is data recorded for the purpose of controlling/managing/reporting/researching events, processes or states."

I'm trying to get around the belief that data recorded by a development team to manage its projects and resources is somehow less than production data. To me it should be regarded as the development team's "production data" and so I'm looking for a definition that satisfactorily encompasses that belief, as well as encompassing regular business production data.


You know, I do not recall ever seeing an actual definition of the term “production data.” The above definition is a good starting point, but I do not think it is complete. The author of the e-mail makes a good point about different types of production data. The data used by an application development team to conduct their business (writing computer programs to support business processes) is definitely production data… to the application development team.

Here is my take on a definition:

  • Production data is information that is persistently stored and used by professionals to conduct business processes. It must be accurate, documented, and managed on an on-going basis to ensure its value to the organization.

I say information instead of data because the data must be defined and in context in order to be useful for production work. And I say persistent because even though there may be many forms of transitory data used by production processes, it is the data that is stored over periods of time that needs to be managed.

I think this definition should serve the needs of the e-mailer... and more. What do you think?

Did I miss anything?
Continue

FEATURED BLOG POSTs

* Jonathan Schwartz resigns a SUN CEO with a tweet and the power of social media
* DB2 on EC2 Quickstart and Production ready on the Cloud
* Free DB2 Express-C Licensing changes in V9.7
* For Databases Size Does Matter: Why DB2 pureScale matters
* Benchmark comparing free databases: MS SQL Express vs. MySQL vs. DB2 Express-C
* Using Cloud for Disaster Recovery: Cheap [HA+] DR Recovery with DB2 and Amazon's EC2: Part #1
* From Backups to Scalability in the Cloud: Learn about complimenting your database backup and scalability strategies with Cloud Computing
 
 

Featured Downloads

New: Download DB2 9.7
Windows | Linux | Mac OS

Download FREE Database: DB2 Express-C

FREE Book: Getting started with DB2

DB2 on the Cloud

ChannelDB2 is a social network for the DB2 community. It features content such as DB2 related videos, podcasts, blogs, photos, resources, etc. for Linux, UNIX, Windows, System z, and System i.

Latest Activity

Great Interview on Partnering and DB2 Virtualization :)
17 hours ago
Thnx Radim :)
17 hours ago
Nice music
17 hours ago
Anil Mahadev added a video
DubuntuTKL - The easiest way to get started on DB2 Dubuntu-TKL Patch Ever wanted to get started with DB2 quickly? Did you ever want to build an appliance with DB2 without much fuss? Are you into Appliance Customization / Management creation? Do you…
yesterday
A blog post by Radim Kolar was featured
If you ask your IBM sales rep: How much DB2 Express C scale? Do you have any benchmarks? Then answer probably will be: We don't have benchmarks, but probably not much. I was interested how much is not much. It is true that there are no benchmarks fo…
yesterday
Mikk Warren added 3 blog posts
yesterday
Radim Kolar added a blog post
If you ask your IBM sales rep: How much DB2 Express C scale? Do you have any benchmarks? Then answer probably will be: We don't have benchmarks, but probably not much. I was interested how much is not much. It is true that there are no benchmarks fo…
on Monday
on Monday
hi lohith, this is vinay frrom hyd.i had some datastage projects descriptions.but i dont know how to explain the project scenario.plz help me. thanq u.
on Monday
this is very useful to the people
on Saturday
A video by Natasha Tolub was featured
This presentation will quickly refresh your understanding of the DB2 9.5 security capabilities and then bring you up to speed on the latest additions made in DB2 9.7 to help you better meet your regulatory compliance needs such as separation of duti…
March 11
Hellow Word! Gostaria de saber como fazer uma consulta e retornar o conteúdo que está entre traços. ex: 1º 2º 3º XXYYY-XXXYYY-12345-XXXYYYZZZ no caso acima gostaria saber como fazer uma consulta para retornar os valores que estão entre o 2º traço e…
March 11
 

© 2010   Created by channeldb2 on Ning.   Create a Ning Network!

Badges  |  Report an Issue  |  Privacy  |  Terms of Service