Publications

Journal Publications

  1. Graeme Douglas and Ramon Lawrence, Efficient SQL Querying on Embedded Devices using Pre-Compilation, Applied Computing Review, June 2016, Volume 16, Number 2, pages 42-47.
  2. Tyler Cossentine and Ramon Lawrence, Efficient External Sorting on Flash Memory Embedded Devices, International Journal of Database Management Systems (IJDMS), February 2013, Volume 5 Number 1, pages 1-20.
  3. Ramon Lawrence and Vadim Bultiko, Database-Driven Real-time Heuristic Search in Video-game Pathfinding, IEEE Transactions on Computational Intelligence and AI in Games, September 2013, Volume 5, Number 3, pages 227-241..
  4. Scott Fazackerley and Ramon Lawrence, Automatic In-Situ Determination of Field Capacity using Soil Moisture Sensors, Journal of Irrigation and Drainage.
  5. Vadim Bulitko, Yngvi Bjornsson and Ramon Lawrence, Case-Based Subgoaling in Real-Time Heuristic Search for Video Game Pathfinding, Journal of Artificial Intelligence Research. Volume 39 (September 2010), pages 269-300.
  6. Bryce Cutt and Ramon Lawrence, Using Intrinsic Data Skew to Improve Hash Join Performance, Information Systems, Volume 34, Issue 6, September 2009, pages 493-510.
  7. Ramon Lawrence, Using Slice Join for Efficient Evaluation of Multi-Way Joins, Data and Knowledge Engineering, Volume 67, Issue 1, October 2008, pages 118-139.
  8. Ramon Lawrence, Ralph P. Russo and Nariankadu D. Shyamalkumar, The Effect of Reading Policy on Early Join Result Production, Information Sciences, Volume 177, Issue 19, October 2007, pages 3939-3956.
  9. Shyamalkumar, Nariankadu D., Ralph P. Russo and Ramon Lawrence, Optimal Policies to Obtain the Most Join Results, Journal of Theoretical Probability, Volume 20, Issue 2, June 2007, pages 237-256.
  10. Anton Kruger, Ramon Lawrence, Eduard Dragut, Building a Terabyte NEXRAD Radar Database for Hydrometeorology Research, Computers & Geosciences, Volume 32, Issue 2, March 2006, pages 247-258.
  11. Ramon Lawrence, Teaching Data Structures using Competitive Games, IEEE Transactions on Education, Volume 47, Issue 4, November 2004, pages 459-466.
  12. Ramon Lawrence, The Space Efficiency of XML, Information and Software Technology, Volume 46, Issue 11, September 2004, pages 753-759.

Book Chapters

  1. Michael Henderson and Ramon Lawrence, An Evaluation of Multi-Way Joins for Relational Database Systems. Lecture Notes in Business Information Processing 190 - Enterprise Information Systems. Springer. Invited and revised papers from ICEIS 2013. 37 - 50. ISBN 978-3-319-09491-5. July 2015.
  2. Vadim Bulitko, Yngvi Bjornsson, Nathan R. Sturtevant, and Ramon Lawrence, Real-time Heuristic Search for Pathfinding in Video Games, Artificial Intelligence for Computer Games. 1 - 30. IBSN 978-1441972569. January 2011.
  3. Ramon Lawrence,Motivating Students Using Competitive Programming, Guide to Competitive Learning, Springer. 157-172. ISBN 978-84-937580-3-5. April 2010.
  4. Ramon Lawrence and Ken Barker, Integrating Data Sources Using A Standardized Global Dictionary 4th International Conference on Business Information Systems (BIS-2000) Poznan, Poland April 12-13,2000. Appears in KNOWLEDGE DISCOVERY FOR BUSINESS INFORMATION SYSTEMS Chapter 7, pages 153-172. Presentation

