Patents
Literature
Hiro is an intelligent assistant for R&D personnel, combined with Patent DNA, to facilitate innovative research.
Hiro

31 results about "Comma-Separated Values" patented technology

A comma-separated values (CSV) file is a delimited text file that uses a comma to separate values. A CSV file stores tabular data (numbers and text) in plain text. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format.

Iterative definition of flat file data structure by using document instance

InactiveUS20060259519A1Interactively create a parsing schema quicklyMinimal knowledge necessarySemi-structured data mapping/conversionSpecial data processing applicationsXML schemaEnterprise application integration
Flat file formats are used widely in Enterprise Application Integration (EAI) and Business to Business (B2B) solutions. The formats describe the layout of the meaningful information within the data stream in such a way so that the parsing of that stream and extraction of the information can be automated. An example of a flat file format is a Comma Separated Values (CSV) format, where units of data are delimited between each other by using comma character. Another example is a positional format where the units of data occupy certain positions relative to each other within the data stream. The common task that is performed very often is conversion of the documents from various flat file formats into an XML representations and vise versa. The algorithm of iterative definition of the flat file structure from document instance described herein simplifies the process of defining the conversion rules for the flat file formats. These rules are used by components that perform conversion from flat file format to XML and back. The algorithm allows definition of those rules by working with the flat file document instance and iteratively creating an XML schema from that instance.
Owner:MICROSOFT TECH LICENSING LLC

Web navigation method and system

Computer-readable data (150) is imported into a known component such as an electronic spreadsheet program (201), hierarchically structured (203), and saved in comma-separated values (CSV) format (204). The resulting URL link file (111), a web navigation presentation program (110) and an initiating file (109) are made accessible to a web browser (101) to create a web navigation system, making it possible to create an autonomously-alterable navigation web page (127) without the complexity of creating a special-purpose data conversion tool (401) and without the time required to manually re-enter (403) the computer-readable data (150).
Owner:VERMEULEN BERT MARTIN +1

System for describing text file formats in a flexible, reusable way to facilitate text file transformations

A text file schema enables any text file to be expressed as an XML or database format, or vice versa. The text file may be simple (e.g., binary data, comma separated values, tab separated values, or the like) or complex (basic EDI files, UN / EDIFACT, ANSI X.12 EDI, or the like). With the present invention, a text file format is expressed as a set of external files that define the file format in a flexible, reusable way. The external files preferably conform to a given XML schema. They enable the text file format to be used across data integration mapping projects and, in particular, to facilitate transformation of data contained in text files (that conform to the file format) from / to other data formats. Preferably, the external files comprise a first external file that describes the text file configuration according to the schema, a second external file that describes the structure of the text file according to the schema, and a third external file that describes control data of the text file according to the schema.
Owner:ALTOVA

Home gateway and method for analyzing user online behavior and monitoring network quality

The invention discloses a method for analyzing user online behavior and monitoring network quality on a home gateway. The method comprises the following steps of: A10, collecting user online data, analyzing a data packet access to a home gateway, generating a corresponding online behavior CSV (Comma Separated Value) file, and uploading to an FTP (File Transfer Protocol) server; A20, monitoring the network quality, simulating PPPOE (Point-to-Point Protocol over Ethernet) dialing periodically through the home gateway, initiatively starting TCP (Transmission Control Protocol), DNS (Domain Name Server), HTTP (Hyper Text Transport Protocol) and FTP (File Transfer Protocol) service availability detections, generating a corresponding network quality CSV file according to the detection result, and uploading to the FTP server; and A30, analyzing the online behavior CSV file and the network quality CSV file, and obtaining the user online behavior and the network quality result. According to the method, the user online behavior is analyzed on the home gateway, so that corresponding business information can be effectively acquired, the network is adjusted correspondingly according to the network quality monitoring result, differentiation service is provided, and the best service quality is provided for users.
Owner:WUHAN FIBERHOME TECHNICAL SERVICES CO LTD

Data transformation system

The present invention provides a system and a method for software conversions which maps and translates data from model reports to files formatted as either Comma Separated Value (CSV) files or Flat Fixed Position files in order to migrate the data from one software systems' service to a similar service of a different software system. Using a report generated from the current system and a translation tool the data is mapped and translated to the receiving systems' conversion format. By developing standard reports and pre-defined translation templates data from one system's application can be converted easily, repeatedly and efficiently.
Owner:CERNER INNOVATION

