User:Ruftas/Books/Databases

This user book is a user-generated collection of Wikipedia articles that can be easily saved, rendered electronically, and ordered as a printed book. If you are the creator of this book and need help, see Help:Books (general tips) and WikiProject Wikipedia-Books (questions and assistance).

Edit this book: Book Creator · Wikitext

Order a printed copy from: PediaPress

[ About ] [ Advanced ] [ FAQ ] [ Feedback ] [ Help ] [ WikiProject ] [ Recent Changes ]

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