Conference Publications

  1. Wade Penson, Eric Huang, Dana Klamut, Eliana Wardle, Graeme Douglas, Scott Fazackerley, and Ramon Lawrence, Continuous Integration Platform for Arduino Embedded Software, IEEE Canadian Conference on Electrical and Computer Engineering 2017 (CCECE 2017).
  2. Ramon Lawrence, Erik Brandsberg, and Roland Lee, Next Generation JDBC Database Drivers for Performance, Transparent Caching, Load Balancing, and Scale-out, 32nd Annual ACM Symposium on Applied Computing (SAC'17), pages 915-918. Best Poster Award out of 52 posters at conference.
  3. Kenny Raharjo and Ramon Lawrence, Using Multi-Arm Bandits to Optimize Game Play Metrics and Effective Game Design, ICCG 2016: 18th International Conference on Computers and Games, New York, USA, pages 1021-1024.
  4. Wade Penson, Scott Fazackerley, Ramon Lawrence, TEFS: A Flash File System for Use on Memory Constrained Devices, IEEE Canadian Conference on Electrical and Computer Engineering 2016 (CCECE 2016).
  5. Scott Fazackerley, Wade Penson, Ramon Lawrence, Write Improvement Strategies for Serial NOR Dataflash Memory, IEEE Canadian Conference on Electrical and Computer Engineering 2016 (CCECE 2016).
  6. Graeme Douglas and Ramon Lawrence, Improving SQL Query Performance on Embedded Devices using Pre-Compilation, 31st Annual ACM Symposium on Applied Computing (SAC'16), pages 961-964. Best Paper Award.
  7. Scott Fazackerley, Eric Huang, Graeme Douglas, Raffi Kudlac, Ramon Lawrence, Key-Value Store Implementations for Arduino Microcontrollers, IEEE Canadian Conference on Electrical and Computer Engineering 2015 (CCECE 2015), pages 158-164.
  8. Giuseppe Burtini, Jason Loeppky and Ramon Lawrence, Improving Online Marketing Experiments with Drifting Multi-Armed Bandits, 17th International Conference on Enterprise Information Systems (ICEIS 2015), pages 630-636.
  9. Ramon Lawrence, Integration and Virtualization of Relational SQL and NoSQL Systems including MySQL and MongoDB, 2014 International Conference on Computational Science and Computational Intelligence (CSCI 2014), Las Vegas, NV, USA.
  10. Graeme Douglas and Ramon Lawrence, LittleD: A SQL Database for Sensor Nodes and Embedded Applications, 29th Annual ACM Symposium on Applied Computing (SAC'14). [23% Acceptance Rate]
  11. Michael Henderson and Ramon Lawrence, Are Multi-way Joins Actually Useful?, 15th International Conference on Enterprise Information Systems (ICEIS 2013), Angers, France. [8% Full Paper Acceptance Rate].
  12. Giuseppe Burtini, Scott Fazackerley, and Ramon Lawrence, Time Series Compression for Adaptive Chart Generation, IEEE Canadian Conference on Electrical and Computer Engineering 2013 (CCECE 2013).
  13. William Lee and Ramon Lawrence, Fast Grid-based Path Finding for Video Games, 26th Annual Canadian Conference on Artificial Intelligence (AI'13), pages 100-111. [27% Acceptance Rate].
  14. William Lee and Ramon Lawrence, Trading Space for Time in Grid-based Path Finding, AAAI-13 Student Abstract and Poster Program.
  15. Giuseppe Burtini, Scott Fazackerley, and Ramon Lawrence, Reducing Data Transfer for Charts on Adaptive Web Sites, (Download Paper), 28th Annual ACM Symposium on Applied Computing (SAC'13).
  16. Scott Fazackerley, Andrew Campbell, Ryan Trenholm, and Ramon Lawrence, A Holistic Framework for Water Sustainability and Education in Municipal Green Spaces, IEEE Canadian Conference on Electrical and Computer Engineering 2012 (CCECE'12), May 2012. Montreal, Quebec, Canada.
  17. Scott Fazackerley, Steven McAvoy, and Ramon Lawrence., GPU Accelerated AES-CBC for Database Applications, 27th Annual ACM Symposium on Applied Computing (SAC'12).
  18. Vadim Bulitko, D. Chris Rayner, and Ramon Lawrence, On Case Base Formation in Real-Time Heuristic Search, 8th AAAI Conference on Artificial Intelligence and Interactive Digital Entertainment, AIIDE-12, Stanford, CA, October 2012, pages 106-111.
  19. Alyosha Pushak, Deb Carter, Teresa Wrzesniewski and Ramon Lawrence, Experiences using an Automated Testing and Learning System, Computers and Advanced Technology in Education (CATE 2011).
  20. Scott Fazackerley and Ramon Lawrence, A Flash Resident File System for Embedded Sensor Networks, IEEE Canadian Conference on Electrical and Computer Engineering 2011 (CCECE'11), May 2011. Niagara Falls, Ontario, Canada.
  21. Ramon Lawrence and Vadim Bulitko, Taking Learning out of Real-time Heuristic Search for Video-game Pathfinding, 23rd Australasian Joint Conference on Artificial Intelligence 2010, 405-414. [47% Acceptance Rate]
  22. Tyler Cossentine and Ramon Lawrence, Fast Sorting on Flash Memory Sensor Nodes, International Database Engineering and Applications Symposium (IDEAS'10), 105-113. Montreal, Canada. [17% Acceptance Rate]
  23. Scott Fazackerley and Ramon Lawrence, Reducing Turfgrass Water Consumption using Sensor Nodes and an Adaptive Irrigation Controller, IEEE SAS 2010 - IEEE Sensors Applications Symposium [60% Acceptance Rate - Best Student Paper of 17 student papers], Feb. 2010.
  24. Scott Fazackerley, Alan Paeth and Ramon Lawrence, Cluster Head Selection using RF Signal Strength, CCECE 2009 - IEEE Canadian Conference on Electrical and Computer Engineering 2009, St. John's, Newfoundland, Canada, May 2009.
  25. Miichael Henderson, Bryce Cutt and Ramon Lawrence, Exploiting Join Cardinality for Faster Hash Joins SAC 2009 - 24th ACM Symposium on Applied Computing (SAC'09), March 2009. Honolulu, HI, pages 1549-1554. [29% acceptance rate]
  26. Bryce Cutt and Ramon Lawrence, Managing Data Quality in a Terabyte-Scale Data Archive, SAC 2008 - 23rd Annual ACM Symposium on Applied Computing, Fortaleza, Brazil, March 2008, pages 982-986. Presentation
  27. Bryce Cutt and Ramon Lawrence, Improving Join Performance for Skewed Databases, CCECE 2008 - IEEE Canadian Conference on Electrical and Computer Engineering 2008, Niagara Falls, Ontario, Canada, May 2008.
  28. Uchang Park and Ramon Lawrence, A Database Integration System Based on Global View Generation, ICEIS 2007 - 9th International Conference on Enterprise Information Systems (ICEIS). Funchal, Portugal. Jun, 2007.
  29. Witold F. Krajewski, Anton Kruger, Ramon Lawrence, James A. Smith, A. Allen Bradley, Matthias Steiner, Mary Lynn Baeck, Mohan K. Ramamurthy, Jeffrey Weber, Stephen A. DelGreco, Bong-Chul Seo, Piotr Domaszczynski, Charles Gunyon, Radoslaw Goska, Towards Better Utilization of NEXRAD Data in Hydrology: an Overview of Hydro-NEXRAD, World Environmental and Water Resources Congress 2007: Restoring Our Natural Habitat. Volume 243, Number 40927, pages 288-296.
  30. Terry Mason and Ramon Lawrence, Auto-completion of Underspecified SQL Queries, ER 2006 - 25th International Conference on Conceptual Modeling (ER 2006). Tucson, Arizona. Nov, 2006. 584.
  31. Eduard Dragut and Ramon Lawrence, Reducing the Cost of Validating Mapping Compositions by Exploiting Semantic Relationships, ODBASE 2006 - On the Move to Meaningful Internet Systems 2006: CoopIS, DOA, GADA, and ODBASE (Lecture Notes in Computer Science 4275). Montpellier, France. 882 - 890. [25% acceptance rate] Presentation
  32. Ramon Lawrence and Anton Kruger, An Architecture for Real-Time Warehousing of Scientific Data, CSC 2005 - The 2005 International Conference on Scientific Computing, Monte Carlo Resort, Las Vegas, Nevada, USA (June 20-23, 2005). [37% acceptance rate] Presentation
  33. Ramon Lawrence, A Cost-Based Approach For Converting Relational Schemas To XML, IADC-2005 - International Advanced Database Conference (IADC-2005), June 27-30, 2005, San Diego, CA. [46% acceptance rate] Presentation
  34. Ramon Lawrence, Early Hash Join: A Configurable Algorithm for the Efficient and Early Production of Join Results, VLDB 2005 - 31st Very Large Data Bases Conference, August 30 to September 2, 2005, Trondheim, Norway. - [16% acceptance rate] Presentation
  35. Terry Mason and Ramon Lawrence, Dynamic Database Integration in a JDBC Driver, ICEIS 2005 - 7th International Conference on Enterprise Information Systems - Databases and Information Systems Integration Track, Miami, FL, May 24-28, 2005. [43% acceptance rate] ISBN 972-8865-19-8, Volume 1, pages 326-333. Presentation
  36. Terry Mason, Lixin Wang and Ramon Lawrence, AutoJoin: Providing Freedom from Specifying Joins, ICEIS 2005 - 7th International Conference on Enterprise Information Systems - Human-Computer Interaction Track, Miami, FL, May 24-28, 2005. [20% acceptance rate] ISBN 972-8865-19-8, Volume 5, pages 31-38. Presentation
  37. Eduard Dragut and Ramon Lawrence, Composing Mappings Between Schemas Using a Reference Ontology, ODBASE 2004 - International Conference on Ontologies, Databases and Applications of SEmantics, Oct. 25-29, 2004, Larnaca, Cyprus [25% acceptance rate] Appears in On the Move to Meaningful Internet Systems 2004 (LNCS #3291) pages 783-800. Presentation
  38. Ramon Lawrence and Kirk Hackert, A Case for Merge Joins in Mediator Systems, IIWeb-2004 - Workshop on Information Integration on the Web (co-located with VLDB), Aug. 30, 2004, Toronto, Canada [50% acceptance rate] Presentation
  39. Ramon Lawrence, Naming in XML Documents, ODBASE 2002 - International Conference on Ontologies, Databases and Applications of SEmantics, Oct. 29-31, 2002, Irvine, CA. [27% acceptance rate] Appears in On the Move to Meaningful Internet Systems 2002 (LNCS #2519) pages 1287-1303. Presentation
  40. Alina Bejan and Ramon Lawrence, Peer-to-Peer Cooperative Driving, ISCIS XVII - Seventeenth International Symposium On Computer and Information Sciences, October 28-30, 2002, University of Central Florida, Orlando, Florida, pages 259-263.
  41. Ken Barker and Ramon Lawrence, Flexible Semantic B2B Integration Using XML Specifications, SCI 2002 - The 6th World Multi-Conference on Systemics, Cybernetics, and, Informatics, July 14th - 18th, 2002, Orlando, Florida.
  42. Ramon Lawrence and Ken Barker, Using Unity to Semi-Automatically Integrate Relational Schema, Demonstration at ICDE 2002 - 18th International Conference on Data Engineering, February 26-March 1, 2002, San Jose, California, pages 329-330. Presentation
  43. Ramon Lawrence and Ken Barker, Querying Relational Databases without Explicit Joins, DASWIS 2001- International Workshop on Data Semantics in Web Information Systems (in conjunction with ER'2001), November 29-30, 2001, Yokohama, Japan. [28% acceptance rate] Appears in Conceptual Modeling for New Information Systems Technologies (LNCS #2465) pages 278-291. Presentation
  44. Ramon Lawrence and Ken Barker, Integrating Relational Database Schemas using a Standardized Dictionary, SAC'2001 - 16th ACM Symposium on Applied Computing March 11-14, 2001 Las Vegas, USA, pages 225-230. Presentation
  45. Ramon Lawrence and Ken Barker, Multidatabase Querying by Context, DataSem 2000 20th annual conference on the Current Trends in Databases and Information Systems Brno, Czech Republic October 21-24, 2000, pages 127-136. Presentation
  46. Ramon Lawrence, Ken Barker and Aruna Adil, Simulating MDBS Transaction Management Protocols Computer Applications in Industry and Engineering (CAINE-98) Las Vegas, Nevada, November 11-13, 1998, pages 93-97. Presentation

Technical Reports, Technology Transfer, and Thesis Documents

Doctorate Thesis

My Ph.D. thesis was on schema integration in multidatabase systems. I constructed an integration architecture called Unity that automatically combines diverse relational database schema into an integrated view. The integrated view provides physical and logical access transparency for the underlying data sources. Research work on expanding the power of the integration architecture is ongoing. The thesis was completed and defended on May 7, 2001 at the University of Manitoba.

Student Reports


* Root Page * Go Back