User:Ruftas/Books/Databases

Ruftas Ent...™

 * Introduction
 * Data management
 * Database
 * Database system
 * Database management system
 * Types of DBMS
 * Data store
 * Technical Information Project


 * Introduction to Data Modeling
 * Data modeling
 * Data model
 * Database model
 * Database design
 * Conceptual schema
 * Data structure diagram
 * Hierarchical database model
 * Network model
 * Navigational database


 * ERD
 * Entity-relationship model
 * Has-a
 * Many-to-many
 * Enhanced Entity-Relationship Model
 * Weak entity
 * Associative Entities
 * Structured-Entity-Relationship-Model
 * Barker's Notation
 * Peter Chen


 * Other Data Modeling Techniques
 * Unified Modeling Language
 * The Third Manifesto
 * Three schema approach
 * White pages schema
 * Anchor Modeling
 * Bachman diagram
 * Bitemporal Modeling
 * Bitemporal data
 * IDEF1X
 * Universal Data Element Framework
 * Terminology model
 * Georelational data model
 * Semantic data model
 * Relational Model/Tasmania


 * Relational Schema
 * Relational model
 * Relational database
 * Relational database management system
 * Life cycle of a relational database
 * Logical data model
 * Logical schema
 * Relation
 * Table
 * Tuple
 * Row
 * Attribute domain
 * Candidate key
 * Unique key
 * Natural key
 * Key field
 * Compound key
 * Foreign key
 * Persistent Object Identifier
 * Cardinality
 * Recordset
 * Superkey
 * Integrity constraints
 * Check Constraint
 * Propagation constraint
 * Transition constraint
 * Wide and narrow data
 * Universal relation assumption
 * Reference table
 * Junction table
 * Nested set model
 * Information schema
 * Codd's 12 rules
 * Edgar F. Codd


 * Relational algebra
 * Relational algebra
 * Projection
 * Rename
 * Selection
 * Generalized selection
 * Range query
 * Monotonic query
 * Recursive join
 * Relvar
 * Relational calculus
 * Tuple relational calculus


 * Overview
 * Query language
 * Data Definition Language
 * Varchar
 * Data Manipulation Language
 * Create, read, update and delete
 * SQL
 * SQL-92
 * SQL:1999
 * SQL:2003
 * SQL:2008
 * SQL:2011
 * Data
 * Metadata


 * Database objects
 * Table
 * Column
 * Field
 * Row
 * Data type


 * Statements
 * Select
 * Result set
 * Synonym
 * Alias
 * Insert
 * Update
 * Merge
 * Delete
 * Join
 * Set operations
 * Commit
 * Rollback
 * Truncate


 * Views
 * View
 * Materialized view


 * Advanced Issues
 * Hierarchical query
 * Hint


 * Extensions
 * SQL/CLI
 * SQL/JRT
 * SQL/MED
 * SQL/OLB
 * SQL/PSM
 * SQL/Schemata
 * StreamSQL


 * dBase and derived languages
 * DBase
 * Clip
 * Clipper
 * Flagship compiler
 * FoxPro 2
 * Harbour
 * Visual FoxPro
 * Visual Objects
 * XBase
 * XBase++
 * XHarbour


 * Other Query Languages
 * QUEL query languages
 * Query by Example
 * SQR
 * .QL
 * Yahoo! query language
 * YQL
 * YANG
 * WQL
 * Versa
 * SPARQL
 * RDF query language
 * Access query language
 * Nonprocedural language
 * Facebook Query Language


 * Databases Programming
 * Active database
 * Database trigger
 * Stored procedure
 * PL/SQL
 * SQL PL
 * SQL programming tool
 * User-defined function
 * Cursor
 * SQL Problems Requiring Cursors
 * WxSQLite3


 * Database connectivity
 * Application programming interface
 * Structured Query Language Interface
 * Database transaction
 * Prepared statement
 * Open Database Connectivity
 * Java Database Connectivity
 * ODBC
 * OLE DB provider
 * OLE DB
 * UnixODBC
 * IODBC
 * Pool
 * Connection pool
 * Remote Database Access
 * SQLJ
 * Native Queries
 * Meta-SQL
 * ADO.NET


 * Software and Tools
 * List of relational database management systems
 * Comparison of relational database management systems
 * Comparison of database tools
 * Comparison of object-relational database management systems
 * Transactions per second


 * SQL Server
 * Microsoft SQL Server
 * Microsoft SQL Server Master Data Services
 * Transact-SQL
 * WCF Data Services
 * Windows Internal Database
 * SQL Server Agent
 * SQL Server Compact
 * SQL CLR
 * Microsoft Transaction Server


 * Oracle
 * Database schema
 * Oracle Database
 * Oracle Exadata
 * Oracle Coherence
 * NVL
 * Pro*C


 * Tools
 * Toad Data Modeler
 * SQuirreL SQL Client
 * SQuirreL SQL Client Plugin API
 * SQLPro SQL Client
 * Navicat
 * ModelRight


 * Other DBMS
 * MySQL
 * SQL Anywhere
 * SQLite
 * SESAM
 * LAMP
 * Watcom SQL
 * Microsoft Access
 * VMDS
 * Superbase database
 * Rocket U2
 * PointBase
 * R:BASE System
 * REAL Server
 * MaxDB
 * Adaptive Server Enterprise
 * Advantage Database Server
 * Ingres


 * Normal Form
 * Data redundancy
 * Database normalization
 * Functional dependency
 * Armstrong's axioms
 * Transitive dependency
 * Superkey
 * First normal form
 * Second normal form
 * Third normal form
 * Boyce–Codd normal form
 * Lossless-Join Decomposition
 * Join dependency
 * Multivalued dependency
 * Fourth normal form
 * Fifth normal form
 * Sixth normal form
 * Denormalization
 * Domain/key normal form
 * Single Source of Truth
 * Single version of the truth
 * Principle of Orthogonal Design


 * Transaction Management
 * Database transaction
 * Transaction processing
 * Concurrency control
 * Transaction Control Language
 * ACID
 * Atomicity
 * Isolation
 * Durability
 * Atomic commit
 * Schedule
 * Serializability
 * Precedence graph
 * Serializability theory
 * Read–write conflict
 * Write–read conflict
 * Write–write conflict
 * Lock
 * Record locking
 * Multiple granularity locking
 * Two-phase locking
 * Readers–writer lock
 * Blind write
 * Conservative two-phase locking
 * Strong strict two-phase locking
 * Index locking
 * Snapshot isolation
 * Non-lock concurrency control
 * Commitment ordering
 * Long-running transaction
 * Timestamp-based concurrency control
 * Pseudoconversational transaction
 * Thomas write rule
 * Global concurrency control
 * Global serializability
 * Modular concurrency control
 * Multiversion concurrency control
 * Optimistic concurrency control
 * Autocommit
 * Transaction log
 * Savepoint
 * No-force
 * Non-blocking algorithm
 * Data recovery
 * Point-in-time recovery
 * Redo log
 * Extreme transaction processing
 * In-database processing
 * Locks with ordered sharing
 * Nested transaction
 * Transaction processing system
 * Transaction processing systems
 * Transaction server
 * Priority inversion
 * Priority ceiling protocol
 * Priority inheritance


 * Query Optimization and Indexing
 * Query optimization
 * Query optimizer
 * Query plan
 * Index
 * Partial index
 * Expression index
 * Reverse index
 * Bitmap index
 * Inverted index
 * Sargable
 * V-optimal histograms
 * Cardinality
 * Online aggregation


 * Distributed DB
 * Very large database
 * Big data
 * XLDB
 * Secondary database server
 * Centralized database
 * Distributed database
 * Distributed database management system
 * Distributed file system
 * Distributed data store
 * Heterogeneous Database System
 * Simple Sloppy Semantic Database
 * Distributed transaction
 * Network transparency
 * Long-lived transaction
 * Distributed concurrency control
 * Consistency model
 * Distributed Transaction Coordinator
 * Two-phase commit protocol
 * Three-phase commit protocol
 * Xeround
 * Vector-field consistency
 * Storage area network
 * Partition
 * Shared nothing architecture
 * Shard
 * Quorum


 * Physical Design
 * Physical data model
 * Physical schema
 * Storage model
 * Storage block
 * Tablespace
 * Database tuning
 * Database dump
 * Spindling


 * Data Mapping and Integration Tasks
 * Data mapping
 * Semantic integration
 * Semantic translation
 * Record linkage
 * Metadata discovery
 * Schema matching
 * Schema crosswalk
 * Schema evolution
 * Data integration
 * Ontology-based data integration
 * Ontology merging


 * Parallel
 * MapReduce
 * Apache Hadoop
 * Pig
 * H-Store


 * Information Security
 * Data control language
 * SQL injection


 * Data Warehousing
 * Business intelligence
 * Reactive business intelligence
 * Business analytics
 * Sales intelligence
 * Data warehouse
 * Data warehouse architectures
 * Data mart
 * The Kimball Lifecycle
 * Time variance
 * Federated database system
 * Single Source of Truth
 * XLeratorDB


 * Design
 * Dimension
 * Fact
 * Measure
 * Fact table
 * Degenerate dimension
 * Slowly changing dimension
 * Star schema
 * Dimension table
 * Dimensional Fact Model
 * Snowflake schema
 * Denormalization
 * Single version of the truth
 * Transaction data
 * Enterprise bus matrix


 * OLAP
 * Statistical database
 * Online transaction processing
 * Operational system
 * Operational data store
 * Operational database
 * Online analytical processing
 * OLAP cube
 * Aggregate
 * MOLAP
 * ROLAP
 * HOLAP
 * Thomsen Diagrams
 * Spreadmart
 * MultiDimensional eXpressions


 * OLAP Servers and Tools
 * Comparison of OLAP Servers
 * Applix
 * BusinessObjects OLAP Intelligence
 * Crystal Analysis
 * CubePort
 * Essbase
 * Microsoft Analysis Services
 * Mondrian OLAP server
 * OLE DB for OLAP
 * Oracle OLAP
 * Palo
 * Panorama Software
 * ProClarity
 * SAP BI Accelerator
 * SAP NetWeaver Business Intelligence
 * NEVOD DMB


 * Data Transformation
 * Extract, transform, load
 * Staging
 * Vocabulary-based transformation
 * Surrogate key
 * Variable data publishing
 * Semantic warehousing
 * Scriptella


 * Data Quality
 * Bit rot
 * Cleansing and Conforming Data
 * Data auditing
 * Data cleansing
 * Data corruption
 * Data integrity
 * Data profiling
 * Data quality
 * Data quality assessment
 * Data quality assurance
 * Data Quality Firewall
 * Data truncation
 * Data validation
 * Data verification
 * Database integrity
 * Database preservation
 * Declarative Referential Integrity
 * Digital continuity
 * Digital preservation
 * User:TheAmazing0and1/draftdigipres
 * Dirty data
 * Entity integrity
 * Information quality
 * Link rot
 * One-for-one checking
 * Referential integrity
 * Soft error
 * Two pass verification
 * Validation rule


 * XML
 * Semi-structured data
 * Semi-structured model
 * Standard Generalized Markup Language
 * XML
 * XML database
 * XML Schema Language comparison
 * XML schema
 * XML validation
 * Xpath data model
 * Path expression
 * XQuery
 * XSA
 * XSIL
 * SQL/XML
 * Regular Language description for XML
 * PureXML
 * List of XML schemas


 * Object database
 * Object database
 * Object Definition Language
 * Object Query Language
 * Object-oriented SQL
 * Object Exchange Model
 * Object-relational database
 * Object-relational impedance mismatch
 * Object-relational mapping
 * Polymorphic association
 * Polyinstantiation
 * Single Table Inheritance
 * Versant Object Database
 * Terminology-oriented database
 * Odaba
 * Object Data Management Group
 * List of object database management systems
 * Comparison of object database management systems
 * PostgreSQL
 * PL/pgSQL
 * PL/Perl
 * JADE
 * ObjectDB
 * Versant Object Database
 * Zope Object Database


 * No-SQL Databases
 * Strozzi NoSQL
 * NoSQL
 * Graph database
 * DEX
 * Neo4j
 * Sones GraphDB
 * Apache Cassandra
 * Triplestore
 * Keyspace
 * Super column
 * BigTable
 * Flat file database
 * Terminfo
 * Termcap
 * MultiValue
 * OpenInsight
 * Document-oriented database
 * MongoDB


 * Spatiotemporal Databases
 * Temporal database
 * RRDtool
 * Spatial database
 * Spatial query
 * Spatiotemporal database
 * Object-based spatial database
 * Tuple-versioning
 * Valid time
 * Transaction time
 * Geospatial metadata
 * Geographical database
 * Time series database
 * Operational historian


 * Special Databases
 * Real-time database
 * In-memory database
 * Probabilistic database
 * Deductive database
 * Deductive language
 * Mobile database


 * Well Known Databases
 * Standard data model
 * Suppliers and Parts database
 * Internet Movie Database
 * YAGO
 * World Wide Molecular Matrix
 * Voter database
 * VIOLIN vaccine database
 * Census of Governments
 * Management information base
 * Planetary Data System
 * Parameter Value Language
 * National Data Repository


 * Data Centers
 * Data center
 * Virtual data room
 * Virtual facility
 * Network-neutral data center


 * Related Technologies
 * Virtual directory
 * Virtuoso Universal Server
 * Workflow engine


 * Metadata Models
 * Metadata
 * Meta-data management
 * Metadatabase
 * Metadirectory
 * Metadata controller
 * Data element
 * Metadata publishing
 * Metadata registry
 * Metadata facility for Java
 * Object Management Group
 * Semantics of Business Vocabulary and Business Rules
 * Business Motivation Model
 * Business Process Definition Metamodel
 * Knowledge Discovery Metamodel
 * Resources, events, agents
 * Learning object metadata
 * Learning object
 * OGML