154
edits
Changes
Jump to navigation
Jump to search
==== INDEX CREATION ====
Patent numbers are distinct in this table, and are central to the rest of the fields in the table. A primary key can therefore be imposed on the column. Also, since a number of searches are likely to be conducted on this table, an index has been imposed as well.
Code:
ALTER TABLE patents ADD PRIMARY KEY (patentnumber);
-- RESULT : ALTER TABLE
allpatent=# CREATE UNIQUE INDEX patent_idx ON patents (patentnumber);
Since the table is relatively large, and is likely to be searched often, an index has been imposed on the table.
allpatent=# CREATE INDEX ON assignees (orgname);
CREATE INDEX
'''==== Index and Key Creation ====Patent numbers are distinct in this table, and are central to the rest of the fields in the table. A primary key can therefore be imposed on the column. Also, since a number of searches are likely to be conducted on this table, an index has been imposed as well. Code: ALTER TABLE patents ADD PRIMARY KEY (patentnumber); -- RESULT : ALTER TABLE allpatent=# CREATE UNIQUE INDEX patent_idx ON patents (patentnumber); ====Sample Insert and Copy Statements''' ====
********** INDEX CREATION **************
ALTER TABLE patents ADD PRIMARY KEY (patentnumber);
-- RESULT : ALTER TABLE
allpatent=# CREATE UNIQUE INDEX patent_idx ON patents (patentnumber);
allpatent=# CREATE INDEX ON assignees (orgname);
CREATE INDEX
Patent Data Processing - SQL Steps (view source)
Revision as of 17:43, 23 June 2016
, 17:43, 23 June 2016no edit summary
Therefore, if a row has appropriate values for orgname, state, city ,etc, but 'null' values for lastname, firstname, address and postcode, the row has come from the patentdata table.
==== Index ====
Since the table is relatively large, and is likely to be searched often, an index has been imposed on the table.
allpatent=# CREATE INDEX ON assignees (orgname);
CREATE INDEX
====Sample insert and copy commands ====
==Patents ==
Patentdata:
);
patentdata:
INSERT INTO patents_merged
(0 rows)
== Citations==
