{
  "id": "07b22741-6e31-4820-b9d5-ccbf29193aa4",
  "title": "Fundamentals of Databases and Networking",
  "description": null,
  "userId": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
  "verifiedDate": null,
  "authTokenHashed": null,
  "content": null,
  "context": null,
  "contextDescription": null,
  "isOrigin": true,
  "slug": "fundamentals-of-databases-and-networking",
  "type": "Collection",
  "bookId": null,
  "chapterNumber": null,
  "isPrivate": false,
  "query": null,
  "triggerDevId": null,
  "triggerError": null,
  "createdAt": "2024-10-01T20:08:15.895Z",
  "updatedAt": "2024-10-01T20:08:15.895Z",
  "User": {
    "id": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
    "username": "chatgpt",
    "name": "ChatGPT"
  },
  "MediaAssets": [
    {
      "id": "c07e2ea8-5122-42bc-b07f-48718fad2d24",
      "knowledgeId": "07b22741-6e31-4820-b9d5-ccbf29193aa4",
      "mimeType": "image/webp",
      "order": null,
      "host": "Supabase",
      "bucket": "media",
      "path": "c07e2ea8-5122-42bc-b07f-48718fad2d24.webp",
      "name": "dalle-6aCTGuL6oyLP4QBb",
      "downloadLink": "https://files.oaiusercontent.com/file-yBFlDNxVRBSbjB1Q3xaccXYs?se=2024-10-01T20%3A13%3A12Z&sp=r&sv=2024-08-04&sr=b&rscc=max-age%3D604800%2C%20immutable%2C%20private&rscd=attachment%3B%20filename%3Dc99dafff-b6c3-44d0-903b-0620feb90cdd.webp&sig=PjTHYzoTeTNAOG%2BpG4T12i%2ByG%2BqEhAZQ8s4vAaRIpuA%3D",
      "triggerDevId": "run_1mb4fnq2bzn88r1e7syws",
      "triggerDevError": null,
      "createdAt": "2024-10-01T20:08:15.906Z",
      "updatedAt": "2024-10-01T20:08:30.355Z"
    }
  ],
  "Book": null,
  "SourceConnections": [
    {
      "id": "9113d785-1135-42e5-90b0-5a6d9aa88bac",
      "notes": "Explores data systems architecture, with a focus on scaling, consistency, and distributed systems.",
      "order": null,
      "type": "Contains",
      "sourceKnowledgeId": "07b22741-6e31-4820-b9d5-ccbf29193aa4",
      "targetKnowledgeId": "deb4acca-50ea-486f-9b8c-61f5df071bbe",
      "createdAt": "2024-10-01T20:08:15.916Z",
      "updatedAt": "2024-10-01T20:08:15.916Z",
      "metadata": null,
      "SourceKnowledge": null,
      "TargetKnowledge": {
        "id": "deb4acca-50ea-486f-9b8c-61f5df071bbe",
        "userId": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
        "slug": null,
        "isOrigin": false,
        "title": null,
        "description": null,
        "content": null,
        "context": null,
        "contextDescription": null,
        "type": "Book",
        "isPrivate": false,
        "createdAt": "2024-10-01T20:08:15.916Z",
        "updatedAt": "2024-10-01T20:08:15.916Z",
        "triggerDevId": null,
        "triggerError": null,
        "verifiedDate": null,
        "MediaAssets": [],
        "bookId": null,
        "chapterNumber": null,
        "query": "Designing Data-Intensive Applications Martin Kleppmann",
        "User": {
          "id": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
          "username": "chatgpt",
          "name": "ChatGPT"
        },
        "SourceConnections": [],
        "Book": null
      }
    },
    {
      "id": "a1130efe-2593-4ab4-afad-71414e140483",
      "notes": "This book introduces fundamental database concepts, including relational models, SQL, and data management.",
      "order": null,
      "type": "Contains",
      "sourceKnowledgeId": "07b22741-6e31-4820-b9d5-ccbf29193aa4",
      "targetKnowledgeId": "11876471-9de5-4205-9b08-56e864606cd3",
      "createdAt": "2024-10-01T20:08:15.916Z",
      "updatedAt": "2024-10-01T20:08:15.916Z",
      "metadata": null,
      "SourceKnowledge": null,
      "TargetKnowledge": {
        "id": "11876471-9de5-4205-9b08-56e864606cd3",
        "userId": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
        "slug": "databases-demystified-2nd-edition",
        "isOrigin": false,
        "title": "Databases DeMYSTiFieD, 2nd Edition",
        "description": null,
        "content": null,
        "context": null,
        "contextDescription": null,
        "type": "Book",
        "isPrivate": false,
        "createdAt": "2024-10-01T20:08:15.916Z",
        "updatedAt": "2024-10-01T20:08:15.916Z",
        "triggerDevId": null,
        "triggerError": null,
        "verifiedDate": null,
        "MediaAssets": [],
        "bookId": "80b27506-891a-496d-a1dc-159185f55d28",
        "chapterNumber": null,
        "query": "Databases Demystified Andrew Oppel",
        "User": {
          "id": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
          "username": "chatgpt",
          "name": "ChatGPT"
        },
        "SourceConnections": [],
        "Book": {
          "id": "80b27506-891a-496d-a1dc-159185f55d28",
          "title": "Databases DeMYSTiFieD, 2nd Edition",
          "subtitle": null,
          "description": "Learning DATABASE fundamentals just got a whole lot EASIER! Now you can design, build, and manage a fully functional database with ease. Thoroughly updated to cover the latest technologies and techniques, Databases Demystified, Second Edition gives you the hands-on help you need to get started. Written in a step-by-step format, this practical guide covers methods that can be used with any database, including Microsoft Access, MySQL, Microsoft SQL Server, and Oracle. You'll learn about relational database components, database queries, SQL, the database life cycle, logical database design using normalization, and physical database design. Data and process modeling, database security, Online Analytical Processing (OLAP), and XML are also covered. Detailed examples and concise explanations make it easy to understand the material, and end-of-chapter quizzes and a final exam help reinforce learning. It's a no-brainer! You'll find out how to: Create and run database queries using the forms-based query tool in Microsoft Access Write SQL statements and queries Use entity relationship diagrams (ERDs) for data modeling Design physical tables Connect databases to users, computer systems, and applications Secure database data Handle cursor processing, transaction management, and performance tuning Integrate XML documents and objects into databases Simple enough for a beginner, but challenging enough for an advanced student, Databases Demystified, Second Edition is your self-paced guide to learning universal database concepts.",
          "isbn13": "9780071747998",
          "isbn10": "0071747990",
          "asin": null,
          "editions": null,
          "googleId": "YJc70AEACAAJ",
          "olid": "OL24823949M",
          "slug": "databases-demystified-2nd-edition-0071747990",
          "publishedDate": "2010-11-10",
          "publisher": "Mcgraw-hill",
          "pageCount": 0,
          "language": "en",
          "cover": {
            "large": "https://covers.openlibrary.org/b/id/8635553-L.jpg",
            "small": "https://covers.openlibrary.org/b/id/8635553-S.jpg",
            "medium": "https://covers.openlibrary.org/b/id/8635553-M.jpg"
          },
          "triggerDevId": "run_t7u4jjqcverbjpmgp7k5y",
          "inferrenceError": null,
          "lastGoogleUpdated": "2024-10-01",
          "lastOLUpdated": "2024-10-01",
          "inferredAuthor": "Andy Oppel",
          "createdAt": "2024-10-01",
          "updatedAt": "2024-10-01"
        }
      }
    },
    {
      "id": "8ac70915-4131-40d4-943c-abb06713fb14",
      "notes": "A comprehensive guide to Postgres, covering everything from setup to query optimization.",
      "order": null,
      "type": "Contains",
      "sourceKnowledgeId": "07b22741-6e31-4820-b9d5-ccbf29193aa4",
      "targetKnowledgeId": "84fc2fde-afcb-4f62-aa11-6ddc791a44c9",
      "createdAt": "2024-10-01T20:08:15.916Z",
      "updatedAt": "2024-10-01T20:08:15.916Z",
      "metadata": null,
      "SourceKnowledge": null,
      "TargetKnowledge": {
        "id": "84fc2fde-afcb-4f62-aa11-6ddc791a44c9",
        "userId": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
        "slug": "postgresql-up-and-running",
        "isOrigin": false,
        "title": "PostgreSQL: Up and Running",
        "description": null,
        "content": null,
        "context": null,
        "contextDescription": null,
        "type": "Book",
        "isPrivate": false,
        "createdAt": "2024-10-01T20:08:15.916Z",
        "updatedAt": "2024-10-01T20:08:15.916Z",
        "triggerDevId": null,
        "triggerError": null,
        "verifiedDate": null,
        "MediaAssets": [],
        "bookId": "4d1ad0e2-961c-401f-9490-c75e62b9102a",
        "chapterNumber": null,
        "query": "PostgreSQL: Up and Running Regina Obe & Leo Hsu",
        "User": {
          "id": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
          "username": "chatgpt",
          "name": "ChatGPT"
        },
        "SourceConnections": [],
        "Book": {
          "id": "4d1ad0e2-961c-401f-9490-c75e62b9102a",
          "title": "PostgreSQL: Up and Running",
          "subtitle": null,
          "description": "Thinking of migrating to PostgreSQL? This updated guide helps you quickly understand and use the 9.3 release of this open source database system. You’ll not only learn about its unique enterprise-class features, but also discover that PostgeSQL is more than just a database system—it’s also an impressive application platform. Using numerous examples, this book shows you how to achieve tasks that are difficult or impossible in other databases. The second edition covers LATERAL queries, augmented JSON support, materialized views, and other key topics. If you’re an existing PostgreSQL user, you’ll pick up gems you may have missed along the way. Learn basic administration tasks, such as role management, database creation, backup, and restore Apply the psql command-line utility and the pgAdmin graphical administration tool Explore PostgreSQL tables, constraints, and indexes Learn powerful SQL constructs not generally found in other databases Use several different languages to write database functions Tune your queries to run as fast as your hardware will allow Query external and variegated data sources with Foreign Data Wrappers Learn how to replicate data, using built-in replication features",
          "isbn13": "9781449326296",
          "isbn10": "1449326293",
          "asin": null,
          "editions": null,
          "googleId": "37uYGc5pp8cC",
          "olid": null,
          "slug": "postgresql-up-and-running-1449326293",
          "publishedDate": "2012-07-06",
          "publisher": "\"O'Reilly Media, Inc.\"",
          "pageCount": 167,
          "language": "en",
          "cover": {
            "large": "http://books.google.com/books/content?id=37uYGc5pp8cC&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api",
            "small": "http://books.google.com/books/content?id=37uYGc5pp8cC&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api",
            "medium": "http://books.google.com/books/content?id=37uYGc5pp8cC&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api"
          },
          "triggerDevId": "run_d37up8g4re94ztojvnh4q",
          "inferrenceError": null,
          "lastGoogleUpdated": "2024-10-01",
          "lastOLUpdated": null,
          "inferredAuthor": "Regina O. Obe, Leo S. Hsu",
          "createdAt": "2024-10-01",
          "updatedAt": "2024-10-01"
        }
      }
    },
    {
      "id": "7f960e3d-0eef-4825-8513-e73360a8b921",
      "notes": "Provides in-depth coverage of networking protocols, including TCP/IP, essential for understanding database networking.",
      "order": null,
      "type": "Contains",
      "sourceKnowledgeId": "07b22741-6e31-4820-b9d5-ccbf29193aa4",
      "targetKnowledgeId": "d2a55902-0384-421b-99f2-1ead411e8287",
      "createdAt": "2024-10-01T20:08:15.916Z",
      "updatedAt": "2024-10-01T20:08:15.916Z",
      "metadata": null,
      "SourceKnowledge": null,
      "TargetKnowledge": {
        "id": "d2a55902-0384-421b-99f2-1ead411e8287",
        "userId": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
        "slug": "tcpip-illustrated-tcp-for-transactions-http-nntp-and-the-unix-domain-protocols",
        "isOrigin": false,
        "title": "TCP/IP Illustrated: TCP for transactions, HTTP, NNTP, and the UNIX domain protocols",
        "description": null,
        "content": null,
        "context": null,
        "contextDescription": null,
        "type": "Book",
        "isPrivate": false,
        "createdAt": "2024-10-01T20:08:15.916Z",
        "updatedAt": "2024-10-01T20:08:15.916Z",
        "triggerDevId": null,
        "triggerError": null,
        "verifiedDate": null,
        "MediaAssets": [],
        "bookId": "0bfd7844-9384-4bcc-8673-b31e5712129b",
        "chapterNumber": null,
        "query": "TCP/IP Illustrated, Volume 1 W. Richard Stevens",
        "User": {
          "id": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
          "username": "chatgpt",
          "name": "ChatGPT"
        },
        "SourceConnections": [],
        "Book": {
          "id": "0bfd7844-9384-4bcc-8673-b31e5712129b",
          "title": "TCP/IP Illustrated: TCP for transactions, HTTP, NNTP, and the UNIX domain protocols",
          "subtitle": null,
          "description": "TCP/IP Illustrated, Volume 3 covers four major topics of great importance to anyone working TCP/IP. It contains the first thorough treatment of TCP for transactions, commonly known as T/TCP, an extension to TCP that makes client-server transactions faster and more efficient. Next, the book covers two popular applications of T/TCP, the very hot topic of HTTP (the Hypertext Transfer Protocol), the foundation for the World Wide Web, and NNTP (the Network News Transfer Protocol), the basis for the Usenet news system. Both of these topics have increased in significance as the Internet has exploded in size and usage. Finally, the book covers UNIX Domain Protocols, protocols that are used heavily in UNIX implementations.",
          "isbn13": null,
          "isbn10": null,
          "asin": null,
          "editions": null,
          "googleId": "KP5SAAAAMAAJ",
          "olid": null,
          "slug": "tcpip-illustrated-tcp-for-transactions-http-nntp-and-the-unix-domain-protocols-74b99db4215c418c8ca68ba4b2e680a4",
          "publishedDate": "1996-01-01",
          "publisher": "Addison-Wesley Professional",
          "pageCount": 360,
          "language": "en",
          "cover": {
            "large": "http://books.google.com/books/content?id=KP5SAAAAMAAJ&printsec=frontcover&img=1&zoom=1&source=gbs_api",
            "small": "http://books.google.com/books/content?id=KP5SAAAAMAAJ&printsec=frontcover&img=1&zoom=1&source=gbs_api",
            "medium": "http://books.google.com/books/content?id=KP5SAAAAMAAJ&printsec=frontcover&img=1&zoom=1&source=gbs_api"
          },
          "triggerDevId": "run_ts8afufk22r5ptd2jjq2b",
          "inferrenceError": null,
          "lastGoogleUpdated": "2024-10-01",
          "lastOLUpdated": null,
          "inferredAuthor": "W. Richard Stevens, Gary R. Wright",
          "createdAt": "2024-10-01",
          "updatedAt": "2024-10-01"
        }
      }
    },
    {
      "id": "698b4344-1c2e-40b6-9eec-373733896f4c",
      "notes": "Introduces edge databases and their importance in distributed environments to improve data locality.",
      "order": null,
      "type": "Contains",
      "sourceKnowledgeId": "07b22741-6e31-4820-b9d5-ccbf29193aa4",
      "targetKnowledgeId": "1c9cb05c-4a03-4100-bb7d-793efd58d691",
      "createdAt": "2024-10-01T20:08:15.916Z",
      "updatedAt": "2024-10-01T20:08:15.916Z",
      "metadata": null,
      "SourceKnowledge": null,
      "TargetKnowledge": {
        "id": "1c9cb05c-4a03-4100-bb7d-793efd58d691",
        "userId": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
        "slug": "ecology-and-conservation-of-the-dutch-ground-beetle-fauna",
        "isOrigin": false,
        "title": "Ecology and conservation of the Dutch ground beetle fauna",
        "description": null,
        "content": null,
        "context": null,
        "contextDescription": null,
        "type": "Note",
        "isPrivate": false,
        "createdAt": "2024-10-01T20:08:15.916Z",
        "updatedAt": "2024-10-01T20:08:15.916Z",
        "triggerDevId": null,
        "triggerError": null,
        "verifiedDate": null,
        "MediaAssets": [],
        "bookId": "4a071620-e385-4469-ac96-73e5d7c0dd3d",
        "chapterNumber": null,
        "query": "Edge Databases: What You Need to Know Fauna",
        "User": {
          "id": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
          "username": "chatgpt",
          "name": "ChatGPT"
        },
        "SourceConnections": [],
        "Book": {
          "id": "4a071620-e385-4469-ac96-73e5d7c0dd3d",
          "title": "Ecology and conservation of the Dutch ground beetle fauna",
          "subtitle": "Lessons from 66 years of pitfall trapping",
          "description": "Over the past decades, large amounts of data about carabids have been collected in the Netherlands, initially for the purpose of creating distribution maps for the country. In addition to information from collections and faunistic publications, a significant amount of data came from ecological studies using pitfall traps. Because of the rich tradition of carabidological research in the Netherlands, an exceptionally large database of these pitfall data is available. The database is a mix of approximately 1,500 short-term samples and circa 4,400 so-called 'year-samples', for which pitfalls were functional during the whole activity period of ground beetles in spring and autumn. These year-samples came from 2,850 sites, covering the period of 1953-2018, and represent all habitats on the Dutch landscape. These data offer an unusual view of the presence and activity of this common insect family. The data gathered from pitfall trapping is summarised and provides a fresh integrated perspective about the Dutch ground beetle fauna. The characteristic species composition of 17 habitat groups is described in detail. Over 320 species present in the database have been classified into six main groups, according to their patterns of habitat use. Both the classification of habitats and associated species have been tested and used in various analyses in the book. Two chapters give special attention to changes in the Dutch fauna over the past 66 years by means of extensive trend analysis and relate this understanding to nature conservation. The book provides an extension and update for Turin's (2000) atlas. The Dutch carabid fauna is discussed considering relevant literature but uses predominantly European studies to put the faunal patterns in broader context. This book presents the story of Dutch ground beetles and illustrates the contribution of pitfall trapping to our understanding of the ecology of this fascinating and unusually well-studied group of beetles.",
          "isbn13": "9789086869213",
          "isbn10": "9086869211",
          "asin": null,
          "editions": null,
          "googleId": "CMz7EAAAQBAJ",
          "olid": "OL38119904M",
          "slug": "ecology-and-conservation-of-the-dutch-ground-beetle-fauna-9086869211",
          "publishedDate": "2023-09-14",
          "publisher": "BRILL",
          "pageCount": 451,
          "language": "en",
          "cover": {
            "large": "http://books.google.com/books/content?id=CMz7EAAAQBAJ&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api",
            "small": "http://books.google.com/books/content?id=CMz7EAAAQBAJ&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api",
            "medium": "http://books.google.com/books/content?id=CMz7EAAAQBAJ&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api"
          },
          "triggerDevId": "run_psucgc588p1bzisero5d6",
          "inferrenceError": null,
          "lastGoogleUpdated": "2024-10-01",
          "lastOLUpdated": "2024-10-01",
          "inferredAuthor": "Hans Turin, D. Johan Kotze, Stefan Müller-Kroehling, Pavel Saska, John Spence, Theodoor Heijerman",
          "createdAt": "2024-10-01",
          "updatedAt": "2024-10-01"
        }
      }
    },
    {
      "id": "7bc4aec0-9c86-4a3d-a7a0-e6487c998c7b",
      "notes": "Explains the internals of query execution in Postgres, from parsing to optimization.",
      "order": null,
      "type": "Contains",
      "sourceKnowledgeId": "07b22741-6e31-4820-b9d5-ccbf29193aa4",
      "targetKnowledgeId": "05c2f0d8-0d5a-4c47-93ea-acbd883feaec",
      "createdAt": "2024-10-01T20:08:15.916Z",
      "updatedAt": "2024-10-01T20:08:15.916Z",
      "metadata": null,
      "SourceKnowledge": null,
      "TargetKnowledge": {
        "id": "05c2f0d8-0d5a-4c47-93ea-acbd883feaec",
        "userId": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
        "slug": "postgresql",
        "isOrigin": false,
        "title": "PostgreSQL",
        "description": null,
        "content": null,
        "context": null,
        "contextDescription": null,
        "type": "Note",
        "isPrivate": false,
        "createdAt": "2024-10-01T20:08:15.916Z",
        "updatedAt": "2024-10-01T20:08:15.916Z",
        "triggerDevId": null,
        "triggerError": null,
        "verifiedDate": null,
        "MediaAssets": [],
        "bookId": "84cffa91-c5e8-4f86-a657-c0ad07eb9365",
        "chapterNumber": null,
        "query": "The Anatomy of a PostgreSQL Query Citus Data",
        "User": {
          "id": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
          "username": "chatgpt",
          "name": "ChatGPT"
        },
        "SourceConnections": [],
        "Book": {
          "id": "84cffa91-c5e8-4f86-a657-c0ad07eb9365",
          "title": "PostgreSQL",
          "subtitle": "Introduction and Concepts",
          "description": "The open source PostgreSQL database is soaring in popularity, as thousands of database and web professionals discover its powerful features, transaction support, performance, and industrial-strength scalability. In this book, a founding member of the PostgreSQL development team introduces everything you need to know to succeed with PostgreSQL, from basic SQL commands through database administration and optimization. PostgreSQL assumes no previous database expertise: it establishes a firm foundation of basic concepts and commands before turning to PostgreSQL's advanced, innovative capabilities. Bruce Momjian walks readers step-by-step from their first database queries through the complex queries needed to solve real-world problems. He presents proper query syntax, then explores the value and use of each key SQL commands in working applications. Learn to manipulate and update databases, customize queries, work with SQL aggregates, use joins, combine SELECTs with subqueries, work with triggers and transactions, import and export data, use PostgreSQL query tools, and more. Discover PostgreSQL techniques for server-side programming and multi-user control, and master PostgreSQL's interfaces to C, C++, ODBC, JDBC, Perl, and Tcl/TK. You'll also find detailed coverage of PostgreSQL administration, including backups, troubleshooting, and access configuration.",
          "isbn13": null,
          "isbn10": null,
          "asin": null,
          "editions": null,
          "googleId": "GE9GAQAAIAAJ",
          "olid": null,
          "slug": "postgresql-a679f3c56f7f4b9b90f51c5417a86a8c",
          "publishedDate": "2001-01-01",
          "publisher": "Addison-Wesley Professional",
          "pageCount": 504,
          "language": "en",
          "cover": {
            "large": "http://books.google.com/books/content?id=GE9GAQAAIAAJ&printsec=frontcover&img=1&zoom=1&source=gbs_api",
            "small": "http://books.google.com/books/content?id=GE9GAQAAIAAJ&printsec=frontcover&img=1&zoom=1&source=gbs_api",
            "medium": "http://books.google.com/books/content?id=GE9GAQAAIAAJ&printsec=frontcover&img=1&zoom=1&source=gbs_api"
          },
          "triggerDevId": "run_pkz6fmp16st77dmdia19t",
          "inferrenceError": null,
          "lastGoogleUpdated": "2024-10-01",
          "lastOLUpdated": null,
          "inferredAuthor": "Bruce Momjian",
          "createdAt": "2024-10-01",
          "updatedAt": "2024-10-01"
        }
      }
    },
    {
      "id": "5ced877c-6d07-4eac-820f-94cd4867d806",
      "notes": "A detailed explanation of how indexing in Postgres works, and how it can improve query performance.",
      "order": null,
      "type": "Contains",
      "sourceKnowledgeId": "07b22741-6e31-4820-b9d5-ccbf29193aa4",
      "targetKnowledgeId": "bc31d1e1-688a-4ef5-be01-f3ebcd6f4c55",
      "createdAt": "2024-10-01T20:08:15.916Z",
      "updatedAt": "2024-10-01T20:08:15.916Z",
      "metadata": null,
      "SourceKnowledge": null,
      "TargetKnowledge": {
        "id": "bc31d1e1-688a-4ef5-be01-f3ebcd6f4c55",
        "userId": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
        "slug": "mastering-postgresql-96",
        "isOrigin": false,
        "title": "Mastering PostgreSQL 9.6",
        "description": null,
        "content": null,
        "context": null,
        "contextDescription": null,
        "type": "Note",
        "isPrivate": false,
        "createdAt": "2024-10-01T20:08:15.916Z",
        "updatedAt": "2024-10-01T20:08:15.916Z",
        "triggerDevId": null,
        "triggerError": null,
        "verifiedDate": null,
        "MediaAssets": [],
        "bookId": "c91e8c56-c2a9-489d-9f63-f1d72d1b8a15",
        "chapterNumber": null,
        "query": "A Deep Dive into PostgreSQL Indexes Hans-Jürgen Schönig",
        "User": {
          "id": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
          "username": "chatgpt",
          "name": "ChatGPT"
        },
        "SourceConnections": [],
        "Book": {
          "id": "c91e8c56-c2a9-489d-9f63-f1d72d1b8a15",
          "title": "Mastering PostgreSQL 9.6",
          "subtitle": null,
          "description": "Master the capabilities of PostgreSQL 9.6 to efficiently manage and maintain your database About This Book Your one-stop guide to mastering the advanced concepts in PostgreSQL with ease Master query optimization, replication, and high availability with PostgreSQL Extend the functionalities of PostgreSQL to suit your organizational needs with minimum effort Who This Book Is For If you are a PostgreSQL data architect or an administrator who wants to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL is required to make the best use of this book. What You Will Learn Get to grips with the advanced features of PostgreSQL 9.6 and handle advanced SQL Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries Work with the stored procedures and manage backup and recovery Master the replication and failover techniques Troubleshoot your PostgreSQL instance for solutions to the common and not-so-common problems Learn how to migrate your database from MySQL and Oracle to PostgreSQL without any hassle In Detail PostgreSQL is an open source database used for handling large datasets (Big Data) and as a JSON document database. It also has applications in the software and web domains. This book will enable you to build better PostgreSQL applications and administer databases more efficiently. We begin by explaining the advanced database design concepts in PostgreSQL 9.6, along with indexing and query optimization. You will also see how to work with event triggers and perform concurrent transactions and table partitioning, along with exploring SQL and server tuning. We will walk you through implementing advanced administrative tasks such as server maintenance and monitoring, replication, recovery and high availability, and much more. You will understand the common and not-so-common troubleshooting problems and how you can overcome them. By the end of this book, you will have an expert-level command of the advanced database functionalities and will be able to implement advanced administrative tasks with PostgreSQL. Style and Approach This book is a comprehensive guide covering all the concepts you need to master PostgreSQL. Packed with hands-on examples, tips and tricks, even the most advanced concepts are explained in a very easy-to-follow manner. Every chapter in the book does not only focus on how each task is performed, but also why.",
          "isbn13": "9781783555369",
          "isbn10": "178355536X",
          "asin": null,
          "editions": null,
          "googleId": "unc5DwAAQBAJ",
          "olid": null,
          "slug": "mastering-postgresql-96-178355536X",
          "publishedDate": "2017-05-30",
          "publisher": "Packt Publishing Ltd",
          "pageCount": 408,
          "language": "en",
          "cover": {
            "large": "http://books.google.com/books/content?id=unc5DwAAQBAJ&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api",
            "small": "http://books.google.com/books/content?id=unc5DwAAQBAJ&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api",
            "medium": "http://books.google.com/books/content?id=unc5DwAAQBAJ&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api"
          },
          "triggerDevId": "run_csctpcw3qii9uuituxuyd",
          "inferrenceError": null,
          "lastGoogleUpdated": "2024-10-01",
          "lastOLUpdated": null,
          "inferredAuthor": "Hans-Jurgen Schonig",
          "createdAt": "2024-10-01",
          "updatedAt": "2024-10-01"
        }
      }
    },
    {
      "id": "8a68bb01-1612-4471-ac13-afd17ba7c0d8",
      "notes": "This article introduces the concept of database connection pooling, explaining how it improves resource management and efficiency.",
      "order": null,
      "type": "Contains",
      "sourceKnowledgeId": "07b22741-6e31-4820-b9d5-ccbf29193aa4",
      "targetKnowledgeId": "973e48a1-2156-4e0e-85ee-6382801c65ed",
      "createdAt": "2024-10-01T20:08:15.916Z",
      "updatedAt": "2024-10-01T20:08:15.916Z",
      "metadata": null,
      "SourceKnowledge": null,
      "TargetKnowledge": {
        "id": "973e48a1-2156-4e0e-85ee-6382801c65ed",
        "userId": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
        "slug": "dbas-guide-to-databases-under-linux",
        "isOrigin": false,
        "title": "DBAs Guide to Databases Under Linux",
        "description": null,
        "content": null,
        "context": null,
        "contextDescription": null,
        "type": "Note",
        "isPrivate": false,
        "createdAt": "2024-10-01T20:08:15.916Z",
        "updatedAt": "2024-10-01T20:08:15.916Z",
        "triggerDevId": null,
        "triggerError": null,
        "verifiedDate": null,
        "MediaAssets": [],
        "bookId": "77174d9c-b3d8-4256-9ac8-86f5bb166c32",
        "chapterNumber": null,
        "query": "Understanding Database Pooling Compose",
        "User": {
          "id": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
          "username": "chatgpt",
          "name": "ChatGPT"
        },
        "SourceConnections": [],
        "Book": {
          "id": "77174d9c-b3d8-4256-9ac8-86f5bb166c32",
          "title": "DBAs Guide to Databases Under Linux",
          "subtitle": null,
          "description": "In an effort to increase its marketshare and threat to Windows NT, Oracle8 was ported to Linux in late 1998, opening the popular database to an additional 10 million Linux users worldwide. The availability of Oracle8 enables current Linux users to deploy enterprise-class applications at low cost and provides an alternative to Microsoft Windows NT. This book covers that marriage of the most popular database and the fastest growing operating system. * Complete coverage. Covers both Oracle8i and Oracle8i Lite, as well as Oracle Applications, Oracle Applications Server, and Oracle Developer * Organizations and Oracle database administrators will be looking for information on Linux as is gets adopted - this book fits the bill * Covers two growth markets and fills a need for information not covered elsewhere",
          "isbn13": "9780080530291",
          "isbn10": "008053029X",
          "asin": null,
          "editions": null,
          "googleId": "TszUjeyeo8cC",
          "olid": "OL35759744M",
          "slug": "dbas-guide-to-databases-under-linux-008053029X",
          "publishedDate": "2000-04-26",
          "publisher": "Elsevier",
          "pageCount": 527,
          "language": "en",
          "cover": {
            "large": "http://books.google.com/books/content?id=TszUjeyeo8cC&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api",
            "small": "http://books.google.com/books/content?id=TszUjeyeo8cC&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api",
            "medium": "http://books.google.com/books/content?id=TszUjeyeo8cC&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api"
          },
          "triggerDevId": "run_wvn9x8z9r5k78z9tc7i5e",
          "inferrenceError": null,
          "lastGoogleUpdated": "2024-10-01",
          "lastOLUpdated": "2024-10-01",
          "inferredAuthor": "Syngress",
          "createdAt": "2024-10-01",
          "updatedAt": "2024-10-01"
        }
      }
    },
    {
      "id": "b0bafe0e-1b30-44e5-998a-022b65bac288",
      "notes": "A detailed dive into the internals of databases, covering storage engines, query execution, and indexing.",
      "order": null,
      "type": "Contains",
      "sourceKnowledgeId": "07b22741-6e31-4820-b9d5-ccbf29193aa4",
      "targetKnowledgeId": "3813b167-73af-429a-8589-c931db5c7ee8",
      "createdAt": "2024-10-01T20:08:15.916Z",
      "updatedAt": "2024-10-01T20:08:15.916Z",
      "metadata": null,
      "SourceKnowledge": null,
      "TargetKnowledge": {
        "id": "3813b167-73af-429a-8589-c931db5c7ee8",
        "userId": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
        "slug": "database-internals",
        "isOrigin": false,
        "title": "Database Internals",
        "description": null,
        "content": null,
        "context": null,
        "contextDescription": null,
        "type": "Book",
        "isPrivate": false,
        "createdAt": "2024-10-01T20:08:15.916Z",
        "updatedAt": "2024-10-01T20:08:15.916Z",
        "triggerDevId": null,
        "triggerError": null,
        "verifiedDate": null,
        "MediaAssets": [],
        "bookId": "b2a6c113-e19e-4dc0-839e-ebd04d96c065",
        "chapterNumber": null,
        "query": "Database Internals Alex Petrov",
        "User": {
          "id": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
          "username": "chatgpt",
          "name": "ChatGPT"
        },
        "SourceConnections": [],
        "Book": {
          "id": "b2a6c113-e19e-4dc0-839e-ebd04d96c065",
          "title": "Database Internals",
          "subtitle": "A Deep Dive into How Distributed Data Systems Work",
          "description": "When it comes to choosing, using, and maintaining a database, understanding its internals is essential. But with so many distributed databases and tools available today, it’s often difficult to understand what each one offers and how they differ. With this practical guide, Alex Petrov guides developers through the concepts behind modern database and storage engine internals. Throughout the book, you’ll explore relevant material gleaned from numerous books, papers, blog posts, and the source code of several open source databases. These resources are listed at the end of parts one and two. You’ll discover that the most significant distinctions among many modern databases reside in subsystems that determine how storage is organized and how data is distributed. This book examines: Storage engines: Explore storage classification and taxonomy, and dive into B-Tree-based and immutable Log Structured storage engines, with differences and use-cases for each Storage building blocks: Learn how database files are organized to build efficient storage, using auxiliary data structures such as Page Cache, Buffer Pool and Write-Ahead Log Distributed systems: Learn step-by-step how nodes and processes connect and build complex communication patterns Database clusters: Which consistency models are commonly used by modern databases and how distributed storage systems achieve consistency",
          "isbn13": "9781492040316",
          "isbn10": "1492040312",
          "asin": null,
          "editions": null,
          "googleId": "-l2vDwAAQBAJ",
          "olid": null,
          "slug": "database-internals-1492040312",
          "publishedDate": "2019-09-13",
          "publisher": "O'Reilly Media",
          "pageCount": 373,
          "language": "en",
          "cover": {
            "large": "http://books.google.com/books/content?id=-l2vDwAAQBAJ&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api",
            "small": "http://books.google.com/books/content?id=-l2vDwAAQBAJ&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api",
            "medium": "http://books.google.com/books/content?id=-l2vDwAAQBAJ&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api"
          },
          "triggerDevId": "run_xsk1e9xbjpoksvh9ia3sp",
          "inferrenceError": null,
          "lastGoogleUpdated": "2024-10-01",
          "lastOLUpdated": null,
          "inferredAuthor": "Alex Petrov",
          "createdAt": "2024-10-01",
          "updatedAt": "2024-10-01"
        }
      }
    },
    {
      "id": "60f356ed-0fc5-4113-9c50-63bc389e6079",
      "notes": "Discusses the relationship between databases and networking, focusing on how they interact in distributed systems.",
      "order": null,
      "type": "Contains",
      "sourceKnowledgeId": "07b22741-6e31-4820-b9d5-ccbf29193aa4",
      "targetKnowledgeId": "bb993fcc-1944-4899-ad29-20ab895dca91",
      "createdAt": "2024-10-01T20:08:15.916Z",
      "updatedAt": "2024-10-01T20:08:15.916Z",
      "metadata": null,
      "SourceKnowledge": null,
      "TargetKnowledge": {
        "id": "bb993fcc-1944-4899-ad29-20ab895dca91",
        "userId": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
        "slug": "ibm-btype-data-center-networking-design-and-best-practices-introduction",
        "isOrigin": false,
        "title": "IBM b-type Data Center Networking: Design and Best Practices Introduction",
        "description": null,
        "content": null,
        "context": null,
        "contextDescription": null,
        "type": "Note",
        "isPrivate": false,
        "createdAt": "2024-10-01T20:08:15.916Z",
        "updatedAt": "2024-10-01T20:08:15.916Z",
        "triggerDevId": null,
        "triggerError": null,
        "verifiedDate": null,
        "MediaAssets": [],
        "bookId": "fb902408-0752-4c96-8d98-79f343cda4db",
        "chapterNumber": null,
        "query": "Networking and Databases: How They Work Together IBM",
        "User": {
          "id": "f1a2ab2a-9195-45c1-982e-8b5bc661986c",
          "username": "chatgpt",
          "name": "ChatGPT"
        },
        "SourceConnections": [],
        "Book": {
          "id": "fb902408-0752-4c96-8d98-79f343cda4db",
          "title": "IBM b-type Data Center Networking: Design and Best Practices Introduction",
          "subtitle": null,
          "description": "As organizations drive to transform and virtualize their IT infrastructures to reduce costs, and manage risk, networking is pivotal to success. Optimizing network performance, availability, adaptability, security, and cost is essential to achieving the maximum benefit from your infrastructure. In this IBM® Redbooks® publication, we address these requirements: Expertise to plan and design networks with holistic consideration of servers, storage, application performance, and manageability Networking solutions that enable investment protection with performance and cost options that match your environment Technology and expertise to design and implement and manage network security and resiliency Robust network management software for integrated, simplified management that lowers operating costs of complex networks IBM and Brocade have entered into an agreement to provide expanded network technology choices with the new IBM b-type Ethernet Switches and Routers, to provide an integrated end-to-end resiliency and security framework. Combined with the IBM vast data center design experience and the Brocade networking expertise, this portfolio represents the ideal convergence of strength and intelligence. For organizations striving to transform and virtualize their IT infrastructure, such a combination can help you reduce costs, manage risks, and prepare for the future. This book is meant to be used along with \"IBM b-type Data Center Networking: Product Introduction and Initial Setup,\" SG24-7785.",
          "isbn13": "9780738435015",
          "isbn10": "0738435015",
          "asin": null,
          "editions": null,
          "googleId": "QVbAAgAAQBAJ",
          "olid": "OL37774923M",
          "slug": "ibm-b-type-data-center-networking-design-and-best-practices-introduction-0738435015",
          "publishedDate": "2010-12-30",
          "publisher": "IBM Redbooks",
          "pageCount": 614,
          "language": "en",
          "cover": {
            "large": "http://books.google.com/books/content?id=QVbAAgAAQBAJ&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api",
            "small": "http://books.google.com/books/content?id=QVbAAgAAQBAJ&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api",
            "medium": "http://books.google.com/books/content?id=QVbAAgAAQBAJ&printsec=frontcover&img=1&zoom=1&edge=curl&source=gbs_api"
          },
          "triggerDevId": "run_3e5vzskdxm8avcnv84ogg",
          "inferrenceError": null,
          "lastGoogleUpdated": "2024-10-01",
          "lastOLUpdated": "2024-10-01",
          "inferredAuthor": "Jon Tate, Norman Bogard, Michal Holenia, Sebastian Oglaza, Steven Tong, IBM Redbooks",
          "createdAt": "2024-10-01",
          "updatedAt": "2024-10-01"
        }
      }
    }
  ]
}