• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Dealing with transient information

 
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
One of the user requirements is to mark down the customers
that have never spent since last 6 months.
This is basically done by a joined query.
Now the client asks me how to take care of the customers
whom have been followed but still not yet done any spending afterwards.
They asked me to export a list of customer who haven't spent since last 6 months.
After this list has been followed, the customers, sometimes, will not be dealt with
anymore.
Do you think it is not good idea to open up another table?
and just dump the list to Excel, and let the user deal with them manually
But if I am, how do I store this kind of information.
The customer table is not a good choice, I think.
What do you think?
Thanks
Jack
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
What's wrong with the customer table? You could have an active/inactive flag.

You don't know a customer will go inactive so you don't know the information is transient when it first gets written to the database. And taking it out of the customer table would require you to clean up other tables with foreign keys.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic