Database Software

You might want to cancel a repair process on your MySQL server if, for example, the process has stalled and become unresponsive. MySQL incorporates a repair tool that allows developers to run…

The Oracle database is an object-relational database management system consisting of an application and data storage. A trigger is a named program stored in an Oracle database and executed for a…

Data mining is a process that analyzes data from different viewpoints and produces information sets organized in a concise manner. Applications then use this information for a variety of purposes. For…

IBM’s DB2 is a relational database manager, the first commercial offering to use the industry-standard Structured Query Language, or SQL. As with other modern database systems, such as Oracle or…

SQLite software takes an unusual approach to database management, compared to offerings such as IBM’s DB2 and Microsoft’s SQL Server. SQLite does not have a separate database server…

The MySQL database allows you to store images in a table field data type called a "BLOB." A BLOB stores binary information, so the image and its data are stored for future use, and you do…

Extraction is the first step in moving data from an operational Oracle database to a destination such as a Data warehouse. While it may seem a simple task, copying data from a source system can be…

Triggers are SQL processes that are "fired" when a particular data condition holds for a table. The database application programmer teams with the database administrator to write triggers…

A control file is a backup of your database, so you can use it to create a new database from the Oracle backup. You use the Oracle command line utility to restore the database. You can give the…

In simple terms, a role is a collection of permissions or privileges and other roles. This is in contrast with privileges that give database users distinct rights to access another user’s…

The Oracle database engine has a "link" feature that links an external database to your local Oracle database. You can use a linked database to copy database tables from one server to…

The Oracle Corporation provides a software development environment it calls Application Development Framework, or ADF. The Java-based ADF gives software developers tools to create sophisticated…

When you use software in which you enter information into text fields, that information goes into a database. Users don’t see the database because they’re dealing with a graphical user…

Metadata is information about data. The entries in a library catalog, such as the topic, the title, and where the book is filed on the shelves, are metadata about the library's books. A metadata layer…

The capacity of an Oracle Database can refer to several things: the hard disk space assigned to the datafiles – the files containing the actual data stored in the database – or the overall…

Oracle Database 10g database software allows server administrators to create databases for PHP, SQL and other online applications that need to store dynamic user data. As with many software titles,…

The Oracle RMAN utility lets you control the database for your server using a command-line utility. Some administrators prefer a command-line utility instead of using a graphical interface, because…

SQL Server Reporting Services (SSRS) allows you to create automated scripts for the data in your database. SQL includes a "round" function you use to round the numbers when you insert the…

Some columns in MySQL, such as date and time stamp columns, cannot contain the null value. If you attempt to update the column to a null value, you receive the error message that the update column…

The Oracle system global area controls the shared memory resources for large Oracle database farms. You change the SGA settings using the "alter system" command available in Oracle…

The MySQL "insert" statement adds a new record to your database. After you use this statement, you can either ignore the new ID added to the database or retrieve it in a new variable. You…

The Oracle command line utility includes an import feature you use to import data from a file such as Microsoft Word to the Oracle database. The command line feature is convenient, because you can…

Structured query language, or SQL, works with named parameters, so you can pass data back and forth between your desktop and Web applications. These parameters also protect from SQL injection, which…

The "V$DATABASE" log keeps a record of all metadata for an Oracle database. You use this log to view the creation or "start time" for an Oracle database. This view helps you…

The file extension PDB generally stands for Program Database. Many different programs use their own version of a PDB file for this purpose. Other types of files that use the PDB extension include…

The Microsoft SQL Server interface includes a section that lets you customize and install new SQL hotkeys. You use these hotkeys to make programming in the Microsoft SQL language more convenient, as…

Databases often serve the needs of clients who need to store large amounts of data. Inside these databases, however, certain parameters and settings limit the amount of files a database can hold at…

Oracle produces an enterprise-quality series of database solutions for small to very large operations. Your database is valuable and must be protected in the event of hardware or software failures.…

Most relational database systems use the Structured Query Language, or SQL, to create database structures, update data and perform reporting and maintenance tasks. Database managers use stored…

Most modern relational database servers use the Structured Query Language, or SQL, to add, update and report on information in databases. SQL’s SELECT statement, used to display data, has an…

Most Web and desktop computing applications involving databases use SQL statements to manage their data. With SQL statements, applications and websites can query databases for specific sets of data.…

MediaWiki is the software backbone that is used to power many popular wiki databases, such as Wikipedia. The MediaWiki freeware is powered by PHP scripts and can be expanded upon by nearly 2,000…

The Oracle relational database uses Structured Query Language, or SQL, to build and maintain database structures, modify data and generate reports from the data. As with other databases that use SQL,…

You must use a specific command at the terminal prompt to recover or import a full Oracle database export. This command not only imports the data into memory, but also writes it to disk or a backup…

In the 21st century, Oracle has databases that hold anywhere from one terabyte -- equal to a billion kilobytes -- to 10 or even 100 Tb. Databases have grown because business needs have grown. Mergers…

PuTTY provides a way to access remote computers over Secure Shell, or SSH, connections. When you do this, you are given a command terminal to that computer, and complete access to its commands as if…

WordPress is a dynamic content management system, meaning that the main content -- including the posts, pages and category structure -- is kept in a MySQL database, separate from the main theme files.…

SQL Toolbelt is Redgate’s software tool set developed for users of Microsoft's Structured Query Language Server database. The utility programs in SQL Toolbelt simplify the maintenance,…

A database array is a list of records stored in a table that you must insert into another table. You use a combination of the "select" and "insert" statements to insert the array…

The Oracle PL/SQL language lets you compress tables with your queries, so you can compress the data when the user queries data from the server over a WAN connection. A WAN connection is slower than a…

The archive mode, also known as ARCHIVELOG mode, instructs an Oracle database to automatically save a copy of its redo logs. Those logs contain a list of all the changes that are made to a database.…

An Adobe VB6 connection links to a specified database and server, which then allows you to list all of the tables in the database. You use this type of query to view the tables in an administration or…

The sleep function in Oracle is in reality a procedure you can include in a function rather than a function itself. Confusion often occurs because of striking similarities between the two, with the…

Simple databases may not need normalization; complex ones probably do. If you've heard the word "normalization" but never looked it up, you may discover that your database could use…

Web-tiering is an approach to browsing online that improves efficiency by breaking up the work involved. A single-tier system runs Web applications on a mainframe. Adding more tiers reduces the…

SQL Server Reporting Services let you create reports and output data for users who have access to your reports server. SQL Server provides a graphical-friendly interface with templates that developers…

LogixPro is an educational tool used for teaching PLC simulator programming. It offers visual aids to help students see their programs in action as they build them, letting them make changes and…

The MySQL database system provides developers with a range of numerical data types to choose from, including various integer types. The range of values you can store within a database using integers…

Lally columns are frequently called adjustable steel columns. These columns are often used as an intermittent, load-bearing structural replacement. For example, when remodeling a home, a lally column…

MySQL has a list of reserved words used to create functions and stored procedures in your database. You use the tick mark key to use these reserved words as a database column name. These tick marks…