Sikha Bagui

Professor and Chair
Director, Center for Cybersecurity

B.S., Cuttington University (Liberia)
M.B.A., University of Toledo
Ed.D., Curriculum & Instruction: Math & Stat / Science/ Computer Science, University of West Florida

Phone: (850) 474-3022
Office Location: Bldg 4, Room 227
Personal Site: http://www.cs.uwf.edu/~sbagui
Email: bagui@uwf.edu

Research Interests

My research interests are in the areas of database, datawarehousing, datamining, and statistical computing. All these areas have applications in various fields including bioinformatics, medical information systems, genomics, etc. My areas of specialization in database are on database modeling, design and development, web databases, working with oracle, SQL Server, and other major databases. In data mining, my areas of concentration are on data pre-processing, association rule mining, and pattern analysis in very large datasets/databases.


Publications
  • Books

    1. Earp, R. and Bagui, S. (2003). Learning SQL: A Step-by-Step Guide using Oracle, Addison Wesley, ISBN: 0-201-77363-5.

    2. Bagui, S. and Earp, R. (2003). Database Design Using ER Diagrams, CRC Press, Auerbach Publications, ISBN: 0-8493-1548-4.

    3. Bagui, S. and Earp, R. (2004). Learning SQL: A Step-by-Step Guide using Access, Addison Wesley, ISBN: 0-321-11904-5.

    4. Earp, R., and Bagui, S. (2006). Advanced SQL Functions in Oracle 10g, Wordware Publishing, ISBN: 13: 978-1-59822-021-6.

    5. Bagui, S. and Earp, R. (2006) Learning SQL Using SQL Server 2005, O’Reilly Publishers, ISBN: 0-596-10215-1.

    6. Earp, R. and Bagui, S. (2008). Practical Guide to Using SQL in Oracle, Wordware Publishing, ISBN: 13:978-1-59822-063-6.

    7. Bagui, S. and Earp, R. (2009). SQL Essentials in Access, Linus Publications, ISBN: 13:978-1-60797-040-8.

    8. Bagui, S. and Earp, R. (2011). Essential of SQL Using SQL Server 2008, Jones and Bartlett, ISBN: 978-0-7637-8138-5.

    9. Bagui, S. and Earp, R. (2012). Database Design Using ER Diagrams, 2nd edition, Taylor and Francis. ISBN: 9781439861769.

    International Editions (books)

    10. Earp, R. and Bagui, S. (2003). Learning SQL: A Step-by-Step Guide using Oracle, Pearson Education Asia Limited and Tsinghua University Press, EISBN 0-201-77363-5 and ISBN: 7-302-06755-4 (In Chinese language).

    11. Bagui, S. and Earp, R. (2004). Learning SQL: A Step-by-Step Guide using Access, Addison Wesley, ISBN: 0-321-21075-1 (International Edition).

    12. Bagui, S. and Earp, R. (2007). Naucite SQL na SQL Serveru 2005, O’Reilly Publishers, ISBN: 978-86-7555-309-0.

    Journal Articles (Published/Accepted)

    1. Bagui, S. (1998). Reasons for increase in learning with multimedia, The Journal of Educational Multimedia and Hypermedia, 7(1), 03-18.

    2. Bagui, S.C., Bagui, S., Pal, K., and Pal, N. (2003). Breast Cancer detection using Rank Nearest Neighbor Classification Rule, Pattern Recognition, 36(1), 25-34.

    3. Bagui, S. and Rodgers, E. (2003). Impact of Kolb’s Learning Style on Selection of Media During Authoring of Multimedia, Journal of Interactive Instruction and Development, 15(4), 3-11.

    4. Bagui, S. (2003). Achievements and Weakness of Object-Oriented Databases, Journal of Object Technology, 2(4), 29-41.

    5. Bagui, S. and Rodgers, E. (2003). Correlation between Kolb’s Experiential Learning Style and Selection of a Structure in Multimedia Authoring, Journal of Interactive Instruction and Development, 16(2), 10-24.

    6. Bagui, S. and Bagui, S.C. (2004). An Algorithm and Code for Computing Exact Critical Values for the Kruskal-Wallis Nonparametric One-Way ANOVA, Journal of Modern Applied Statistical Methods, 3(1), 498-503.

    7. Bagui, S. and Rodgers, E. (2005). Relationship between Kolb’s Experiential Learning Style and Use of Navigational Features during the Authoring of Multimedia Projects, Journal of Interactive Instruction and Development, 17(3), 3-14.

    8. Bagui, S. and Bagui, S.C. (2005). An Algorithm and Code for Computing Exact Critical Values for Friedman's Nonparametric ANOVA, Journal of Modern Applied Statistical Methods, 4(1), 312-318.

    9. Bagui, S. (2006). An Approach to Mining Crime Patterns, International Journal of Data Warehousing and Mining, 2(1), 50-80.

    10. Bagui, S.C., Bagui, S., Chatterjee, A., and Mehra, K.L. (2006). Classification with repeated independent measurements under separate sampling scheme, Statistical Methodology, 3, 234-251.

    11. Bagui, S., (2006). Rules for Migrating from Entity Relationship (ER) diagrams to Object Relationship (OR) diagrams, Computing Letters, 2(4), 177-191.

    12. Bagui, S. and Bagui, S.C. (2006). Computing Percentiles of Skew-Normal Distributions, Journal of Modern Applied Statistical Methods, 5(2), 575-588.

    13. Bagui, S., Mink, D., and Cash, P. (2007). Data Mining Techniques to Study Voting Patterns in the US, Data Science Journal, 6, 46-63.

    14. Bagui, S., (2007). A Formal Definition for Translating XML Documents to the ER Model, International Journal of Metadata, Semantics and Ontologies, 2(1), 54-66.

    15. Bagui, S., Bagui, S.C., Pal, N.R., and Matin, M.A. (2007). Comparison between k-NN and k-RNN Classification Rules: A Monte Carlo Simulation Study, Journal of Statistical Research, 41(1), 69-79.

    16. Bagui, S., (2007). Mapping XML Schema to Entity Relationship and Extended Entity Relationship Models, International Journal of Intelligent Information and Database Systems, 3(4), 325-345.

    17. Bagui, S. Just, J., and Bagui, S. (2009). Deriving Strong Association Mining Rules Using a Dependency Criteria, the Lift Measure, International Journal of Data Analysis Techniques and Strategies (IJDATS), 1(3), 297-312.

    18. Bagui, S. and Loggins, A. (2009). Generating Join Queries for Large Databases and Web Services, International Journal of Information Technology and Web Engineering (IJITWE), 4(2), 54-72.

    19. Bagui, S. and Ter Haar, L. (2009). Database Education in the New Millenium, The Journal of Computing Sciences in Colleges, 24(4), 80-87.

    20. Bagui, S. (2009). Mapping OWL to the Entity Relationship and Extended Entity Relationship Models, International Journal of Knowledge and Web Intelligence (IJKWI), 1(1/2), 125-149.

    21. Caffrey, J. M., Landing, W. M., Nolek, S. D., Gosnell, K., Bagui, S. S., and Bagui, S.C. (2010). Atmospheric Deposition of Mercury and Major Ions to the Pensacola (Florida) Watershed: spatial, seasonal and inter-annual variability, The Journal of Atmospheric Chemistry and Physics, 10, 4593-4616.

    22. Bagui, S. Just, J., Bagui, S, and Hemasinha, R. (2010). Using a Cosine-type Measure to Derive Strong Association Mining Rules, International Journal of Knowledge Engineering and Data Mining (IJKEDM), 1(1), 69-83.

    23. Bagui, S. and Musgrove, C. (2010). Optimizing Outerjoins in Large Databases Using Cluster Based Partitioning. International Journal of Data Analysis and Information Systems (IJDAIS), 2(2), 55-65.

    24. Bagui, S. Islam, M., and Bagui, S. (2011). An Architecture for Query Optimization Using Association Rule Mining. International Journal of Knowledge Based Organizations (IJKBO), 1(4), 32-55.

    25. Bagui, S., Brown, J., Caffrey, J., and Bagui, S. (2012). Designing a Relational Database for Tracking and Analysis of Atmospheric Deposition of Mercury and Trace Metals in the Pensacola (Florida) Bay Watershed, International Journal of Sustainable Society (IJSSoc), 4(3), 240-265.

    26. Bagui, S. and Sweetman, R. (2012). Modeling Service Data Objects (SDO's) To the Entity-Relationship (ER) Model, by Bagui and Sweetman. International Journal of Information Technology and Web Engineering (IJITWE), 7(3), 14-36.

    27. Bagui, S., Spratlin, S., and Bagui, S. (2013). Calculating Support, Confidence and Lift in Multi-relational XML Data, International Journal of Data Analysis and Information Systems (IJDAIS), Vol 5(1), 13-27.

    28. Goehring, G., Reichherzer, T., El-Sheikh, E., Snider, D., Wilde, N., Bagui, S., Coffey, J., White, L.J. (2013). A Knowledge-Based System Approach for Extracting Abstractions from Service Oriented Architecture Artifacts in International Journal of Advanced Research in Artificial Intelligence (IJARAI), Vol. 2(3), 44-52.

    29. Bagui, S.C., Bagui, S., and Hemasinha, R. (2013). Nonrigorous proofs of stirling’s formula, Mathematics and Computer Education, Vol. 47(2), 115–125.

    30. El-Sheikh, E., Reichherzer, T., White, L., Wilde, N., Coffey, J., Bagui, S., Goehring, G., Baskin, A. (2013). Towards Enhanced Program Comprehension for Service Oriented Architecture (SOA) Systems, Journal of Software Engineering and Application (JSEA) Vol. 6(9), 435-445.

    31. Bagui, S. and Zaynako, A. (2014). Determining Approximate Functional Dependencies using Association Rule Mining, International Journal of Research in Computer Applications and Management (IJRCM), Vol. 4(1), 10-17.

    Refereed Publication in Encyclopedia

    1. Bagui, S. (2006). Generalizations and Specializations and Categories in ER Diagrams, Encyclopedia of Database Technologies, Idea Group Publishing, 233-239.

    Refereed Proceedings

    1. Bagui, S. (2005). Rules for Migrating from ER and EER diagrams to Object-Relationship (OR) diagram, Proceedings of the 43rd ACM Southeast Conference, 1, 243-244, Kennesaw, GA, March 18-20 (acceptance rate – about 28%).

    2. Bagui, S. and Walker, D. (2006). A Java Based Parser Software for Converting XML Documents to the ER Model and Relational Databases, Proceedings of the 2006 International Conference on Semantic Web and Web Services, 166-169, Las Vegas, Nevada, June 26-29 (acceptance rate –approx.. 32%). 3. Bagui, S. (2007). Developing a conceptual model for XML Schema, Proceedings of the 2007 International Conference on Semantic Web and Web Services, 69-71, Las Vegas, Nevada, June 25-28 (acceptance rate – about 32%).

    4. Prayaga, L., White, L., Bagui, S. (2009). Innovative Strategies to Build IT Workforce, Proceedings of 22nd Conference on Software Engineering Education and Training, 202-209.

    5. Bagui, S. Mohammad, I. (2010). Query optimization in large databases using Association Rule Mining, Proceedings of the 48th ACM Southeast Conference, Oxford, MS, April 15-17.

    6. El-Sheikh, E., Bagui, S., Firesmith, D.., Petrov, I., Wilde, N., Zimmermann, A. (2013). Towards Semantic-Supported SmartLife System Architectures for Big Data Services in the Cloud. Proceedings of the 5th International Conferences on Advanced Service Computing, May 27-June 1, Valencia, Spain, IARIA XPS Press.

    Book Chapters

    1. Earp, R. and Bagui, S. (2000). Building An Entity Relationship Diagram: A Software Engineering Approach, Data Management Handbook, CRC Press, Auerbach Publications, 22-10-41, Dec., 1-16.

    2. Earp, R. and Bagui, S. (2001). Extending Relationships in the Entity Relationship Diagram, Data Management Handbook, CRC Press, Auerbach Publications, 22-10-42, May, 1-14.

    3. Earp, R. and Bagui, S. (2002). Binary Relationships in Entity Relationships in Entity Relationship (ER) Diagrams, Data Management Handbook, CRC Press, Auerbach Publications, 22-10-43, April, 1-17.

    4. Bagui, S. and Earp, R. (2003). Ternary and Higher-Order ER Diagrams, Data Management Handbook, CRC Press, Auerbach Publications, 22-10-44, June, 1-21.

    5. Wilde, N., Bagui, S., Coffey, J., El-Sheikh, E., Reichherzer, T., White, L., Goehring, G., Terry, C., Baskin, A. (2013). Interoperable Systems and Software Evolution: Issues and Approaches, Digital Enterprise Design and Management 2013, Advances in Intelligent Systems and Computing, Volume 205, 2013, chapter 10, 45-56, Springer Berlin Heidelberg, doi={10.1007/978-3-642-37317-6_5}.

    Other Publications

    1. Earp, R., and Bagui, S. (2000). Oracle’s Joins, Oracle Internals, 2(3), 6-14.

    2. Earp, R. and Bagui, S. (2001). Oracle’s Triggers, Oracle Internals, 2(10), 14-20.

    3. Earp, R. and Bagui, S. (2001). An In-depth look at Oracle's Correlated Subqueries, Oracle Internals, 3(4), 2-8.

    4. Saha, Sikha (1988). Software Review of ENABLE, Journal of Computer Based Instruction, 15(1).

    5. Saha, Sikha, (1988). Book Review, Files and Databases, An Introduction, Interfaces, 18(3).

    Papers re-printed as Book Chapters

    1. Earp, R., and Bagui, S. (2004). Oracle’s Joins, Oracle Internals: Tips, Tricks, and Techniques for DBAs, edited by Donald K. Burleson, Auerbach Publications, Taylor and Francis Group.

    2. Earp, R. and Bagui, S. (2004). Oracle’s Triggers, Oracle Internals: Tips, Tricks, and Techniques for DBAs, edited by Donald K. Burleson, Auerbach Publications, Taylor and Francis Group.

    3. Earp, R. and Bagui, S. (2004). An In-depth look at Oracle's Correlated Subqueries, Oracle SQL Training and CBO Internals, edited by Kimberly Floss, Rampant Press. 4. Earp, R., and Bagui, S. (2004). Oracle’s Joins, Oracle SQL Training and CBO Internals, edited by Kimberly Floss, Rampant Press. 5. Bagui, S. (2008). An Approach to Mining Crime Patterns, Data Warehousing and Mining: Concepts, Methodologies, Tools, and Applications, edited by John Wang, IGI Global Publications.

    6. Bagui, S. (2009). An Approach to Mining Crime Patterns, Selected Readings on Database Technologies and Applications, edited by Terry Halpin, IGI Global Publications.

    7. Bagui, S. (2009). Mapping Generalizations and Specializations and Categories to Relational Databases, Handbook of Research on Innovations in Database Technologies and Applications: Current and Future Trends, edited by Viviana E. Ferraggine, Jorge H. Doorn, Laura C. Rivero, Information Science Reference. ISBN-13: 9781605662428, 1-11.

    8. Bagui, S. and Loggins, A. (2011). Automating the Generation of Joins in Large Databases and Web Services, Web Engineered Applications for Evolving Organizations: Emerging Knowledge, edited by Ghazi, I. Alkhatib, IGI Global Publications. ISBN: 978-1-60960-523-0. 9. Bagui, S., Islam, M., and Bagui, S. (2012). An Architecture for Query Optimization Using Association Rule Mining, Intelligence Methods and Systems Advancements for Knowledge-Based Business, IGI Global (to appear).

Feedback

Feedback