Multidimensional Database Representation of Real-time, Volatile, and Multi-behavioral Environments

1. Multidimensional DatabaseRepresentation ofReal-time, Volatile, andMulti-behavioral Environments David Levit

2. At Time of Disaster New Orleans afterHurricane Katrina

3. At Time of Disaster In case of disasters, rescue delegations have little time to prepare and must operate in chaotic conditions. Coordination efforts between rescue forces are complex tasks. "You can do all the planning in the world, but if you can’t communicate with one another, then you're going to have some issues," ~ Mike Zezeski of the Maryland Sate Highway Department

4. Arriving teams don’t have information about concurrent operations of other teams in the area.

5. To increase efficiency, teams will interact with a database to retrieve necessary data collected by all types of teams (police, firefighters, army, etc.)

6. The volatile nature of rescue operations requires teams to immediately store different type of information in the database, leaving no time for human evolvement to modify the database structure

7. Traditional relational and multidimensional databases are poorly equipped to deal with data collected from dynamic and volatile environments, like rescue operations These databases’ data models of real-world objects require human involvement for creation and modification

8. The goal of this research is to design a database architecture that does not depart far from the foundations in relational and multidimensional databases, but has a sufficiently flexible structure to allow the database to adequately self-manage its data model, responding to volatile nature of the environment

9. The proposed design is based on a multidimensional model’s fundamental structure, because of its ability to intuitively divide complex entities of the real world into basic constituentscalled dimensions and member

10. Rescue teams equipped with portable computers with database clients will operate with dimensions unique to teams’ tasks and dimensions shared with other rescue teams

11. N-Dimensional Cube Central Database

12. N-Dimensional Cube Connection Database capable to self-restructure toinclude new dimension Central Database Connection Connection

13. N-Dimensional Cube Data Inserted Central Database

14. N-Dimensional Cube Data Queried Central Database

15. N-Dimensional Cube Data Inserted Central Database

16. N-Dimensional Cube Data Queried Central Database

17. N-Dimensional Cube Data Inserted Central Database

18. N-Dimensional Cube Dimensions and data shared between rescue teams Data Queried Central Database

19. Central Database

20. Graphical representation of two handheld computer systems that rescue teams will carry during missions

21. No Agents Connected to Database No dimensions are present in the database

22. Firefighters Team Connected to Database Locations inserted in database Can insert data into database pertinent to different types of teams Dimensions present in database

23. Firefighters Team & Ambulance Team Connected to Database Ambulance “Amb” dimension added “T”, “Agent”, “B”, A” are shared

24. Firefighters Team Disconnected from Database Firefighters “F” dimensions subtracted from database

25. Firefighters Team Reconnect with Database Data restored fromhistorical record Firefighters “F” dimensions added to database

26. Advantages of the Database Architecture • The database architecture is ready to be used in any environment without human modification • The architecture can self-restructure to accommodate changes in environments • The database architecture delivers right information at the right time for the right client • Especially beneficial for any disaster situation or other volatile settings • Hurricanes • Tsunami • Combat Operations