Relational, NoSQL, and Artificial Intelligence-Integrated Database Architectures: Foundations, Cloud Platforms, and Regulatory-Compliant Systems

##plugins.pubIds.doi.readerDisplayName## https://doi.org/10.70593/978-93-7185-129-9

Authors

Sibaram Prasad Panda
Decision Ready Solutions

Keywords:

Databases, Cloud Databases, NoSQL Databases, Relational Databases, Distributed Databases, Data Warehousing, Big Data Analytics, Artificial Intelligence

Synopsis

A modern entrance to the science of data. This textbook introduces the basic principles of the database system and guides students to advanced subjects such as distributed data processing, NOSQL model and intelligent query. Explanation, with practice on hands and real-world scenarios, prepares learners for both academic and professional activities in data management.

Beyond the tradition, the book examines modern architecture including emerging patterns such as NoSQL database, Amazon RDS and Google Big Query such as cloud-country platforms and distributed and multi-model systems. We also check how artificial intelligence is changing database management through automation, discrepancy detection and future maintenance.

Recognizing the increasing importance of trust and compliance, dedicated chapters focus on industries’ rules such as safety, access control, data governance and GDPR and HIPAA. The study of real-world cases from areas such as retail, healthcare and finance provides valuable insight into practical implementation, challenges and migration strategies.

Whether you are a student, data engineer, software developer, or IT leader, this book serves as a complete guide to understand the developed world of database-where basic knowledge fulfils the state-of-the-art innovation.

References

Paton, Norman W., and Oscar Diaz. "Active database systems." ACM Computing Surveys (CSUR) 31.1 (1999): 63-103.

https://doi.org/10.1145/311531.311623

Liu, Ling, and M. Tamer Özsu, eds. Encyclopedia of database systems. Vol. 6. New York, NY, USA: Springer, 2009.

https://doi.org/10.1007/978-0-387-39940-9

DeWitt, David, and Jim Gray. "Parallel database systems: The future of high-performance database systems." Communications of the ACM 35.6 (1992): 85-98.

https://doi.org/10.1145/129888.129894

Ullman, Jeffrey D. Principles of database systems. Galgotia publications, 1983.

Elmasri, Ramez. Fundamentals of database systems. Pearson Education India, 2008.

Date, Christopher John. An introduction to database systems. Pearson Education India, 2006.

Özsu, M. Tamer, and Patrick Valduriez. Principles of distributed database systems. Vol. 2. Englewood Cliffs: Prentice Hall, 1999.

Bonnet, Philippe, Johannes Gehrke, and Praveen Seshadri. "Towards sensor database systems." International Conference on mobile Data management. Berlin, Heidelberg: Springer Berlin Heidelberg, 2001.

https://doi.org/10.1007/3-540-44498-X_1

Silberschatz, Abraham, Henry F. Korth, and Shashank Sudarshan. "Database system concepts." (2011).

Bertino, Elisa, et al. Indexing techniques for advanced database systems. Vol. 8. Springer Science & Business Media, 2012.

Yaqoob, Ibrar, et al. "Big data: From beginning to future." International Journal of Information Management 36.6 (2016): 1231-1247.

https://doi.org/10.1016/j.ijinfomgt.2016.07.009

Das, Sudipto, et al. "Automatically indexing millions of databases in microsoft azure sql database." Proceedings of the 2019 International Conference on Management of Data. 2019.

https://doi.org/10.1145/3299869.3314035

Chaudhuri, Surajit, and Vivek R. Narasayya. "An efficient, cost-driven index selection tool for Microsoft SQL server." VLDB. Vol. 97. 1997.

Casanova, Marco Antonio, ed. The concurrency control problem for database systems. Berlin, Heidelberg: Springer Berlin Heidelberg, 1981.

Franaszek, Peter, and John T. Robinson. "Limitations of concurrency in transaction processing." ACM Transactions on Database Systems (TODS) 10.1 (1985): 1-28.

https://doi.org/10.1145/3148.3160

Bernstein, Philip A., and Nathan Goodman. "Concurrency control in distributed database systems." ACM Computing Surveys (CSUR) 13.2 (1981): 185-221.

