Oracle Ë÷Òý×éÖ¯±í£¨IOT£©
Ë÷Òý×éÖ¯±í£¨IOT£©ÓÐÒ»ÖÖÀàBÊ÷µÄ´æ´¢×éÖ¯·½·¨¡£ÆÕͨµÄ¶Ñ×éÖ¯±íÊÇÒÔÒ»ÖÖÎÞÐòµÄ¼¯ºÏ´æ´¢¡£¶øIOTÖеÄÊý¾ÝÊÇ°´Ö÷¼üÓÐÐòµÄ´æ´¢ÔÚBÊ÷Ë÷Òý½á¹¹ÖС£ÓëÒ»°ãBÊ÷Ë÷Òý²»Í¬µÄµÄÊÇ£¬ÔÚIOTÖÐÿ¸öÒ¶½áµã¼´ÓÐÿÐеÄÖ÷¼üÁÐÖµ£¬ÓÖÓÐÄÇЩ·ÇÖ÷¼üÁÐÖµ¡£
ÔÚIOTËù¶ÔÓ¦µÄBÊ÷½á¹¹ÖУ¬Ã¿¸öË÷ÒýÏî°üÀ¨<Ö÷¼üÁÐÖµ£¬·ÇÖ÷¼üÁÐÖµ>¶ø²»ÊÇROWID£¬¶ÔÓÚÆÕͨ¶Ñ×éÖ¯±í£¬oracle»áÓжÔÓ¦µÄË÷ÒýÓëÖ®¶ÔÓ¦£¬ÇÒ·Ö¿ª´æ´¢¡£»»¾ä»°Ëµ£¬IOT¼´ÊÇË÷Òý£¬ÓÖÊÇʵ¼ÊµÄÊý¾Ý¡£
Ë÷Òý×éÖ¯±í(IOT)²»½ö¿ÉÒÔ´æ´¢Êý¾Ý£¬»¹¿ÉÒԴ洢Ϊ±í½¨Á¢µÄË÷Òý¡£Ë÷Òý×éÖ¯±íµÄÊý¾ÝÊǸù¾ÝÖ÷¼üÅÅÐòºóµÄ˳Ðò½øÐÐÅÅÁеģ¬ÕâÑù¾ÍÌá¸ßÁË·ÃÎʵÄËٶȡ£µ«ÊÇÕâÊÇÓÉÎþÉü²åÈëºÍ¸üÐÂÐÔÄÜΪ´ú¼ÛµÄ(ÿ´ÎдÈëºÍ¸üкó¶¼ÒªÖØнøÐÐÖØÐÂÅÅÐò)¡£
Ë÷Òý×éÖ¯±íµÄ´´½¨¸ñʽÈçÏ£º
create table indexTable(
ID varchar2 ( 10 ),
NAME varchar2 ( 20 ),
constraint pk_id primary key ( ID )
)
organization index ;ʽ
×¢ÒâÁ½µã£º
¡ñ ´´½¨IOTʱ£¬±ØÐëÒªÉ趨Ö÷¼ü£¬·ñÔò±¨´í¡£
¡ñ Ë÷Òý×éÖ¯±íʵ¼ÊÉϽ«ËùÓÐÊý¾Ý¶¼·ÅÈëÁËË÷ÒýÖС£
Ë÷Òý×éÖ¯±íÊôÐÔ
1¡¢OVERFLOW×Ó¾ä(ÐÐÒç³ö)
ÒòΪËùÓÐÊý¾Ý¶¼·ÅÈëË÷Òý£¬ËùÒÔµ±±íµÄÊý¾ÝÁ¿ºÜ´óʱ£¬»á½µµÍË÷Òý×éÖ¯±íµÄ²éѯÐÔÄÜ¡£´ËʱÉèÖÃÒç³ö¶Î½«Ö÷¼üºÍÒç³öÊý¾Ý·Ö¿ªÀ´´æ´¢ÒÔÌá¸ßЧÂÊ¡£Òç³ö¶ÎµÄÉèÖÃÓÐÁ½ÖÖ¸ñʽ£º
PCTTHRESHOLD n £ºÖƶ¨Ò»¸öÊý¾Ý¿éµÄ°Ù·Ö±È£¬µ±ÐÐÊý¾ÝÕ¼ÓôóС³¬³öʱ£¬¸ÃÐеÄÆäËûÁÐÊý¾Ý·ÅÈëÒç³ö¶Î
INCLUDING column_name £ºÖ¸¶¨ÁÐ֮ǰµÄÁж¼·ÅÈëË÷Òý¿é£¬Ö®ºóµÄÁж¼·Åµ½Òç³ö¶Î
¡ñ µ±ÐÐÖÐij×ֶεÄÊý¾ÝÁ¿ÎÞ·¨È·¶¨Ê±Ê¹ÓÃPCTTHRESHOLD¡£
¡ñ ÈôËùÓÐÐоù³¬³öPCTTHRESHOLD¹æ¶¨´óС£¬Ôò¿¼ÂÇʹÓÃINCLUDING¡£
create table t88(
Ïà¹ØÎĵµ£º
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
²éѯ¼°É¾³ýÖظ´¼Ç¼µÄSQLÓï¾ä
1¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊÇ ......
Ò»£ºSQL Loader µÄÌصã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄǨÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌص㡣
±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһЩȱµ ......
/*²»´øÈκβÎÊý´æ´¢¹ý³Ì(Êä³öϵͳÈÕÆÚ)*/
create or replace procedure output_date is
begin
dbms_output.put_line(sysdate);
end output_date;
/*´ø²ÎÊýinºÍoutµÄ´æ´¢¹ý³Ì*/
create or replace procedure get_username(v_id in number,v_username out varchar2)
as
begin
select username into v_usern ......