ETL (extract-transform-load) data processing method, device and system

The invention discloses ETL (extract-transform-load) data processing method, device and system. The method includes: acquiring source data from a data source, and converting the source data into source data in the CSV (comma-separated value) format; establishing an ETL task according to the source data in the CSV format, and triggering an ETL tool to run the ETL task; transmitting running results of the ETL task to a target data warehouse. The data, to be processed, of the data source is uniformly converted in the CSV format and is then extracted, transformed and loaded; loading results are disposed in the target data warehouse; in case of varieties of data sources, adding a conversion method of CSV-formatted data is required only; accordingly, setting of various drive / import / export tools causes decreased processing speed of ETL data in the prior art is avoided, and processing speed and efficiency of the ETL data can be higher.
Owner:杭州勒卡斯广告策划有限公司

Logic test method and device suitable for reactor protection system

The invention relates to a logic test method and device suitable for a reactor protection system. The logic test method comprises a construction step, a call step, an operation step and a judgment step, wherein the construction step is as follows: constructing test programs and a truth table based on a comma separated values (CSV) format, wherein the truth table comprises the logic diagram index information of the reactor protection system, an input variable, an output variable, the voluation information of the input variable, the input variable of the output variable, and an execution time; the call step is as follows: reading the logic diagram index information, calling the test programs corresponding to the logic diagram index information; the operation step is as follows: reading the input variable and carrying out voluation on the input variable in accordance with the voluation information of the input variable, and carrying out logic operation in accordance with the called test program and the execution time so as to obtain the output value of the output variable; and the judgment step is as follows: judging whether the output value of the output variable is consistent with the expected value, if yes, outputting correct result information, and if no, outputting wrong result information. In the logic test method, the test is carried out by constructing the truth table based on the CSV format and the test program, thus being convenient for modification and regulation, and avoiding human errors.
Owner:中广核工程有限公司 +2

Packing method based on line storage database engine

The invention discloses a packing method based on a line storage database engine, which comprises a line storage database, and following operations are carried out based on the line database: creating a compress table, specifying a corresponding compressing level, and importing data files with CSV (Comma Separated Value) format into the created compress table. The method is characterized in that: the compress table is a common data table showed externally for supporting general DML / DDL (Data Manipulation Language / Data Definition Language) operation; the compress table comprises a master HOT data segment and a slave LOB large object segment realized internally, wherein the master HOT segment is used for storing internally defined attribute lines, and the slave LOB segment is used for storing a compression method control structure and compressed data content; the compress table is used for supporting various query languages, and when in query, even though all fields in the line need to be read into memory, the related line data only needs to be decompressed and queried; the compress table is used for supporting update operation, and only decompressing updated lines when in update; and the compress table is used for supporting speedy deletion, only delete mark is made, and when no record is in a slave line, a master line is automatically deleted; and the compress table is deleted. According to the invention, through a line storage database technology, without changing a storage engine physical result, the technology of compression and storage according to line is realized, and the effect of high compression ratio of the line storage database is achieved.
Owner:天津神舟通用数据技术有限公司

Method for converting CSV (Comma-Separated Values) data labeled by metadata to RDF (Resource Description Framework) data

The invention discloses a method for converting CSV (Comma-Separated Values) data labeled by metadata to RDF (Resource Description Framework) data. The method comprises the following steps: reading and analyzing a CSV file, obtaining tabular data, and storing the tabular data into a memory data structure; reading and analyzing a metadata description file, obtaining metadata, and storing the metadata into the memory data structure; combining with the obtained tabular data and metadata, generating an RDF triple set, and storing the RDF triple set into the memory data structure; and outputting the generated RDF triple set as an RDF data file of a Turtle grammatical format. The method for converting the data format converts the CSV data labeled by a metadata model vocabulary defined by a W3C (World Wide Web Consortium) technical specification <Web Tubular Data and Metadata Model> into the semantically equivalent RDF data, so that a traditional software tool can be utilized to conveniently publish the RDF data obtained by conversion onto an associated data network for various semantic web applications to share, reuse and process the tubular data from the CSV file, and therefore, a great quantity of large-coverage CSV data can perform the maximum potential.
Owner:HOHAI UNIV