https://doi.org/10.1145/356842.356846

Barghouti, Naser S., and Gail E. Kaiser. "Concurrency control in advanced database applications." ACM Computing Surveys (CSUR) 23.3 (1991): 269-317.

https://doi.org/10.1145/116873.116875

Bernstein, Philip A., Vassos Hadzilacos, and Nathan Goodman. Concurrency control and recovery in database systems. Vol. 370. Reading: Addison-wesley, 1987.

Han, Jing, et al. "Survey on NoSQL database." 2011 6th international conference on pervasive computing and applications. IEEE, 2011.

Stonebraker, Michael. "SQL databases v. NoSQL databases." Communications of the ACM 53.4 (2010): 10-11.

https://doi.org/10.1145/1721654.1721659

Stonebraker, Michael. "SQL databases v. NoSQL databases." Communications of the ACM 53.4 (2010): 10-11.

https://doi.org/10.1145/1721654.1721659

Okman, Lior, et al. "Security issues in nosql databases." 2011IEEE 10th International Conference on Trust, Security and Privacy in Computing and Communications. IEEE, 2011.

https://doi.org/10.1109/TrustCom.2011.70

Li, Yishan, and Sathiamoorthy Manoharan. "A performance comparison of SQL and NoSQL databases." 2013 IEEE Pacific Rim conference on communications, computers and signal processing (PACRIM). IEEE, 2013.

https://doi.org/10.1109/PACRIM.2013.6625441

Gupta, Anurag, et al. "Amazon redshift and the case for simpler data warehouses." Proceedings of the 2015 ACM SIGMOD international conference on management of data. 2015.

https://doi.org/10.1145/2723372.2742795

Arora, Indu, and Anu Gupta. "Cloud databases: a paradigm shift in databases." International Journal of Computer Science Issues (IJCSI) 9.4 (2012): 77.

Deka, Ganesh Chandra. "A survey of cloud database systems." It Professional 16.2 (2013): 50-57.

https://doi.org/10.1109/MITP.2013.1

Inmon, William H., Derek Strauss, and Genia Neushloss. DW 2.0: The architecture for the next generation of data warehousing. Elsevier, 2010.

Ponniah, Paulraj. Data warehousing fundamentals for IT professionals. John Wiley & Sons, 2011.

https://doi.org/10.1002/9780470604137

Devlin, Barry. Data warehouse: from architecture to implementation. Addison-Wesley Longman Publishing Co., Inc., 1996.

Widom, Jennifer. "Research problems in data warehousing." Proceedings of the fourth international conference on Information and knowledge management. 1995.

https://doi.org/10.1145/221270.221319

Bernstein, Philip A., et al. "Query processing in a system for distributed databases (SDD-1)." ACM Transactions on Database Systems (TODS) 6.4 (1981): 602-625.

https://doi.org/10.1145/319628.319650

Bernstein, Philip A., and Nathan Goodman. "Concurrency control in distributed database systems." ACM Computing Surveys (CSUR) 13.2 (1981): 185-221.

https://doi.org/10.1145/356842.356846

Corbett, James C., et al. "Spanner: Google's globally distributed database." ACM Transactions on Computer Systems (TOCS) 31.3 (2013): 1-22.

https://doi.org/10.1145/2518037.2491245

Han, Jing, et al. "Survey on NoSQL database." 2011 6th international conference on pervasive computing and applications. IEEE, 2011.

Guo, Zhihan. "How to Design Disaggregation in Large-Scale Transaction Systems."

Manolopoulos, Yannis, Yannis Theodoridis, and Vassilis Tsotras. Advanced database indexing. Vol. 17. Springer Science & Business Media, 2012.

Giles, C. Lee, Kurt D. Bollacker, and Steve Lawrence. "CiteSeer: An automatic citation indexing system." Proceedings of the third ACM conference on Digital libraries. 1998.

https://doi.org/10.1145/276675.276685

Lancaster, Frederick Wilfrid. Indexing and abstracting in theory and practice. Library Association, 1998.

