• Main Menu
  • Databases

    • Database Replication

      Database Replication

      Database replication is the creation and maintenance of multiple copies of the same database. In most implementations of database replication, one database server maintains the master copy of the database and additional database servers maintain slave copies of the database. Database writes are sent to the master database server and are then replicated by the

    • ODBC (Open Database Connectivity)

      ODBC (Open Database Connectivity)

      ODBC (Open Data Base Connectivity) is an interface to access databases via SQL queries. ODBC can be used as an access tool to various databases such as MS-Access, dBase, DB2, Excel, and Text. Through these Call Level Interface (CLI) specifications of the SQL Access Group, the OBDC allows a neutral way of accessing the data

    • Database Normalization

      Database Normalization

      Database normalization is the process of organizing data into distinct and unique sets. The purposes of normalization are to: Reduce or eliminate storage of duplicate data Organize data into an efficient and logical structure The process of normalization involves determining what data should be stored in each database table. By tradition, the process of normalization

    • DBMS (Database Management System)

      DBMS (Database Management System)

      Databases are collections of organized information. The data is normally organized to help model the aspects of the information in a manner that support processing requests for information in a useful manner. A DBMS (database management system) is an application that is designed specifically to interact with the end-user, the database of information, and other

    • Transactional Database

      Transactional Database

      A transactional database is a database management system (DBMS) that has the capability to roll back or undo a database transaction or operation if it is not completed appropriately. Although this was a unique capability several decades ago, today the majority of relational database systems support transactional database operations. What is a Database Transaction? Whenever

    • OLAP Cube

      OLAP Cube

      When a company or organization wants to combine all of their information and resources into one stockpile for easier analysis and research, they use the OLAP cube to comprehensively link and find the information that they need. OLAP cubes allow you to add fact sheets of information to a specific product or project and then

    • DSN (Data Source Name)

      DSN (Data Source Name)

      A DSN (Data Source Name) is an identifier that is used to store information relating to a database connection. DSNs can store a database’s name and server location, the directory that is used to store offline content, the database driver, and the user’s ID and password. DSNs can be used for a wide variety of

    • Data Dictionary

      Data Dictionary

      A data dictionary is an integral part of a database. It holds information about the database and the data that it stores, i.e., the meta-data. Any well designed database will surely include a data dictionary as it gives database administrators and other users easy access to the type of data that they should expect to

    • Data Mining

      Data Mining

      Data mining is usually defined as searching, analyzing and sifting through large amounts of data to find relationships, patterns, or any significant statistical correlations. With the advent of computers, large databases and the internet, it is easier than ever to collect millions, billions and even trillions of pieces of data that can then be systematically

    • What is a Database?

      What is a Database?

      One of the technology terms that most people have become accustomed to hearing either at work or while surfing the Internet is the database. The database used to be an extremely technical term, however with the rise of computer systems and information technology throughout our culture, the database has become a household term. A database

    databases
    151 queries in 0.385 seconds.