• Main Menu
  • Databases

    • 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

    • Data Warehouse

      Data Warehouse

      A data warehouse is a place where data is stored for archival, analysis, and security purposes. Usually a data warehouse is either a single computer or many computers (servers) tied together to create one giant computer system. Data consists of raw data or formatted data. It can be on various types of topics including the

    • Free Database Software

      Free Database Software

      MySQL The MySQL database server is the world’s most popular open source database server. Over six million installations use the MySQL database server to power high volume websites and other mission critical business systems including industry leaders like NASA, Yahoo, The Associated Press (AP), Suzuki, and Sabre Holdings. MySQL is an attractive alternative to high

    • 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 Management

      Data Management

      Data Management is a broad field of study, but essentially is the process of managing data as a resource that is valuable to an organization or business. One of the largest organizations that deal with data management, DAMA (Data Management Association), states that data management is the process of developing data architectures, practices, and procedures

    • Flat File

      Flat File

      A computer, in its most simplified definition, is nothing more than a device that stores, processes, communicates, and manipulates data. Data is at the heart of every computer program, every web site, and even every video game. The computer has revolutionized modern life by enabling a level of speed and accuracy to handling information that

    • 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

    • 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

    • SQL (Structured Query Language)

      SQL (Structured Query Language)

      SQL (Structured Query Language) is the most common standardized database language used to create, retrieve, access, modify, controland manage relational databases. SQL is a querying language exclusively designed for controlling data and managing databases effectively. SQL was originally developed by IBM (International Business Machines Corporation) in the 1970's for their DB2 RDBMS. The team of

    • Data Mart

      Data Mart

      Most people are familiar with terms like data warehousing, data mining, and data cleansing, but fewer people are familiar with data mart. A data mart is a subsection of a data warehouse that deals with specific information. Much like the chapters of a book, a data mart contains related information that deals with the same

    databases
    } 170 queries in 0.494 seconds.