File analysis system and method

The invention relates to a file analysis method, which comprises the following steps of: reading a file and a file type parameter of the file from a file transfer protocol (FTP) server; judging whether the type of the file is one of textfile (TXT), comma separated values (CSV), meta database (MDB), database file (DBF) and Microsoft Excel (XLS) formats or not according to the file type parameter; when the type of the file is TXT or CSV, calling a JAVA algorithm to analyze TXT or CSV so as to generate an extensible markup language (XML) file; when the type of the file is MDB, calling the JAVA algorithm to analyze MDB so as to generate an XML file; when the type of the file is DBF, calling the JAVA algorithm to analyze DBF so as to generate an XML file; and when the type of the file is XLS, calling the JAVA algorithm to analyze XLS so as to generate an XML file. The invention also provides a file analysis system. By the method and the system, a binary file can be analyzed into a file which can be processed by a file sender adapter and is in an XML format.
Owner:北京首冠教育科技集团有限公司

Method for importing csv (Comma Separated Value) question bank to interactive teaching platform

The invention provides a method for importing a csv (Comma Separated Value) question bank to an interactive teaching platform. The method comprises the following steps of: at first, using a TstringList to open a question bank file with a csv format; scanning a first line of the question bank file; judging whether the first line of the question bank file accords with a format of the interactive teaching platform or not; putting data of the csv file into a configuration window of the csv question bank; adjusting the first line of the question bank file which does not accord with the format of the interactive teaching platform, so that the first line of the question bank file accords with the format of the interactive teaching platform; gradually reading the configuration window of the csv question bank line by line until all lines in the configuration window of the csv question bank are read, and a question type is completed to judge; and importing the entire file of the csv question bank in. With the adoption of the method provided by the invention, a teacher does not need to edit the question bank file with the csv format for the second time when the interactive teaching platform is used, so that the direct importing can be realized.
Owner:RETURNSTAR INTERACTIVE TECH GRP

Test automation method for software programs

A method for testing a software program creates test data by simulating data exchange messages between a server and a client and stores test data in Comma Separated Value (CSV) files. Data repository files stored in the CSV format can be edited by common tools, like a spreadsheet program, and can be maintained easily. The test automation method provides a data capturer tool so that the data repository could be created based on any existing test environment. The test automation method converts data repository files and simulates messages in order to load data to a mobile infrastructure system and set up data fixtures. The test automation method could be integrated in a build process so that data repository and test cases are validated against any program changes periodically.
Owner:SAP AG

Dynamic domain name verification method and system, computer equipment and storage medium

ActiveCN108388796AMigrate safely and correctlyPlatform integrity maintainanceDomain nameArray data structure
The invention relates to the field of domain name verification, in particular relates to a dynamic domain name verification method and system, computer equipment and a storage medium. The dynamic domain name verification method comprises the following steps: obtaining a parameterized element; carrying out array configuration on the parameterized element, and storing the configured array into a CSV1 (Comma-Separated Value 1) file; carrying out traversal combination on each parameterized element in the array in the CSV1 file, and generating a plurality of static URLs (Uniform Resource Locators)and dynamic URLs; storing the generated dynamic URLs and static URLs into a CSV2 file used for storing and reading the dynamic URLs and the static URLs; putting the dynamic URLs and the static URLs into a browser one by one for access verification; then, storing a verification result into a CSV3 file used for storing and reading the verification result; filtering the URL which fails to verify in the CSV3 file, and carrying out positioning analysis. According to the verification method, the safe and correct migration of the category of items is guaranteed, and a domain name migration category test is more efficient and comprehensive.
Owner:ONE CONNECT SMART TECH CO LTD SHENZHEN

Machine learning characteristic based symbolic regression GP (Genetic Programming) algorithm

