types of databases based on data structure
Post on 26-Jun-2015
117 Views
Preview:
TRANSCRIPT
TYPES OF DATABASES
BASED ON DATA STRUCTURE
OSAID TOMEH
STRUCTURED DATAWHAT IS STRUCTURED DATA?
STRUCTURED DATA IS DATA THAT IS APPLIED TO A UNIVERSAL FORMAT MAKING IT EASILY RECOGNIZED, UNDERSTOOD AND DISPLAYED BY SEARCH ENGINES.
• Representation: discrete (rows and column).
• Storage/persistence: DBMS or File format (ex: VSAM ' Virtual Storage Access method ‘).
• Metadata focus: syntax (ex. location and format).
• Standards: SQL, ADO.NET, ODBC (Open Database Connectivity), RDMS support XML as another option.
UNSTRUCTURED DATA
• THE FOUNDATION OF TEXTUAL ANALYTICS IS THE ABILITY TO ACCESS AND ANALYZE UNSTRUCTURED DATA IN AN UNFETTERED MANNER
• TO ACHIEVE THIS STATE, AN INFRASTRUCTURE SUITABLE FOR ANALYTICAL PROCESSING MUST BE CREATED.
The heart of that environment is the unstructured database.
UNSTRUCTURED DATA(CONT.)• REPRESENTATION:
* BINARY LARGE OBJECTS: LESS-DEFINED BOUNDARIES, LESS EASY ADDRESSABLE.
* SMALL DISCRETE OBJECTS: INFORMATION REPRESENTED FOR A VERY SPECIFIC PURPOSE.
• STORAGE / PERSISTENCE: UNMANAGED.
• METADATA FOCUS: SEMANTICS (DESCRIPTIVE AND OTHER MARKUP).
• STANDARDS: OPEN XML, SMTP (SIMPLE MAIL TRANSFER PROTOCOL), SMS, CSV, INFORMATION AND CONTENT EXCHANGE.
EXAMPLES OF STRUCTURED DATA
- DATABASES - DATA WAREHOUSES
- XML DATA - ENTERPRISE SYSTEMS (CRM, ERP, ETC.)
EXAMPLES OF UNSTRUCTURED DATA
- EXCEL SPREADSHEETS - WORD DOCUMENTS
- EMAIL MESSAGES - VIDEO FILES
- RSS FEEDS - AUDIO FILES
SEMI-STRUCTURED DATA• IS A FORM OF STRUCTURED DATA THAT DOES NOT CONFORM WITH THE
FORMAL STRUCTURE OF DATA MODELS ASSOCIATED WITH RELATIONAL DATABASES OR OTHER FORMS OF DATA TABLES.
• ENTITIES BELONGING TO THE SAME CLASS MAY HAVE DIFFERENT ATTRIBUTES EVEN THOUGH THEY ARE GROUPED TOGETHER “THE ATTRIBUTE ORDER " IS NOT IMPORTANT.
SEMI-STRUCTURED DATA(CONT.)
• SEMI-STRUCTURED DATA IS INCREASINGLY OCCURRING SINCE THE ADVENT OF THE INTERNET WHERE FULL-TEXT DOCUMENTS
• IN OBJECT-ORIENTED DATABASES, ONE OFTEN FINDS SEMI-STRUCTURED DATA.
TYPES OF SEMI-STRUCTURED DATA
• XM
• OME (OBJECT EXCHANGE MODEL)
• EDI (ELECTRONIC DATA INTERCHANGE)
top related