Postgres Plus Advanced Server 9.2新機能ご紹介

Postgres Plus Advanced Server 9.2新機能ご紹介

• 1.
  Postgres Plus AdvancedServer 9.2 ! ! EnterpriseDB Corporation! Feb. 2013! EnterpriseDB, Postgres Plus and Dynatune are trademarks of EnterpriseDB Corporation. Other names may be trademarks of their 1 respective owners. © 2010. All rights reserved.
• 2.
  Version 9.2 ! u  9.2 : u  Oracle u  u  / u  u  u  DBA © 2012 EnterpriseDB. All rights reserved. 2
• 3.
  EnterpriseDB ! Oracle •  •  • ANSI/ISO • PL/SQL •  •  • SMP •  •  ( ) •  (sub-query SELECTS) •  •  •  •  INSERT ”Append” / •  •  xDB HA ( ) •  •  • PgPool 3.2 •  xxxxxxx © 2012 EnterpriseDB. All rights reserved. 3
• 4.
  EnterpriseDB •  SQL USAGE •  JSON •  RANGE •  pg_dump . •  pg_upgrade © 2012 EnterpriseDB. All rights reserved. 4
• 5.
  PL/SQL u  u  u  SPL DECLARE SUBTYPE INTEGER IS NUMBER (38,0); SUBTYPE NAME IS VARCHAR (20) NOT NULL; var1 INTEGER; var3 NAME := 'hello'; -- NOT NULL constraint, must initialize BEGIN var1 := 38.38; -- can't have fractional part, it will be lost because of constraint DBMS_OUTPUT.PUT_LINE ('Var1 = '|| var1); END;
• 6.
  u  DROP TABLE mytable CASCADE CONSTRAINTS; u  “current_date” u  “Log” u  “STRING” (VARCHAR2 ) u  “NVARCHAR2” (VARCHAR2 ) u  Table() CREATE OR REPLACE TYPE string_a IS TABLE OF VARCHAR2(765); select * from table(string_a('abc','xyz')) ; column_value -------------- abc xyz (2 rows)
• 8.
  u  u  u 
• 9.
  xDB u  u 
• 10.
  u  u  u  vs.
• 11.
  PgPool 3.2 u  •  ! •  pgpool-II ! u  Watchdog •  pgpool •  watchdog •  ! •  IP ! •  !
• 12.
  u  u  VIEW u  VIEW VIEW
• 13.
  JSON u  JSON (JavaScript ) u  u  : •  array_to_json() Returns the array as JSON! •  row_to_json() Returns the row as JSON! u 
• 14.
  RANGE u  u  Range data u  integer, big int, numeric, timestamp and date u  “CREATE TYPE” u  9.2 2 u  u  date/time range, price ranges, scientific data ranges u  calculating containment, overlaps, intersections, emptiness, upper/lower bounds
• 15.
  u  pg_dump •  ! •  e.g. restore... ! •  table structure and check constraints first, ! •  ! •  ! u  pg_upgrade •  / ! •  ! •  !
• 16.
  ! u  Postgres Plus Advanced Server u  u  © 2012 EnterpriseDB. All rights reserved. 16
• 17.
  ! u  : •  http://www.enterprisedb.com/download-advanced-server! u  •  http://www.enterprisedb.com/documentation! © 2012 EnterpriseDB. All rights reserved. 17
• 18.
  What’s New in
 Postgres Plus Advanced Server 9.2?! Questions?! EnterpriseDB, Postgres Plus and Dynatune are trademarks of EnterpriseDB Corporation. Other names may be trademarks of their 18 respective owners. © 2010. All rights reserved.