The invention provides a machine learning characteristic based symbolic regression GP (Genetic Programming) algorithm. By using a data storage mode of Weka, table data or database data can be easily converted into a ARFF (Attribute-related file format) data file; most of table data or database data can be exported to CSV (Comma-separated value)-format data, and the data is a series of comma-separated data item values; after the exporting is completed, the file is opened in a text editor, and attributes are added in the file; adding the name of a dataset to @relation tag, adding attribute information by using @attribute, and data information is added to @data and then is saved. The save it. The machine learning characteristic based symbolic regression GP algorithm is combined with a conversion algorithm, a set similarity algorithm, a minimum Hash and local sensitive hash algorithm of a tree set so as to find a new individual similarity determining algorithm and apply the algorithm to GP.
Owner:LANGCHAO ELECTRONIC INFORMATION IND CO LTD

Data acquisition method and device

The invention discloses a data acquisition method and device, relates to the technical field of internet, and aims at solving the problem that the process of acquiring data in CSV files is not reusable in the prior art. The method comprises the following steps of: receiving metadata information corresponding to a business requirement, wherein the metadata information comprises an attribute name, a row identifier and a format type corresponding to different pieces of attribute information, and the row identifier is an identifier of a row in a Comma-separated values CSV file; establishing a mapping table according to the metadata information, wherein the mapping table records a corresponding relationship among the attribute name, the row identifier and the format type; extracting data corresponding to the row identifier from the CSV file according to the mapping table; converting the extracted data into a format type corresponding to the row identifier according to the mapping table; and binding the format-converted data with the attribute name corresponding to the row identifier. The data acquisition method and device are suitable for being applied to the process of extracting the data in the CSV file.
Owner:BEIJING GRIDSUM TECH CO LTD

Data transmission method and device

The invention provides a data transmission method and device. The data transmission method includes the steps that at least one comma separated value CSV file is pre-obtained; a leading-out instruction input by the outside is received; according to the leading-out instruction, a to-be-led-out CSV file is determined from the at least one CSV file; the data volume in the to-be-led-out CSV file is determined; according to the data volume, the to-be-led-out CSV file is divided into at least two data blocks; all the data blocks are sequentially mapped into an internal storage; the data blocks mapped into the internal storage are sequentially processed; according to the leading-out instruction, to-be-led-out data generated after processing is sent to a specified target. By means of the data transmission method and device in the technical scheme, the data processing speed of an application program can be increased.
Owner:INSPUR SOFTWARE CO LTD

Method and device for analyzing non-standard JSON string

The invention discloses a method and a device for analyzing a non-standard JSON string. The method comprises the following steps: acquiring the non-standard JSON string, wherein the head of the non-standard JSON string comprises identification information; converting the non-standard JSON string into a comma separation value (CVS) file format to obtain a target field of an STRING type; extracting a JSON (JavaScript Object Notation) string of which the identification information is removed from the target field by utilizing an SUBSTRING function; and when a non-standard separator exists in the JSON string of which the identification information is removed, replacing the non-standard separator with a preset standard separator by using a regular expression to obtain a standard JSON string. The invention relates to the technical field of big data, wherein the non-standard JSON string is converted into the standard JSON string according to the SUBSTRING function and the regular expression, so that the analysis efficiency of the non-standard JSON string is improved.
Owner:CHINA CONSTRUCTION BANK

Logic test method and device suitable for reactor protection system

The invention relates to a logic test method and device suitable for a reactor protection system. The logic test method comprises a construction step, a call step, an operation step and a judgment step, wherein the construction step is as follows: constructing test programs and a truth table based on a comma separated values (CSV) format, wherein the truth table comprises the logic diagram index information of the reactor protection system, an input variable, an output variable, the voluation information of the input variable, the input variable of the output variable, and an execution time; the call step is as follows: reading the logic diagram index information, calling the test programs corresponding to the logic diagram index information; the operation step is as follows: reading the input variable and carrying out voluation on the input variable in accordance with the voluation information of the input variable, and carrying out logic operation in accordance with the called test program and the execution time so as to obtain the output value of the output variable; and the judgment step is as follows: judging whether the output value of the output variable is consistent with the expected value, if yes, outputting correct result information, and if no, outputting wrong result information. In the logic test method, the test is carried out by constructing the truth table based on the CSV format and the test program, thus being convenient for modification and regulation, and avoiding human errors.
Owner:中广核工程有限公司 +2

Address book management method based on long message service for mobile communication terminal

