B Supported SQL Statements

Neoview Script supports these SQL statements, SQL utilities, and other SQL-related commands. For more information about these statements, see the Neoview SQL Reference Manual. For a list of statements that are available only to HP support, see the Neoview Database Support Guide.

SQL Statement

Description

ALTER MVGROUP

Adds or removes a materialized view to or from a

 

materialized view group.

ALTER SYNONYM

Alters the synonym of a specified table.

ALTER TABLE

Adds a column to a table or renames a table.

ALTER TRIGGER

Enables or disables triggers, individually or by SQL table.

ALTER VIEW

Renames a view.

BEGIN WORK

Starts a transaction.

COMMIT WORK

Commits changes made during a transaction and ends the

 

transaction.

CREATE INDEX

Creates an index on a table.

CREATE MATERIALIZED VIEW

Creates a materialized view.

CREATE MVGROUP

Creates a logical collection of materialized views, such as

 

materialized views that are defined on a common table or

 

that share the same refresh frequency rate.

CREATE SCHEMA

Creates a schema.

CREATE SYNONYM

Creates a synonym for a table so that queries can refer to

 

the synonym instead of the actual table name.

CREATE TABLE

Creates a table.

CREATE TRIGGER

Creates a trigger on an SQL table. A trigger is a mechanism

 

that enables a database system to perform certain actions

 

automatically when specified events occur.

CREATE VIEW

Creates a view.

CREATE VOLATILE INDEX

Creates a volatile index.

CREATE VOLATILE TABLE

Creates a volatile table.

DELETE

Deletes a row or rows from a table or an updateable view.

DROP INDEX

Deletes an index.

DROP MATERIALIZED VIEW

Deletes a materialized view.

DROP MVGROUP

Deletes a materialized view group.

DROP SCHEMA

Deletes a schema.

DROP SYNONYM

Deletes a synonym.

DROP TABLE

Deletes a table and any indexes, constraints, and inactive

 

locks on the table.

DROP TRIGGER

Deletes a trigger on an SQL table.

DROP VIEW

Deletes a view.

DROP VOLATILE INDEX

Deletes a volatile index.

DROP VOLATILE TABLE

Deletes a volatile table.

EXECUTE

Executes an SQL statement previously compiled by a

 

PREPARE statement.

GRANT

Grants access privileges for a table or view to specified

 

users.

133

Page 132 Page 134
Page 133
Image 133
HP NEOVIEW 544530-001 manual Supported SQL Statements, Create Mvgroup
Page 132 Page 134

NEOVIEW 544530-001 specifications

The HP Neoview 544530-001 is a sophisticated data warehousing solution that was designed to address the complex demands of modern businesses. Known for its robust architecture, it enables organizations to efficiently manage, store, and process vast amounts of data. This appliance offers a cohesive combination of hardware and software, configured to deliver high performance and reliability for business intelligence applications.

One of the standout features of the HP Neoview 544530-001 is its ability to support large-scale data analytics. The system utilizes a massively parallel processing architecture, which allows it to handle multiple data queries simultaneously, thereby enhancing the overall performance and response time. This characteristic is vital for businesses that rely on real-time data analysis to make informed decisions.

Another significant technology embedded in the Neoview 544530-001 is its advanced data storage capabilities. With generous storage capacity, it can accommodate extensive datasets, ensuring that organizations have the flexibility to grow their data without compromising system performance. The appliance also integrates advanced compression techniques, which optimize storage efficiency, reducing the physical space required and associated costs.

The HP Neoview is engineered with various data management features, including data quality tools that help ensure the integrity and accuracy of information. These tools can cleanse and normalize data, making it more reliable for analysis. Moreover, the system supports a wide array of data formats, facilitating easy integration with existing databases and applications.

Security is also a critical consideration for the HP Neoview 544530-001. The appliance incorporates robust security measures to protect sensitive data from unauthorized access. This includes encrypted connections and user authentication protocols, which are essential for compliance with industry standards.

In terms of scalability, the Neoview 544530-001 allows businesses to expand their data environment as their needs evolve. The system's modular architecture means that organizations can easily add hardware components, ensuring they can keep pace with increasing data volumes.

Overall, the HP Neoview 544530-001 provides organizations with a complete solution for data warehousing that combines powerful performance, extensive storage, advanced data management tools, and scalable architecture, making it an ideal choice for enterprises looking to leverage data for strategic advantage.
Top Page Image Contents