wiktionarypar DatabaseDatabase may refer to Database , central article discussing the organised collection of data Springfield Elementary School Students DatabaseDatabase , a character on The Simpsons Bibliographic database , in libraries, a collection of bibliographic information on a particular topic Glass database , a collection of glass compositions and related properties disambig ... more details
Merge from Database administrator date January 2010 A database is a system intended to organize, store ... database management system s, which store database contents, allowing data creation and maintenance, and search and other access. Architecture Database architecture consists of three levels external ... model relational database model that dominates 21st century databases. ref name date31 harvnb Date .... A single database can have any number of views at the external level. The internal level defines how ... of indirection between internal and external. It provides a common view of the database that is uncomplicated ... into a coherent whole. ref name date31 Database management systems Main Database management system A database management system DBMS consists of software that operates databases, providing storage, access, security, backup and other facilities. Database management systems can be categorized according to the database model that they support, such as relational model relational or XML database ... s that access the database, such as SQL or XQuery , performance trade offs, such as maximum scale ... Access, SQL Server, FileMaker,Oracle,Sybase, dBASE, Clipper,FoxPro etc. Almost every database software comes with an Open Database Connectivity ODBC driver that allows the database to integrate with other ... web url http en.wikibooks.org wiki Design of Main Memory Database System Overview of DBMS title Design of Main Memory Database System Overview of DBMS publisher En.wikibooks.org date accessdate 2010 ... DBMS RDBMS include Data Definition Language DDL for defining the structure of the database, Data Control ... , Firebird database server FireBird Python programming language Python . SQL engine This component ... of objects instead of relational rows. Types unreferenced section date January 2011 Analytical database Analysts may do their work directly against a data warehouse or create a separate analytic database ... are the norm. Distributed database These are databases of local work groups and departments ... more details
For other uses GeoBase disambiguation GeoBase GEOBASE is a database, multidisciplinary in scope, which indexes bibliographic information and abstracts for the Geography Geographical , Earth sciences Earth , and Ecology Ecological sciences . The broad subject coverage includes earth sciences, ecology, geomechanics , human geography , physical geography, social geography and oceanography . Development studies are also included in this database. ref name elsevier ref name dialog Coverage Coverage includes 2000 peer review peer reviewed journal , and trade journal titles. Other journal titles and books are included in the archival coverage of this database. With more than 2 million records, it has temporal coverage from 1980 to the present. Each year, at least 100,000 additional citations and abstracts are added, and it is updated every two weeks. Access is covered through both online internet , and CD ROM. ref name elsevier ref name dialog Other types of publications indexed in this database are magazine articles, product reviews, directories and all related materials. Interanational literature coverage pertains to Non English language papers, and lesser avaialble books, conference proceedings and reports. ref name elsevier Cite web title Database description work Bibliographic database for the Earth, Geographical and Ecological sciences publisher Elsevier date September 2010 url http ... 2010 09 30 ref ref name dialog Cite web title Geobase work Database description publisher Dialog ... 2010 09 30 ref ref name oclc geobase Cite web title Geobase work More in depth database description ... geobase Print counterparts The GEOBASE database is covered in print, in the following abstracts journals ... 0953 9611, LCCN 89646812 This database is published monthly, and contains abstracts from 2000 journals ... lccnGAHG This database was formed by the union of the following abstracts journals Geographical abstracts ... Geography ISSN 0954 0504 This database is published monthly, and contains abstracts from 2000 ... more details
Protein database may refer to Any protein structure database Any protein sequence database Exact names Protein NIH Protein database of the National Institute of Health Protein Database of Bio Synthesis, Inc. disambig ... more details
Database state may refer to Database state, in database technology the set of stored data. Entering, modifying, or deleting information changes the database state. A state that practices Mass surveillance . disambig ... more details
The Diseases Database is a free website that provides information about the relationships between medical conditions, symptoms , and medications . The database is run by Medical Object Oriented Software Enterprises Ltd, a small company based in London , UK . It directly integrates the Unified Medical Language System . External links http www.diseasesdatabase.com Diseases Database Category Bioinformatics Category Medical literature website stub med org stub ar az Diseases Database bs Diseases Database ca Diseases Database cy Cronfa ddata o Afiechydon et Diseases Database es Diseases Database fa fr Diseases Database gl Diseases Database ko id Diseases Database jv Diseases Database no Diseases Database pl Diseases Database pt Diseases Database ru Diseases Database sr Diseases Database sv Diseases Database ta tr Hastal k Veri Taban uk Diseases Database ur vi Diseases Database zh ... more details
Orphan date February 2009 A database machine or back end processor is a computer or special hardware that stores and retrieves data from a database. It is specially designed for database access and is coupled to the main front end computer s by a high speed channel. This contrasts with a database server, which is a computer in a local area network that holds a database. The database machine is tightly coupled to the main CPU, whereas the database server is loosely coupled via the network. An example is the IBM System 38 . FOLDOC compu hardware stub Category History of computing ... more details
NMR database NMR nuclear magnetic resonance may refer to NMR spectra database , a collection of NMR spectra for a large number of compounds NMR database method , a strategy to identify the stereochemistry of certain chiral compounds dab ... more details
The Openedge Database is a relational database with some growing Object capabilities . It was formerly known as the Progress RDBMS. see also Progress Software Corporation OpenEdge Advanced Business Language database software stub Category Proprietary database management systems ... more details
Mergeto Database date January 2010 Notability date September 2009 A database administrator DBA is a person responsible for the design, implementation, maintenance and repair of an organization s database . They are also known by the titles Database Coordinator or Database Programmer , and is closely related to the Database Analyst , Database Modeler , Programmer Analyst , and Systems Manager . The role includes the development and design of database strategies, monitoring and improving database performance ... and implement security measures to safeguard the database. ref cite web url http www.acs.org.au ictcareers index.cfm?action show&conID 200707200948211895 title Database Administrator publisher ICT Careers Portal Australian Computer Society ref Employing organizations may require that a database administrator have a certification or degree for database systems for example, the Microsoft Certified Professional Microsoft Certified Database Administrator .28MCDBA.29 Microsoft Certified Database Administrator . Some organizations have a hierarchical level of database administrators, generally ... f27a4a19 254b 4fb6 a469 768d14d1fc81 40sessionmgr10&vid 4 title Database Administrator? DBA publisher ... skills br Willing to pursue education throughout your career br Database administrator s activities can be listed as below ref cite web url http www.developer.com db article.php 718491 What Is a Database Administrator.htm title What is a Database Administrator? DBA publisher Developer.com ref ref cite web url http www.developer.com db article.php 718491 What Is a Database Administrator.htm title What is a Database Administrator? DBA publisher Developer.com ref ref cite web url http www.businessdictionary.com definition Database Administrator DBA.html title Database Administrator DBA publisher BusinessDictionary.com ref Transferring Data Replicating Data Maintaining database and ensuring its availability to users Controlling privileges and permissions to database users Monitoring database ... more details
A lexical database is a lexical resource which has an associated software environment database which permits access to its contents. The database may be custom designed for the lexical information or a general purpose database into which lexical information has been entered. Information typically stored in a lexical databasedatabase includes lexical category and synonyms of words, as well as semantic relations between different words or sets of words. See also Machine readable dictionary WordNet External links http wordnet.princeton.edu The WordNet Home Page http lexicaldatabase.com Lexical Database Category Linguistics Category Translation databases database stub ar ... more details
Notability date October 2008 Unreferenced date October 2008 The LOLI List of LIsts Database is an international chemical regulatory database developed and maintained by ChemADVISOR, Inc. The LOLI database is one of the primary sources of information for the creation of material safety data sheet s and other hazard communication documents. The database was first created in 1986. Since then, the database has grown to include over 3000 separate lists from 93 countries. See also Chemical database External links http www.chemadvisor.com Products Lolidb.aspx ChemADVISOR, Inc. LOLI Database Category Occupational safety and health Category Chemical databases ... more details
A database refactoring is a simple change to a database schema that improves its design while retaining both its behavioral and informational semantics. A database refactoring is conceptually more difficult than a code refactoring code refactorings only need to maintain behavioral semantics while database refactorings also must maintain informational semantics. ref Scott Ambler and Pramod Sadalage 2006 . Refactoring databases Evolutionary database design . Addison Wesley. ISBN 978 0321293534 ref The process of database refactoring is the act of applying database refactorings to evolve an existing database schema database refactoring is a core practice of evolutionary database design . You refactor a database schema for one of two reasons to develop the schema in an evolutionary manner in parallel with the evolutionary design of the rest of your system or to fix design problems with an existing legacy database schema Database refactoring does not change the way data is interpreted or used and does not fix computer bug bug s or add new functionality. Every single refactoring to a database leaves the system in a working state, thus not causing maintenance lags, provided the meaningful data exists in the production environment. An example of database refactoring would be splitting an aggregate table into two different tables in the process of database normalization See also Test driven development Unit testing Refactoring Tools LiquiBase References reflist Refimprove date May 2009 External links http www.infoq.com presentations ambler database refactoring Database refactoring presentation at InfoQ.com by Scott W. Ambler http www.agiledata.org essays databaseRefactoring.html The Process of Database Refactoring by Scott W. Ambler http www.agiledata.org essays databaseRefactoringCatalog.html Catalog of Database Refactorings . by Scott W. Ambler. http www.databaserefactoring.com Database Refactoring Website by Pramod Sadalage Category Extreme Programming ... more details
A database server is a computer program that provides database services to other computer programs or computer s, as defined by the client server software modeling model . The term may also refer to a computer dedicated to running such a program. Database management system s frequently provide database server functionality, and some database management system DBMSs e.g., MySQL rely exclusively on the client server model for database access. Such a server is accessed either through a front end running on the user s computer which displays requested data or the back end which runs on the server and handles tasks such as data analysis and storage. In a Master slave technology master slave model, database master servers are central and primary locations of data while database slave servers are synchronized backups of the master acting as proxies. Some examples of Database servers are Oracle Corporation Oracle , DB2 , Informix , Ingres , SQL Server . Every server uses its own query logic and structure. The SQL query language is more or less the same in all the database servers. See also Replication computer science Database replication Database replication Category Data management Category Servers software type stub database stub de Datenbankserver id Server basis data nl Databaseserver ... more details
A Centralized database is a database located and maintained in one location, unlike a distributed database . ref http kalgaming.net forums ref One main advantage is that all data is located in one place. The disadvantage is that bottlenecks may occur. References reflist DEFAULTSORT Centralised Database Category Data management Category Databases database stub web stub ... more details
morereferences date October 2008 A database system is a term that is typically used to encapsulate the constructs of a data model , database Management system DBMS and database . ref Beynon Davies P. 2004 . Database Systems 3rd Edition. Palgrave, Basingstoke, UK. ISBN 1 4039 1601 2 ref A database is an organised pool of logically related data. Data is stored within the data structures of the database. A DBMS is a suite of computer software providing the interface between users and a database or databases. A DBMS is a shell which surrounds a database or series of databases and through which all interactions take place with the database. The interactions catered for by most existing DBMS fall into four main groups Data Definition. Defining new data structures for a database, removing data structures from the database, modifying the structure of existing data. Data Maintenance. Inserting new data into existing data structures, updating data in existing data structures, deleting data from existing data structures. Data Retrieval. Querying existing data by end users and extracting data for use by application programs. Data Control. Creating and monitoring users of the database, restricting access to data in the database and monitoring the performance of databases. Both a database and its DBMS conform to the principles of a particular data model. ref Tsitchizris, D. C. and F. H. Lochovsky 1982 . Data Models. Englewood Cliffs, Prentice Hall. ref Data models include the Hierarchical model hierarchical data model , the Network model network data model , the Relational model relational data model and the Object database object oriented data model . See also Heterogeneous Database System References reflist Database models DEFAULTSORT Database System Category Database management systems ko ru ... more details
An online database is a database accessible from a network, including from the Internet . It differs from a local database, held in an individual computer or its attached storage, such as a CD. For the system or software designed to manage a database, see Database management system s DBMS For information on the structure of a database itself, see Database For information on the programs for searching a database, see Search engine s Currently, there are several database products designed specifically as hosted databases delivered as Software as a Service products. These differ from typical traditional databases such as Oracle, Microsoft SQL Server, Sybase, etc. Some of the differences are These online databases are delivered primarily via a web browser They are often purchased by a monthly subscription They embed common collaboration features such as sharing, email notifications, etc. For information on the contents of specific types of database, see Bibliographic database s See also List of online databases List of search engines List of academic databases and search engines References Unreferenced date October 2009 DEFAULTSORT Online Database Category Online databases Category Types of databases compu network stub ... more details
Database theory encapsulates a broad range of topics related to the study and research of the theoretical realm of database s and database management system s. Theoretical aspects of data management include, among other areas, the foundations of query languages, computational complexity and expressive power of queries, finite model theory , database design theory, dependency theory database theory dependency theory , foundations of concurrency control and database recovery , deductive database s, temporal database temporal and spatial database s, real time database s, managing uncertain data and probabilistic database s, and Web data. Most research work has traditionally been based on the relational model , since this model is usually considered the simplest and most foundational model of interest. Corresponding results for other data models, such as object oriented or semi structured model s, or, more recently, graph data models and XML , are often derivable from those for the relational model. A central focus of database theory is on understanding the complexity and power of query languages and their connection to logic . Starting from relational algebra and first order logic which are equivalent by Codd s theorem and the insight that important queries such as graph reachability are not expressible in this language, more powerful language based on logic programming and fixpoint logic such as datalog were studied. Another focus was on the foundations of query optimization and data integration . Here most work studied conjunctive query conjunctive queries , which admit query ... in the area are the ACM Symposium on Principles of Database Systems PODS and the International Conference on Database Theory ICDT . References Serge Abiteboul , Richard B. Hull , Victor Vianu ... query Expressive power DEFAULTSORT Database Theory Category Database management systems Category Database theory lv Datu b u teorija tr Veritaban kuram zh ... more details
unreferenced date August 2007 A database engine or storage engine is the underlying software component that a database management system DBMS uses to create, read, update and delete CRUD data from a database . Most database management systems include their own Application Programming Interface API that allows the user to interact with their underlying engine without going through the user interface of the DBMS. Many of the modern DBMS supports multiple database engines within the same database. For example, MySQL supports InnoDB as well as MyISAM . Some database engines are Database transaction transactional . class wikitable Name Free Transactional BlitzDB GPL No Falcon storage engine Falcon GPL Yes InnoDB GPL Yes Maria storage engine Maria GPL No MyISAM GPL No XtraDB GPL Yes See also Architecture of Btrieve Micro Kernel Database Engine Btrieve s Micro Kernel Database Engine FLAIM Database Engine InnoDB Microsoft Jet Database Engine MyISAM MySQL Cluster , on the NDB storage engine of MySQL Maria storage engine External links http dev.mysql.com tech resources articles storage engine part 3.html DEFAULTSORT Database Engine Category Data management Category Database management systems database stub az Baza veril nl rin proqramla d rma dill ri fr Moteur de base de donn es ja ru Database engine ... more details
Unreferenced date December 2009 Orphan date December 2009 A cooperative database is a type of database that holds information on customers and their transactions. Many companies will contribute information to a database in return for aggregate information on the customers other companies have provided. Such databases are used for promotional mailings, credit card fraud detection and fighting E mail spam . DEFAULTSORT Cooperative Database Category Anti spam ... more details
The database catalog of a database instance consists of metadata in which definitions of database Object file object s such as base tables, views virtual tables , synonym s, value ranges, index database indexes , User computing users , and user groups are stored. ref citebook title Systems Development Handbook author Paul C. Tinnirello year 1999 publisher CRC Press isbn 0849398223 ref ref cite title CREATE VIEW Transact SQL in SQL Server 2008 Books Online publisher Microsoft Corporation url http msdn.microsoft.com en us library ms187956.aspx ref The SQL standard specifies a uniform means to access the catalog, called the INFORMATION SCHEMA, but not all databases follow this, even if they implement other aspects of the SQL standard. For an example of database specific metadata access methods, see Oracle metadata . References refs Category Database theory database stub ko ... more details
An Active Database is a database that includes an event driven architecture often in the form of Event Condition Action ECA rules which can respond to conditions both inside and outside the database. Possible uses include security monitoring, alerting, statistics gathering and authorization. Most modern relational databases include active database features in the form of Database trigger SQL Triggers . See also Event driven architecture References cite journal last Paton first Norman W coauthors D az, Oscar title Active database systems journal ACM Computing Surveys year 1999 volume 31 issue 1 pages 63 103 doi 10.1145 311531.311623 url http portal.acm.org citation.cfm?id 311623 accessdate 8 July 2010 publisher ACM location NY, USA issn 0360 0300 cite web title Active Database url http it.toolbox.com wiki index.php Active Database publisher IT Toolbox accessdate 8 July 2010 Use dmy dates date October 2010 DEFAULTSORT Active Database Category Databases Database stub ... more details
A current database is a conventional database that stores data that is valid now . For example, if a user inserts John Smith into the Staff table of a current database, this asserts that the fact is valid now and until it is subsequently deleted. By contrast, a temporal database qualifies each row with a valid time stamp , valid time period or valid time interval . For example, we can assert the fact that John Smith was a member of staff during the period 1 June 2001 and now . Current databases are the most common type of database in use today. The concept of now is discussed in Clifford et alia 1997 . External links cite doi 10.1145 249978.249980 Category Databases ... more details
orphan date August 2008 A negative database , in Credit Card terms, refers to a list of Credit Card owners who chargeback a lot. Negative databases are usually maintained by Credit Card companies. The term negative database also refers to a security concept in database terms where contrary to traditional databases, such database saves attributes that cannot be associated with a certain entry. http sigfpe.blogspot.com 2006 10 negative databases.html http www.economist.com science displayStory.cfm?story id 7854216 Category Credit cards Category Data security econ stub database stub ... more details
Unreferenced date March 2007 For information on obtaining the Wikipedia database, see Wikipedia Database download . A database dump contains a record of the Table database table structure and or the data from a database and is usually in the form of a list of SQL statements. A database dump is most often used for backup backing up a database so that its contents can be restored in the event of data loss . Data corruption Corrupted databases can often be recovered by analysis of the dump. Database dumps are often published by free software and free content projects, to allow reuse or Fork software development forking of the database. Example source lang sql Database CREATE DATABASE example USE example Table structure for table users CREATE TABLE users id int 8 unsigned NOT NULL AUTO INCREMENT, username varchar 16 NOT NULL, password varchar 16 NOT NULL, PRIMARY KEY id Data for table users INSERT INTO users VALUES 1, alice , secret , 2, bob , secret source See also Core dump Databases Database management system References Empty section date July 2010 External links http dev.mysql.com doc refman 5.0 en mysqldump.html mysqldump A Database Backup Program http www.postgresql.org docs 8.2 interactive backup dump.html PostgreSQL dump backup methods , for PostgreSQL databases. databases Category Database administration tools database stub de Datenbankdump ... more details
Encyclopedia
top