PURPOSE: A method for managing an address book by using an LMS(Long Message Service) in a mobile communication terminal is provided to use an LMS which employs a CSV(Comma Separated Value) format, and to wirelessly transmit an address book regardless of a place, thereby updating and restoring the address book of a user terminal. CONSTITUTION: A system generates a long message including CSV-type address book information. The system transmits the long message including the address book information to a message center, and stores the long message in an inner backup server. The system requests the long message stored in the backup server to be transmitted, and receives the long message. The system separates the address book information from the received long message, and parses the address book information. The system stores the parsed address book information according to an address book type.
Owner:INSPUR LG DIGITAL MOBILE COMMUNICATIONS CO LTD

A http retrieval method for csv fragments identified by uri

The invention discloses an HTTP (Hyper Text Transport Protocol) retrieval method for a CSV (Comma-Separated Values) fragment marked by a URI (Uniform Resource Identifier). The HTTP retrieval method comprises the following steps that: a client resolves a fragment URI and obtains a main resource URI and a CSV fragment identifier; the client sends the selection mode and the selection range of the CSV fragment to a server; the server extracts the CSV fragment according to the selection mode and the selection range of the CSV fragment; the server returns the extracted CSV fragment to the client; and the client obtains the CSV fragment and displays or stores the CSV fragment. The HTTP retrieval method for the CSV fragment marked by the URI disclosed by the invention has the advantages that on one hand, the expansion on a current HTTP / 1.1 protocol is not needed; and on the other hand, the RFC 7111 international standard 'URI Fragment Identifiers for the Text / CSV Media Type' is supported, and compared with a conventional technical scheme of extracting the fragment after the client downloads a complete CSV file, the method provided by the invention has the advantages that the network bandwidth can be greatly reduced, and the communication time delay is reduced.
Owner:HOHAI UNIV

Debugging method and device of fire-fighting host and debugging system of fire-fighting host

The invention discloses a debugging method and device of a fire-fighting host and a debugging system of the fire-fighting host. The method comprises the steps: acquiring a target engineering file, wherein the target engineering file is a file in a comma separation value CSV format; analyzing the target engineering file to obtain an analysis result, and generating a debugging instruction based on the analysis result; and issuing the debugging instruction to the to-be-debugged fire-fighting host to enable the fire-fighting host to run the debugging instruction for debugging. According to the invention, the technical problem of relatively low efficiency of a mode of debugging the fire-fighting host on site in related technologies is solved.
Owner:中消云(北京)物联网科技研究院有限公司

Address book management method based on long message service for mobile communication terminal

PURPOSE: A method for managing an address book by using an LMS(Long Message Service) in a mobile communication terminal is provided to use an LMS which employs a CSV(Comma Separated Value) format, and to wirelessly transmit an address book regardless of a place, thereby updating and restoring the address book of a user terminal. CONSTITUTION: A system generates a long message including CSV-type address book information. The system transmits the long message including the address book information to a message center, and stores the long message in an inner backup server. The system requests the long message stored in the backup server to be transmitted, and receives the long message. The system separates the address book information from the received long message, and parses the address book information. The system stores the parsed address book information according to an address book type.
Owner:INSPUR LG DIGITAL MOBILE COMMUNICATIONS CO LTD

HTTP retrieval method for CSV fragment marked by URI

The invention discloses an HTTP (Hyper Text Transport Protocol) retrieval method for a CSV (Comma-Separated Values) fragment marked by a URI (Uniform Resource Identifier). The HTTP retrieval method comprises the following steps that: a client resolves a fragment URI and obtains a main resource URI and a CSV fragment identifier; the client sends the selection mode and the selection range of the CSV fragment to a server; the server extracts the CSV fragment according to the selection mode and the selection range of the CSV fragment; the server returns the extracted CSV fragment to the client; and the client obtains the CSV fragment and displays or stores the CSV fragment. The HTTP retrieval method for the CSV fragment marked by the URI disclosed by the invention has the advantages that on one hand, the expansion on a current HTTP / 1.1 protocol is not needed; and on the other hand, the RFC 7111 international standard 'URI Fragment Identifiers for the Text / CSV Media Type' is supported, and compared with a conventional technical scheme of extracting the fragment after the client downloads a complete CSV file, the method provided by the invention has the advantages that the network bandwidth can be greatly reduced, and the communication time delay is reduced.
Owner:HOHAI UNIV

