LECCOTECH Introduces SQL Expert Version 2.4 To Add Table Browser, Analysis Tools for Oracle Database Optimization.Business Editors/High Tech Writers Oracle OpenWorld Oracle OpenWorld is an annual Oracle event for business decision-makers, IT management, and line of business end users. It is held in major cities around the world. The 2007 event was held in Sao Paulo, Brazil. 2000 Booth No. 2326 SAN FRANCISCO--(BUSINESS WIRE)--Oct. 2, 2000 LECCOTECH, a global developer of database performance optimization software Free and Open Source software
OOW Officer Of the Watch OoW Omens of War (gaming) OOW Out-Of-Warranty OOW Out Of Work (disability management) OOW Out Of Wedlock OOW Out Of Whack ) conference and exposition here Monday to announce the new Version 2.4 of its powerful LECCO SQL SQL in full Structured Query Language. Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results. Expert(TM) SQL performance optimization software for Oracle databases. LECCO SQL Expert is a powerful yet easy-to-use, Windows-based client software tool that identifies, evaluates and rewrites problematic structured query language See SQL. Structured Query Language - SQL (SQL) statements in order to optimize database transaction performance. LECCOTECH's unique Feedback-Searching engine uses artificial intelligence technology to detect the indexes and data structure of the user database, then uses this information to rewrite input SQL statements, tailored to the database environment providing highest performing SQL statements possible that are guaranteed to return correct results. The new version 2.4 provides enhanced cross-reference and summary information features within the SQL Editor and Database Explorer modules that make it easier for application developers and database administrators (DBAs) to analyze applications and database schema The definition of a database. It defines the structure and content in each data element within the structure. Schemas are often designed with visual modeling tools that automatically create the SQL code necessary to define the table structures. See subschema and XML schema. , both in the development and production phases of deployment. "A new Table Browser function within the Database Explorer module displays table rows so that users can easily access detailed object information -- such as object definition, column, index and data -- without having to actually write and execute any SQL statements," explained Stephen Wong, LECCOTECH president and CEO (1) (Chief Executive Officer) The highest individual in command of an organization. Typically the president of the company, the CEO reports to the Chairman of the Board. . "This is a much more convenient analysis tool for verifying that correct values have been inserted in the rewritten statement." The SQL Editor has been enhanced to include direct navigation to object information in the Database Explorer, right from the Execution Plan window. This makes execution plan analysis much easier to accomplish by providing direct access to detailed object information within the Database Explorer simply by pointing and clicking on the Execution Plan text itself. "In addition, the Database Explorer module has been enhanced with new point-and-click navigation tabs that help users to more quickly view summary reference information simply by clicking on an object in an object list," Wong added. "The new features provide a preview summary of all objects as well as lists of objects that depend on the selected object and lists of objects on which the selected object depends. New text functions add the 'create index,' the 'create primary' and the 'create foreign' key statements on table text (DDL (1) (Data Description Language) A language used to define data and their relationships to other data. It is used to create the data structure in a database. Major database management systems (DBMSs) use a SQL data description language. ). A new 'Jump to Object' function will let the user jump to associated objects merely by double clicking on the row. All of these features make it easier for application developers and DBAs to perform impact analysis on changes to SQL statements." The LECCO SQL Expert package consists of five modules: -- Syntactical SQL Optimizer -- SQL Formatter -- Database Explorer -- SQL Inspector -- SQL Scanner The SQL Inspector and SQL Scanner modules are designed to quickly identify potentially problematic SQL statements within the database objects and source code. Once they have been identified, the Syntactical SQL Optimizer can be used to tune the low-performing SQL statements not only to enhance their efficiency but to assure high quality of all SQL statements executed on the database server. In addition, it lays out every SQL statement in a consistent format so that maintainability is enhanced. The Database Explorer module helps users determine whether any changes to the database structure are needed to further improve the performance of the SQL statement. The SQL Editor and Formatter provides automated tools to edit and optimize the statements, then to do a batch run to obtain their run times and then compare and identify which optimized statement best suits the application. The new LECCO SQL Expert Version 2.4 is being demonstrated in the LECCOTECH exhibit (Booth No. 2326) at the OOW conference being held at the Moscone Center The Moscone Center is San Francisco, California's largest convention and exhibition complex. The complex consists of two main underground halls underneath Yerba Buena Gardens, Moscone North and Moscone South, as well the three-level Moscone West exhibition hall across 4th Street. here all this week. LECCO Technology Ltd. is a fast-growing global developer of database performance solutions that incorporate artificial intelligence methodology to provide the highest level of SQL optimization for Oracle, Microsoft SQL Server A relational DBMS from Microsoft that is a major component of the Windows Server System. It is Microsoft's high-end client/server database and is closely integrated with Microsoft Visual Studio and the Microsoft Office System. and Sybase databases. The company was founded in 1995 and was named the winner of the Hong Kong Hong Kong (hŏng kŏng), Mandarin Xianggang, special administrative region of China, formerly a British crown colony (2005 est. pop. 6,899,000), land area 422 sq mi (1,092 sq km), adjacent to Guangdong prov. Computer Society's 1999/2000 Gold Award for Product Excellence. The company also has been honored as Technology Firm of the Year by the U.S.-based National Business Incubation Association (NBIA NBIA National Business Incubation Association NBIA National BioEnergy Industries Association (Washington, DC) NBIA Network Business Information Architecture (Sprint) ). The company so far has received more than $12 million in venture funding. LECCOTECH provides global sales, service and support through its own offices in San Francisco San Francisco (săn frănsĭs`kō), city (1990 pop. 723,959), coextensive with San Francisco co., W Calif., on the tip of a peninsula between the Pacific Ocean and San Francisco Bay, which are connected by the strait known as the Golden and Irvine, Calif., and Saddlebrook, N.J. in the U.S.; Coventry, England; Ontario, Ottawa and Montreal, Canada; Hong Kong; and Sydney, Australia. The company also sells through a distributor/reseller network that covers other major markets in Japan, India and continental Europe. |
|
||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion