Write a program to implement inverted file shown slider, PL-SQL Programming

Write a program to implement the inverted file shown in the slides (Simple Index file, LabelID file and Data file).  Use the Avail_List to point at the deleted Label IDs so that their spaces can be re-used for new records.  Insert the example data in the slides in the three files (see below).

Data file: 

Simple Index: 

LabelID file: 

Then, show the content of the files and the Avail_List after each of the operation:Add a new data record with a new composer name "Xxxx"and new label ID "XXX12345".Add a new data record with a new composer name "Bbbbb"and new label ID "BBB12345".Delete data record with key "DG139201".Delete data record with key "COL31809"Add a new data record with a new composer name "Hhhhh"and new label ID "HHH12345".

Draw a B-tree and show its content after every operation.  The nodes in the B-tree can store maximum of 4 keys and minimum 2 keys.  
Insert: A,G,F,B,K,D,H,M,Insert: J,Delete: A, D,Insert: E,S,I,R,X,Delete: M,Insert: A,C,D, Delete: S,Insert: L,N,T,U,Delete: R 

Posted Date: 3/22/2013 6:30:15 AM | Location : United States







Related Discussions:- Write a program to implement inverted file shown slider, Assignment Help, Ask Question on Write a program to implement inverted file shown slider, Get Answer, Expert's Help, Write a program to implement inverted file shown slider Discussions

Write discussion on Write a program to implement inverted file shown slider
Your posts are moderated
Related Questions
Data Types in SQL - Character CHARACTER or, synonymously, CHAR, for character strings. When this type is to be the declared type of something (e.g., a column), the permissible

i NEED TO CREATE 3 guiS IN pl/sql sERVER PAGE FORM

Example of Check Constraints Example: Workaround for when subqueries not permitted in CHECK constraints CREATE FUNCTION NO_MORE_THAN_20000_ENROLMENTS ( ) RETURNS BOOLEAN

Project Description: I want to write some SQL statements. The things I need are between pages 5-7. The only problem is that i want it till tomorrow. Skills required is SQL

Magento change address format depending on store Project Description: What I need is that depending on the store in which the customer bought the address should change the fo

Indeterminacy in SQL Some SQL expressions are actually not function invocations at all in the mathematical sense, being indeterminate-invocations operating on identical input

SQL Is a Database Language: The commands given to a DBMS by an application are written in the database language of the DBMS. The term data sublanguage is sometimes used instea

Some Varray Examples In SQL Plus, assume that you define an object type Project, as described below: SQL> CREATE TYPE Project AS OBJECT ( 2 project_no NUMBER(2), 3 title VARCHA

Cursor Variables:   To execute the multi-row query, the Oracle opens an unnamed work region that stores the processing information. You can use an explicit cursor that names