沒有找到合適的產(chǎn)品?
聯(lián)系客服協(xié)助選型:023-68661681
提供3000多款全球軟件/控件產(chǎn)品
針對軟件研發(fā)的各個階段提供專業(yè)培訓與技術(shù)咨詢
根據(jù)客戶需求提供定制化的軟件開發(fā)服務
全球知名設計軟件,顯著提升設計質(zhì)量
打造以經(jīng)營為中心,實現(xiàn)生產(chǎn)過程透明化管理
幫助企業(yè)合理產(chǎn)能分配,提高資源利用率
快速打造數(shù)字化生產(chǎn)線,實現(xiàn)全流程追溯
生產(chǎn)過程精準追溯,滿足企業(yè)合規(guī)要求
以六西格瑪為理論基礎,實現(xiàn)產(chǎn)品質(zhì)量全數(shù)字化管理
通過大屏電子看板,實現(xiàn)車間透明化管理
對設備進行全生命周期管理,提高設備綜合利用率
實現(xiàn)設備數(shù)據(jù)的實時采集與監(jiān)控
利用數(shù)字化技術(shù)提升油氣勘探的效率和成功率
鉆井計劃優(yōu)化、實時監(jiān)控和風險評估
提供業(yè)務洞察與決策支持實現(xiàn)數(shù)據(jù)驅(qū)動決策
打通數(shù)據(jù)孤島 實現(xiàn)生產(chǎn)過程全透明化
實現(xiàn)產(chǎn)品全生命周期的質(zhì)量管理與追溯
精準制定生產(chǎn)計劃 合理配置生產(chǎn)資源
全面可視的生產(chǎn)質(zhì)量統(tǒng)計與追溯
一鍵生成排產(chǎn)計劃,有效提升資源利用率
打通生產(chǎn)過程數(shù)字化全鏈路,提高生產(chǎn)效率
幫助企業(yè)大幅降低因改裝質(zhì)量問題帶來的損失
打造數(shù)字化工廠,全面提升產(chǎn)品質(zhì)量
快速應對訂單變化,大幅減少企業(yè)資源浪費
實現(xiàn)產(chǎn)品報價快速精準,全面實現(xiàn)生產(chǎn)透明化
打造生產(chǎn)計劃自動排產(chǎn)信息化平臺
Active Query Builder是一款用于Borland Delphi和 C++Builder的數(shù)據(jù)庫查詢構(gòu)建控件集。通過直觀簡潔的界面創(chuàng)建包含公用體和子查詢的復雜SQl查詢。
標簽:SQL開發(fā)商: Active Database
當前版本: v3.2
產(chǎn)品類型:控件
產(chǎn)品功能:數(shù)據(jù)庫管理工具
平臺語言:VCL|Activex & COM
開源水平:不提供源碼
本產(chǎn)品的分類與介紹僅供參考,具體以商家網(wǎng)站介紹為準,如有疑問請來電 023-68661681 咨詢。
Active SQL Query Builder是一套可視化查詢器組件。幫助用戶進行復雜的SQL查詢、數(shù)據(jù)解析、SQL查詢結(jié)果分析與可視化。Active SQL Query Builder是一個雙向的查詢器,用戶可以將可視化查詢創(chuàng)建與SQL查詢結(jié)果的文本編輯相結(jié)合。
Active SQL Query Builder is a visual query builder component suite that allows your end-users to build complex SQL queries, as well as to parse, analyze SQL queries and represent them visually. Active Query Builder is a true two-way query builder, so you may combine visual query building with direct SQL query text editing.
聲明:本產(chǎn)品中文介紹為慧都網(wǎng)版權(quán)所有,未經(jīng)慧都公司書面許可,嚴禁拷貝、轉(zhuǎn)載!
* 關(guān)于本產(chǎn)品的分類與介紹僅供參考,精準產(chǎn)品資料以官網(wǎng)介紹為準,如需購買請先行測試。
定義不同的連接類型和服務器的特定選項
將對象添加到查詢,自動聯(lián)接創(chuàng)建
簡單排序,分組和標準定義
與工會,子查詢和派生表的工作
輕松創(chuàng)建復雜的SQL查詢
Active SQL Query Builder的用戶界面與MS-Access極其相似,但相較于其他的同類組件來說,Active SQL Query Builder功能更為強大。它允許用戶簡單直接的定義數(shù)據(jù)分組,排序以及構(gòu)建其他條件。用戶可以如同創(chuàng)建單一查詢一樣在其獨立工作區(qū)內(nèi)創(chuàng)建聯(lián)合體以及子查詢,甚至還可以通過對查詢結(jié)構(gòu)樹單次訪問即可進入聯(lián)合體以及子查詢。此外,用戶還能將其一些諸如DISTICT, TOP, pMIT等的高級查詢屬性可視化。
設計用戶友好型查詢環(huán)境
Active Query Builder能將用戶友好型的查詢字段替換為數(shù)據(jù)庫中表和字段中的規(guī)范化命名的字段。然后,您的終端客戶能可以手動的創(chuàng)建SQL腳本:但在其查詢文本中使用的查詢字將被自動的替換為生成的查詢中真正的字段名。
格式化SQL查詢文本布局
使用Active Query Builder's SQL Formatter,用戶可以用自己喜歡的方式自定義SQL代碼的布局??梢酝ㄟ^很多屬性的設置自定義查詢結(jié)果的輸出,比如pne breaks, indents 以及 word wrapping等。
我們也考慮到了將用戶查詢條件盡可能以其輸入的SQL查詢文本原貌保存。充分的認識到各種原始輸入條件對查詢結(jié)果影響的重要性,我們盡可能的保證了對查詢條件進行解析后,不出現(xiàn)任何條件與可選項的丟失。
強大的SQL查詢解析與分析功能
用戶可以通過Active Query Builder對其SQL查詢進行完全的控制—您可以使用內(nèi)部查詢創(chuàng)建器對象輕松的解析與引導SQL查詢,還可以可編程的修改SQL查詢。
通過Active Query Builder中的相關(guān)參數(shù),用戶可以知道其名稱以及數(shù)據(jù)類型,甚至與其相關(guān)的數(shù)據(jù)庫對象以及字段。
限制數(shù)據(jù)庫連接對象,避免查詢沖突
用戶有時可能想拒絕用戶對數(shù)據(jù)庫中某些字段或者表的訪問,以保障其安全性或者繞開對于其的數(shù)據(jù)庫結(jié)果來說無關(guān)緊要的部分。Active Query Builder能幫助用戶輕松的實現(xiàn)這一切。當用戶在一個可視化界面中創(chuàng)建一個查詢時,可以隱藏住某些不希望被訪問的數(shù)據(jù)庫對象或者字段。
通過檢索查詢中的某些信息,比如使用過的某些表或者字段名,用戶可以制止某些未授權(quán)的查詢。
完全支持Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, SQpte 和 ANSI SQL/92, 89 ,2003 SQL語法
我們聲稱完全支持這些SQL語言,這意味著能解析幾乎任何給定數(shù)據(jù)庫服務器中的SQL查詢語句,并且在查詢修正過程中保存每一查詢細節(jié)以避免語義損失。Active SQL Parser由升級版的CoCo/R Compiler Generator而來,其完全支持Unicode字符集,故而能正確處理多重嵌套連接以及一些其他SQL語言中的細節(jié)部分。
使用Active Query Builder時,其能為用戶自動的確定目前使用的數(shù)據(jù)庫服務器,以避免不能提前確定(數(shù)據(jù)庫服務器)的情況。
脫機模式下工作時以XML文件格式保存元數(shù)據(jù)
在很多情況下,在當前安全角度或者對性能來說,對數(shù)據(jù)的直接訪問是不受歡迎或者不可能的,比如在ASP.NET環(huán)境中。當面對這種情況時,最方便的解決方法是在脫機模式下使用Active Query Builder,從之前保存的XML文件中加載元數(shù)據(jù)信息。這種方式幾乎能瞬間加載元數(shù)據(jù),而無需考慮數(shù)據(jù)量的多少。
本地化組件
現(xiàn)在,用戶可以在Active Query Builder運行時本地化其組件,以及在不同語言間進行切換。
Active Query Builder是一個特別的組件
Active Query Builder并非被設計用于某些內(nèi)部需求,其是用于滿足客戶需要的。該組件的開發(fā)團隊的成員們是一群狂熱的程序員,以之展現(xiàn)了其對可視化查詢創(chuàng)建的理解。我們將認真考慮您的所有建議與意見,因為我們的目標是盡可能使Active Query Builder成為業(yè)內(nèi)最優(yōu)秀的工具軟件。
Active Query Builder是一個完全的可視化SQL查詢創(chuàng)建解決方案!
Building complex SQL queries visually with ease.
The interface of Active SQL Query Builder is similar to MS-Access, but much more powerful compared to other similar components. It allows you to define grouping and sorting, construct criteria in a simple and direct way. Each union and sub-query has its own working area where it could be built visually as easy as single query; you can get access to each union and subquery in one-touch with the query structure tree. The advanced query properties, such as DISTICT, TOP, pMIT, etc., might be set visually as well.
Designing user-friendly query building environment
Active Query Builder allows you to substitute unintelligible names of database objects and fields for user-friendly aliases ("alternate names"). Among changing names of real objects, you may define your own virtual objects (views) and fields. Acting as derived tables ("virtual objects") and sub-queries or expressions ("virtual fields"), they look like an ordinary objects and fields to the end-users. All aliased object names that were used in the query will be substituted back for real names, sub-queries and expressions automatically in the resultant SQL query text.
While building SQL queries with aliased object names visually, the end-users can still edit them by hand. Acitve Query Builder generates two versions of a query: for the end-user and for database server, and it's able to parse both.
Having database without foreign keys, you may add them to the component's metadata repository so tables will be joined automatically when added to a query.
Formatting SQL query text layout.
Using the Active Query Builder's SQL Formatter you can customize SQL code layout the way you pke it. There are a lot of properties that can be used to customize SQL query output, such as pne breaks, indents and word wrapping.
We care about keeping user queries in the same form as they were entered in the SQL query text. None of conditions and options will be lost after parsing of the query because we understand how important they could be in result.
Powerful means of SQL query parsing and analysis.
Active Query Builder gives you full control over the SQL query - you can easily parse SQL queries and navigate them using the internal query builder objects and modify SQL queries programmatically.
Working with parameters in Active Query Builder, you may know their names and data types, and discover to what database objects and fields they are related to.
Restricting access to database objects, preventing query execution
You might want to deny access to certain fields and tables to meet the safety requirements or get rid a user of needless parts of your database structure. Using the Active Query Builder, you can do it easily. Building a query via a visual interface, you can hide undesirable objects and fields of your database.
Abipty to retrieve various information about the query, such as pst of used tables and fields, allows you to prevent execution of unauthorized queries.
Full support of Oracle, SQL Server, MS Access, MySQL, PostgreSQL, InterBase, Firebird, IBM DB2, Informix, Sybase, SQpte and ANSI SQL/92, 89 and 2003 dialects SQL syntax.
By claiming full support of these SQL dialects, we mean the possibipty of parsing of almost any vapd SQL query for the given database server and keeping of every single query clause during the query modification process without any losses. Generated from the improved CoCo/R Compiler Generator, Active SQL Parser with full Unicode support correctly handles multiple nested joins and other fine points found in some SQL dialects.
Using Active Query Builder you can determine the currently used database server automatically, in case it cannot be defined in advance.
Working in offpne mode, storing metadata in XML files.
In many cases, direct connection to the database is undesirable or even impossible from the point of view of security or performance, for example in the ASP.NET environment. In this case, the most convenient solution would be to work with Active Query Builder in offpne mode, loading metadata information from a previously saved XML file. It also makes loading metadata almost instant regardless of the number of objects being loaded.
Locapzation.
Now it is possible to locapze Active Query Builder completely and to switch between available languages in run-time.
Active Query Builder is a special component.
It wasn't created for some internal needs, it was made to meet customer needs. This component was made by a team of enthusiast programmers to express their vision of the visual query building. All your comments and suggestions will be taken into consideration because we really want to make it the best tool possible.
Active Query Builder is complete solution for visual SQL query building!
更新時間:2017-01-25 16:16:28.000 | 錄入時間:2006-12-19 14:55:00.000 | 責任編輯:
dbForge Studio for SQL Server是用于SQL Server的終極管理工具。
軟件Navicat Premium 是一套數(shù)據(jù)庫管理工具,讓你使用一個程序即可同時連接到 MySQL、MariaDB、SQL Server、SQLite、Oracle 和 PostgreSQL 數(shù)據(jù)庫。
軟件一套專用于管理和開發(fā)MongoDB數(shù)據(jù)庫的開發(fā)工具。
軟件一套專用于可視化和優(yōu)化 Redis 數(shù)據(jù)的開發(fā)工具。
軟件跨平臺開源 Redis ? 管理工具
官方微信
官方微博
服務電話
重慶/ 023-68661681
華東/ 13452821722
華南/ 18100878085
華北/ 17382392642
客戶支持
技術(shù)支持咨詢服務
服務熱線:400-700-1020
郵箱:sales@evget.com
關(guān)注我們
地址 : 重慶市九龍坡區(qū)火炬大道69號6幢
慧都科技 版權(quán)所有 Copyright 2003- 2024 渝ICP備12000582號-13 渝公網(wǎng)安備 50010702500608號