Win a copy of The Journey To Enterprise Agility this week in the Agile and Other Processes forum! And see the welcome thread for 20% off.
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Jeanne Boyarsky
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
Sheriffs:
  • Paul Clapham
  • Junilu Lacar
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Ganesh Patekar
  • Tim Moores
  • Pete Letkeman
  • Stephan van Hulst
Bartenders:
  • Carey Brown
  • Tim Holloway
  • Joe Ess

Representing seats of a flight in the database  RSS feed

 
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In working on SCEA part 2, I'm trying to code some things to help me along.
I'm having trouble visualizing how seats are represented in a database. When a user goes to select seats for a flight, what happens? I'm thinking that a flight record will have a type-of-equipment field. There could be a separate table for seats that might consist of flight#, type-of-equipment, seatname, seatTaken (true or false). But what is tripping me up is that it seems you would need such a table for every flight; you'd have as many of these tables as you do flights. (I don't have much database experience but that somehow doesn't sound right to me.) If that were the case, it sounds like a better idea would be to have the flight record contain a field called seats and that field would contain a HashMap (where key is the seatname and value is available or not). I'm not seeing how to store an array or HashMap in a database. What datatype would you give it when you go to create the table? Would one even do this? If so, how? And if not, how to handle the case where a database record contains a field that needs to be an array or List or Map?

Thank you very much in advance!
 
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Jeffe,

Neither am I a database expert.

But oracle supports 'CLOB' types. You can put 'anything' in it. So you can put a Map in CLOB?

Anyway, database are system that supports to persist mass data. So why not store that things in tables?

As far as I know, the company I worked for has a lot of data in a database. Further there are items duplicated.

Lucy
 
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Jeff,

Here are my thoughts on this problem. What if the database had a Reservations table that held the Flight#, date and Seat# for those seats that were already reserved? Then you only need to retrieve the seat numbers for that equipment type for that flight on that day that re not in the Reservations table. Or we can retrieve that info. from the stored itineraries since we have to persist them anyway.
 
Ranch Hand
Posts: 129
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
IMHO, there are two sides we need to put in consideration.

One is the "flight" from airlines for sale. it contains the segment(from-to), the flight Id(an actual flight, not the flight number), the equipment Id(an actual airplane, same 767 may have different seat setting), and a set of seats(if a seat is booked, there is reference to the "booked flight" transaction record). the admin loads the "flight"s when they are going for sale.

On another side, the "booked flight transaction record" has the similar info and some thing extra.

Maybe we can use same class and DB table to keep the two kind info. The purpose of CLOB is to separate long descriptive strings to make query faster, I don't thing well use it here.

Just my 2 cents.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!