Bertino, Elisa, and Ravi Sandhu. "Database security-concepts, approaches, and challenges." IEEE Transactions on Dependable and secure computing 2.1 (2005): 2-19.

https://doi.org/10.1109/TDSC.2005.9

Benantar, Messaoud. Access control systems: security, identity management and trust models. Springer Science & Business Media, 2005.

Blackley, John A., Thomas R. Peltier, and Justin Peltier. Information security fundamentals. Auerbach Publications, 2004.

https://doi.org/10.1201/9780203488652

Ungar, Michael, ed. Multisystemic resilience: Adaptation and transformation in contexts of change. Oxford University Press, 2021.

https://doi.org/10.1093/oso/9780190095888.001.0001

Khatri, Vijay, and Carol V. Brown. "Designing data governance." Communications of the ACM 53.1 (2010): 148-152.

https://doi.org/10.1145/1629175.1629210

Simuni, Govindaiah, and Amaranatha Atla. "Hadoop in Enterprise Data Governance: Ensuring Compliance and Data Integrity." Available at SSRN 4982500 (2024).

https://doi.org/10.2139/ssrn.4982500

Janssen, Marijn, et al. "Data governance: Organizing data for trustworthy Artificial Intelligence." Government information quarterly 37.3 (2020): 101493.

https://doi.org/10.1016/j.giq.2020.101493

Kreps, Jay, Neha Narkhede, and Jun Rao. "Kafka: A distributed messaging system for log processing." Proceedings of the NetDB. Vol. 11. No. 2011. 2011.

Gupta, Rajeev, Himanshu Gupta, and Mukesh Mohania. "Cloud computing and big data analytics: what is new from databases perspective?." International conference on big data analytics. Berlin, Heidelberg: Springer Berlin Heidelberg, 2012.

https://doi.org/10.1007/978-3-642-35542-4_5

Kolajo, Taiwo, Olawande Daramola, and Ayodele Adebiyi. "Big data stream analysis: a systematic literature review." Journal of Big Data 6.1 (2019): 47.

https://doi.org/10.1186/s40537-019-0210-7

Ranjan, Rajiv. "Streaming big data processing in datacenter clouds." IEEE cloud computing 1.01 (2014): 78-83.

https://doi.org/10.1109/MCC.2014.22

Corrao, Giovanni, and Giuseppe Mancia. "Generating evidence from computerized healthcare utilization databases." Hypertension 65.3 (2015): 490-498.

https://doi.org/10.1161/HYPERTENSIONAHA.114.04858

van den Braak, Susan, Sunil Choenni, and Sicco Verwer. "Combining and analyzing judicial databases." Discrimination and Privacy in the Information Society: Data Mining and Profiling in Large Databases. Berlin, Heidelberg: Springer Berlin Heidelberg, 2013. 191-206.

https://doi.org/10.1007/978-3-642-30487-3_10

Raman, Ananth. "Retail-data quality: Evidence, causes, costs, and fixes." Technology in Society 22.1 (2000): 97-109.

https://doi.org/10.1016/S0160-791X(99)00037-8

Grover, Lov K. "A fast quantum mechanical algorithm for database search." Proceedings of the twenty-eighth annual ACM symposium on Theory of computing. 1996.

https://doi.org/10.1145/237814.237866

Jakobi, Markus, et al. "Practical private database queries based on a quantum-key-distribution protocol." Physical Review A-Atomic, Molecular, and Optical Physics 83.2 (2011): 022301.

https://doi.org/10.1103/PhysRevA.83.022301

Published

22 June 2025

Details about the available publication format: E-Book

E-Book

ISBN-13 (15)

978-93-7185-129-9

Details about the available publication format: Book (Paperback)

Book (Paperback)

ISBN-13 (15)

978-93-7185-196-1

How to Cite

Panda, S. P. . (2025). Relational, NoSQL, and Artificial Intelligence-Integrated Database Architectures: Foundations, Cloud Platforms, and Regulatory-Compliant Systems. Deep Science Publishing. https://doi.org/10.70593/978-93-7185-129-9