Method and device for data acquisition

The invention discloses a data acquisition method and device, relates to the technical field of internet, and aims at solving the problem that the process of acquiring data in CSV files is not reusable in the prior art. The method comprises the following steps of: receiving metadata information corresponding to a business requirement, wherein the metadata information comprises an attribute name, a row identifier and a format type corresponding to different pieces of attribute information, and the row identifier is an identifier of a row in a Comma-separated values CSV file; establishing a mapping table according to the metadata information, wherein the mapping table records a corresponding relationship among the attribute name, the row identifier and the format type; extracting data corresponding to the row identifier from the CSV file according to the mapping table; converting the extracted data into a format type corresponding to the row identifier according to the mapping table; and binding the format-converted data with the attribute name corresponding to the row identifier. The data acquisition method and device are suitable for being applied to the process of extracting the data in the CSV file.
Owner:BEIJING GRIDSUM TECH CO LTD

A data import method, device and electronic equipment

The embodiment of the present invention provides a data import method, device and electronic equipment, which are applied in the field of multimedia technology. The method includes: writing the data in each data source in the Hadoop cluster into the Hadoop distributed Each comma-separated value in a CSV file for the file system HDFS. Synchronize HDFS from the Hadoop cluster to the Druid cluster through distcp. For each CSV file, according to the attribute information of the CSV file, generate a JSON configuration file. According to the JSON configuration file, initiate a request to build an index task through the CURL command, so that Druid The cluster imports the written data in the CSV file into the Druid cluster. The invention can improve the efficiency of data import.
Owner:BEIJING QIYI CENTURY SCI & TECH CO LTD

Character processing method and device

The invention provides a character processing method and device. The method comprises the steps of: reading a first character string stored in a data source file in an EXCEL format; substituting the first character string according to a preset character string substituting relation, and storing a second substituted character string in a blank EXCEL file; and converting the EXCEL file for storing the second character string into a comma separated value CSV formatted file. By employing the character processing method and device, the error rate can be lowered, and the utilization efficiency can be increased.
Owner:BEIJING AEONMED

Data extraction method and system of CSV-format (comma-separated value format) files

InactiveCN108399153ASimple, efficient and easy-to-understand methodSimple, efficient and easy-to-understand systemNatural language data processingSpecial data processing applicationsData ingestionSoftware system
The invention discloses a data extraction method and system of CSV-format (comma-separated value format) files. The method comprises the steps of traversing each character of a CSV-format file in sequence; confirming that the CSV-format file is successfully extracted only when a file end character occurs and a quotation mark identifier is closed; confirming that the format of the CSV-format file is incorrect if the file end character occurs but the quotation mark identifier is not closed. The method and system are simple, efficient and easily comprehensible; various special conditions are centrally handled in several steps, and the method and system are convenient to apply to the development of various software systems, may be applied across programming languages, and are extensible to other text coding formats.
Owner:EAST CHINA NORMAL UNIV

A conversion method from metadata-annotated csv data to rdf data

The invention discloses a method for converting CSV (Comma-Separated Values) data labeled by metadata to RDF (Resource Description Framework) data. The method comprises the following steps: reading and analyzing a CSV file, obtaining tabular data, and storing the tabular data into a memory data structure; reading and analyzing a metadata description file, obtaining metadata, and storing the metadata into the memory data structure; combining with the obtained tabular data and metadata, generating an RDF triple set, and storing the RDF triple set into the memory data structure; and outputting the generated RDF triple set as an RDF data file of a Turtle grammatical format. The method for converting the data format converts the CSV data labeled by a metadata model vocabulary defined by a W3C (World Wide Web Consortium) technical specification <Web Tubular Data and Metadata Model> into the semantically equivalent RDF data, so that a traditional software tool can be utilized to conveniently publish the RDF data obtained by conversion onto an associated data network for various semantic web applications to share, reuse and process the tubular data from the CSV file, and therefore, a great quantity of large-coverage CSV data can perform the maximum potential.
Owner:HOHAI UNIV
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products