LU7 Database for the Web and Social Media PDF

LU7: Database for the Web and Social Media 1. Database Connectivity Technologies Java Database Native SQL Connectivity Database Middleware Connectivity (JDBC) What It Is A Java-based to...

LU7: Database for the Web and Social Media 1. Database Connectivity Technologies Java Database Native SQL Connectivity Database Middleware Connectivity (JDBC) What It Is A Java-based tool that Database-specific tools for Middleware acts as a bridge helps Java programs optimized connections. between applications and connect to databases. databases. Main Features Works with object- Fast connections tailored for Universal API for connecting oriented programming. specific databases. databases (ODBC). Connects directly to Includes advanced features Interfaces for various data databases or via unique to the database. sources (OLE-DB). middleware..NET classes for database Supports web browser access (ADO.NET). integration. Example ODBC (Open Database Connectivity) OLE-DB (Object Linking and Oracle’s SQL*Net Embedding Directory (Oracle Net Services) Services) ADO.NET (ActiveX Data Objects) Benefits Uses familiar Optimized for performance Standardizes database technologies, making it with specific databases. communication across easier to learn. Takes advantage of platforms. Flexible, supports many proprietary features. Simplifies data integration. DBMS. 2. Database Connectivity APIs ODBC (Open Database Aspect DAO (Data Access Objects) RDO (Remote Data Objects) Connectivity) An object-oriented API for Microsoft A standard API for accessing A higher-level API for accessing Definition databases like MS Access, MS FoxPro, databases using SQL. remote database servers. and dBase. - Built on DAO and ODBC for - Universal data access for various - Optimized interface for Jet database abstraction. - Optimized for server- databases. - Connects to any database engine. - Object-oriented data Key Features based databases (e.g., MS SQL Server, with an ODBC driver. - Executes SQL manipulation. - Accesses other Oracle). - Simplifies remote data queries. relational data sources. connections and transactions. Level of Low-level API for direct database Mid-level API with an object-oriented High-level API offering streamlined Abstraction access. approach. remote access. Target Supports a wide range of database Specific to Microsoft databases. Focused on remote database servers. Databases systems. Used for general database connectivity Commonly used in Visual Basic Suitable for accessing remote Usage Context and independence. applications for Microsoft databases. databases efficiently. ODBC: Best for general database connectivity across multiple systems. DAO: Ideal for Microsoft database-focused Visual Basic applications. RDO: Excellent for remote database access and server-based databases. 3. Extensions for Database Interaction Features Client-Side Extensions Server-Side Extensions Client-side extensions are software components Server-side extensions are components that run on Definition that run on the user's machine (client) and interact the web server and handle database interactions. with the web application. Execution Location User's device Web server User Interaction Direct interaction with users Processes requests from clients Performance Client resource-dependent Server-based processing Examples Browser plug-ins, JavaScript Web frameworks, REST APIs 4. Database types Database Definition Key Features Examples Use Cases Type Databases that ACID Properties: Ensure reliable Applications requiring Relational MySQL, organize data into transactions (Atomicity, Consistency, complex queries and Databases PostgreSQL, tables with predefined Isolation, Durability). strict data integrity, (RDBMS) Oracle schemas. SQL: Uses Structured Query Language. e.g., financial systems. Schema-less: Flexible data models with Databases designed to MongoDB, Big data, real-time dynamic schema changes. NoSQL handle unstructured Redis, analytics, and Types: Document Stores, Key-Value Databases or semi-structured Cassandra, applications requiring Stores, Column-Family Stores, Graph data. Neo4j horizontal scaling. Databases. 5. CAP Theorem https://www.voltactivedata.com/blog/2024/04/acid-vs-cap/ 6. BASE https://www.geeksforgeeks.org/acid-model-vs-base-model-for-database/