“Draft:Jagacy Total Access”的意思、由来-开放百科全书

词条

Draft:Jagacy Total Access

释义

ETL/ELT
Web Screen Scraping
On-line Report Generation
System requirements
See also
References
External links
Jagacy Total Access

{{AFC submission|d|n|u=Bobjustchillin|ns=118|decliner=K.e.coffman|declinets=20181229022711|reject=yes|ts=20181130125828}} {{AFC submission|d|nn|u=Bobjustchillin|ns=118|decliner=TheSandDoctor|declinets=20181129160703|small=yes|ts=20181129130152}} {{AFC submission|d|nn|u=Bobjustchillin|ns=118|decliner=KylieTastic|declinets=20181128141935|small=yes|ts=20181128122413}} {{AFC comment|1=Does not meet NSOFT; significant RS coverage not found. K.e.coffman (talk) 02:27, 29 December 2018 (UTC)}}{{AFC comment|1=Please add independent reliable sources. TheSandDoctor ^Talk 16:07, 29 November 2018 (UTC)}}
{{Infobox Software
| name = Jagacy Total Access
| developer = Bob Preston
| programming language = Java
| operating system = Microsoft Windows,Mac OS X,Linux
| website = {{url|jagacy.com/}}
}}

Jagacy^[1] Total Access is a new on-demand ETL / ELT data processing tool and report generator, written in 100% Java -- it runs on Windows, macOS and Linux. It leverages an enhanced^[2] awk scripting language, on top of Java, that specializes in data conversion and management. Total Access can be used for Web screen scraping (and automated testing^[3]), data mining^[4], generating adhoc analytics reports, and manipulating/cleansing data^[5] from a variety of data sources (including Web pages, databases, XML, HTML, CSV, fixed width (flat files) and Microsoft® Excel™ spreadsheets). In addition, it provides online Web report generation and viewing using Java.

ETL/ELT

Total Access enables you to manage and convert large sets of data. The tool is useful for mining specific data, as well as managing the information that you grab from a wide variety of sources.

While the utility relies on the awk programming language, it includes a rich set of additional features^[2] to it. For instance, the individual rows passed to the script are treated individually as a line, each of them having the field and/or column separate by the value of the IFS variable.

The program relies on the traditional method for extracting data and then transforming it on the specific server before loading the data into a data warehouse where it can be analyzed and visualized. In the ELT method, the same principles apply, but with the difference that the transformations are applied last on your target data platform.

Since the app works with both data processing methods, it is up to you to make the final decision based on your target platform.

Web Screen Scraping

Total Access screen scrapes Web pages^[7] that can be queried using XPath.

On-line Report Generation

Total Access can generate adhoc reports from within a Web application for viewing online by using Java Servlets. It leverages Apache POI for reading and writing Excel files; however it also corrects POI's memory leaks^[8].

System requirements

Java 1.7 or above

References

^[1]^[2]^[3]^[4]^[5]^[6]^[7]

1. ^¹{{Cite web | url=http://www.jagacy.com | title=Jagacy Software LLC: Business Intelligent Solutions}}
2. ^¹²{{Cite web | url=http://www.jagacy.com/totalAccess.pdf | title=Jagacy Total Access - Jagacy Software LLC}}
3. ^¹{{Cite web | url=https://en.wikipedia.org/wiki/Web_scraping | title=Web scraping - Wikipedia}}
4. ^¹{{Cite web | url=https://stackoverflow.com/questions/36389920/java-apache-poi-memory-leak-with-excel-files | title=Java Apache-poi, memory leak with excel files - Stack Overflow}}
5. ^¹{{Cite web | url=https://smartbear.com/learn/automated-testing/what-is-automated-testing | title=What is Automated Testing? - SmartBear}}
6. ^¹{{Cite web | url=https://en.wikipedia.org/wiki/Data_cleansing | title=Data cleansing - Wikipedia}}
7. ^¹{{Cite web | url=https://en.wikipedia.org/wiki/Data_mining | title=Data mining - Wikipedia}}

External links

{{url|http://www.jagacy.com/}}

Jagacy Total Access

随便看

开放百科全书收录14589846条英语、德语、日语等多语种百科知识，基本涵盖了大多数领域的百科知识，是一部内容自由、开放的电子版国际百科全书。