MacImage of Maine Electronic Registry System Oracle Port

Size Estimates of Tables

This table lists the major tables for the Electronic Registry System that will be ported to Oracle, width of all fields, and number of records in table (total and 1997 data). Megs are megabytes estimated as width X no. of records
			Hancock County Data
Table	Old Table Name	Width	Records	Megs	1997 records	Megs
InstrumentInfo		120	27,542	3.31	21,004	2.52
Names	GrantorFile+GranteeFile	88	83,580	7.36	63,710	5.61
PageIndex		21	76,897	1.61	20,615	0.43
HInstrumentInfo	HDocData	110	341,404	37.55
Hnames		88	176,729	15.55
HPageIndex		21	350,000	7.35
Receipts		234	18,309	4.28	13,687	3.20
Sales		37	7,155	0.26
Checks		21	15,451	0.32
TransactionTypes		69	13	0.00

Total				77.61		11.76

Entity-Relationship Diagram

The following shows the fields and the entity-relationship diagram for the major tables listed above. History tables -- those holding data beyond the current last few years -- are prefixed with an 'H'.

Last Updated on 7/28/98
By Craig Doremus